Re: [HACKERS] CREATE TABLE ... PRIMARY KEY kills backend - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] CREATE TABLE ... PRIMARY KEY kills backend
Date
Msg-id 200001120001.TAA04995@candle.pha.pa.us
Whole thread Raw
In response to CREATE TABLE ... PRIMARY KEY kills backend  ("Oliver Elphick" <olly@lfix.co.uk>)
List pgsql-hackers
> Using the cvs version updated this morning, this query kills the backend,
> with no explanation in the log (-d 3):
> 
>   create table junk (id char(4) primary key, name text not null)
> 
> If the primary key constraint is omitted, it is OK.
> 
> This worked yesterday.  Is this a solved problem, or do I need to trace it?
> 

Works for me on current sources:

test=>   create table junk (id char(4) primary key, name text not null);
NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index 'junk_pkey'
for table 'junk'
CREATE

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] Potential vacuum bug?
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] CREATE TABLE ... PRIMARY KEY kills backend