Postgres Pro
Downloads
Home   >   mailing lists

pgsql-server/contrib/pg_autovacuum pg_autovacuum.c - Mailing list pgsql-committers

From momjian@svr1.postgresql.org (Bruce Momjian)
Subject pgsql-server/contrib/pg_autovacuum pg_autovacuum.c
Date
Msg-id 20030911190118.2BFCED1B546@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    momjian@svr1.postgresql.org    03/09/11 16:01:18

Modified files:
    contrib/pg_autovacuum: pg_autovacuum.c

Log message:
    > It quotes table names for vacuum and analyze, and uppercases the
    > keywords for clarity.

    Yeah, this is basically what I meant, sorry I didn't get to it quicker.

    However, I tested it out a little and the patch you made doesn't work
    because it produces commands like:

    VACUUM ANALYZE "public.FooBar"

    Which doesn't work, so I made my own patch that creates commands like:

    VACUUM ANALYZE "public"."FooBar"

    This allows for mixed case schema names as well as tables.

    Adam, can you please give this a test as you are the person who caught
    the bug in the first place.

    Thanks,

    Matthew T. O'Connor

pgsql-committers by date:

Previous
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql-server/ oc/src/sgml/charset.sgml oc/src/ ...
Next
From: momjian@svr1.postgresql.org (Bruce Momjian)
Date:
Subject: pgsql-server/doc/src/sgml docguide.sgml ecpg.s ...