[ADMIN] lo_unlink usage

2002-03-26 Thread Richard Emberson
I'm I correct in understanding that the correct way to delete a LargeObject from within a PL/psql procedure is to call: lo_unlink(oid); Are there any other issues? Thanks. Richard ---(end of broadcast)--- TIP 1: subscribe and unsubscribe comma

[ADMIN] Use ident sameuser?

2002-03-26 Thread William C. Rowden
Is anyone using AUTH_TYPE=ident with AUTH_ARGUMENT=sameuser in the PostgreSQL Host-Based Access file ("pg_hba.conf")? The documentation within that file says this: # AUTH_ARGUMENT is required: [...] # The special map name "sameuser" indicates an implied #

Re: [ADMIN] info request : listing active connections

2002-03-26 Thread Bruce Momjian
Vilson farias wrote: > Hi Bruce, > > Thanks for quick answer. It's a great feature for newer releases for > PostgreSQL, but here I'm still using 7.1.2 (and few 7.0.3), so is there some > way in older versions? > No, just ps. -- Bruce Momjian| http://candle.pha.pa.

[ADMIN] PL/pgsql -> C

2002-03-26 Thread Richard Emberson
Premise: There exists a mapping of any legal PL/pgsql procedure into the equivilent C code. Question: Has anyone every written a PL/pgsql-2-C transformer? Issues: One would really like to map the optimized PL/pgsql into C, not just the unoptimized, as coded, PL/pgsql. Optimization depends upon

Re: [ADMIN] info request : listing active connections

2002-03-26 Thread Vilson farias
Hi Bruce, Thanks for quick answer. It's a great feature for newer releases for PostgreSQL, but here I'm still using 7.1.2 (and few 7.0.3), so is there some way in older versions? Best regards. - Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Vilson farias" <[EMAIL P

Re: [ADMIN] info request : listing active connections

2002-03-26 Thread Bruce Momjian
Vilson farias wrote: > Greetings, > > I've been looking for a way to list active connections from > clients to the postmaster. What kind of features does postgresql > has to make it possible? I would like to list users, ips and > maybe calling application and plataform. Now, the only way

[ADMIN] info request : listing active connections

2002-03-26 Thread Vilson farias
Greetings,     I've been looking for a way to list active connections from clients to the postmaster. What kind of features does postgresql has to make it possible?  I would like to list users, ips and maybe calling application and plataform. Now, the only way I know is through ps -ef | grep