Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Eric Worden" <worden.eric@xxxxxxxxx> 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

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux