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

Reply via email to