[HACKERS] Adding help to psql

2004-01-04 Thread Greg Sabino Mullane
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

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

2004-02-17 Thread Greg Sabino Mullane
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] Solaris initdb fails: shmmax tweak alternative?

2004-04-04 Thread Greg Sabino Mullane
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] Solaris initdb fails: shmmax tweak alternative?

2004-04-05 Thread Greg Sabino Mullane
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?

2004-04-05 Thread Greg Sabino Mullane
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

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

2004-04-23 Thread Greg Sabino Mullane
, 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] Module dependency on PostgeSQL version

2004-05-11 Thread Greg Sabino Mullane
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

2004-05-01 Thread Greg Sabino Mullane
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] Weird prepared stmt behavior

2004-05-03 Thread Greg Sabino Mullane
= 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] Call for 7.5 feature completion

2004-05-18 Thread Greg Sabino Mullane
a developer's perspective. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200405182046 -BEGIN PGP SIGNATURE- iD8DBQFAqq6GvJuQZxSWSsgRAuruAKCkzWbtYcfu9DR+f4JUHKPWjaPiswCg/Vcf ZGLywaE2OOgr3Mk+Kua1fUA= =vqHP -END PGP SIGNATURE- ---(end of broadcast

[HACKERS] Archive links slightly redundant

2002-11-29 Thread Greg Sabino Mullane
-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] Postgres idea list

2002-06-25 Thread Greg Sabino Mullane
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] Wanted: RelationIsVisible interface

2002-08-09 Thread Greg Sabino Mullane
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

2002-08-09 Thread Greg Sabino Mullane
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] psql not showing triggers

2001-10-06 Thread Greg Sabino Mullane
, 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

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

2004-06-06 Thread Greg Sabino Mullane
, dbdpg_2, etc. and the increment is increased only after a statement is created successfully. There is also support for user-created (and user-named) statements, with the caveat that it is up to the user, not DBD::Pg, to watch for name collisions. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key

[HACKERS] Improving postgresql.conf

2004-06-09 Thread Greg Sabino Mullane
here before it starts to put data ## into temporary files. Also, several running sessions could be doing sort operations ## simultaneously. So the total memory used could be many times the value set here. work_mem = 1024 - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8

Re: [HACKERS] Improving postgresql.conf

2004-06-10 Thread Greg Sabino Mullane
them in postgresql.conf. We do that for psql's use of \help now, so it seems this is possible. I'm not sure this is the way to go. The SGML should be more detailed, and also assumes that you are reading it in a different context than from within the configuration file. - -- Greg Sabino Mullane

Re: [HACKERS] Improving postgresql.conf

2004-06-15 Thread Greg Sabino Mullane
in favor of a simple what you see is what you get behavior, just like every other configuration file. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200406151936 -BEGIN PGP SIGNATURE- iD8DBQFAz4iBvJuQZxSWSsgRAkO8AKD7t4qdWbeqs7aAuw5ZsQOsKUwGQACfb0/Y x+vvo6KZ2NgZ9i

Re: [HACKERS] PREPARE and transactions

2004-06-23 Thread Greg Sabino Mullane
they last until an explicit deallocate, the simple use of unique names makes it fairly easy on the application side. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200406232330 -BEGIN PGP SIGNATURE- iD8DBQFA2krxvJuQZxSWSsgRAhLSAJ9othitQerDlB9+J65rVl3EbRT9+QCeJfzH vFdWCDLvxU

Re: [HACKERS] PREPARE and transactions

