Re: [BUGS] to_char(date,'YYYYMMDD') bug

2002-10-30 Thread Tom Lane
Jord Tanner <[EMAIL PROTECTED]> writes: > It looks like to_char is unable to convert dates that fall in the range > of 01/01/1902 to 12/31/1969 (see below). I am running the Postgresql RPM > that is distributed with RH 8.0 (7.2.2.1). PGDATESTYLE is set to "SQL". You need PG 7.2.3; it works around

[BUGS] to_char(date,'YYYYMMDD') bug

2002-10-30 Thread Jord Tanner
Greetings, It looks like to_char is unable to convert dates that fall in the range of 01/01/1902 to 12/31/1969 (see below). I am running the Postgresql RPM that is distributed with RH 8.0 (7.2.2.1). PGDATESTYLE is set to "SQL". I find to_char behaves correctly on my RH 7.2 box with Postgresql 7.2

Re: [BUGS] Bug #808: bison dies with max table size fatal error

2002-10-30 Thread Neil Conway
[EMAIL PROTECTED] writes: > bison -y -d preproc.y > preproc.y:5560: fatal error: maximum table size (32767) exceeded You need to use Bison 1.50 or greater -- although if you're building an official source release (e.g. 7.3beta3), Bison shouldn't be required at all. Cheers, Neil -- Neil Conway

[BUGS] Bug #808: bison dies with max table size fatal error

2002-10-30 Thread pgsql-bugs
Dave Bartmess ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description bison dies with max table size fatal error Long Description I downloaded the source, ran configure with --with-java option, then ran make. The error coming back is:

Re: [BUGS] hi-problem while installing postgressql 7.2 version

2002-10-30 Thread Stephan Szabo
On Wed, 30 Oct 2002, saurabh garg wrote: > while Creating a database cluster postgressql it just hangs. i'm using > these command on cygwin. i gave the command > ./configure > make > make install > make install-all-headers > all above are sucessful. after that i set the environmental path in >

[BUGS] PostgreSQL Installation on SCO

2002-10-30 Thread Shibashish
Dear Sir, I use SCO Open Server 5.0.5 on an intel box. Although I have installed and used PostgreSQL on Linux, setting it on SCO has not been smooth :) I have downloaded the latest version ie "Postgresql-7.2.3." I also installed "ant" package for using java. I have "tcl8.0," "tk8.0," "itclsh3.0" an

[BUGS] hi-problem while installing postgressql 7.2 version

2002-10-30 Thread saurabh garg
hi while Creating a database cluster postgressql it just hangs. i'm using these command on cygwin. i gave the command ./configure make make install make install-all-headers all above are sucessful. after that i set the environmental path in profile. now i give initdb -D /usr/local/pgsql/data th

[BUGS] /tmp/.s.PGSQL.5432.lock: Permission denied

2002-10-30 Thread Ban
Hi,   I tried to run postgreSQL service under NT4 many times, and I always get the following messages in postgreSQL.log:   FATAL 1:  Can't read lock file /tmp/.s.PGSQL.5432.lock: Permission denied\   (full detail is in the attachment). What am I going to do to solve the problem? thanks. Po

[BUGS] Wrong order of rows in result during regression test.

2002-10-30 Thread Magnus Enbom
POSTGRESQL BUG REPORT TEMPLATE Your name : Magnus Enbom Your email address : [EMAIL PROTECTED] System Config

Re: [BUGS] Bug #805: pg_dump examines all tables even with -t "table_name" speficied

2002-10-30 Thread Vitaliy Fuks
Hello, Could there potentially be an option in addition to -t "table_name", to either: a) Examine all relationships and dump all dependant objects b) Dump only table named "table_name" One can argue that when asking for "a" table one really only wants that table information, and nothing else. S

Re: [BUGS] Postgresql 7.2.3

2002-10-30 Thread Vincent Lim
Dear sir(s)/madam(s), I have upgraded to 7.2.3 as advised. However, I still get the following errors: DEBUG: recycled transaction log file 00DE FATAL 2: open of /var/lib/pgsql/data/pg_clog/0747 failed: No such file or directory DEBUG: server process (pid 22689) exited with exit cod

Re: [BUGS] socket problem under BeOS

2002-10-30 Thread Mr Yves Crevecoeur
Hi, Make sure you are running postmaster with the -i option.  Also double check you pg_hba.conf ciao yc  drac <[EMAIL PROTECTED]> wrote: Hallo!I have a problem with BeOS and PostgreSQL7.2.1 with BONE.The follow error is comming.$ createdb db01psql: could not create socket: Address family not suppor