=?UTF-8?B?QmVuamFtaW4gQsO2cm5nZW4tU2NobWlkdA==?= <benja...@boerngen-schmidt.de>
writes:
> The Lateral statement does return a result, which I do not expect. I
> returns an end point multiple times for diverent start points. Why? I
> thought, that the selected point by the lateral is locked by the FOR
> UPDATE and if the lateral selects a point that is already locked it will
> be skipped by the SKIP LOCKED.
It sounds like you think SKIP LOCKED means to skip rows locked by your own
transaction. That's not what it does, AFAIK. It skips rows you couldn't
get a lock on without waiting ... but if you already have a lock, that's
fine.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