2004-06-25 Thread Greg Sabino Mullane
to a invalid statement name. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200406252215 -BEGIN PGP SIGNATURE- iD8DBQFA3ODAvJuQZxSWSsgRAun9AKCAy13RU4mJ14J9bihiPVm15kvitACghTKv GgSrqeg9MRROXEwP+AuLSqM= =Tq9h -END PGP SIGNATURE- ---(end

Re: [HACKERS] Adding column comment to information_schema.columns

2004-07-01 Thread Greg Sabino Mullane
and Stephan have made enough concrete points that the answer to that has to be stick to the standard. If there is that much clamor for this, why not make a new schema, such as pginformation_schema People could then tweak the views to their heart's content, while keeping 100% compliance. - -- Greg Sabino

Re: [Re] Re: [HACKERS] PREPARE and transactions

2004-07-02 Thread Greg Sabino Mullane
alternative. Prepare statements already break the rules anyway, by the fact that a commit() after a prepare does not make them available to any other people viewing the database. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200407021729 -BEGIN PGP SIGNATURE

Re: [HACKERS] working on support triggers on columns

2004-07-02 Thread Greg Sabino Mullane
. Thanks for the work: hopefully this will make it into 7.6 (8.1 ?) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200407021828 -BEGIN PGP SIGNATURE- iD8DBQFA5eLpvJuQZxSWSsgRAmSWAKCIjN3nbtZMqWZ3rCCirjYDG0meogCgrnMD +qVc1lfPJ8epbvKMacC3YD4= =e2pq -END PGP SIGNATURE

Re: [HACKERS] Creating a selective aggregate ??

2004-07-03 Thread Greg Sabino Mullane
LOOP; IF endday IS NOT NULL THEN RETURN NEXT startday || \' - \' || endday; END IF; RETURN; END; ' LANGUAGE plpgsql; - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200407031237 -BEGIN PGP SIGNATURE

Re: [Re] Re: [HACKERS] PREPARE and transactions

2004-07-04 Thread Greg Sabino Mullane
to know about them, as all of this prepare/execute stuff is rather new and undertested. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200407041434 -BEGIN PGP SIGNATURE- iD8DBQFA6E8uvJuQZxSWSsgRAivsAJwIBtULWbqxIxenRee16iIBtTDvywCfUDNT pT7cVKHpmq0/Torj+yZkSWA= =NzIl

Re: [Re] Re: [HACKERS] PREPARE and transactions

2004-07-06 Thread Greg Sabino Mullane
PREPARE and DEALLOCATE are so perfect the way they are: outside of transactions. Although I think Tom mentioned that deallocating a statement that did not exist should raise a notice and not change the transaction status, which I would totally agree with. - -- Greg Sabino Mullane [EMAIL PROTECTED

Re: [HACKERS] Nested Transactions, Abort All

2004-07-11 Thread Greg Sabino Mullane
version (now in cvs) will report back the SQLSTATE. It will probably go beta in a couple of weeks and eventually become version 1.33. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200407102121 -BEGIN PGP SIGNATURE- iD8DBQFA8e5QvJuQZxSWSsgRAo5TAKDD1OX5xV4mfyUC8RAt

Re: [HACKERS] Open items

2004-08-03 Thread Greg Sabino Mullane
something like this: PREPARE mystatement AS SELECT * FROM pg_class WHERE relanem = $1 which will make driver writers very, very happy. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200408021700 -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.5 (MingW32

Re: [HACKERS] Open items

2004-08-05 Thread Greg Sabino Mullane
will certainly yield to Core's decision. I'm still hoping someone else will step up to the plate and tackle this: I feel that it would be nice not to confuse a whole new group of users with commented-out defaults which may or may not have a relation to the actual setttings. :) - -- Greg Sabino

[HACKERS] psql questions: SQL, progname, copyright dates

2004-08-27 Thread Greg Sabino Mullane
could check out the 'progname' var and see if I overlooked something. 6. Can someone run that magic year-changing update script mentioned earlier? The dates should be 2004, not 2003. Thanks, - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200408271906 -BEGIN PGP SIGNATURE

Re: [HACKERS] psql questions: SQL, progname, copyright dates

2004-08-29 Thread Greg Sabino Mullane
. -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200408290833 -BEGIN PGP SIGNATURE- iD8DBQFBMc3HvJuQZxSWSsgRAiL0AKD7E/nT9f1vCuhuh1pZiyvjgUAJEQCgkxDg jq/ABuHdXb2uDaspHdPJ7ls= =MCkP -END PGP SIGNATURE- ---(end of broadcast

Re: [HACKERS] psql questions: SQL, progname, copyright dates

2004-08-29 Thread Greg Sabino Mullane
created, or simply because I want to view all 12 quickly. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200408291827 -BEGIN PGP SIGNATURE- iD8DBQFBMlj2vJuQZxSWSsgRAtOIAJ4mpzC/pSzDcVSjRSecwoGVYUOScgCg150m m4qpZuc7wT0998bNyPQWU6E= =yXLQ -END PGP SIGNATURE

Re: [HACKERS] psql questions: SQL, progname, copyright dates

2004-09-05 Thread Greg Sabino Mullane
this more clear as well. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200409051221 -BEGIN PGP SIGNATURE- iD8DBQFBOz0TvJuQZxSWSsgRAmdhAKCke2FfyB58/2dGoQF3Z+qmfNq3swCglmk9 aHa4jh1T2fzfCQ7XRQIlhLM= =r5Qb -END PGP SIGNATURE- ---(end of broadcast

Re: [HACKERS] psql questions: SQL, progname, copyright dates

2004-09-09 Thread Greg Sabino Mullane
t|i|v|s|S thing has been broken up, and the S objects are grouped together. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200409090737 -BEGIN PGP SIGNATURE- iD8DBQFBQECGvJuQZxSWSsgRAgG5AJ9EYY1+s42wBsrF+Q2g1Jpu2F+M2wCgvkB0 /prkBWW1Z7Mqc2KRtDyf0vo= =8muz -END PGP

Re: [HACKERS] psql questions: SQL, progname, copyright dates

2004-09-09 Thread Greg Sabino Mullane
describe table, view, sequence, or index Very good idea. I guess I am once again in the 'S' camp, after a brief foray into '' land. Sorry, Bruce! :) I'll keep working on the patch when I have the time. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200409091808 -BEGIN PGP

[HACKERS] libpq and prepared statements progress for 8.0

2004-09-13 Thread Greg Sabino Mullane
a SQL parser, that's the backend's job, so we need a way to force unknown, or a way to return the data types back to us when we prepare a statement. The latter is on the 8.0 todo list, but have not seen any progress onit) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200409132114

Re: [HACKERS] libpq and prepared statements progress for 8.0

2004-09-20 Thread Greg Sabino Mullane
(DBD::Pg), and we've never really had an issue with libpq until now, and it's getting fixed, so no worries. [1] Well, C and pseudo-C XS code anyway. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200409202318 -BEGIN PGP SIGNATURE

Re: [HACKERS] PL/PgSQL for counting all rows in all tables.

2004-09-28 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 My version: ANALYZE; SELECT n.nspname, relname, reltuples FROM pg_class c, pg_namespace n WHERE c.relnamespace=n.oid AND relkind='r' AND NOT n.nspname ~ '^pg_' ORDER BY 1,2; - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8

Re: [HACKERS] Time off

2004-10-19 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Has a MySQL backend unfortunately - maybe I can convert them :) We might not let you back otherwise! :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200410192349 -BEGIN PGP SIGNATURE

Re: [HACKERS] How to check the postgresql version

2004-11-22 Thread Greg Sabino Mullane
and PQserverVersion in interfaces/libpq/fe-connect.c for more details. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200411222127 -BEGIN PGP SIGNATURE- iD4DBQFBoqBJvJuQZxSWSsgRAleLAJQOmBAN69x7A/79IGiAV6T0GZt5AKDDDTFw WWXPNFSsUp/iRNgM/Mgy1g== =QV4u -END PGP SIGNATURE

Re: [HACKERS] Opinions on Usenet ...

2004-11-29 Thread Greg Sabino Mullane
a broken implementation of the former. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200411290939 -BEGIN PGP SIGNATURE- iD8DBQFBqzU+vJuQZxSWSsgRAnWBAKCxND6C6HYplw+DO/FO3F0JIbMbeQCg4JHM Sp/jKz0wodd4layMgdjLfbk= =c/1R -END PGP SIGNATURE

Re: [HACKERS] Schedule for 8.1 feature freeze

2005-06-21 Thread Greg Sabino Mullane
not be a problem. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200506211841 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCuJe+vJuQZxSWSsgRAkSnAKDhwsRXoupe1DhHGgCYrquimK9CJQCgz1K5 /nHRvPxNs+41vxs7G9ngvW4= =C+M3 -END PGP

Re: [HACKERS] pg_get_prepared?

2005-07-15 Thread Greg Sabino Mullane
statements it has already prepared (after all, they cannot span connections). Seems a waste of resources to make a separate call to the database for information you should already know. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200507151017 https://www.biglumber.com/x/web?pk

Re: [HACKERS] Sleep functions

2005-08-21 Thread Greg Sabino Mullane
[u], I don't need it any more. :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200508212134 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDCSwOvJuQZxSWSsgRAhzAAJ9mXYOWLyhB7/IICDKk3avZkYstQACg3FNm 1a8uSRArDhytzdbHIceQGFc

Re: [HACKERS] Sleep functions

2005-08-22 Thread Greg Sabino Mullane
it for? To properly emulate other, slower, RDBMSs? :) To simulate long-running queries without actually invoking them, and to simulate concurrency of shorter queries. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200508221055 https://www.biglumber.com/x/web?pk

Re: [HACKERS] TODO questions

2005-08-24 Thread Greg Sabino Mullane
of simply uncommenting *all* settings, which would make things very clear and also make our conf file work like most others. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200508241037 https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP

Re: [HACKERS] API like mysql_ping

2005-08-25 Thread Greg Sabino Mullane
'pingtest' if it returns PQTRANS_IDLE. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200508250940 https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEARECAAYFAkMNymsACgkQvJuQZxSWSsjm2gCgt+4pdyd5GiFjyJeDqNSbR14C

Re: [HACKERS] TODO questions

2005-08-25 Thread Greg Sabino Mullane
clear exactly what will happen on reload. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200508250958 https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEARECAAYFAkMNzrsACgkQvJuQZxSWSsgbPgCgqTEOjdxhJ1TCA/Fnl9UGFo/C

Re: [HACKERS] TODO list comments

2005-08-25 Thread Greg Sabino Mullane
than that, multi-line queries work just fine. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200508250952 https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEARECAAYFAkMNzTAACgkQvJuQZxSWSshB8gCgvOU3rZi1uwFnwXO2zVz6KjUG

Re: [HACKERS] Stuff running slooow

2005-08-26 Thread Greg Sabino Mullane
shouldn't repeat any questions you already sent in). I have no idea how hard it is to do, but it sure seems like it would make things more pleasant all around. Even just adding that text to the welcome message would help a lot for the current system. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP

