Re: [GENERAL] Index bloat of 4x

maintenance. At the very least, it's unlikely to ever be that severe again unless you don't reindex for an equally long period of time. Come to think of it, an auto-reindex option might be nice in core someday. TODO item? - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200701171129 http

Re: [GENERAL] Subcribing to this list, what`s the secret?

to anyone else having recent subscription problems. - -- Greg Sabino Mullane [EMAIL PROTECTED] End Point Corporation PGP Key: 0x14964AC8 200612141112 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFFgXf1vJuQZxSWSsgRAhLfAKCxniJBwl04lUhqW4pm

Re: [GENERAL] a question on SQL

simultaneously bad (from a portatbility aspect) and brilliant (because it's a million times easier and faster than the alternatives). You mean second-most useful. LIMIT/OFFSET is the champion, hand down. :) - -- Greg Sabino Mullane [EMAIL PROTECTED] End Point http://www.endpoint.com/ PGP Key

Re: [GENERAL] Trapping PL/Perl spi_query_exec errors

, and make some more limited wrapper functions in pl/perl. And for the sake of the archives, it is spi_exec_query not spi_query_exec. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200611230659 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP

Re: [GENERAL] Postgresql 6.13

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, I'm from an alternative universe and I'm trying to install Postgresql 6.12. When will 6.13 be available? It's in the /extras/postgres directory on the eighth installation DVD of Duke Nukem Forever. - -- Greg Sabino Mullane [EMAIL PROTECTED

Re: [GENERAL] Majordomo drops multi-line Subject:

find to be far easier for dealing with multiple accounts. Just for the record, both Mailman and Majordomo support the nomail option. More specifically, all the Postgres lists do, and a number of subscribers are using this feature. - -- Greg Sabino Mullane [EMAIL PROTECTED] End Point Corporation PGP

Re: [GENERAL] plz unsubscribe me

of manually approving your posts, so at least change the subject line! :) Thanks, - -- Greg Sabino Mullane [EMAIL PROTECTED] End Point Corporation PGP Key: 0x14964AC8 200609181453 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [GENERAL] Majordomo drops multi-line Subject:

to be working just fine. - -- Greg Sabino Mullane [EMAIL PROTECTED] [EMAIL PROTECTED] End Point Corporation 610-983-9073 PGP Key: 0x14964AC8 200609071154 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [GENERAL] Cutting the Gborg throat

that aside, this seems to be a fairly long outage and an update would be nice. Perhaps for something as important as this a daily update could be a standard way of doing things moving forward? - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200608311059 http://biglumber.com/x/web?pk

Re: [GENERAL] plz unsubscribe me

he stirred up. - -- Greg Sabino Mullane [EMAIL PROTECTED] End Point Corporation PGP Key: 0x14964AC8 200608301626 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFE9fSmvJuQZxSWSsgRAv7/AKDiYIjZfj0zOVRyIgtjXl0JQsrECQCfTvK3 uj/ifkhRqevkX/RWov

Re: [GENERAL] Atomicity?

in -hackers ? This has some workarounds and explanations that may help: http://people.planetpostgresql.org/greg/index.php?/archives/2006/06/10.html - -- Greg Sabino Mullane [EMAIL PROTECTED] [EMAIL PROTECTED] End Point Corporation 610-983-9073 PGP Key: 0x14964AC8 200608281703 http://biglumber.com/x/web?pk

Re: [GENERAL] Cutting the Gborg throat

available? This is not a must, but a strong nice to have and having it would be a good indication that a) someone is actively working on the site, and b) someone is willing to help pgfoundry move forward in the future. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200608272100 http

Re: [GENERAL] Excluding a table from pg_dump

resepectively. Any of the four flags can be used multiple times, and they all accept POSIX-style regular expressions as well. - -- Greg Sabino Mullane [EMAIL PROTECTED] End Point Corporation PGP Key: 0x14964AC8 200608150821 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP

[GENERAL] GnuPG / PGP signed checksums for PostgreSQL 8.1.4, 8.0.8, 7.4.13, and 7.3.15

-8.1.4.tar.gz 855077b7943d791f1a013f2ffdbdfd163dac152d postgresql-test-8.1.4.tar.gz - -- Greg Sabino Mullane [EMAIL PROTECTED] http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFEjJQ0vJuQZxSWSsgRAnU7AJwKKlFRd9yoJDBkX+1z3pOVwxK6DwCgr+ap

Re: [GENERAL] New version of DBD::Pg for 8.1.4?

discoveries. Watch this list of monitor www.planetpostresql.org for updates. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200606060704 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFEhXMxvJuQZxSWSsgRAlnVAKDm4hjDPS4RywSneyNWtY2

Re: [GENERAL] UTF-8 context of BYTEA datatype??

PG version, using DDL, having a DEFAULT in your query, etc. But in general, DBD::Pg does its best to use it (and PQexecParams) whenever possible. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200605312152 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

Re: [GENERAL] National Number to text conversion

- -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200605291907 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFEe3/gvJuQZxSWSsgRAmGtAJ4/Pt2rz7uOaaaobpM05q4J/TqENgCfXwDc B5IzxhxXMC4wmr7kaxmE0js= =0FIt -END PGP SIGNATURE

Re: [GENERAL] Invoke diff from plpgsql?

://www.postgresql.org/docs/current/static/pltcl.html http://www.postgresql.org/docs/current/static/plperl.html http://www.postgresql.org/docs/current/static/plpython.html - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200605262300 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

[GENERAL] DBD::Pg 1.49 released

-1.49/ MD5 checksum: 76b9d6a2f4cbaefcba23380f83998215 DBD-Pg-1.49.tar.gz SHA1 checksum: 37c1c37a02afa00d48f8dd739d5d8502a7c40045 DBD-Pg-1.49.tar.gz Remember to do a cpansign -v before you run the Makefile.PL (see Module::Signature for more info) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP

Re: [GENERAL] enforce naming convention

want to make sure that when we create new tables we can't have the same table name in 'zref' and 'public'. Allowing two tables with the same name to exist is a prime feature of schemas, so working around that is not generally something that is done. :) - -- Greg Sabino Mullane [EMAIL PROTECTED

[GENERAL] DBD::Pg version 1.48 released

location: http://search.cpan.org/~dbdpg/DBD-Pg-1.48/ MD5 checksum: 77e56726219cccf2abb42f70c58b6eeb DBD-Pg-1.48.tar.gz SHA1 checksum: 8fc1633dd20c04bf5040a0ce768b3ffe1b00d484 DBD-Pg-1.48.tar.gz - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200604052300 http://biglumber.com/x/web

Re: [GENERAL] majordomo unmaintained, postmaster emails ignored?

to normal; please let me know if you don't start seeing messages again. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200603091925 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [GENERAL] majordomo unmaintained, postmaster emails ignored?

on the List-ID header? (Assuming you are setting up that expanded email address to help with filtering). Feel free to email me offlist as well. - -- Greg Sabino Mullane [EMAIL PROTECTED] [EMAIL PROTECTED] PGP Key: 0x14964AC8 200602281003 http://biglumber.com/x/web?pk

Re: [GENERAL] majordomo unmaintained, postmaster emails ignored?

name in question. [1] I actually use links, so there is no mouse clicking involved, but I've never been able to find a better verb to use there. :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200602282257 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

Re: [GENERAL] Any way to make PG driver obey PrintWarn?

. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200602061916 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFD5+cNvJuQZxSWSsgRAtHQAJ46pbdh3SgFak9RvHGu2ZJcOiT7OgCg7p1j vNiJP5Erc78SEFM45FSQovY= =p+Sc -END PGP SIGNATURE

Re: [GENERAL] Plans for 8.2?

a 503 error. We really need to work on that. Bad enough we don't use Postgres to do the searching. I'd better stop here before I start ranting myself. I didn't expect that 503 error when I started this letter. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200601131734 http

Re: [GENERAL] E-mail harvesting on PG lists?

is not a surefire solution, it does help. Quite a bit, as spammers generally go for the low hanging fruit. I've done tests on this, and the number of spams received is far higher for unobfuscated email addresses. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200601101538 http

Re: [GENERAL] DBlink documentation

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Is the documentation not available online somewhere? Quick version for you: http://www.gtsm.com/dblink/ - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200512170951 http://biglumber.com/x/web?pk

[GENERAL] GnuPG / PGP signed MD5 and SHA1 checksums for PostgreSQL 8.1.0

-8.1.0.tar.gz ca4034698a72a0d5f6a652a754f05e0d23ac6049 postgresql-test-8.1.0.tar.gz - -- Greg Sabino Mullane [EMAIL PROTECTED] http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDmIwYvJuQZxSWSsgRAv4jAJsHpsFmYcHDo0LRZMz1y3kOJHgZxQCg7AGz

Re: [GENERAL] 8.1, OID`s and plpgsql

Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200512042018 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDk5WBvJuQZxSWSsgRAnaaAKDswxUhZH4wHAJJDTZSBtTVNY/9/gCgk3La KWRzIVIeamQZvhr+TaFp4RY= =Nevb -END PGP SIGNATURE

