Re: BUG #15060: Row in table not found when using pg function in anexpression - Mailing list pgsql-bugs

From Mark Scheffer
Subject Re: BUG #15060: Row in table not found when using pg function in anexpression
Date
Msg-id 1518445209487-0.post@n3.nabble.com
Whole thread Raw
In response to Re: BUG #15060: Row in table not found when using pg function in an expression  (Marko Tiikkaja <marko@joh.to>)
List pgsql-bugs
Marko Tiikkaja-4 wrote
> I don't think this is relevant, since the changes were NOT made by the SQL
> command calling the function.  They were made by the INSERT which executed
> earlier in a VOLATILE function.

Yes I should have read a few lines further, and wake up:

> Because of this snapshotting behavior, a function containing only SELECT
> commands can safely be marked STABLE, even if it selects from tables that
> might be undergoing modifications by concurrent queries. PostgreSQL will
> execute all commands of a STABLE function using the snapshot established
> for the calling query, and so it will see a fixed view of the database
> throughout that query.

Sorry for inconvenience. Hope the VOLATILE-STABLE difference in behavior
helps in resolving this bug.





--
Sent from: http://www.postgresql-archive.org/PostgreSQL-bugs-f2117394.html


pgsql-bugs by date:

Previous
From: Guo Xiang Tan
Date:
Subject: Re: BUG #15032: Segmentation fault when running a particular query
Next
From: 石勇虎
Date:
Subject: response time is very long in PG9.5.5 using psql or jdbc