Re: [HACKERS] uuid type for postgres

2005-09-08 Thread Greg Sabino Mullane
the paragraphs above, I could see a use for it), I'd rather do something like picking from a predetermined range of values at random and deplete the pool as you go rather than create large values with a low (but finite) probability of collision. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key

Re: [HACKERS] Questions about proper newline handling in psql output

2005-09-26 Thread Greg Sabino Mullane
samples with a third column (and a large 2nd one) might be nice. Thanks for tackling this, it should be a nice improvement. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200509262011 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [HACKERS] Last call for back-branch fixes

2005-10-03 Thread Greg Sabino Mullane
Index: fe-exec.c === RCS file: /projects/cvsroot/pgsql/src/interfaces/libpq/fe-exec.c,v retrieving revision 1.175 diff -c -r1.175 fe-exec.c *** fe-exec.c 24 Sep 2005 17:53:28 - 1.175 --- fe-exec.c 3 Oct 2005 12:49:08

Re: [HACKERS] Last call for back-branch fixes

2005-10-03 Thread Greg Sabino Mullane
that tripped me up a few months ago when writing some code based on this section, and I finally remembered it when I saw your email. It's more of a nice to have, as the surrounding code should prevent the %03o from making more than 3 characters. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key

Re: [HACKERS] Vote needed: revert beta2 changes or not?

2005-10-06 Thread Greg Sabino Mullane
(and a small apology) in the release notes. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200510062202 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDRdenvJuQZxSWSsgRAniyAJ9hjJBYdGl1PttvZm1VrfR+vPnI1wCeMW/t

Re: [HACKERS] PG 8.1beta3 out soon

2005-10-10 Thread Greg Sabino Mullane
like to see it fixed for 8.1, as it's a showstopper. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200510101855 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDSvFvvJuQZxSWSsgRAuF/AJ9NFETn9KyTjjZh5qKLLyESMZkAgQCgpPHf

Re: [HACKERS] PG 8.1beta3 out soon

2005-10-11 Thread Greg Sabino Mullane
]; shift;, 0))); -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200510110838 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDS7J2vJuQZxSWSsgRAt7XAKC8D7HohA27CnaD7SVLrdKi80K49wCeI+o6 Tg9r3CSUeIV4872xuhZ0WBA= =JRAX -END PGP

Re: [HACKERS] PG 8.1beta3 out soon

