[HACKERS] 7.0.3 spelling error

2001-02-11 Thread Christopher Kings-Lynne
I just got this error message in 7.0.3: ERROR: to_char/to_number(): not unique decimal poit. Might want to ensure it's correctly spelled in 7.1 Chris -- Christopher Kings-Lynne Family Health Network (ACN 089 639 243)

Re: [HACKERS] Recovery of PGSQL after system crash failing!!!

2001-02-11 Thread Vadim Mikheev
> DEBUG: starting up > DEBUG: database system was interrupted at 2001-02-11 04:08:12 > DEBUG: Checkpoint record at (0, 805076492) > postmaster: reaping dead processes... > Startup failed - abort > > And that is it, from running 'postmaster -D /usr/local/pgsql/data/'. I get > the same thing each t

Re: [HACKERS] ODBC backward versions

2001-02-11 Thread Hiroshi Inoue
Tom Lane wrote: > > "Hiroshi Inoue" <[EMAIL PROTECTED]> writes: > > Does removing pre-6.4 code improve the status ? > > Yes, it does (IMHO anyway) because it removes a configuration option > that is confusing new users. Right. There's even an idea(not mine) to remove the option by automatically

[HACKERS] Re: [ODBC] RE: [PATCHES] Fix for ODBC close

2001-02-11 Thread Hiroshi Inoue
Bruce Momjian wrote: > > > > -Original Message- > > > From: Bruce Momjian > > > > > > OK, I have a pretty good guess about the cause of the ODBC shutdown > > > failure message in the server logs. Sending 'X' is still causing the > > > error message. > > > > > > The error you are seeing is

Re: [HACKERS] Recovery of PGSQL after system crash failing!!!

2001-02-11 Thread Tom Lane
Ryan Kirkpatrick <[EMAIL PROTECTED]> writes: > DEBUG: Checkpoint record at (0, 805076492) > postmaster: reaping dead processes... > Startup failed - abort Hm. All we can tell from this is that the startup subprocess exited with nonzero status. Did it leave a corefile? If so, what's the stack t

[HACKERS] Recovery of PGSQL after system crash failing!!!

2001-02-11 Thread Ryan Kirkpatrick
Guess this what I get for attempting to use a beta version of pgsql in a production system. :( My database server crashed (kernel paging fault it looks like) and after reboot, postmaster refuses to start up. There error it gives is: DEBUG: starting up DEBUG: database system was interrupt

Re: [HACKERS] ODBC backward versions

2001-02-11 Thread Tom Lane
"Hiroshi Inoue" <[EMAIL PROTECTED]> writes: > Does removing pre-6.4 code improve the status ? Yes, it does (IMHO anyway) because it removes a configuration option that is confusing new users. The odds that someone will want to use 7.1 ODBC with a pre-6.4 server seem very small to me, while we do

Re: [HACKERS] Re: [ODBC] RE: [PATCHES] Fix for ODBC close

2001-02-11 Thread Tom Lane
+ SOCK_put_char(self, 'X'); + SOCK_flush_output(self); + if (!shutdown(self->socket, 2)) /* no sends or receives */ closesocket(self->socket); I think you should issue the close() whether the shutdown() succeeds or not. Otherwise

Re: [INTERFACES] Re: [HACKERS] pgAccess fails to launch on HPUX

2001-02-11 Thread Peter Eisentraut
Tatsuo Ishii writes: > I thought the point in these discussions is libpgtl.so could not be > loaded even if LD_LIBRARY_PATH or whatever is set. No, the point is that we are trying to avoid the requirement that LD_LIBRARY_PATH has to be set before the system can be used. This works okay with C l

Re: [INTERFACES] Re: [HACKERS] pgAccess fails to launch on HPUX

2001-02-11 Thread Tatsuo Ishii
> > > If I had known that this was possible I would have done it myself already. > > > ;-) This is a good idea in general because in a default installation > > > pgaccess won't find libpgtcl on any system because it doesn't have the > > > benefit of the -rpath/-R business. Please review/remove t

Re: [HACKERS] ODBC backward versions

2001-02-11 Thread Bruce Momjian
> > -Original Message- > > From: Bruce Momjian > > Sent: Sunday, February 11, 2001 11:01 AM > > To: PostgreSQL-development > > Subject: [HACKERS] ODBC backward versions > > > > > > I checked the logs, and we released the new 6.4 backend protocol on > > 1998-10-30. That was 2.5 years ago

[HACKERS] Re: [ODBC] RE: [PATCHES] Fix for ODBC close

2001-02-11 Thread Bruce Momjian
> > -Original Message- > > From: Bruce Momjian > > > > OK, I have a pretty good guess about the cause of the ODBC shutdown > > failure message in the server logs. Sending 'X' is still causing the > > error message. > > > > The error you are seeing is from the backend libpq code, the are

RE: [HACKERS] ODBC backward versions

2001-02-11 Thread Hiroshi Inoue
> -Original Message- > From: Bruce Momjian > Sent: Sunday, February 11, 2001 11:01 AM > To: PostgreSQL-development > Subject: [HACKERS] ODBC backward versions > > > I checked the logs, and we released the new 6.4 backend protocol on > 1998-10-30. That was 2.5 years ago. > > We normally

[HACKERS] RE: [ODBC] RE: [PATCHES] Fix for ODBC close

2001-02-11 Thread Hiroshi Inoue
> -Original Message- > From: Bruce Momjian > > OK, I have a pretty good guess about the cause of the ODBC shutdown > failure message in the server logs. Sending 'X' is still causing the > error message. > > The error you are seeing is from the backend libpq code, the area that > communi

Re: [HACKERS] pgAccess fails to launch on HPUX

2001-02-11 Thread Peter Eisentraut
Tatsuo Ishii writes: > > If I had known that this was possible I would have done it myself already. > > ;-) This is a good idea in general because in a default installation > > pgaccess won't find libpgtcl on any system because it doesn't have the > > benefit of the -rpath/-R business. Please r