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

BUG #6612: Functions can be called inside CHECK statements

From: atrigent(at)ccs(dot)neu(dot)edu
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6612: Functions can be called inside CHECK statements
Date: 2012-04-25 10:33:10
Message-ID: (view raw or whole thread)
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      6612
Logged by:          Ari Entlich
Email address:      atrigent(at)ccs(dot)neu(dot)edu
PostgreSQL version: 9.1.2
Operating system:   Windows?

Seeing as Postgres does not allow sub-queries in CHECK constraints yet, it
doesn't make any sense to me for it to allow function calls, since functions
can perform queries. Additionally, if a function is called from a check
constraint and that function executes a query, the change that caused the
check constraint to fire does not appear to be "visible" to the query.
Therefore, calling functions in check constraints does not have the ability
to check whether that change is valid, making it mostly useless.


pgsql-bugs by date

Next:From: snehal maniyarDate: 2012-04-25 13:44:02
Subject: Broken Pipe Error
Previous:From: Josh KupershmidtDate: 2012-04-23 23:51:34
Subject: Re: BUG #6609: pattern matching (version 8.2 or so...)

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