Re: [SQL] Constraint doesn't see a currently insertet record

2005-02-15 Thread KÖPFERL Robert
Thanks. I managed it via a trigger. > -Original Message- > From: Michael Fuhr [mailto:[EMAIL PROTECTED] > Sent: Sonntag, 13. Februar 2005 02:57 > To: KÖPFERL Robert > Cc: pgsql-sql@postgresql.org > Subject: Re: [SQL] Constraint doesn't see a currently inserte

Re: [SQL] Constraint doesn't see a currently insertet record

2005-02-12 Thread Michael Fuhr
On Fri, Feb 11, 2005 at 07:10:50PM +0100, KÖPFERL Robert wrote: > Another Idea was to make a trigger. But BTW how do I access a trigger > parameter if my trigger function must not have any parameter?? PL/pgSQL triggers can access arguments via TG_ARGV. http://www.postgresql.org/docs/8.0/

[SQL] Constraint doesn't see a currently insertet record

2005-02-11 Thread KÖPFERL Robert
Hi, yes that's my problem. I've got a table and I put lots of contraints on it so that data stays consistent. One constraint calls a fcn to do some kind of count() over that table but it omits the 'to be inserted record'. What to do? concrete problem: Suppose a table i | tel | status | ... ..|