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

Re: [HACKERS] COPY view

From: Zoltan Boszormenyi <zboszor(at)dunaweb(dot)hu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org
Subject: Re: [HACKERS] COPY view
Date: 2006-08-24 18:58:18
Message-ID: 44EDF6CA.3000107@dunaweb.hu (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Zoltan Boszormenyi írta:
> Zoltan Boszormenyi írta:
>> The option parsing and error checking is now common.
>>
>> I also changed it to use transformStmt() in analyze.c.
>> However, both the UNION and sunselect cases give me
>> something like this:
>>
>> ERROR:  could not open relation 1663/16384/16723: No such file or 
>> directory
>>
>> What else can I do with it?
>
> But a single SELECT with two tables joined
> also works so it must be something trivial.

Now UNIONs and subselects also work.

Your concern about copy_dest_printtup()
wasn't solved yet.

Best regards,
Zoltán Böszörményi



Attachment: pgsql-copyselect-5.patch.gz
Description: application/x-tar (10.0 KB)

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 2006-08-24 19:01:22
Subject: Re: PL/Perl: spi_prepare() and RETURNING
Previous:From: Greg Sabino MullaneDate: 2006-08-24 18:55:11
Subject: Intervals within information_schema

pgsql-patches by date

Next:From: Bernd HelmleDate: 2006-08-24 19:08:32
Subject: Re: [HACKERS] Updatable views
Previous:From: Greg Sabino MullaneDate: 2006-08-24 18:55:11
Subject: Intervals within information_schema

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