Postgres Pro
Downloads
Home   >   mailing lists

Add schema-qualified relnames in constraint error messages. - Mailing list pgsql-hackers

From Petr Korobeinikov
Subject Add schema-qualified relnames in constraint error messages.
Date
Msg-id CAJL5ff_XSMLL+MZNAaw8nisyLrUfO_UfOde4M3ZodWcoGE-Njg@mail.gmail.com
Whole thread Raw
Responses Re: Add schema-qualified relnames in constraint error messages.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
Hackers,

At the moment schemas used as single-level namespaces.
It's quite convenient in large databases.

But error messages doesn’t contain schema names.

I have done a little patch with schema-qualified relation names in error messages that produced by foreign key constraints and triggers.

Patch and usage example are attached.
Based on real bug hunting.

Pre-reviewed by Alexander Korotkov.
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: Re: No Issue Tracker - Say it Ain't So!
Next
From: Tom Lane
Date:
Subject: Re: pg_conversion seems rather strangely defined