Re: Server v7.3RC2 Dies

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