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
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" |