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

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] CREATE TABLE ... PRIMARY KEY kills backend
Дата
Msg-id 200001120001.TAA04995@candle.pha.pa.us
обсуждение исходный текст
Ответ на CREATE TABLE ... PRIMARY KEY kills backend  ("Oliver Elphick" <olly@lfix.co.uk>)
Список 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 по дате отправления:

Предыдущее
От: "Hiroshi Inoue"
Дата:
Сообщение: RE: [HACKERS] Potential vacuum bug?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] CREATE TABLE ... PRIMARY KEY kills backend