Re: [ADMIN] UTF8 Questions

Am Dienstag, 15. August 2006 00.42 schrieb Abu Mushayeed: > We upgraded our Db from LATIN1 to UTF8 as follows: > > 1. new install with encoding=UTF8 > 2. pg_dump from old DB and import into new db using psql as follows: > pg_dump out of old_db|psql into new_db > 3. New feeds (data files) come in s

[ADMIN] UTF8 Questions

We upgraded our Db from LATIN1 to UTF8 as follows:1. new install with encoding=UTF82. pg_dump from old DB and import into new db using psql as follows: pg_dump out of old_db|psql into new_db3. New feeds (data files) come in same as when the DB was latin1. If error message from any load script like

[ADMIN] dropping partitioned table waits forever

Hi   I have a table partitioned on a daily basis. Data is constantly inserted in this table. When I attempt to drop a partition that is not used(i.e previous day’s), the drop table waits for a lng time.This is probably due to the fact that the old partitioned table is being referenced

[ADMIN] unsubscribe

Regards, Amaro ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq