From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
---|---|
To: | Irina Sourikova <irina(at)bnl(dot)gov> |
Cc: | pgsql-patches(at)postgresql(dot)org |
Subject: | Re: bug in vacuumlo? |
Date: | 2003-09-24 02:34:56 |
Message-ID: | 20030924103444.H72688-100000@houston.familyhealth.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
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
> irina(at)bnl(dot)gov
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-09-24 05:39:18 | Re: bug in vacuumlo? |
Previous Message | Nigel J. Andrews | 2003-09-24 00:19:39 | tsearch2 memory alloc checks |