Re: [GENERAL] Rebranding PostgreSQL

is going to call it Orakle? :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200511161737 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDe7TKvJuQZxSWSsgRAsHeAJ0eaiY58hbfU8CCehyNxTo5uGIu8QCgmyxL VDTXoeXupwD79/zYM+Zfgm8

Re: [GENERAL] [pgsql-advocacy] Wikipedia help requested, especially

the main image, for example) and clearly state somewhere that they are all (or which ones are) public domain? I'll be happy to add things to the commons once I have a URL to point people to as proof of public domain status. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200511131311

[GENERAL] Wikipedia help requested, especially non-English speakers

above). Thanks! - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 20051145 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDdOAPvJuQZxSWSsgRAsiLAJ4zNEM8fmzjvV6gFmYRn0GKnbqHRACfTeN7 QZxgU6xCB7qOhlEpa29Y47I= =NQh2 -END

Re: [GENERAL] Perl::DBI and interval syntax

. This is correct. Though generally not recommeded, you can switch it off with the pg_server_prepare attribute like so: $dbh-{pg_server_prepare} = 0; This will force DBD::Pg to do the quoting itself, with the subsequent penalty of speed and loss of auto type casting. - -- Greg Sabino Mullane [EMAIL

Re: [pgsql-advocacy] [GENERAL] Oracle buys Innobase

is on the radar of Sybase, Microsoft, and IBM as well. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200510170838 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDU5wKvJuQZxSWSsgRAryKAKCkK1+4raUv0MOr/TaFOJoV6Vm9sACfXHDC fRH5

Re: [GENERAL] Oracle buys Innobase

reason many people like it. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200510101028 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDSnrqvJuQZxSWSsgRAj7lAJ96I0TGpeOTFSkR91J8FLLIjU2ekgCgsM7C DfI6bse1MVYUVrW9uGl69hM= =ose4

Re: [GENERAL] DBI/DBD::Pg mem. use goes exponential

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Any ideas please? This seems well weird to me, but... I could not duplicate this. Can you provide a self-contained test case? It's not useful if we don't know what's actually in the table and what the table structure looks like. - -- Greg Sabino

[GENERAL] YAPC::Israel looking for Perl/Database speakers

it. :) -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200509211603 https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 YAPC::Israel::2006 - Call for Papers and Participation After three Perl

Re: [GENERAL] Implementing a change log

and you're done. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200509192258 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFDL3txvJuQZxSWSsgRArxSAJ9z4v+pRjULrBg4AiyD4jw7iHpE2wCg/qa0 UwTQQdH4CVfs97l4OgLUATY= =Yap5 -END

Re: [GENERAL] Email Verification Regular Expression

$route_addr); my $group = $phrase:$lwsp*(?:$mailbox(?:,\\s*$mailbox)*)?;\\s*; my $address = (?:$mailbox|$group); my $EMAILRE = qr{$lwsp*$address}; return $_[0] =~ $EMAILRE ? 1 : 0; $$; - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200509071223 https://www.biglumber.com/x/web?pk

Re: [GENERAL] insert performance riddle

mentioned debugging aids and see if you can spot a difference. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200508120941 https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [GENERAL] duplicate messages?

to it. :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200507271007 https://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iEYEARECAAYFAkLnlU8ACgkQvJuQZxSWSsjwpwCgxKKjWvtud1UdVUpkhMvEsO1x foUAniDRZxc0VQRKkwXzt9Gq/EH1SNIr =FiHA -END

[GENERAL] Wikipedia hackers wanted

for a summer project? :) I know that myself and a few others occasionally look at/ hack on the Wikipedia Postgres effort, but it would be nice if someone could coordinate it all or really give it an overhaul. And if someone *is* already doing this, please let me know, of course. - -- Greg Sabino Mullane

Re: [GENERAL] Which record causes referential integrity violation on delete

names.) ALTER TABLE customer ADD CONSTRAINT FK|invoice|id|customer|invkey FOREIGN KEY (invkey) REFERENCES invoice(id) ON DELETE RESTRICT; You can invent your own system of course, but that's one simple way to keep things sorted. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8

[GENERAL] Version 1.43 of DBD::Pg released

/listinfo/dbdpg-general - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200506230812 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFCuv9ivJuQZxSWSsgRAqBAAJ45OzDzh+imvIRgwzYgx35/Q4VmwQCdECv3

Re: [GENERAL] Perl DBI issue

version? - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200506230815 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.1 (GNU/Linux) iD8DBQFCuv+IvJuQZxSWSsgRAmfzAJ9UwSZ0+fz3bt+L2nxfZR50YoDU5QCdHUba Enqv/TzwemyCd

Re: [GENERAL] Viewing non-system objects in psql

on my part, there may be some more historical reasons. I don't think a capital S is too much work myself... :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200506181059 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

[GENERAL] Viewing non-system objects in psql

-tree) The recent patches discussion: http://makeashorterlink.com/?U2F92164B http://makeashorterlink.com/?E20A3164B (same, non-tree) Thanks, - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200506161509 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN

Re: [GENERAL] PostgreSQL vs. InnoDB performance

better than that and using properly transactioned inserts. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200506022050 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCn6mavJuQZxSWSsgRAq4JAJ9SszAYi6i+RhhS0AQTLGr/+JqI6ACgk9Dj

Re: [GENERAL] DBD::Pg for ActiveState Perl on WinXP

out here: http://www.blingforyourring.com/DBD-Pg.ppd Feedback on it welcome at [EMAIL PROTECTED] - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200505280743 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

[GENERAL] GnuPG / PGP signed checksums for PostgreSQL 8.0.2

-8.0.2.tar.gz 99ad405a5a8d9ba90d7a5c04f8cc515aad977636 postgresql-test-8.0.2.tar.gz - -- Greg Sabino Mullane [EMAIL PROTECTED] http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCkIKAvJuQZxSWSsgRAqUeAJ41CrsWYlbS5vNJKRDshmagWXIeCwCdFdnw

[GENERAL] GnuPG / PGP signed checksums for PostgreSQL 7.2.8, 7.3.10, 7.4.8, and 8.0.3

-8.0.3.tar.gz 1b65d4c87734212378cbf9635f7360d95d70bc98 postgresql-test-8.0.3.tar.gz - -- Greg Sabino Mullane [EMAIL PROTECTED] http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCkIRvvJuQZxSWSsgRAs4MAKDaXJKq30IF1UP4yCk+s6EAehbOFwCfaHUn

