[GENERAL] ODBC query problem AGAIN

2003-07-18 Thread Luis Magaña
Hi, After having moved all of the data to a new database initializaed with es_MX as locale, the postmaster is dying and restarting every time a program tries to read information on this tables: pg_catalog.pg_class pg_catalog.pg_namespace it is important to note that if I do a simple select *

Re: [GENERAL] ODBC query problem

2003-07-17 Thread Luis Magaña
I've moved all data to a new location using pg_dum/pg_restore, Things seems to be working properly so far, data seems to be where it should be and complete, I did the initdb once again using es_MX as locale. This was the first time I face such a problem with this Solaris installation after 14

Re: [GENERAL] ODBC query problem

2003-07-16 Thread Luis Magaña
I've compiled postgresql in 32bit mode, although I'm using the --enable-integer-datetimes flag when configuring. I've already moved database to a diferent partition nad got the same results, I wonder, if it is a hardware problem, why can I access both tables individually with no problem at all ?.

Re: [GENERAL] ODBC query problem

2003-07-16 Thread Luis Magaña
Locale is es_MX and it seems that the hardware issue wil be the reason. I've moved it to another partition and now is working fine. I'll do more testing. Thanks for the help. Regards. On Wed, 2003-07-16 at 12:52, Maksim Likharev wrote: Forgotten to ask, what is locale for DB cluster?

Re: [GENERAL] ODBC query problem

2003-07-16 Thread Luis Magaña
I've moved the database to a third location in the same disk using pg_dumpall, the new location works with no errors, the initdb was made without localization. The production db was inited with es_MX locale, may that has something to do with the problem ?. On Wed, 2003-07-16 at 12:40, Andrew