[GENERAL] [Fedora Core 1] yum repositories with 7.4?

2003-12-03 Thread Boris Popov
Hello pgsql-general, It appears 7.4 is not published in all the usual places so I was wondering if there's a yum repository with updated packages available and if not then what's the approach that will cause the least amount of pain? I do realize I'll need to dump/restore, just want some expert ad

Re: [GENERAL] Temp rows - is it possible?

2003-11-10 Thread Boris Popov
Hello Bruce, Monday, November 10, 2003, 11:08:47 AM, you wrote: BM> Tom Lane wrote: >> Bruce Momjian <[EMAIL PROTECTED]> writes: >> > Tom Lane wrote: >> >> We recently decided we had to forbid foreign-key references from temp >> >> tables to permanent tables because of this effect. I wonder whet

Re: [GENERAL] Temp rows - is it possible?

2003-11-07 Thread Boris Popov
Hello Dennis, Friday, November 7, 2003, 1:29:32 PM, you wrote: DG> Boris Popov 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 >>o

[GENERAL] Temp rows - is it possible?

2003-11-07 Thread Boris Popov
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 -

[GENERAL] Help with "locking" please

2003-11-06 Thread Boris Popov
Hello, Here's a scenario I am trying to find a solution for. I have a contacts table individual rows of which can be edited in our app. I'd like to be able to mark a row as 'opened by someone else' when editor is opened and un-mark it when window is closed. No problems there, I could add a procpid

[GENERAL] pid of current session?

2003-11-06 Thread Boris Popov
Hello pgsql-general, Is there a way to tell which session from 'select * from pg_stat_activity' is a current session? Obviously if there's way to find out pid of a current session by some other means I could then look the rest in pg_stat_activity. Thanks! -- -Boris ---

Re: [GENERAL] pid of current session?

2003-11-06 Thread Boris Popov
Hello, Thursday, November 6, 2003, 1:48:25 PM, I wrote: BP> Is there a way to tell which session from 'select * from BP> pg_stat_activity' is a current session? Obviously if there's way BP> to find out pid of a current session by some other means I could BP> then look the rest in pg_stat_activity