Re: [GENERAL] getting the ranks of items

| 20 3 | 4 | 16 3 | 7 | 16 4 | 6 | 12 5 | 1 | 10 Neither of which are terribly efficient, but that wasn't a prerequisite :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200505022047 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8

Re: [GENERAL] Deep integration of PostgreSQL with Apache

, this is a classic argument for using mod_perl. Each Apache child can connect once to the database, and stay connected as it serves requests to different clients. There is very little overhead, and if you take advantage of server-side prepares, things can run even faster. - -- Greg Sabino Mullane [EMAIL PROTECTED

Re: [Dbdpg-general] Re: [GENERAL] 'prepare' is not quite schema-safe

{addwidget}-execute($_-{partnumber}, $_-{color}); } } A simplified example, but the take home moral of all this is to be very careful when using prepare_cached (which is actually a DBI feature, not a DBD::Pg one). - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 20050509 http

[GENERAL] DBD::Pg version 1.41 released

: 19bee3f504cc79118f8085e8b46b03ffe4168590 DBD-Pg-1.41.tar.gz 3f58b53877954f5a07a08e64f6a67287 DBD-Pg-1.41.tar.gz - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200504072133 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

Re: [GENERAL] Perl and AutoCommit

... In some circumstances commit() returns false when it should return true (even though it still committed). If you find that happening, simply change it to $DB-commit(); and trust that the correct thing is indeed happening. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200503271548 http

Re: [GENERAL] Checking for schedule conflicts

.finish)) FROM sched s1, sched s2 WHERE s1.date = s2.date AND s1.start = s2.start AND s2.finish = s2.finish AND NOT s1.ctid = s2.ctid Add AND s1.date = $date as needed. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200503140639 http://biglumber.com/x/web?pk

Re: [GENERAL] Error: catalog is missing 8 attribute(s) for relid 16683

to rebuild it from a backup. This was a pretty lightly used database, and certainly all the SQL used was pretty standard (no mucking with pg_attribute directly, as a google-searched thread of this problem insinuated). - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200503060137 http

[GENERAL] PGP / GnuPg signed MD5 and SHA1 checksums for PostgreSQL version 8.0.1

-8.0.1.tar.gz 94c560ffb22966805075daaf8051936ce1056d90 postgresql-test-8.0.1.tar.gz - -- Greg Sabino Mullane [EMAIL PROTECTED] http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCI9PevJuQZxSWSsgRAkOHAKDV9/qh/kFzC44/BEJIowG9iqJieACgwgjR

[GENERAL] PGP / GnuPg signed MD5 and SHA1 checksums for PostgreSQL version 8.0.0

-8.0.0.tar.gz f9d0ddf0e76f5eaafc482f8173d51e1fbd3fd197 postgresql-test-8.0.0.tar.gz - -- Greg Sabino Mullane [EMAIL PROTECTED] http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFCI9DlvJuQZxSWSsgRAlaTAKD+jv5zdf3XqFth/h6oV5qdXqHu8gCgwDK

Re: [GENERAL] random record from small set

; -- To initially populate r2 SELECT id FROM r2 ORDER BY random() LIMIT 1; -- repeat as needed - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200502152252 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE

[GENERAL] ANNOUNCE: DBD::Pg 1.40 release candidate 1 request for testing

the last version (1.32): - Added $dbh-func($filehandle, `server_trace`) [Greg Sabino Mullane] - Added $dbh-{pg_errorlevel}. [Greg Sabino Mullane] - Fix utf8 quote() support [Dominic Mitchell [EMAIL PROTECTED]] - Added explicit support for types SQL_BOOLEAN, DATE, TIME

Re: [pgsql-www] [GENERAL] FTP mirror problems

[.win32] if I get a chance, but I am currently swamped. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200411091925 -BEGIN PGP SIGNATURE- iD8DBQFBkWAwvJuQZxSWSsgRAuKxAJ0eVpUA65ZpmDYPCGNGyuYCtZCugwCglMni +4eTbwppsIdTewIYfYLAsHE= =kGJe -END PGP SIGNATURE

