Skip site navigation (1) Skip section navigation (2)

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

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] COPY does not work with regproc and aclitem
Date: 2006-10-24 12:43:20
Message-ID: 453E0A68.4070506@sun.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Tom Lane wrote:
> Alvaro Herrera <alvherre(at)commandprompt(dot)com> writes:
>> Hmm, maybe it should be using regprocedure instead?
> 
> Not unless you want to break initdb.  The only reason regproc still
> exists, really, is to accommodate loading of pg_type during initdb.
> Guess what: we can't do type lookup at that point.
> 

I prepared patch which use oid output function instead regproc output. 
This change works only for COPY TO command. SELECT behavior is 
untouched. I extended copy regression test as well.

Please, look on it if it is acceptable fix.

	With regards Zdenek

Attachment: copy.patch
Description: text/x-patch (2.7 KB)

In response to

Responses

pgsql-hackers by date

Next:From: Hannu KrosingDate: 2006-10-24 13:29:36
Subject: Re: Replication documentation addition
Previous:From: Alvaro HerreraDate: 2006-10-24 12:11:33
Subject: Re: WAL logging freezing

pgsql-patches by date

Next:From: Thomas H.Date: 2006-10-24 13:15:52
Subject: Re: could not rename xlog (was: BUG #2712)
Previous:From: Alvaro HerreraDate: 2006-10-24 12:11:33
Subject: Re: WAL logging freezing

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group