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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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 Content-Type Size
pgsql-copyselect-5.patch.gz application/x-tar 10.0 KB

In response to

Browse pgsql-hackers by date

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

Browse pgsql-patches by date

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