This is great! I have been looking for this too... I think this should go in the
manual as an example of how application sessions can be recorded in the db. Very
useful!
/M
----- Original Message -----
From: "TANIDA Yutaka" <[EMAIL PROTECTED]>
To: "Boris Popov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, November 10, 2003 2:41 AM
Subject: Re: [GENERAL] Temp rows - is it possible?
> I found one way to do by combining temporary table and inhertis.
> Temporary table will automatically dropped when disconnects, and
> table can show inherited tables result, too.I assume SQL_Inheritance is
> on.
>
> Or you can use union too.
>
> ex.
>
> create table a(...);
> insert into a(...); # fixed values
>
> create table b() inherits (a);
> insert into b values(...); # temporary values
>
> select * from a; # You can get both global and temporary values.
>
>
>
> On Fri, 07 Nov 2003 13:09:15 -0800
> Boris Popov <[EMAIL PROTECTED]> wrote:
>
> > Hello pgsql-general,
> >
> > I'm trying to implement a table with rows that are automatically
> > deleted when the session that inserted them disconnects, sort of like
> > our own alternative to pg_stat_activity. Is it possible and what
> > approach should I be trying to achieve such a thing?
> >
> > Thanks!
> >
> > --
> > -Boris
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 9: the planner will ignore your desire to choose an index scan if your
> > joining column's datatypes do not match
>
> --
> TANIDA Yutaka <[EMAIL PROTECTED]>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
>
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