[GENERAL] FTP mirror problems

Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200411071350 -BEGIN PGP SIGNATURE- iD8DBQFBjm+VvJuQZxSWSsgRAsMyAJ9ZNlOGzQ1P9Z05qg8YYJSylLqXOQCg2C7D G/mFgh99zxos0baBjuEsgIA= =ryNl -END PGP SIGNATURE- ---(end of broadcast)--- TIP

Re: [GENERAL] Sorting street addresses

, check out the source code of the module and see how they have done it and create your own version. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200410290722 -BEGIN PGP SIGNATURE- iD8DBQFBgihdvJuQZxSWSsgRAvFBAKC1EcSW5Ru5+nZwNLenbRVqQlQP/wCgpvd6 TOiKff34E+DJVM7rcPkMACU

Re: [GENERAL] Activestate Perl and DBD-Pg?

list. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200410080725 -BEGIN PGP SIGNATURE- iD8DBQFBZnk8vJuQZxSWSsgRAsb4AJ0a3b+mi0l6N8QihOha1LfRjRiA5QCeNskp BwKZ7OmgcjxX1UfbVsGlBY8= =6xpR -END PGP SIGNATURE- ---(end of broadcast

[GENERAL] GnuPG / PGP signed checksums for PostgreSQL 7.4.5, 7.4.4, 7.3.7, 7.3.6, 7.3.5. 7.2.5

Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200410031234 http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -BEGIN PGP SIGNATURE- iD8DBQFBYCu8vJuQZxSWSsgRAoInAKD2PbcLeC5Za0j6HezKYiAaTuQBJQCg/CkI /mNohvnLAFalW+FZTpjzT/o= =Dez5 -END PGP SIGNATURE

[GENERAL] META: Filtering viruses/worms

that the first one is not a worm but 4k of message content with about 30k of unnecessary HTML markup. Filtering such stuff would be alright with me too. :) - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200403040640 -BEGIN PGP SIGNATURE

Re: [GENERAL] DBD::Pg 1.32 ready for testing

that would be great. If the bug still exists, please let us know as soon as possible so we can get the fix into 1.32. Thanks, - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200402241922 -BEGIN PGP SIGNATURE- iD8DBQFAO+savJuQZxSWSsgRAkUPAKDOk5U2vGy+R1dYgsX4S11Z+oOiBwCfStV0

Re: [GENERAL] website doc search is extremely SLOW

. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200401041439 -BEGIN PGP SIGNATURE- iD8DBQE/+GwIvJuQZxSWSsgRAkOgAJ9lmXwd/h/d+HzPiaPUVvO/Gq1O9wCeNbmn CidSrTYP0sc5pp/hdlIS19o= =YPWw -END PGP SIGNATURE- ---(end of broadcast

[GENERAL] PostgreSQL Porting Project

further than designing it on paper. I will get to it eventually, but I have a lot of other projects, so if anyone wants to help out, please let me know and I'll share what I have so far. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200312302056 -BEGIN PGP SIGNATURE

[GENERAL] PostgreSQL speakers needed for OSCON 2004

as the backend, etc. Feel free to post your ideas on the advocacy list (and post replies to that list, please). Even if you are not interested in speaking, let everyone know what you would like to hear, and perhaps it will inspire somebody. - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key

Re: [GENERAL] sequences not renamed with tables

nextval('barbell_seq') ); - -- Greg Sabino Mullane [EMAIL PROTECTED] PGP Key: 0x14964AC8 200312172134 -BEGIN PGP SIGNATURE- iD8DBQE/4RJjvJuQZxSWSsgRAgEdAJ9y4eDaQENuRWVRETJdLu/vKO5PggCeKLjs dkPyceUBRMkTbvcqMBAgLr4= =5b5j -END PGP SIGNATURE- ---(end

<    1   2   3