Re: Memory consumption problem

On Fri, May 5, 2006 10:52 am, Franck Routier said:
> Hi,
>
> I have a problem with a simple request :
>
> insert into mytable
> select a.id, a.desc, 'mystring'
> from mytable a;

Um, is that selecting the ids and descriptions from a table and then
inserting them into that same table?

I'm not sure what Postgres does with recursion...

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author.  Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes.  This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------