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

Re: [HACKERS] Performance testing of COPY (SELECT) TO

From: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To: Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>,Andrew Dunstan <andrew(at)dunslane(dot)net>,Bruce Momjian <bruce(at)momjian(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] Performance testing of COPY (SELECT) TO
Date: 2006-08-30 17:36:32
Message-ID: 20060830173632.GF81373@pervasive.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Mon, Aug 28, 2006 at 07:35:11PM +0200, Zoltan Boszormenyi wrote:
> >>COPY (SELECT ...) (col1, col2, ...) TO
> >>and it was actually working. In your v9
> >>you rewrote the syntax parsing so that
> >>feature was lost in translation.
> >>    
> >
> >Interesting.  I didn't realize this was possible -- obviously I didn't
> >test it (did you have a test for it in the regression tests?  I may have
> >missed it).  In fact, I deliberately removed the column list from the
> >grammar, because it can certainly be controlled inside the SELECT, so I
> >thought there was no reason the support controlling it in the COPY
> >column list.
> >  
> 
> Yes, it was even documented. I thought about having
> queries stored statically somewhere (not in views) and
> being able to use only part of the result.
 
ISTM that there should have been a regression test that tried that
capability out. That would have made it obvious when the functionality
was lost, at least.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby(at)pervasive(dot)com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

In response to

pgsql-hackers by date

Next:From: Magnus HaganderDate: 2006-08-30 17:46:25
Subject: Re: stats test on Windows is now failing repeatably?
Previous:From: Tom LaneDate: 2006-08-30 17:11:57
Subject: Re: [COMMITTERS] pgsql: Second try committing the path changes.

pgsql-patches by date

Next:From: Christopher BrowneDate: 2006-08-30 17:50:44
Subject: BUG #2600: dblink compile with SSL missing libraries
Previous:From: Bruce MomjianDate: 2006-08-30 17:09:04
Subject: Re: [HACKERS] Interval aggregate regression failure

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