Re: [HACKERS] 2PC-induced lockup

2007-07-10 Thread Tom Lane
[EMAIL PROTECTED] writes: > On Tue, Jul 10, 2007 at 10:41:31AM -0400, Tom Lane wrote: >> Right offhand, clearing pg_twophase while the system is stopped should >> be safe enough. > It might make sense then to clear the pg_twophase directory on DB > startup. I fear you have 100% misunderstood th

Re: [HACKERS] 2PC-induced lockup

2007-07-10 Thread tomas
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, Jul 10, 2007 at 10:41:31AM -0400, Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > The following command sequence appears to lock up the database system: > > BEGIN; > > LOCK pg_authid; > > PREPARE TRANSACTION 'foo'; > > \q >

Re: [HACKERS] GSSAPI patch

2007-07-10 Thread Tom Lane
"Henry B. Hotz" <[EMAIL PROTECTED]> writes: > I just DL'ed the "2007-07-10 08:16:17" snapshot and I don't see any > reference to "gss" or "GSS" in configure.in. Should I wait for > tomorrow's snapshot tarball? Either that or pull from the CVS server, cf http://developer.postgresql.org/pgdocs/

Re: [HACKERS] GSSAPI patch

2007-07-10 Thread Henry B. Hotz
On Jul 10, 2007, at 7:49 AM, Magnus Hagander wrote: On Tue, Jul 10, 2007 at 10:43:22AM -0400, Tom Lane wrote: Magnus Hagander <[EMAIL PROTECTED]> writes: I'd appreciate it if people can run tests with this on some other platforms (I've only tested on Ubuntu linux and Win32). Specifically, I'

Re: [HACKERS] GSSAPI patch

2007-07-10 Thread Magnus Hagander
Stefan Kaltenbrunner wrote: > Magnus Hagander wrote: >> On Tue, Jul 10, 2007 at 10:43:22AM -0400, Tom Lane wrote: >>> Magnus Hagander <[EMAIL PROTECTED]> writes: I'd appreciate it if people can run tests with this on some other platforms (I've only tested on Ubuntu linux and Win32). Speci

[HACKERS] Tipos abstractos definidos por el usuarios

2007-07-10 Thread Livia Carolina
Estoy interesada en saber como se hace tratamiento de Objetos en postgresql; especìficamente necesito saber como se encapsulan data y metodos en una clase y las primitivas para lograrlo así como puedo definir tipos donde se encapsulen datos con mètodos y se declaren referncias (apuntadores)

[HACKERS] Tipos abstractos definidos por el usuarios

2007-07-10 Thread Livia Carolina
Estoy interesada en saber como se hace tratamiento de Objetos en postgresql; especìficamente necesito saber como se encapsulan data y metodos en una clase y las primitivas para lograrlo así como puedo definir tipos donde se encapsulen datos con mètodos y se declaren referncias (apuntadores)

Re: [HACKERS] Updated tsearch documentation

2007-07-10 Thread Bruce Momjian
Thanks, I applied this patch and rebuild HTML version. I was wondering how I was going to make all the changes accurately. ;-) --- Nicolas Barbier wrote: > 2007/7/7, Bruce Momjian <[EMAIL PROTECTED]>: > > > FYI, I have ma

Re: [HACKERS] GSSAPI patch

2007-07-10 Thread Stefan Kaltenbrunner
Magnus Hagander wrote: > On Tue, Jul 10, 2007 at 10:43:22AM -0400, Tom Lane wrote: >> Magnus Hagander <[EMAIL PROTECTED]> writes: >>> I'd appreciate it if people can run tests with this on some other platforms >>> (I've only tested on Ubuntu linux and Win32). Specifically, I'm certain >>> that the

Re: [HACKERS] GSSAPI patch

2007-07-10 Thread Magnus Hagander
On Tue, Jul 10, 2007 at 10:43:22AM -0400, Tom Lane wrote: > Magnus Hagander <[EMAIL PROTECTED]> writes: > > I'd appreciate it if people can run tests with this on some other platforms > > (I've only tested on Ubuntu linux and Win32). Specifically, I'm certain > > that the autoconf stuff will need t

Re: [HACKERS] GSSAPI patch

2007-07-10 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > I'd appreciate it if people can run tests with this on some other platforms > (I've only tested on Ubuntu linux and Win32). Specifically, I'm certain > that the autoconf stuff will need to be expanded a bit in order to work for > them all. What sort of

Re: [HACKERS] 2PC-induced lockup

2007-07-10 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > The following command sequence appears to lock up the database system: > BEGIN; > LOCK pg_authid; > PREPARE TRANSACTION 'foo'; > \q > After that you can't connect anymore, even in single-user mode. The > only way I could find is to clear out the pg_t

Re: [HACKERS] 2PC-induced lockup

2007-07-10 Thread Hans-Juergen Schoenig
is it good to allow locks on system tables at all? i am not so sure. have seen some disaster in the past with that. just consider somebody placing ACCESS EXCLUSIVE LOCK on a system table. it is basically denial of service. best regards, hans On Jul 10, 2007, at 3:

[HACKERS] GSSAPI patch

2007-07-10 Thread Magnus Hagander
I have applied the latest version of the GSSAPI patch with only minor further fixes. I'm still working on the documentation part and will make a separate commit with that as soon as I can. I'd appreciate it if people can run tests with this on some other platforms (I've only tested on Ubuntu linu

[HACKERS] 2PC-induced lockup

2007-07-10 Thread Peter Eisentraut
The following command sequence appears to lock up the database system: BEGIN; LOCK pg_authid; PREPARE TRANSACTION 'foo'; \q After that you can't connect anymore, even in single-user mode. The only way I could find is to clear out the pg_twophase directory, but I'm not sure whether it is safe t

[HACKERS] Man Lebt nur einmal - probiers aus ! of clarity I think -- who've faced the

2007-07-10 Thread Shelby Epps
Verpassen Sie nichts am Lebem - Sie werden fuhlen was unsere Kunden bestatigen! Preise die keine Konkurrenz kennen - keine versteckte Kosten - Visa verifizierter Onlineshop - Kein peinlicher Arztbesuch erforderlicht - Kostenlose, arztliche Telefon-Beratung - Diskrete Verpackung und Zahlung - Kei