| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)commandprompt(dot)com>, David Fetter <david(at)fetter(dot)org>, Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: and it's not a bunny rabbit, either |
| Date: | 2010-12-31 13:48:18 |
| Message-ID: | 1293803298.19789.2.camel@fsopti579.F-Secure.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On tor, 2010-12-30 at 11:03 -0500, Robert Haas wrote:
> No, quite the opposite. With the other approach, you needed:
>
> constraints cannot be used on views
> constraints cannot be used on composite types
> constraints cannot be used on TOAST tables
> constraints cannot be used on indexes
> constraints cannot be used on foreign tables
>
> With this, you just need:
>
> constraints can only be used on tables
At the beginning of this thread you said that the error messages should
focus on what you tried to do, not what you could do instead.
Also, in this particular case, the user could very well assume that a
TOAST table or a foreign table is a table.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stefan Kaltenbrunner | 2010-12-31 13:48:41 | Re: Sync Rep Design |
| Previous Message | Robert Haas | 2010-12-31 13:39:19 | Re: Sync Rep Design |