2005-10-11 Thread Greg Sabino Mullane
, - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200510110941 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDS8E4vJuQZxSWSsgRAvsYAJ9cz6yNdInOY2HbGJ5LKKBRFxe97QCgwoa4 r4sJrmQ4cHPE+NyYo+9dX1A= =Kfwb -END PGP SIGNATURE

Re: [HACKERS] SHOW ALL output too wide

2005-11-26 Thread Greg Sabino Mullane
is to use the features already built-in to psql. Specifically, you can use a pager (e.g. less on unixy systems) that supports horizontal scrolling, plus \pset pager always, thus fixing the problem, regardless of what your terminal settings are. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key

[HACKERS] Windows installation notes

2005-11-26 Thread Greg Sabino Mullane
? The psql history is not saved between sessions. For pgadmin, one hint said is the 8th July instead of 8th of July - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200511261732 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [HACKERS] Patent issues and 8.1

2005-01-28 Thread Greg Sabino Mullane
why the feature should be replaced. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200501282155 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFB+vtuvJuQZxSWSsgRAnB8AKDnUsQM7xb1tRF93ehT05xg6Bf6TwCeOYn9

Re: [HACKERS] working on support triggers on columns

2005-01-28 Thread Greg Sabino Mullane
in to 8.1. Thanks, - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200501282317 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFB+w6wvJuQZxSWSsgRAr8dAKDGfpxUaqMaJr/Az0MBWQMvBc6IWQCgrZvH U2bNlnmWVYDgk3nSzL1Bil8= =5xZJ

Re: [HACKERS] [NOVICE] Last ID Problem

2005-02-02 Thread Greg Sabino Mullane
,undef,lii2,undef); print Last insert id was $newid\n; } - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200502022110 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [HACKERS] [NOVICE] Last ID Problem

2005-02-02 Thread Greg Sabino Mullane
(at this point) a quick abstraction of a nextval call between Oracle and PostgreSQL. We do go out of our way to be more compatible to MySQL by accepting just a table name, but one should really use the sequence directly, IMO. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200502030012 http

Re: [HACKERS] Patch Count?

2005-02-04 Thread Greg Sabino Mullane
about doing that. :) Not sure if I still have the script around, but I can dig it up if it's needed. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200502050103 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [HACKERS] Patch Count?

2005-02-06 Thread Greg Sabino Mullane
by Tom should get credit as a developer, even if no actual patch was submitted. I'll give it a go for 8.0 and see what number I come up with. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200502061348 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

Re: [HACKERS] Get rid of system attributes in pg_attribute?

2005-02-21 Thread Greg Sabino Mullane
. This sounds bad to me. Maybe not for things like cmin and cmax, but I use ctid a lot, and would be quite thrown off if a table suddenly were allowed to create it's own ctid column that did not behave as the current one does. Perhaps if it was called pg_ctid? 1/2 :) - -- Greg Sabino Mullane [EMAIL PROTECTED

Re: [HACKERS] TODO item: support triggers on columns

2005-03-13 Thread Greg Sabino Mullane
over my head? By the way, does anyone know what the tgattr field in pg_triggers is for? It's allocated but never populated, and would be perfect for my purposes on this patch, but I don't want to use it if it is being reserved for something else. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key

Re: [HACKERS] TODO item: support triggers on columns

2005-03-14 Thread Greg Sabino Mullane
something that can do that. I use emacs + glimpse but there are probably newer tools out there. I actually use emacs and glimpse, but not together. I won't bother to ask if emacs has a glimpse-mode: it's emacs after all, so of course it does. :) I'll have to give it a shot. Thank, - -- Greg Sabino

Re: [HACKERS] PHP stuff

2005-03-18 Thread Greg Sabino Mullane
docs evolve from them, or were they created later on? - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200503171713 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCOgExvJuQZxSWSsgRAgi0AKD5UUl3frO6uv4UBTGed/1OaZppqwCgiw12

Re: [HACKERS] \x in psql

2005-03-23 Thread Greg Sabino Mullane
I would expect it to. I would not want to see the footers chopped up further. Christopher, maybe you can describe more what behavior you would like to see? - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200503232000 http://biglumber.com/x/web?pk

Re: [HACKERS] HEAD \df doesn't show functions with no arguments

2005-03-31 Thread Greg Sabino Mullane
to have \df only show non-system functions. Since the user will in the future have to explicitly call \dfS to see the system functions, 60 extra out of 1700 should not matter too much. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200503311907 http://biglumber.com/x/web?pk

