Re: Memory consumption problem

On Fri, May 05, 2006 at 11:33:06 -0400,
  "Daniel T. Staal" <DStaal@usa.net> wrote:
> 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...

That wouldn't cause recursion. The SELECT part of the query will see the
original contents of the table and not ones being inserted in the same query.