Re: [HACKERS] Bug - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] Bug
Date
Msg-id 199909171543.LAA19225@candle.pha.pa.us
Whole thread Raw
In response to Re: [HACKERS] Bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> Oleg Broytmann <phd@sun.med.ru> writes:
> > ran=> create table test1 (n int default nextval('seq_test'), t text);
> > ran=> insert into test1 ("t") select distinct src from test_source;
> > [ doesn't work right ]
> 
> My, that's an interesting case.  I think that fits right in with my
> remark yesterday that the SELECT inside an INSERT ... SELECT needs
> to have a targetlist that's separate from the INSERT's list.  As it
> stands, we form a targetlist representing the set of values that need
> to be inserted into the target table --- and then the DISTINCT pass
> runs on those tuples :-(, because there is nothing else for it to
> run on.
> 
> In short, this is not a trivial thing to fix.  We need multilevel
> query trees...

Added to TODO:
* Allow multi-level query trees for INSERT INTO ... SELECT

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Brook Milligan
Date:
Subject: Re: [HACKERS] pgaccess seems a tad confused
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: attdisbursiont