From: | Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
---|---|
To: | Peter Eisentraut <peter_e(at)gmx(dot)net>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Andrew Dunstan <andrew(at)dunslane(dot)net>, Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Information Schema and constraint names not |
Date: | 2003-11-06 23:54:34 |
Message-ID: | 6.0.0.22.0.20031107105014.04689af8@203.8.195.10 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
At 03:37 AM 7/11/2003, Peter Eisentraut wrote:
>It would
>already help a lot if we just added the table name, or something that was
>until a short time before the action believed to be the table name, or
>even only the table OID, before (or after) the $1.
Can we allow/bypass the pg_* restriction, and call it pg_<table-oid>_<n>,
and for pedants like me, add a DB setting that says 'enforce unique
constraints' ala the spec to avoid manually created constraints being
non-unique?
Alternatively, I would be happy *not* to enforce constraint name uniqueness
(and break the spec) so long as we also break the spec and add table OID
(or something else) to the information schema (table name would be OK so
long as renaming the table won't break anything).
----------------------------------------------------------------
Philip Warner | __---_____
Albatross Consulting Pty. Ltd. |----/ - \
(A.B.N. 75 008 659 498) | /(@) ______---_
Tel: (+61) 0500 83 82 81 | _________ \
Fax: (+61) 03 5330 3172 | ___________ |
Http://www.rhyme.com.au | / \|
| --________--
PGP key available upon request, | /
and from pgp5.ai.mit.edu:11371 |/
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2003-11-07 00:16:23 | Re: Information Schema and constraint names not |
Previous Message | Stephan Szabo | 2003-11-06 23:41:57 | Re: Deferrable triggers |