• Bruce Momjian's avatar
    > It quotes table names for vacuum and analyze, and uppercases the · 3d48045a
    Bruce Momjian authored
    > 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
    3d48045a
pg_autovacuum.c 30 KB