From: | Flavio Fonseca <ff(at)dr(dot)ufu(dot)br> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | sql problem |
Date: | 2004-11-05 14:34:30 |
Message-ID: | 200411051234.30961.ff@dr.ufu.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Hi,
I am having a problem with a system I developed using php with postgres.
Take a look at this:
Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
NetAdmin=# delete from operador where oplogin = 'ff';
ERROR: fk_historicosessao_operador referential integrity violation - key in
operador still referenced from historicosessao
and then, this:
Welcome to psql 7.4.2, the PostgreSQL interactive terminal.
NetAdmin=# delete from operador where oplogin = 'ff';
ERROR: update or delete on "operador" violates foreign key constraint
"fk_historicosessao_operador" on "historicosessao"
I am not able to get a error_number in pgsql errors, only the error message.
So when I used pgsql 7.3 a used the string "referential integrity violation"
to detect this error, but on version 7.4 of pgsql this string was replaced
with "violates foreign key constraint" .
Anyone has a definitive solution on this or the way is to wait and change all
my code on future releases of pgsql?
Thank you all for the attention.
--
Att.
Flavio Fonseca
Administrador de Redes
Divisao de Redes
Universidade Federal de Uberlandia
From | Date | Subject | |
---|---|---|---|
Next Message | Igor Maciel Macaubas | 2004-11-05 14:35:58 | Help in stored procedure |
Previous Message | SZŰCS Gábor | 2004-11-05 13:29:30 | Re: Delayed result from another connection |