Re: [HACKERS] HEAD \df doesn't show functions with no arguments

2005-04-01 Thread Greg Sabino Mullane
behavior *and* a gratuitously different syntax. http://makeashorterlink.com/?H1FC12BCA [Google groups] - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200504010705 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [HACKERS] LEFT JOIN used in psql describe.c

2005-04-01 Thread Greg Sabino Mullane
like \df tab and \dfS tab, since the code pretty much assumes that the only differentiation of system/non-system objects occurs in pg_class objects. I'll try to get back to it next week, once DBD::Pg 1.41 is finished up. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200504012315 http

Re: [GENERAL] [HACKERS] plPHP in core?

2005-04-04 Thread Greg Sabino Mullane
. Just so we are all on the same sheet of music, DBD::Pg is a completely different animal from Pl/Perl and really has nothing to do with the discussion of adding Pl/PHP to the core. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8

Re: [HACKERS] Tab-completion feature ?

2005-04-10 Thread Greg Sabino Mullane
to rename. It's the same as: ALTER TABLE any_table RENAME mycolumn TO We can probably have the tab-completion code call up a list of column names for comparison: not sure if is worth the trouble though. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200504101714 http://biglumber.com

Re: [HACKERS] [PATCHES] Continue transactions after errors in psql

2005-04-27 Thread Greg Sabino Mullane
could simply \rollbackonerror (or whatever we're calling it today :) and silently discard the handful that happen to violate the primary key constraint and let the rest insert. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200504270754 http://biglumber.com/x/web?pk

Re: [HACKERS] [INTERFACES] DBD::Pg and .pgpass

2005-05-04 Thread Greg Sabino Mullane
can verify this. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200505040905 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCeMjQvJuQZxSWSsgRAhLjAKDwVc1nIHPaAQIME6XpRfQv9uif4wCgjk51 xGLEKTOf0S157j5halCHKNg= =T3wQ -END

Re: [HACKERS] Views, views, views! (long)

2005-05-05 Thread Greg Sabino Mullane
in a pretty fashion. If people want an easy way to look up the information, they use an interface. If not, they should learn the system catalogs. /devilsadvocate - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200505050632 http://biglumber.com/x/web?pk

Re: [HACKERS] Views, views, views! (long)

2005-05-06 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 And what about users who's interface to PostgreSQL is psql? Backslash commands. -BEGIN PGP SIGNATURE- iD8DBQFCeqzEvJuQZxSWSsgRAgkPAKC1V0Sm3Umi1eGFnoj1P5Qt26V32wCeMjLh +3LX4eUjgKdy+SOKHSRzRxQ= =mSNP -END PGP SIGNATURE-

Re: [HACKERS] Views, views, views: Summary of Arguments

2005-05-10 Thread Greg Sabino Mullane
when needed (e.g. lowercase relation names), we could certainly add additional tables and columns here, while maintaining the standard set for applications looking for them. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200505100635 http://biglumber.com/x/web?pk

[HACKERS] libpq lo_open errors when first action in connection

2005-05-12 Thread Greg Sabino Mullane
is commented out, this test will fail: $dbh-do(SELECT 123); my $W = $dbh-{pg_INV_WRITE}; my $object = $dbh-func($W, 'lo_creat'); my $handle = $dbh-func($object, $W, 'lo_open'); printf This test %s!\n, defined $handle ? worked : did not work; $dbh-disconnect; Thanks, - -- Greg Sabino Mullane [EMAIL

Re: [HACKERS] libpq lo_open errors when first action in connection

2005-05-13 Thread Greg Sabino Mullane
() method open a transaction, just like a query does. Yep, that's the basic solution - for lo_creat. Thanks again. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200505130807 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

[HACKERS] Minor issues with bitmap

2005-05-21 Thread Greg Sabino Mullane
. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200505211624 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCj5mdvJuQZxSWSsgRAmfoAKD2CkXDVM5RQWuHaGcFAjy/KjaoZwCfcaOD bgI5mcI12VtU8gPZWSLZ99A= =XidF -END PGP SIGNATURE

Re: [HACKERS] Windows installation notes

2005-12-01 Thread Greg Sabino Mullane
should be safe if so... This is because we don't support readline on windows because it breaks in most locales. Ouch. Those poor Windows users. Thanks for all your comments! Thanks for all the work you and everyone else has done on making this installer! - -- Greg Sabino Mullane [EMAIL

Re: [HACKERS] What`s wrong with the lists?

2005-12-02 Thread Greg Sabino Mullane
. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200512021436 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDkKKRvJuQZxSWSsgRAj7KAJ9lRaxONxpbFkQlDRMDDT8C5aOWtACfdZ5D 4paLbJ+QBN0ZM4NmswXcrkU= =UK+B -END PGP SIGNATURE

[HACKERS] Disparity in search_path SHOW and SET

2005-12-20 Thread Greg Sabino Mullane
search_path, quote the dollar-values, and rebuild the string. Is there an easier way? - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200512201205 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [HACKERS] Disparity in search_path SHOW and SET

2005-12-20 Thread Greg Sabino Mullane
,public - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200512201227 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDqD83vJuQZxSWSsgRAj1gAKDIRGqzD7zORJQwrxLM+oKWOiAPKgCg9/xK OGZIoWEnLdw+Qi71lKbCg0g= =0dBJ -END PGP

[HACKERS] Raising the Pl/Perl required version

2006-02-11 Thread Greg Sabino Mullane
the email right now). Being as 5.6 was released nearly six years ago, in March of 2000, I'm hoping that this won't meet too many objections. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200602111428 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP

Re: [HACKERS] Get explain output of postgresql in Tables

2006-04-12 Thread Greg Sabino Mullane
) - Bitmap Heap Scan on turnstep_mail (C=134.73..11383.79 R=1 W=38) (AT=17085.967..18941.677 R=193 L=1) I use capital letters as it makes it easier to read, especially for things like the common single loop (L=1 vs. l=1) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200604121213

[HACKERS] Demoting the width part of EXPLAIN

2006-05-07 Thread Greg Sabino Mullane
of shortening the explain output quite a bit. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200605071158 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFEXhoJvJuQZxSWSsgRAhwMAJ0fx50409xt/mbrPzlOQo9hHIFb/QCfeo6c

[HACKERS] Return results for PQexec vs PQexecP*

2006-05-17 Thread Greg Sabino Mullane
though COMMAND_OK may be more correct). - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200605170839 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFEaxqEvJuQZxSWSsgRAj2TAJ48s7kkzJqb44l6h2XrGxNfckEtcwCg9U8b ZpZjc6FLtdGu

Re: [HACKERS] String Similarity

2006-05-19 Thread Greg Sabino Mullane
. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200605191835 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFEbktUvJuQZxSWSsgRAiCtAJ9nlpqGxlYnimDPp8t5XQsc8y9RywCfZZL6 iU9iPnxHaWOvYCUD7+rK8Do= =zo3T -END PGP SIGNATURE

[HACKERS] ctid matching behavior changed?

2003-09-25 Thread Greg Sabino Mullane
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

Re: [HACKERS] Exporting type OID macros in a cleaner fashion

2006-06-24 Thread Greg Sabino Mullane
already parse pg_types.h ourselves. ;) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200606241151 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFEnWAfvJuQZxSWSsgRAjgqAKClEDrahFG5NCSrK47Ae7P13QCD+ACg1KHe

Re: [HACKERS] pgsql-patches considered harmful

2006-07-11 Thread Greg Sabino Mullane
will have both the attachment and follow-up posts for those that are interested. Proof of concept below my sig. -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200607111416 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 Weekly PostgreSQL patches summary: http

Re: [HACKERS] Three weeks left until feature freeze

2006-07-13 Thread Greg Sabino Mullane
into the core. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200607131300 End Point Corporation http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFEtn00vJuQZxSWSsgRArG0AKC+PnCbgWWE2pT/8iMVCvnq0bhfSACg3rgF

Re: [HACKERS] contrib promotion?

2006-07-14 Thread Greg Sabino Mullane
occasion for clients who needed to have sha1 instead of md5. I've had to install pgcrypto for other functions as well, so +1 for me on coring it, but at the least please consider adding in sha1. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200607141355 http://biglumber.com/x/web

Re: [HACKERS] url for TODO item, is it right?

2006-07-17 Thread Greg Sabino Mullane
? As far as I can tell, there is nothing magical about the naming schema itself that would cause such URLs to break anything. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200607170743 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

  1   2   3   4   5   >