Skip site navigation (1) Skip section navigation (2)

bug in vacuumlo?

From: Irina Sourikova <irina(at)bnl(dot)gov>
To: pgsql-patches(at)postgresql(dot)org
Subject: bug in vacuumlo?
Date: 2003-09-23 16:59:33
Message-ID: 3F707BF5.9060102@bnl.gov (view raw or flat)
Thread:
Lists: pgsql-patches
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



Responses

pgsql-patches by date

Next:From: Tom LaneDate: 2003-09-23 17:44:56
Subject: Re: bug in vacuumlo?
Previous:From: Gaetano MendolaDate: 2003-09-23 14:28:27
Subject: Re: Improving REINDEX for system indexes (long)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group