Now that I have pg_autovacuum working I've bumped into another small bug. When pg_autovacuum goes to vacuum or analyze one of my tables it runs...

analyze public.ConfigBackup

Because ConfigBackup is mixed case it cannot find the relation. I fixed this by going to the function init_table_info and increasing the malloc for new_tbl->table_name by 2 and adding "'s to either side of the table name. Is there anything wrong with this approach? Is there a config I can set to make this non-case sensitive?

Thanks again for your time.

--- Adam Kavan
--- [EMAIL PROTECTED]


---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to