[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 -

[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

[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

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

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_twophase

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] 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 to be

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 autoconf

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

[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] 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). Specifically, I'm

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'm

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

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 After that

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. blink I fear you have 100% misunderstood the