Re: Constraint doesn't see a currently insertet record

From: KÖPFERL Robert <robert(dot)koepferl(at)sonorys(dot)at>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Constraint doesn't see a currently insertet record
Date: 2005-02-15 12:40:54
Message-ID: ED4E30DD9C43D5118DFB00508BBBA76EB165C7@neptun.sonorys.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thanks.

I managed it via a trigger.

> -----Original Message-----
> From: Michael Fuhr [mailto:mike(at)fuhr(dot)org]
> Sent: Sonntag, 13. Februar 2005 02:57
> To: KÖPFERL Robert
> Cc: pgsql-sql(at)postgresql(dot)org
> Subject: Re: [SQL] Constraint doesn't see a currently insertet record
>
>
> 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/static/plpgsql-trigger.html
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>

Browse pgsql-sql by date

  From Date Subject
Next Message George Weaver 2005-02-15 13:36:37 Re: Working with XML.
Previous Message Mihail Nasedkin 2005-02-15 11:15:51 Re: How to view the list of tables?