Do we need a 'AND NOT a.attisdropped' in there anywhere as well? Chris
On Tue, 23 Sep 2003, Irina Sourikova wrote: > > Hi, > > I tried to use vacuumlo of posgres-7.3.4/contrib/vacuumlo and it didn't > work > for me until I added one line: > > strcat(buf, " AND c.relname <> 'vacuum_l'"); > > after strcat(buf, "SELECT c.relname, a.attname "); > strcat(buf, "FROM pg_class c, pg_attribute a, pg_type t "); > strcat(buf, "WHERE a.attnum > 0 "); > strcat(buf, " AND a.attrelid = c.oid "); > strcat(buf, " AND a.atttypid = t.oid "); > strcat(buf, " AND t.typname in ('oid', 'lo') "); > strcat(buf, " AND c.relkind = 'r'"); > > Is it a bug or I'm missing something? > > Thank you, > Irina > [EMAIL PROTECTED] > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org