| From: | Petr Korobeinikov <pkorobeinikov(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Add schema-qualified relnames in constraint error messages. |
| Date: | 2016-01-06 01:00:07 |
| Message-ID: | CAJL5ff_XSMLL+MZNAaw8nisyLrUfO_UfOde4M3ZodWcoGE-Njg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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 | Content-Type | Size |
|---|---|---|
| namespaced-relname.diff | text/plain | 44.5 KB |
| example.sql | application/octet-stream | 443 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2016-01-06 01:02:16 | Re: pg_conversion seems rather strangely defined |
| Previous Message | Michael Paquier | 2016-01-06 00:53:08 | Re: No Issue Tracker - Say it Ain't So! |