Re: [HACKERS] CREATE TABLE ... PRIMARY KEY kills backend

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] CREATE TABLE ... PRIMARY KEY kills backend
Date: 2000-01-12 00:01:17
Message-ID: 200001120001.TAA04995@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Hiroshi Inoue 2000-01-12 00:04:31 RE: [HACKERS] Potential vacuum bug?
Previous Message Brook Milligan 2000-01-11 23:35:24 psql -f inconsistency with "copy from stdin"