Postgres Pro
Downloads
Home   >   mailing lists

Re: Is a backend id or something available for use as a foreign key? - Mailing list pgsql-sql

From Tom Lane
Subject Re: Is a backend id or something available for use as a foreign key?
Date
Msg-id 4195.1090679988@sss.pgh.pa.us
Whole thread Raw
In response to Is a backend id or something available for use as a foreign key?  (Markus Bertheau <twanger@bluetwanger.de>)
List pgsql-sql
Tree view 
Markus Bertheau <twanger@bluetwanger.de> writes:
> Is there a backend id available or something similar that would allow
> me to define a view like this:

IIRC there is a function to get your backend's PID.  It was meant for
identifying rows relevant to you in the pg_stat views, so look in that
part of the documentation.
        regards, tom lane

pgsql-sql by date:

Previous
From: Andreas Haumer
Date:
Subject: Trigger functions with dynamic SQL
Next
From: Tom Lane
Date:
Subject: Re: Trigger functions with dynamic SQL