Skip site navigation (1) Skip section navigation (2)

Re: and it's not a bunny rabbit, either

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 (view raw or flat)
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.



In response to

Responses

pgsql-hackers by date

Next:From: Stefan KaltenbrunnerDate: 2010-12-31 13:48:41
Subject: Re: Sync Rep Design
Previous:From: Robert HaasDate: 2010-12-31 13:39:19
Subject: Re: Sync Rep Design

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group