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, whole thread or download thread mbox)
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-2017 The PostgreSQL Global Development Group