Lighthouse has a new layout. Prefer the old one? Return to the old layout, and switch back any time from the link at the top of each page.

This project is archived and is in readonly mode.

IntegrityError constraint_name is empty with postgres-9.1

#206

We experienced this weird behaviour. An IntegrityError was raised (due to a foreign key constraint failing) by psycopg.

Under postgres-9.1 .diag.constraint_name is None.
Under postgres-9.3 .diag.constraint_name is properly set to the name of the constraint.

Is this expected?

Reported by Dan Milon · April 10th, 2014 @ 10:14 PM

State: invalid
Milestone: none
Assigned to: nobody

Activity

  1. Daniele Varrazzo
    Daniele Varrazzo
    • State changed from new to invalid

    Yes, it is expected. constraint_name is one of the diag fields that were added to PostgreSQL 9.3.

    April 10th, 2014 @ 11:29 PM

  2. Dan Milon
    Dan Milon

    Makes sense then, thank you!

    April 11th, 2014 @ 06:07 AM