Re: Memory consumption problem - Mailing list pgsql-novice

From Daniel T. Staal
Subject Re: Memory consumption problem
Date
Msg-id 60404.63.172.115.138.1146843186.squirrel@MageHandbook.com
Whole thread Raw
In response to Memory consumption problem  (Franck Routier <franck.routier@axege.com>)
Responses Re: Memory consumption problem
List pgsql-novice
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.
---------------------------------------------------------------


pgsql-novice by date:

Previous
From: Franck Routier
Date:
Subject: Memory consumption problem
Next
From: Bruno Wolff III
Date:
Subject: Re: Memory consumption problem