| From: | "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>, <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: Uniqueness of rule, constraint, and trigger names |
| Date: | 2002-03-05 02:36:10 |
| Message-ID: | GNELIHDDFBOCMGBFGEFOOEJOCBAA.chriskl@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-sql |
> 2. Constraints are not required to have any unique name at all.
> Dropping constraints is done with "ALTER TABLE tablename DROP CONSTRAINT
> constraintname", which will drop all constraints on that table that
> match the given name.
Personally, I'd like to see CHECK contraints given decent names (eg.
mytable_fullname_chk) instead of '$1', '$2', etc. This makes it much easier
to use DROP CONSTRAINT...
Also, when it comes time to let people drop FOREIGN KEY constraints, it
might be a problem that they're all generated as '<unnamed>' at the
moment...
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lincoln Yeoh | 2002-03-05 03:39:41 | Re: numeric/decimal docs bug? |
| Previous Message | Neil Conway | 2002-03-05 02:36:09 | new hash function |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew G. Hammond | 2002-03-05 06:51:38 | Re: Changing sequence cache |
| Previous Message | Thomas O'Dowd | 2002-03-05 02:13:21 | Re: [SQL] Timestamp output |