Re: [GENERAL] referential integrity constraints not checked inside

2004-05-13 Thread Christian Rank
Tom Lane wrote: > Christian Rank <[EMAIL PROTECTED]> writes: > >>... according to the docs, the validity of a constraint should be >>checked after each statement unless this behaviour is altered with a SET >>CONSTRAINTS statement. > > > "Statement&

Re: [GENERAL] referential integrity constraints not checked inside

2004-05-13 Thread Christian Rank
Patrick Welche wrote: > On Thu, May 13, 2004 at 11:41:24AM +0200, Christian Rank wrote: > >> create function f () returns void as ' >> begin >>delete from a; >>delete from b; >>return; >> end; >&

[GENERAL] referential integrity constraints not checked inside PL/pgSQL functions?

2004-05-13 Thread Christian Rank
#x27;. However, the function is executed without errors, and the tables a and b are empty after this operation. It seems that the validity of (integrity) constraints is not checked inside a function, only after executing a function. Is this a bug or a feature? Thanks in advance for your advice

Re: [GENERAL] ECPG - bug in EXEC SQL WHENEVER NOT FOUND?

2004-03-07 Thread Christian Rank
Michael Meskes wrote: > On Sat, Mar 06, 2004 at 09:54:13PM +0100, Christian Rank wrote: > >>Today I ran into problems when combining a C program with SQL statements >>with the ECPG interface of PostgreSQL: >> >>According to the documentation, it should be possible w

[GENERAL] isolating users from each other

2004-02-02 Thread Christian Rank
n the pg_catalog schema, but then a user can no longer access his own metadata ...) Thanks in advance, Christian -- Dr. Christian Rank Rechenzentrum Universität Passau Innstr. 33 D-94032 Passau GERMANY Tel.: 0851/509-1838 Fax: 0851/509-1802 PGP public key see http://www.rz.uni-pass