Douglas Alan <darkwater42@xxxxxxxxx> writes: > delete from pg_statistic s > where exists ( select 1 > from pg_class as c, pg_attribute as a > where a.attrelid = c.relfilenode > and s.starelid = c.relfilenode > and s.staattnum = a.attnum > and c.relname = 'maindb_astobject' > and attname = 'survey_id' > ); Use c.oid, not c.relfilenode. Also, the join to pg_class is both more and less than needed --- it won't handle the situation where there are multiple tables of the same name in different schemas. You could add pg_namespace into the join, but it's the hard way. The way I'd do it is probably delete from pg_statistic where (starelid, staattnum) in (select attrelid, attnum from pg_attribute where attrelid = 'my_relation'::regclass and attname = 'my_attribute'); regclass knows about schemas and search paths, so stuff like 'my_schema.my_relation'::regclass will work unsurprisingly. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
