Ouch... sorry, my fault. I'll fix this tomorrow (Friday) and submit a patch, or if you want to submit a patch that would be fine. All you have to do is change the the sql statements to put quotes around the relation name.
Thanks for catching this. Matthew T. O'Connor On Thu, 2003-09-04 at 18:39, Adam Kavan wrote: > 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 > ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
