On Thu, 23 Sep 2004, Tom Lane wrote:
> Neil Conway <[EMAIL PROTECTED]> writes: > > On Wed, 2004-09-22 at 23:00, Alvaro Herrera wrote: > >> Could that include supporting SELECT INTO as well as both types of > >> CREATE TABLE AS? > > > Right; my thinking is to have the parser construct SELECT INTO as a > > CreateTableAsStmt. That way all the code for creating the "into" > > relation is centralized in one place. > > Another thing that would be really nice would be to get rid of all the > warty special cases for SELECT INTO in executor/execMain.c. I have > thought about handling this stuff in a new tuple receiver type (cf > tcop/dest.h, dest.c) but haven't really pursued it. I also have some That's a pretty good idea. I was also thinking about this and wondering about the optimisations we could make. Skip WAL and just fsync() the file at the end (or dump whole blocks into WAL if we're archiving). Its a bit of a niche case though. Gavin ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org