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 <mailto:dk...@grpl.org>>wrote:
But when I use it as a function it always returns false:
CREATE OR REPLACE
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
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 pg_rewrit
