| From: | Irina Sourikova <irina(at)bnl(dot)gov> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | bug in vacuumlo? |
| Date: | 2003-09-23 16:47:16 |
| Message-ID: | 3F707914.5080406@bnl.gov |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
irina(at)bnl(dot)gov
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marko Karppinen | 2003-09-23 16:51:53 | Re: [GENERAL] Can't Build 7.3.4 on OS X |
| Previous Message | Jan Wieck | 2003-09-23 16:39:03 | Re: pg_dump doesn't dump binary compatible casts |