Zdenek Kotala escribió: > Gregory Stark napsal(a): >> AFAIK we can't easily connect to the new database and do some fiddling with >> it, can we? If we could we could check if there are any non-empty indexes >> which depend on the collation and only print the warning if we find any (and >> even mark them invalid). > > Autovacum uses InitPostgres function to swith to another database. I'm > not sure how much safe it is in create database command and when we are > already switched we can reindex affected indexes.
It's only supposed to work if you're not previously connected to any database. (Autovacuum never "switches to another database"; any particular worker only connects to a single database). -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers