Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: [HACKERS] INSERT INTO

Re: [HACKERS] INSERT INTO

From
Bruce Momjian
Date:

Is this done?


> The pages at http://postgresql.nextpath.com/docs/user/sql-select.htm and
> http://postgresql.nextpath.com/docs/user/sql-insert.htm imply that SELECT
> INTO and INSERT INTO <table> SELECT <query> will work with existing
> tables but in fact it always creates the table and issues an error if
> they already exist.  What needs to be fixed here?  The code or the docs?
> 
> -- 
> D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
> http://www.druid.net/darcy/                |  and a sheep voting on
> +1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.
> 
> 


--  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

Re: [HACKERS] INSERT INTO

From
"D'Arcy" "J.M." Cain
Date:
Thus spake Bruce Momjian
> Is this done?
> > The pages at http://postgresql.nextpath.com/docs/user/sql-select.htm and
> > http://postgresql.nextpath.com/docs/user/sql-insert.htm imply that SELECT
> > INTO and INSERT INTO <table> SELECT <query> will work with existing
> > tables but in fact it always creates the table and issues an error if
> > they already exist.  What needs to be fixed here?  The code or the docs?

I posted the correction.  I think Tom Lane is putting it into the docs.

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.

Re: [HACKERS] INSERT INTO

From
Thomas Lockhart
Date:
> I posted the correction.  I think Tom Lane is putting it into the docs.

Actually, the other tgl has some patches :)
                  - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California

Re: [HACKERS] INSERT INTO

From
Tom Lane
Date:
"D'Arcy" "J.M." Cain <darcy@druid.net> writes:
> I posted the correction.  I think Tom Lane is putting it into the docs.

Not me --- Lockhart.

I know it's confusing having two guys with the initials tgl on the
same project ;-).
        regards, tom lane

Re: [HACKERS] INSERT INTO

From
"D'Arcy" "J.M." Cain
Date:
Thus spake Tom Lane
> "D'Arcy" "J.M." Cain <darcy@druid.net> writes:
> > I posted the correction.  I think Tom Lane is putting it into the docs.
> 
> Not me --- Lockhart.
> 
> I know it's confusing having two guys with the initials tgl on the
> same project ;-).

Sheesh!  We'll just have to get together somewhere all together for a beer
and straighten all this out.  :-)

-- 
D'Arcy J.M. Cain <darcy@{druid|vex}.net>   |  Democracy is three wolves
http://www.druid.net/darcy/                |  and a sheep voting on
+1 416 424 2871     (DoD#0082)    (eNTP)   |  what's for dinner.