Re: [BUGS] Conversion errors for datetime fields

2000-12-28 Thread Larry Rosenman
n to hh/mm/ss. Aren't we *REQUIRED* by SQL99 to accept up to :61 to account for leap seconds? -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Re: [BUGS] Conversion errors for datetime fields

2000-12-28 Thread Larry Rosenman
* Tom Lane <[EMAIL PROTECTED]> [001228 11:33]: > Larry Rosenman <[EMAIL PROTECTED]> writes: > > Aren't we *REQUIRED* by SQL99 to accept up to :61 to account for > > leap seconds? > > 60, maybe --- I have not looked at the SQL spec. 61 is a widely > re

Re: [BUGS] Conversion errors for datetime fields

2000-12-28 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [001228 19:39]: > * Tom Lane <[EMAIL PROTECTED]> [001228 11:33]: > > Larry Rosenman <[EMAIL PROTECTED]> writes: > > > Aren't we *REQUIRED* by SQL99 to accept up to :61 to account for > > > leap seconds? > &

Re: [BUGS] Conversion errors for datetime fields

2000-12-28 Thread Larry Rosenman
y of the platforms we run on > do either. IMHO, accepting :60 when we do not have the ability to do > anything correct with it won't improve matters. > > regards, tom lane Ok. I just wanted to mention what I had thought was an *Authoritative* sourc

Re: [BUGS] Conversion errors for datetime fields

2001-01-02 Thread Larry Rosenman
tle as meaning they don't refer you off to another book for SQL stuff. It's actually a nice book. However, given the discussion Tom and I had on-list, I really need to get a REAL copy of the standard someday. LER -- Larry Rosenman http://www.lerctr.org/~ler P

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-25 Thread Larry Rosenman
gt; > > > This is an OpenSSL namespace problem on some platforms (Solaris, Unixware > > so far). Nothing we can really do about it. > > ---(end of broadcast)--- > TIP 4: Don't 'kill -9' the postmaster -- Larry Rosenman

Re: [BUGS] Various bugs with PG7.1 8th March snapshot on Solaris 8INTEL

2001-03-25 Thread Larry Rosenman
* Richard Levitte - VMS Whacker <[EMAIL PROTECTED]> [010325 14:41]: > From: Larry Rosenman <[EMAIL PROTECTED]> > > ler> * Justin Clift <[EMAIL PROTECTED]> [010325 07:34]: > ler> > Hi Peter, > ler> > > ler> > Can't this be at least w

[BUGS] cvs tip: gmake breakage.

2001-09-06 Thread Larry Rosenman
src/backend' gmake[1]: *** [all] Error 2 gmake[1]: Leaving directory `/home/ler/pg-dev/pgsql/src' gmake: *** [all] Error 2 I had re-cvs checkout my source tree into a clean directory LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812

Re: [BUGS] CURRENT CVS: MULTIBYTE: CANT CONNECT....

2001-09-07 Thread Larry Rosenman
* Larry Rosenman <[EMAIL PROTECTED]> [010907 21:06]: > I finally got all the way through a compile set: > > CC=cc CXX=CC ./configure --prefix=/usr/local/pgsql --enable-syslog \ > --with-CXX --with-perl --enable-multibyte --enable-cassert \ > --with-includes=/usr

Re: [BUGS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Larry Rosenman
udes=/usr/local/include --with-libs=/usr/local/lib \ --enable-debug \ --with-tcl --with-tclconfig=/usr/local/lib \ --with-tkconfig=/usr/local/lib --enable-locale --with-python > > > ---(end of broadcast)--- > TIP 4:

Re: [BUGS] [COMMITTERS] pgsql/src/backend/utils/mb encnames.c

2001-09-07 Thread Larry Rosenman
enable-multibyte --enable-cassert \ > > --with-includes=/usr/local/include --with-libs=/usr/local/lib \ > > --enable-debug \ > > --with-tcl --with-tclconfig=/usr/local/lib \ > > --with-tkconfig=/usr/local/lib --enable-locale --with-python > >

[BUGS] CURRENT CVS: MULTIBYTE: CANT CONNECT....

2001-09-07 Thread Larry Rosenman
ith zero length at 0/2922448 DEBUG: redo is not required DEBUG: database system is ready THIS IS UNACCEPTABLE. How do I get out of it? LER -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 972-414-9812 E-Mail: [EMAIL PROTECTED] US Mail: 1905 Ste

Re: [BUGS] BUG #3331: Database Restoring problem

2007-06-02 Thread Larry Rosenman
---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683

Re: [BUGS] BUG #3429: table named MULTIPOLYGON

2007-07-05 Thread Larry Rosenman
try: DROP TABLE "MULTIPOLYGON"; That should do it. (pardon the top post). -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683E-Mail: [EMAIL PROTECTED] US Mail: 430 Valona Loop, Round Rock, TX 78681-3893 -Original Message

Re: [BUGS] PostgreSQL crash on Freebsd 7

2007-11-01 Thread Larry Rosenman
do you have a repeatable test case? I have a FreeBSD 7/amd64 box that I can do the following: 1) make test runs 2) make available to a developer. -- Larry Rosenman http://www.lerctr.org/~ler Phone: +1 512-248-2683E-Mail: [EMAIL PROTECTED] US Mail: 430

Re: [BUGS] postgresql-[any version] from FreeBSD ports - startup problems after crash

2006-05-15 Thread Larry Rosenman
ql_user} -c "exec ${command} ${command_args} >> ${rc_arg}" > > Yeah, but what's the ${command} ? > > If it's pg_ctl then all he's missing is the recent change to check > getppid. If it's execing postmaster directly then maybe we need >