From: | "CN" <cnliou9(at)fastmail(dot)fm> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Server v7.3RC2 Dies |
Date: | 2002-11-27 12:54:06 |
Message-ID: | 20021127125407.F1FD61D46E@server2.fastmail.fm |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi!
My v7.3RC server died. Any idea?
Please note that more message following "key referenced from t40 not f3"
is truncated by telnet program.
Regards,
CN
-------------------------
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.
--
http://fastmail.fm - mmm... fastmail...
From | Date | Subject | |
---|---|---|---|
Next Message | CN | 2002-11-27 13:19:47 | Re: Server v7.3RC2 Dies |
Previous Message | Rison, Stuart | 2002-11-27 12:41:17 | Re: Cannot execute null query - answer |