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

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

From: Ari Entlich <atrigent(at)ccs(dot)neu(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6612: Functions can be called inside CHECK statements
Date: 2012-04-25 20:25:11
Message-ID: 3125270.869581335385510960.JavaMail.root@zimbra (view raw or whole thread)
Lists: pgsql-bugs
Wow, so I guess I'm pretty much wrong about this... Sorry for the noise guys. I failed to consider different uses for functions, obviously, and it's not possible to automatically detect usages which could cause problems.

Perhaps this is more of a bug in the documentation than anything else. I couldn't find any documentation for the behavior for what will happen if a query is executed inside a function which is called from a check statement. I also couldn't find anything about calling function inside check statements in general, but perhaps that's not necessary. 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.




pgsql-bugs by date

Next:From: Tom LaneDate: 2012-04-25 21:28:24
Subject: Re: BUG #6605: wrong type cast from timestamp to timestamptz
Previous:From: ghircoiascamilDate: 2012-04-25 19:34:11
Subject: BUG #6613: tablespace data ignored after reinstalling windows

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