[GENERAL] Recursive CTE in function problem

2016-02-04 Thread Doug Kyle
Postgres 9.4.1, with these tables: grpl_collection.collections id | integer | name | text| parent | bigint | (An adjacency list representing a collections hierarchy) grpl_collection.collections_copy_map id | integer | collection | bigint | copy | bigint | (map a

Re: [GENERAL] Recursive CTE in function problem

2016-02-04 Thread Doug Kyle
ugh, simple syntax screw up. Thanks David. On 02/04/2016 02:45 PM, David G. Johnston wrote: On Thu, Feb 4, 2016 at 12:37 PM, Doug Kyle <dk...@grpl.org <mailto:dk...@grpl.org>>wrote: But when I use it as a function it always returns false: CREATE OR REPL

[GENERAL] dump error parent table oid of pg_rewrite entry oid not found

2010-04-07 Thread Doug Kyle
I have this error from pg_dumpall: pg_dump: failed sanity check, parent table OID 27974 of pg_rewrite entry OID 28689 not found I found a rule was dropped when this server was setup as s Slony replica because it conflicted with the Slony deny access trigger select oid,rulename from