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

2011-11-25 Thread Alex Sherwin
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: WITH RECURSIVE search_graph(id, link, data, depth, path, cycle) AS ( SELECT g.id, g.link, g.data, 1, ARRAY[g.id], false FROM

[DOCS] Wrong advisory locks docs in pg_locks

2011-11-25 Thread Daniele Varrazzo
Hello, 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. => select pg_advisory_lock(11