Re: [DOCS] Wrong advisory locks docs in pg_locks

2011-11-26 Thread Tom Lane
Daniele Varrazzo writes: > documentation about advisory locks in the pg_locks view > > is incorrect/incomplete: the space specifier field is objsubid, not > objid, and there is no information about how the key is stored. Actuall

Re: [DOCS] Documentation example for RECURISVE WITH isn't what I would expect

2011-11-26 Thread Tom Lane
Alex Sherwin writes: > The 9.1 docs for RECURSIVE WITH: > http://www.postgresql.org/docs/9.1/static/queries-with.html eventually > builds up to this example query: > [ which is claimed not to work ] No, the example works as intended for me. The reason "cycle" never gets set to true in your test