Re: Server v7.3RC2 Dies
От | Neil Conway |
---|---|
Тема | Re: Server v7.3RC2 Dies |
Дата | |
Msg-id | 1038414633.1807.28.camel@tokyo обсуждение исходный текст |
Ответ на | Server v7.3RC2 Dies ("CN" <cnliou9@fastmail.fm>) |
Список | pgsql-general |
On Wed, 2002-11-27 at 07:54, CN wrote: > database1=# alter table table40 add CONSTRAINT fkt40c2 FOREIGN KEY (c2) > REFERENCES table13 (c1) ON UPDATE CASCADE ON delete cascade; > NOTICE: ALTER TABLE will create implicit trigger(s) for FOREIGN KEY > check(s) > ERROR: fkt40c2 referential integrity violation - key referenced from t40 > not f3 > database1=# copy table40 to '/tmp/table40'; > server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > The connection to the server was lost. Attempting reset: Failed. Can you get a backtrace from the core file? The core file should be located in $PGDATA/base/$oid_of_database ($oid_of_database being the OID of the database the backend was connected to). If you could recompile PostgreSQL with debugging symbols (./configure --enable-debug), that would be more useful. Also, can you get a reproducible example of the crash? I tried to reproduce it based on your other message (table2, columns c1 & c2, failed attempt to add an FK), but couldn't produce any problems... Cheers, Neil
В списке pgsql-general по дате отправления: