[PATCHES] costly foreign key ri checks (4)

2004-03-09 Thread Fabien COELHO
Dear patchers, 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. 1/ it generates a WARNING 2/ it DETAILs the attributes and types 3/ some regression tests are also

Re: [PATCHES] minor doc work

2004-03-09 Thread Peter Eisentraut
Neil Conway wrote: If commandSET/ is allowed, it overrides all other sources of ! values for the parameter. Superusers are allowed to ! commandSET/ more values than ordinary users. Some parameters ! cannot be commandSET/command even by superusers: for example, Please don't

[PATCHES] PSQLRC environment variable.

2004-03-09 Thread James Tanis
In the tradition of telnet, xinit, and others, I've created a patch which allows users to override the location of .psqlrc by setting the PSQLRC environment variable. I occurs to me that you have probably considered this and the fact that it is not implemented suggests that you have rejected the

Re: [PATCHES] notice about costly ri checks (2)

2004-03-09 Thread Fabien COELHO
As a side question, if there are multiple cross-type conversions in one constraint on different column pairs, what do we think the message should be? One message with multiple column mentions in detail or multiple notices? (I haven't looked at the patch to see if one or the other is

Re: [PATCHES] [GENERAL] dblink: rollback transaction

2004-03-09 Thread Oleg Lebedev
Joe, I applied the patch to 7.4.1 on RH Linux 8.0 and it works great. Thanks. Oleg -Original Message- From: Joe Conway [mailto:[EMAIL PROTECTED] Sent: Thursday, March 04, 2004 11:12 PM To: [EMAIL PROTECTED] Cc: Tom Lane; Oleg Lebedev Subject: Re: [PATCHES] [GENERAL] dblink: rollback

[PATCHES] Alter table Patch

2004-03-09 Thread Rod Taylor
This patch seems to have fallen off of Bruces To be applied list without being applied. Could I get a status report? http://archives.postgresql.org/pgsql-patches/2003-11/msg00222.php -- Rod Taylor rbt [at] rbt [dot] ca Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL PGP Key:

Re: [PATCHES] ALSO keyword to CREATE RULE patch

2004-03-09 Thread Fabien COELHO
I thought the syntax came from Berkeley. We can add ALSO if folks like it. I can't think of cases where we have keywords for both on and off behavior, and allow a default if the keyword is missing. ALTER TABLE ... DROP CONSTRAINT ... [ RESTRICT | CASCADE ] CREATE TABLE ... [ WITH OIDS |

Re: [PATCHES] PSQLRC environment variable.

2004-03-09 Thread Bruce Momjian
Seems like a nice feature to me. --- James Tanis wrote: In the tradition of telnet, xinit, and others, I've created a patch which allows users to override the location of .psqlrc by setting the PSQLRC environment

Re: [PATCHES] PSQLRC environment variable.

2004-03-09 Thread Tom Lane
James Tanis [EMAIL PROTECTED] writes: In message [EMAIL PROTECTED], Tom Lane avows: Uh, why is that a good idea? As you will see, it takes a pretty contrived situation, but indeed I've got one :-) I have a software system which can use postgres if the user so wishes. We have a wrapper

Re: [PATCHES] PSQLRC environment variable.

2004-03-09 Thread Tom Lane
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 PSQLRC in /etc/profile and everyone gets it. ... but people who want to make

Re: [PATCHES] Initial Review of Copy Command Patch

2004-03-09 Thread Tom Lane
mike g [EMAIL PROTECTED] writes: I thought I would try and knock off the count number of rows inserted when using the Copy command from the todo list. I think what was envisioned was adding a field to the COPY command tag returned at command completion. Sending an INFO message seems way too