Skip site navigation (1) Skip section navigation (2)

Re: "disappearing" rows in temp table, in recursing trigger

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Eric Worden" <worden(dot)eric(at)gmail(dot)com>
Cc: "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>, pgsql-general(at)postgresql(dot)org
Subject: Re: "disappearing" rows in temp table, in recursing trigger
Date: 2008-12-30 22:55:14
Message-ID: 2702.1230677714@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
"Eric Worden" <worden(dot)eric(at)gmail(dot)com> writes:
> Thank you this helped me fix it.  I moved the "create temporary
> table..." statement to the outermost calling function and changed it
> from STABLE to VOLATILE.  I'm not sure which change made the
> difference -- I had to move the create table statement for an
> additional reason.

Probably the latter.  STABLE functions generally use the snapshot of the
calling query, which means that on successive calls they'll see the same
state of the database.

			regards, tom lane

In response to

pgsql-general by date

Next:From: Tuan Hoang AnhDate: 2008-12-31 04:49:05
Subject: How to use index in strpos function
Previous:From: Derek LiangDate: 2008-12-30 22:33:46
Subject: return X number of refcursors from a function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group