Postgres Pro
Downloads
Home   >   mailing lists

RI violation msg suggestion - Mailing list pgsql-hackers

From Ed Loehr
Subject RI violation msg suggestion
Date
Msg-id 3A2D4EF8.437FE7F4@austin.rr.com
Whole thread Raw
List pgsql-hackers
Tree view 
Minor usability/debuggability suggestion...

RI violation error messages in 7.0.0 do not appear to identify the
offending value.

Example:

ERROR:  fk_employee_currency referential integrity violation - key
referenced from employee not found in currency

Easier to debug would be:

ERROR:  fk_employee_currency referential integrity violation - key '27'
referenced from employee not found in currency

Regards,
Ed Loehr

pgsql-hackers by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: Need help with phys backed shm segments (Postgresql+FreeBSD).
Next
From: "Martin A. Marques"
Date:
Subject: Re: beta testing version