Re: [Gnumed-devel] database replication with bucardo

[Slappinjohn]

> I once attempted to root out those which didn't. I'm not
> sure I caught all of them. If you find any let me know and
> I'll fix that.
> 

select table_catalog, table_schema, table_name from
information_schema.tables where (table_catalog, table_schema,
table_name) not in (select table_catalog, table_schema, table_name from
information_schema.table_constraints where constraint_type not in
('primary key', 'unique')) and table_schema not in
('information_schema', 'pg_catalog') and table_type = 'base table';

above said: no

Marc