Re: [ADMIN] ignoring data type

2010-11-16 Thread Octavio
Thanks Scott In fact checking the application there are a lots of queries that doesn't make the conversion, in order to temporally skip this issue,I like to try to import those conversions from the 8.1 version to the actual postgres, how can I do that? Octavio --- El mar, 11/16/10,

[ADMIN] ignoring data type

2010-11-15 Thread Octavio
Hello I have migrate a application from a server with postgres 8.1 to another with 8.3 in the new server there are some page that doesn't work because seems to want to compare different data type does anyone know if it is a version issue or there is something Im missing? Thanks Octavi

[ADMIN] Disk usage

2004-07-16 Thread Octavio Alvarez Piza
I have a database to which I re-create daily via ODBC. I only drop the data, not the index definitions or the data definitions. I use TRUNCATE to drop the data. I REINDEX each table afterwards. For some reason, my VACUUM job was not running, so the DB was not being VACUUMed at all. Today I ran o