Re: Another small bug (pg_autovacuum)

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
> --- akavan(at)cox(dot)net
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>