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?
>
> -----Original Message-----
> From: Luis Magaña [mailto:joe666@gnovus.com]
> Sent: Wednesday, July 16, 2003 10:37 AM
> To: Andrew Sullivan
> Cc: Postgresql General Mail List
> Subject: Re: [GENERAL] ODBC query problem
>
>
> 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 ?.
>
> any other Ideas ?
>
> thanks.
>
> On Wed, 2003-07-16 at 12:16, Andrew Sullivan wrote:
> > On Wed, Jul 16, 2003 at 12:04:25PM -0500, Luis Maga?a wrote:
> > > Thanks,
> > >
> > > yes, it's running solaris 8 on a SPARC with SCSI disk.
> >
> > Hmm. 64 bit? There've been plenty of bugs in the 64 bit libraries,
> > AFAICT. We've even discovered some of 'em ourselves, and I got so
> > leery that we still use a 32-bit-compiled Postgres for production
> > work. IIRC, there's a package floating about for gcc 3.2.x that
> > compiles 64 bit binaries by default, so you may want to check this
> > out.
> >
> > > Howver, I have a core file dumped whenever this happens. Let me find
> out
> > > how to do the backtrace and I'll show it to you gladly.
> >
> > If you're using the 64 bit libraries, the bad news is that gdb is
> > pretty flakey with them. So you have to use adb instead. It's not
> > compeltely transparent in its operation, but the man page actually
> > does tell you everything you need, sort of, if you read it all about
> > 60 times. I have suppressed most of my knowledge of it, so I'm sorry
> > not to be much help. Anyway, if you get no symbols, you probably
> > need to re-compile the postmaster with debugging symbols in. If you
> > use gcc, there's _supposed_ to be no cost to that.
> >
> > A
--
Luis Magaña.
Gnovus Networks & Software.
www.gnovus.com
