Opened 13 years ago

Closed 13 years ago

#1429 closed task (worksforme)

Review visibility of database changes.

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 2.0.0
Component: topology Version: master
Keywords: Cc:

Description

While implementing plpgsql functions to add complex objects into a topology I realized that items added by other topology functions are not visible by queries of outer functions.

I suspect this has to do with STABLE/VOLATILE, but I could be wrong.

Change History (2)

comment:1 by strk, 13 years ago

From http://www.postgresql.org/docs/8.3/static/spi-visibility.html

All standard procedural languages set the SPI read-write mode depending on the volatility attribute of the function. Commands of STABLE and IMMUTABLE functions are done in read-only mode, while commands of VOLATILE functions are done in read-write mode. While authors of C functions are able to violate this convention, it's unlikely to be a good idea to do so.

comment:2 by strk, 13 years ago

Resolution: worksforme
Status: newclosed

Seems all good to me, after review. The issue I was after was unrelated..

Note: See TracTickets for help on using tickets.