Re: [PATCHES] pg_autovacuum patch for 7.4.2 and HEAD

Tom Lane wrote: Matthew T. O'Connor [EMAIL PROTECTED] writes: ! new_tbl-relid = atol(PQgetvalue(res, row, PQfnumber(res, oid))); ! new_tbl-reltuples = atof(PQgetvalue(res, row, PQfnumber(res, reltuples))); ! new_tbl-relpages = atol(PQgetvalue(res, row, PQfnumber(res, relpages)));

Re: [PATCHES] costly foreign key ri checks (4)

Fabien COELHO [EMAIL PROTECTED] writes: Following the discussion about previous versions of this patch, please find attached a new patch candidate for warning about costly foreign key referential integrity checks. I have reviewed and applied this, with some tweaking. I attach the patch as

Re: [PATCHES] costly foreign key ri checks (4)

Applied by Tom. Thanks. --- Fabien COELHO wrote: Dear patchers, Following the discussion about previous versions of this patch, please find attached a new patch candidate for warning about costly foreign key

Re: [PATCHES] costly foreign key ri checks (4)

Tom Lane wrote: * I changed the message wording to conform to the message style guidelines. I also made it complain about costly sequential scans instead of costly cross-type conversion, since ISTM that's what's really at issue here. I'm not completely wedded to that wording

Re: [PATCHES] ECPG: Update tests memory leak fix

[ Using diff -c version.] Your patch has been added to the PostgreSQL unapplied patches list at: http://momjian.postgresql.org/cgi-bin/pgpatches I will try to apply it within the next 48 hours. --- Lee Kindness

Re: [PATCHES] contrib/xml2 function name change and minor bitrot

Tom Lane wrote: Neil Conway [EMAIL PROTECTED] writes: A few comments on the module: - can you include some licensing information? Distributed under the same terms as PostgreSQL, Copyright ... should be sufficient unless you'd prefer another license Actually, it had better be same

Re: [PATCHES] PSQLRC environment variable.

Bruce Momjian wrote: Bruce Momjian wrote: Tom Lane wrote: Bruce Momjian [EMAIL PROTECTED] writes: Tom Lane wrote: Uh, why is that a good idea? Well, suppose you want all your users to use the same psqlrc file. Instead of creating symlinks for every user, you can just set

Re: [PATCHES] change output of \dp

Euler Taveira de Oliveira wrote: Hi, I just noticed that \dp outputs Table to indicate relations (tables, sequences and views) instead of Relation or Name. This patch just correct it, using Name and attaching its Type. Maybe we should think of a more general solution. For

Re: [PATCHES] client side syntax error position (v3)

Fabien COELHO [EMAIL PROTECTED] writes: New submission... after suggestions by Tom and others, the current result looks like the following: psql CREATE foo; ERROR: syntax error at or near foo at character 8 LINE 1: CREATE foo; ^ psql I have applied this patch, after some

Re: [PATCHES] PSQLRC environment variable.

Bruce Momjian [EMAIL PROTECTED] writes: I just checked a few apps and I see they usually allow a global config file to be specified. How about SYSPSQLRC that adds a system-wide psql config file to be read before the one in the home directory? The ones I know of that allow such a thing

[PATCHES] win32 horology/float4/float8 fixes

For application to HEAD. [float8-small-is-zero and float8-exp-three-digits will likely need similar changes] --- Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see a

[PATCHES] pgstat win32 fix

For application to HEAD, following community review. Check for EOF on pipe differs under win32, as it is based on a socket implementation. --- Certain disclaimers and policies apply to all email sent from Memetrics. For the full text of these disclaimers and policies see a