possible constraint bug?

Thomas Swan <tswan@olemiss.edu>

From: Thomas Swan <tswan@olemiss.edu>
To: pgsql-hackers@postgresql.org
Date: 2000-08-18T19:35:05Z
Lists: pgsql-hackers
Using Postgresql 7.0.2 (Linux x86, 2.2.16)

CERATE FUNCTION foo(text)

CREATE TABLE bar(
         fud TEXT CHECK (foo(fud))
);

DROP FUNCTION foo(TEXT);
CREATE FUNCTION foo( .....);

INSERT INTO bar VALUES ('Hey'); results in the following error

ERROR init_fcache: Cache lookup failed for procedure 128384

Is this particular to postgres or is this a normal SQLxx standard behavior?
-
- Thomas Swan
- Graduate Student  - Computer Science
- The University of Mississippi
-
- "People can be categorized into two fundamental
- groups, those that divide people into two groups
- and those that don't."