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

Re: BUG #6612: Functions can be called inside CHECK statements

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ari Entlich <atrigent(at)ccs(dot)neu(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6612: Functions can be called inside CHECK statements
Date: 2012-04-26 03:59:24
Message-ID: 22338.1335412764@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Ari Entlich <atrigent(at)ccs(dot)neu(dot)edu> writes:
>  I do, however, think it should definitely be documented somewhere that functions cannot be used to get around the lack of check statement subqueries, because the ordering of operations is wrong.

That statement seems to me to be complete nonsense.  You can certainly
put a query into a function invoked by CHECK.  It may be that there's
some particular use-case that this doesn't work for, but that does not
justify a blanket statement that it "doesn't work".

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Ryan KellyDate: 2012-04-26 11:42:32
Subject: ALTER TABLE ... OWNER TO does not change ownership recursively
Previous:From: piyushmDate: 2012-04-26 01:32:49
Subject: BUG #6614: pg_dump not working for tables with japanese name

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