Re: [HACKERS] Module dependency on PostgeSQL version

it is running against. Whenever possible, is now uses the new protocol version information. It's much handier to just say: if (protocol=3) { ... } - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200405112153 -BEGIN PGP SIGNATURE

Re: [HACKERS] Weird prepared stmt behavior

= prepare yourself as select 1 from pg_proc; ERROR: current transaction is aborted, commands ignored until end of transaction block pgf= rollback; ROLLBACK pgf= deallocate toqualify; DEALLOCATE - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200405032114 -BEGIN PGP SIGNATURE

Re: [HACKERS] Weird prepared stmt behavior

it to get rolled back, let them commit it before going on to the rest of the actions. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200405011816 -BEGIN PGP SIGNATURE- iD8DBQFAlCIivJuQZxSWSsgRAun5AKCUWH3mb59c+iuaDMlf2U+pZG9UXACghalD 5E34MgozbiPkIYMn2tvdGFk= =oenf

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

, both hosted on cpan.org. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200404230734 -BEGIN PGP SIGNATURE- iD8DBQFAiQBDvJuQZxSWSsgRAqn5AJ4pEllgPCiTVfAcrK21r62RgD1tdACg4IHz hAb4LBiqlIMbBF2bsXdZDDI= =xPFb -END PGP SIGNATURE- ---(end

Re: [HACKERS] Solaris initdb fails: shmmax tweak alternative?

affects their performance, that would be helpful in my argument to bump it up for the PG install. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200404050713 -BEGIN PGP SIGNATURE- iD8DBQFAcUE6vJuQZxSWSsgRAr80AKC/SVVm4unhMOh+Z0+rhDqn8zGSigCg5hve iKhSKUt6N7qNhuq9WRO/EH4

Re: [HACKERS] Solaris initdb fails: shmmax tweak alternative?

the problem was). Thanks for the replies: I am going to push for a shmmax boost and go from there. Less pain in the long run. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200404052013 -BEGIN PGP SIGNATURE- iD8DBQFAcfbavJuQZxSWSsgRAr1SAJ0QZ9/Ur2NGmLnHJLzEqZ/grjq0kwCg3XpD

[HACKERS] Solaris initdb fails: shmmax tweak alternative?

this limitation? I know that 50 is pretty low, but the recommended way (changing shmmax) involves rebooting a production machine and, while possible, is not preferred. (This is for a very small database, and having a very low shared buffers is acceptable.) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key

Re: [HACKERS] [GENERAL] Check for prepared statement

to the lack of response on general) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200402172039 -BEGIN PGP SIGNATURE- iD8DBQFAMsKDvJuQZxSWSsgRAtbeAJ9mmm3TKSU/hLc+oN3RREzCnM7kkQCfS4TS 6UoHDhGLc8kNyG7F/pT/6IM= =Lg+O -END PGP SIGNATURE

[HACKERS] Adding help to psql

making help work in psql, but cannot remember the final outcome. Any chance we can revisit it? I think it would be a worthwhile addition. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200401041442 -BEGIN PGP SIGNATURE- iD8DBQE

[HACKERS] ctid matching behavior changed?

on pg_class (cost=0.04..4.05 rows=2 width=4) (actual time=0.00..0.00 rows=0 loops=1) Filter: (ctid = $0) InitPlan - Limit (cost=0.00..0.04 rows=1 width=6) (never executed) - Seq Scan on pg_class (cost=0.00..9.30 rows=230 width=6) (never executed) -- Greg Sabino Mullane [EMAIL

[HACKERS] Archive links slightly redundant

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 The archives for the following mailing lists appear to have two identical links to November 2002: admin advocacy announce bugs cygwin Here's one of them: http://archives.postgresql.org/pgsql-announce/ Greg Sabino Mullane [EMAIL PROTECTED] PGP

[HACKERS] Wanted: RelationIsVisible interface

with the RelationIsVisible stuff when somebody writes a SQL interface to it (or I write it myself, but that will take quite a long time :) Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200208091839 -BEGIN PGP SIGNATURE- Comment: http://www.turnstep.com/pgp.html

Re: [HACKERS] Proposal for psql wildcarding behavior w/schemas

Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200208091849 -BEGIN PGP SIGNATURE- Comment: http://www.turnstep.com/pgp.html iD8DBQE9VEb6vJuQZxSWSsgRAsHNAKDCXz4vUY1A79EaVmfPIfcNS7VyxgCaA5Tx HrNmY0vITbb2G1fZFBCPgBM= =qhYp -END PGP SIGNATURE- ---(end

[HACKERS] Postgres idea list

and developers about Postgres. Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200206251441 -BEGIN PGP SIGNATURE- Comment: http://www.turnstep.com/pgp.html iD8DBQE9GL2ovJuQZxSWSsgRAgKLAJ9zBJhw0SzDu0eXUhGSPuncGXGGdQCgua14 IC2aWSjcSEHYxDU1hZXnZmA= =GV5l -END PGP SIGNATURE

[HACKERS] psql not showing triggers

, maybe?: http://developer.postgresql.org/TODO/docs/cvs.html Thanks, Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200110060755 -BEGIN PGP SIGNATURE- Comment: http://www.turnstep.com/pgp.html iQA/AwUBO77yubybkGcUlkrIEQKYCQCfW9SRNR3WqeHQyDlZ5QT67I7y0MoAn2zg

<    1   2   3   4   5