]> granicus.if.org Git - postgresql/commit
> It quotes table names for vacuum and analyze, and uppercases the
authorBruce Momjian <bruce@momjian.us>
Thu, 11 Sep 2003 19:01:18 +0000 (19:01 +0000)
committerBruce Momjian <bruce@momjian.us>
Thu, 11 Sep 2003 19:01:18 +0000 (19:01 +0000)
commit3d48045ae12dd3d5364dcaf1c12386e5936fb277
tree9e3697d0e7d0dd0a06ac03e5ad939a9cac229dcd
parent188eda0df2ab280d0f5ed43cb1de0512e350a51e
> 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
contrib/pg_autovacuum/pg_autovacuum.c