Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Albert Cervera Areny
Sorry about the wrong diff format. Attached is the good one. A Dimecres 25 Octubre 2006 09:07, Neil Conway va escriure: On Wed, 2006-10-25 at 00:45 +0200, Albert Cervera Areny wrote: Hope the diff and idents are ok. Patches should be submitted in context diff (diff -c) format. -Neil

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Bruce Momjian
This has been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Albert Cervera Areny wrote: Sorry about the wrong diff format. Attached is the good one. A Dimecres 25 Octubre

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Dave Page
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: 26 October 2006 14:19 To: Albert Cervera Areny Cc: pgsql-patches@postgresql.org Subject: Re: [PATCHES] Tablespace for temporary objects and sort files This has been saved

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Bruce Momjian
bruce wrote: Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: 26 October 2006 14:19 To: Albert Cervera Areny Cc: pgsql-patches@postgresql.org Subject: Re: [PATCHES] Tablespace for temporary

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Dave Page
-Original Message- From: Bruce Momjian [mailto:[EMAIL PROTECTED] Sent: 26 October 2006 14:37 To: [EMAIL PROTECTED] Cc: Dave Page; Albert Cervera Areny; pgsql-patches@postgresql.org Subject: Re: [PATCHES] Tablespace for temporary objects and sort files bruce wrote: Dave Page

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Bruce Momjian
Dave Page wrote: -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruce Momjian Sent: 26 October 2006 14:19 To: Albert Cervera Areny Cc: pgsql-patches@postgresql.org Subject: Re: [PATCHES] Tablespace for temporary objects and sort files

Re: [PATCHES] [HACKERS] COPY does not work with regproc and aclitem

2006-10-26 Thread Zdenek Kotala
Tom Lane napsal(a): Zdenek Kotala [EMAIL PROTECTED] writes: I prepared patch which use oid output function instead regproc output. This change works only for COPY TO command. This is not a bug and we're not going to fix it, most especially not like that. OK, The behavior of regproc type is

Re: [PATCHES] [HACKERS] COPY does not work with regproc and aclitem

2006-10-26 Thread Alvaro Herrera
Zdenek Kotala wrote: Tom Lane napsal(a): Zdenek Kotala [EMAIL PROTECTED] writes: I prepared patch which use oid output function instead regproc output. This change works only for COPY TO command. This is not a bug and we're not going to fix it, most especially not like that. OK, The

Re: [PATCHES] [HACKERS] COPY does not work with regproc and aclitem

2006-10-26 Thread Zdenek Kotala
Alvaro Herrera napsal(a): Zdenek Kotala wrote: Tom Lane napsal(a): Zdenek Kotala [EMAIL PROTECTED] writes: I prepared patch which use oid output function instead regproc output. This change works only for COPY TO command. This is not a bug and we're not going to fix it, most especially not

[PATCHES] GUC description cleanup

2006-10-26 Thread Neil Conway
This patch makes the short_desc and extra_desc fields of the GUC table more consistent: both text in both fields should be complete sentences that begin with a capital letter and end in a period. Note that this patch breaks the translations of these strings, so I haven't applied it yet. Should I

[PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Jonah H. Harris
The attached patch handles the simple case where a user wants to increase the user-defined storage size of a variable length object, such as VARCHAR or NUMERIC, without having to rebuild the table. It does so by verifying that no transform was defined and testing whether the user simply

Re: [PATCHES] GUC description cleanup

2006-10-26 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: BTW, should pre_auth_delay be included in SHOW ALL? It's really just a debug aid, so I wouldn't complain if SHOW ALL didn't show it. regards, tom lane ---(end of broadcast)--- TIP 3:

Re: [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Tom Lane
Jonah H. Harris [EMAIL PROTECTED] writes: The attached patch handles the simple case where a user wants to increase the user-defined storage size of a variable length object, such as VARCHAR or NUMERIC, without having to rebuild the table. This makes some really quite unacceptable assumptions

Re: [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Jonah H. Harris
On 10/26/06, Tom Lane [EMAIL PROTECTED] wrote: This makes some really quite unacceptable assumptions about the meaning and encoding of typmod ... True, so VARCHAR seems like the only one? That's the only one I've really encountered in the field on a fairly regular basis. I'm also wondering

Re: [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Tom Lane
Jonah H. Harris [EMAIL PROTECTED] writes: On 10/26/06, Tom Lane [EMAIL PROTECTED] wrote: This makes some really quite unacceptable assumptions about the meaning and encoding of typmod ... True, so VARCHAR seems like the only one? That's the only one I've really encountered in the field on a

Re: [HACKERS] [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Gregory Stark
Jonah H. Harris [EMAIL PROTECTED] writes: On 10/26/06, Tom Lane [EMAIL PROTECTED] wrote: This makes some really quite unacceptable assumptions about the meaning and encoding of typmod ... True, so VARCHAR seems like the only one? That's the only one I've really encountered in the field on

[PATCHES] psql \lo_* quiet mode patch

2006-10-26 Thread Jeremy Drake
I sent this in a while back, but never heard anything about it. This patch makes psql's \lo_* commands respect the -q flag (or other methods of setting quiet mode) as well as HTML output mode. This came in very handy when writing a regression test which uses the \lo_import command since it would

Re: [HACKERS] [PATCHES] Eliminating phase 3 requirement for varlen increases via ALTER COLUMN

2006-10-26 Thread Jonah H. Harris
On 10/26/06, Gregory Stark [EMAIL PROTECTED] wrote: I think what you want is to add a new method entry in pg_type to allow a type to declare a method to tell you whether a change is work-free or not. Then any type, even user-defined types, can allow some changes to be work-free and some not

Re: [PATCHES] GUC description cleanup

2006-10-26 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: Note that this patch breaks the translations of these strings, so I haven't applied it yet. Should I apply it now, or wait for 8.3 to branch? BTW, unless Peter says it's OK, my advice is to wait. It's already likely to be the case that translation updates

Re: [PATCHES] Tablespace for temporary objects and sort files

2006-10-26 Thread Jaime Casanova
On 10/25/06, Jaime Casanova [EMAIL PROTECTED] wrote: On 10/24/06, Albert Cervera Areny [EMAIL PROTECTED] wrote: I'm trying to introduce myself into postgresql development and I'm working on the tablespace for temporary objects and sort files TODO item. Now, PG_TEMP_FILES_DIR seems to add