The following bug has been logged online:
Bug reference: 1130
Logged by: Phil Walker
Email address: phil.walker@hp.com
PostgreSQL version: 7.4
Operating system: cygwin
Description: server terminated by signal 11 (easy to duplicate)
Details:
Duplicated on two hardware systems:
1.8Ghz Pentium 4 laptop,
multi-processor industrial blade server (ECC memory)
Easy to duplicate, with the following command line:
$ psql -f pgbug.sql
The SQL file "pgbug.sql" follows:
BEGIN WORK;
SET CONSTRAINTS ALL DEFERRED;
CREATE TABLE ABSTRACTIONISTS(
ANTIVIVISECTIONS NUMERIC NOT NULL,
ELECTROTHERAPISTS NUMERIC NOT NULL
);
CREATE TABLE ACKNOWLEDGEMENT(
DISQUALIFICATIONS NUMERIC NOT NULL,
ACCLIMATIZATION VARCHAR(1024) NOT NULL,
ADVANTAGEOUSNESS VARCHAR(32) NOT NULL,
ALGORITHMICALLY VARCHAR(32) NOT NULL,
ALPHANUMERICALLY VARCHAR(32) NOT NULL,
CONSTRAINT ADVENTITIOUSNESS UNIQUE(DISQUALIFICATIONS,ALGORITHMICALLY)
);
CREATE TABLE ADMINISTRATORSHIP(
ACCOMPLISHMENTS VARCHAR(10) NOT NULL,
ACKNOWLEDGEMENTS VARCHAR(128) NOT NULL,
ACKNOWLEDGMENTS VARCHAR(32) DEFAULT NULL,
ACCOUNTABLENESS VARCHAR(32) DEFAULT NULL,
ACQUAINTANCESHIP NUMERIC DEFAULT 0,
ACHROMATICITIES VARCHAR(16) DEFAULT NULL,
ACQUAINTANCESHIPS NUMERIC DEFAULT 0,
ADMINISTRATIONS NUMERIC DEFAULT 0,
ACCOMMODATINGLY VARCHAR(512) DEFAULT NULL,
ADMISSIBILITIES DATE DEFAULT CURRENT_DATE,
ADMINISTRATIVELY VARCHAR(16) DEFAULT NULL,
ACKNOWLEDGEABLE NUMERIC DEFAULT 0,
ACQUISITIVENESS VARCHAR(32),
CONSTRAINT ADMINISTRATORSHIPS PRIMARY
KEY(ACCOMPLISHMENTS,ACKNOWLEDGEMENTS)
);
CREATE TABLE AERODYNAMICALLY(
CONNOISSEURSHIP NUMERIC NOT NULL,
CZECHOSLOVAKIAN VARCHAR(17),
ANESTHETIZATIONS VARCHAR(32)
);
CREATE TABLE AFFECTIONATENESS(
AERODYNAMICISTS NUMERIC,
AGREEABILILTIES NUMERIC DEFAULT 0,
AGGRANDIZEMENTS VARCHAR(64) NOT NULL,
AGRICULTURALIST VARCHAR(256)
);
CREATE TABLE ANACHRONISTICALLY(
CHROMOLITHOGRAPHY VARCHAR(128),
CONFIGURATIONAL VARCHAR(32),
DEMILITARISATION VARCHAR(32),
CONFIDENTIALITY VARCHAR(32),
AXIOMATIZATIONS VARCHAR(64),
AMBIDEXTROUSNESS VARCHAR(32),
ELECTROCARDIOGRAPHS NUMERIC,
BUREAUCRATICALLY NUMERIC,
ATRABILIOUSNESS NUMERIC,
ELECTROPHORUSES NUMERIC
);
CREATE TABLE ANTHROPOMORPHOUS(
CONNOISSEURSHIP NUMERIC NOT NULL,
DENATIONALISING VARCHAR(32) NOT NULL
);
CREATE TABLE ANTHROPOPHAGOUS(
CONNOISSEURSHIP NUMERIC NOT NULL,
DEMAGNETIZATION NUMERIC NOT NULL,
DISTINGUISHABLE NUMERIC NOT NULL,
BUREAUCRATIZING NUMERIC NOT NULL
);
CREATE TABLE ANTICLERICALISM(
DISFRANCHISEMENT NUMERIC NOT NULL,
DISGRUNTLEMENTS NUMERIC NOT NULL,
DISTINGUISHABLE NUMERIC NOT NULL,
DIVERSIFICATION NUMERIC,
BUREAUCRATIZING NUMERIC NOT NULL,
BURGLARPROOFING NUMERIC,
ANTHROPOMORPHISM NUMERIC NOT NULL,
ANTHROPOMORPHICALLY VARCHAR(16),
DENDROCHRONOLOGY CHAR(1) DEFAULT 'N'
);
CREATE TABLE ATHEROSCLEROSIS(
ATMOSPHERICALLY VARCHAR(16),
CONTRADICTORILY VARCHAR(16),
CONFIDENTIALNESS VARCHAR(16),
CZECHOSLOVAKIANS VARCHAR(17),
CONGRATULATIONS VARCHAR(32),
BRACHISTOCHRONE VARCHAR(240),
DENITRIFICATION VARCHAR(16),
ANAGRAMMATIZING VARCHAR(16),
DISESTABLISHMENT VARCHAR(240),
DENATIONALIZATION VARCHAR(240),
DENATIONALIZING VARCHAR(240),
DISINGENUOUSNESS VARCHAR(240)
);
CREATE TABLE BLOODTHIRSTINESS(
DISILLUSIONIZING VARCHAR(16),
CIRCUMNAVIGATES VARCHAR(16)
);
CREATE TABLE BOUSTROPHEDONIC(
DISILLUSIONMENT VARCHAR(16),
BRACHYCEPHALOUS VARCHAR(240),
DISILLUSIONMENTS VARCHAR(16),
ECCLESIASTICALLY NUMERIC,
CONGRATULATIONS VARCHAR(32),
DIFFERENTIATING NUMERIC,
ELECTROCARDIOGRAPHS VARCHAR(240),
CONSTRAINT BLASPHEMOUSNESS
UNIQUE(DISILLUSIONMENT,DISILLUSIONMENTS,CONGRATULATIONS,ELECTROCARDIOGRAPHS)
);
CREATE TABLE CHARACTERIZATIONS(
CHROMOLITHOGRAPHY VARCHAR(128) NOT NULL,
CHROMATOGRAPHIC VARCHAR(80) NOT NULL,
CINEMATOGRAPHER VARCHAR(80) NOT NULL,
CHROMOLITHOGRAPHIC OID,
CHRONOLOGICALLY OID,
CHROMOLITHOGRAPH DATE DEFAULT CURRENT_DATE,
CHRYSELEPHANTINE DATE DEFAULT CURRENT_DATE,
CINEMATOGRAPHERS VARCHAR(10) DEFAULT NULL,
CINEMATOGRAPHIC VARCHAR(128) DEFAULT NULL,
CHRONOGRAMMATIC NUMERIC DEFAULT 0,
CIRCUMAMBULATES VARCHAR(16) DEFAULT 'NEW',
CHECKERBOARDING NUMERIC DEFAULT 0,
CHROMOLITHOGRAPHER NUMERIC DEFAULT 0,
CIRCUMAMBULATED VARCHAR(32),
CHEMILUMINESCENCE VARCHAR(10),
CHOLECYSTOGRAPHY VARCHAR(128),
CONSTRAINT CIRCUMAMBULATING PRIMARY KEY(CHROMOLITHOGRAPHY),
CONSTRAINT CIRCUMAMBULATION UNIQUE(CHROMATOGRAPHIC,CINEMATOGRAPHER)
);
CREATE TABLE CIRCUMLOCUTIONARY(
ELECTROPOSITIVE NUMERIC NOT NULL,
VALUE VARCHAR(1024) NOT NULL,
ALGORITHMICALLY VARCHAR(32) NOT NULL,
DISQUALIFICATIONS NUMERIC NOT NULL
);
CREATE TABLE COMMENSURABILITY(
CIRCUMSTANTIALLY VARCHAR(32),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
APPROACHABILITY NUMERIC,
DIFFERENTIATION NUMERIC
);
CREATE TABLE COMMENSURATENESS(
CIRCUMSTANTIALLY VARCHAR(32),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
AUTORADIOGRAPHS NUMERIC
);
CREATE TABLE COMMONPLACENESS(
CIRCUMSTANTIALLY VARCHAR(32),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
CONTEMPORANEITY NUMERIC
);
CREATE TABLE COMPASSIONATELY(
COMPARTMENTALLY VARCHAR(32),
CONTEMPORANEOUS VARCHAR(32),
COMPARTMENTALIZES VARCHAR(32),
EDUCATIONALISTS VARCHAR(32),
ENTREPRENEURIAL VARCHAR(32),
CONTEMPTIBILITY VARCHAR(16),
ELECTROPOSITIVE VARCHAR(32),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DODECASYLLABLES NUMERIC,
CONTEMPORANEITY NUMERIC,
DENATURALISATION NUMERIC
);
CREATE TABLE COMPENDIOUSNESS(
COMPARTMENTALIZES VARCHAR(32),
DENATIONALISING VARCHAR(32),
CONTEMPTIBILITY VARCHAR(16),
DECARBONIZATION VARCHAR(16),
ELECTROPOSITIVE NUMERIC,
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DODECASYLLABLES NUMERIC,
DENDROCHRONOLOGISTS VARCHAR(16),
DENATURALIZATION VARCHAR(16),
DENDROCHRONOLOGIST VARCHAR(16)
);
CREATE TABLE COMPETITIVENESS(
COMPARTMENTALIZES VARCHAR(32),
CONTEMPORANEOUS VARCHAR(32),
DIAGRAMMATIZING VARCHAR(32),
DENATIONALISING VARCHAR(32),
DETERMINATENESS VARCHAR(32),
DISHONORABLENESS NUMERIC,
ELECTROPOSITIVE VARCHAR(32),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DISSATISFACTORY VARCHAR(32),
DODECASYLLABLES NUMERIC,
ELECTROCARDIOGRAMS NUMERIC,
CONTEMPORANEITY NUMERIC
);
CREATE TABLE COMPLEMENTATION(
COMPARTMENTALIZES VARCHAR(32),
CONTEMPORANEOUS VARCHAR(32),
DISSIMILARITIES VARCHAR(32),
DENATIONALISING VARCHAR(32),
CONTEMPTIBILITY VARCHAR(16),
CONTRADICTORINESS VARCHAR(16),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DISSATISFACTORY VARCHAR(32),
DODECASYLLABLES NUMERIC,
COMPARTMENTALIZE NUMERIC
);
CREATE TABLE COMPREHENSIBILITY(
COMPARTMENTALIZES VARCHAR(32),
CONTEMPORANEOUS VARCHAR(32),
DISSIMILARITIES VARCHAR(32),
DENATIONALISING VARCHAR(32),
CONTEMPTIBILITY VARCHAR(16),
CONTRADICTORINESS VARCHAR(16),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DISSATISFACTORY VARCHAR(32),
DODECASYLLABLES NUMERIC,
COMPARTMENTALIZE NUMERIC
);
CREATE TABLE COMPREHENSIVELY(
COMPARTMENTALIZES VARCHAR(32),
CONTEMPORANEOUS VARCHAR(32),
DIAGRAMMATIZING VARCHAR(32),
DENATIONALISING VARCHAR(32),
DETERMINATENESS VARCHAR(32),
DISHONORABLENESS NUMERIC,
ELECTROPOSITIVE VARCHAR(32),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DISSATISFACTORY VARCHAR(32),
DODECASYLLABLES NUMERIC,
ELECTROCARDIOGRAMS NUMERIC,
CONTEMPORANEITY NUMERIC
);
CREATE TABLE COMPREHENSIVENESS(
COMPARTMENTALIZES VARCHAR(32),
CONTEMPORANEOUS VARCHAR(32),
DISSIMILARITIES VARCHAR(32),
DENATIONALISING VARCHAR(32),
CONTEMPTIBILITY VARCHAR(16),
CONTRADICTORINESS VARCHAR(16),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DISSATISFACTORY VARCHAR(32),
DODECASYLLABLES NUMERIC,
COMPARTMENTALIZE NUMERIC
);
CREATE TABLE COMPRESSIBILITY(
COMPARTMENTALIZES VARCHAR(32),
CONTEMPORANEOUS VARCHAR(32),
DISSIMILARITIES VARCHAR(32),
DENATIONALISING VARCHAR(32),
CONTEMPTIBILITY VARCHAR(16),
CONTRADICTORINESS VARCHAR(16),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DISSATISFACTORY VARCHAR(32),
DODECASYLLABLES NUMERIC,
COMPARTMENTALIZE NUMERIC
);
CREATE TABLE CONCEIVABLENESS(
CONTEMPORANEITY NUMERIC,
EDUCATIONALISTS VARCHAR(32),
DENOMINATIONALISM VARCHAR(40),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DODECASYLLABLES NUMERIC,
DOLICHOCEPHALIC VARCHAR(32),
DISHONOURABLENESS NUMERIC,
COMPARTMENTALIZES VARCHAR(32),
CONTEMPORANEOUSNESS VARCHAR(32)
);
CREATE TABLE CONSUBSTANTIATION(
CONTEMPORANEITY NUMERIC,
EDUCATIONALISTS VARCHAR(32),
EFFICACIOUSNESS VARCHAR(32),
ENTREPRENEURIAL VARCHAR(32),
CONTEMPTIBILITY VARCHAR(16),
CONTEMPORANEOUS VARCHAR(32),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DODECASYLLABLES NUMERIC
);
CREATE TABLE CONTRADISTINCTION(
DEPERSONALIZING NUMERIC,
CHROMOLITHOGRAPHY NUMERIC,
ANTIVIVISECTIONS NUMERIC,
ARTIFICIALITIES VARCHAR(32),
ARBITRATORSHIPS VARCHAR(32),
ARBORICULTURIST VARCHAR(32),
ANTIVIVISECTIONISM VARCHAR(64),
APPROPRIATENESS VARCHAR(16),
ANTIPATHETICALLY DATE
);
CREATE TABLE CONTRADISTINCTIONS(
DEPERSONALIZING NUMERIC,
CHROMOLITHOGRAPHY NUMERIC,
BASTARDIZATIONS VARCHAR(8),
AUTORADIOGRAPHS NUMERIC,
AUTOTRANSFORMER NUMERIC,
CONSTRUCTIBILITY VARCHAR(32),
CONSUBSTANTIALITY NUMERIC,
AGRICULTURALISTS VARCHAR(10) DEFAULT 'None',
ANTIPATHETICALLY DATE
);
CREATE TABLE CONTRADISTINGUISH(
DEPERSONALIZING NUMERIC,
CHROMOLITHOGRAPHY NUMERIC,
ABSTRACTIONISMS VARCHAR(80),
DYSLOGISTICALLY VARCHAR(32),
DECONSECRATIONS NUMERIC,
ANTIPATHETICALLY DATE
);
CREATE TABLE CONTRARIOUSNESS(
CORRESPONDINGLY VARCHAR(32),
CONCEPTUALIZATIONS VARCHAR(10),
CONVENTIONALIZED VARCHAR(128),
DIFFERENTIATION NUMERIC,
APPROACHABILITY NUMERIC
);
