[BUGS] Compiler warning on Debian/Sparc

2003-03-03 Thread Hans-Jürgen Schönig
Hello ... I have compiled PostgreSQL on Debian/Woody on a Sparc machine. Unfortunately there are some nasty looking compiler warnings ... gcc -O3 -Wall -Wmissing-prototypes -Wmissing-declarations -I../../../../src/include -c -o giststrat.o giststrat.c In file included from

[BUGS] Bug or Performance Issue?

2003-03-03 Thread Michael Peddemors
We have a postgres backend to our Mail Server product, and encountering performance issues. Simple selects are taking 7-10 seconds.. We have of course applied all the suggested performance settings for Postgres, (We are running on Debian Stable/Linux BTW) We moved the database to a standalone

Re: [BUGS] psql -F problems

2003-03-03 Thread Hubert depesz Lubaczewski
On Thu, Feb 27, 2003 at 05:35:56PM -, Llew Sion Goodstadt wrote: Very curious now. So how would you enter the tab on the command line for sed? with ctrl-v ctrl-tab. YES. i know it is possible to enter tab character itself. and yes - i can work without it. yet - i still belive that allowing

[BUGS] Installation Errors

2003-03-03 Thread dinu paul
Dear sir, i am encounting the following problem while initializing data cluster(i am using Mac os x 10.2). Plez tell me solution for this -- bash-2.05a$ initdb -D /usr/local/PostgreSQL/data The files belonging to this database

Re: [BUGS] psql -F problems

2003-03-03 Thread Hubert depesz Lubaczewski
On Mon, Feb 24, 2003 at 11:19:18AM -, Llew Sion Goodstadt wrote: Most shells allow you to enter in a tab easily. In bash, you need to type control-V followed by a tab. I.e. type -F , followed by the Control-V/tab key sequence and the closing double quote. i know. i can even do: psql -c

[BUGS] Installation problem under Windows NT 4 german version

2003-03-03 Thread Herrmann, DP ITS, SMN, DD
Dear supporter team! I have downloaded your PostgrSQL 7.3.1 installation for windows! After installation the binaries, the post installation script does not work correctly. Therefore, i could not start your database. The reason is that i have an german installation of Windows NT 4! The german

[BUGS] Default values for nulls not being set.

2003-03-03 Thread Donald Fraser
PostgreSQL 7.3.1 on i686-pc-linux-gnu, compiled by GCC 2.96 Given the following SQL: CREATE TABLE "tbl_test" ( "id" int4 NOT NULL, "b_disabled" bool DEFAULT '0' NOT NULL, "s_desc" text NOT NULL, "dt_edited" timestamp (0) without time zone DEFAULT 'now' NOT NULL, CONSTRAINT "tbl_test_pkey"

Re: [BUGS] Installation problem under Windows NT 4 german version

2003-03-03 Thread Peter Eisentraut
Herrmann, DP ITS, SMN, DD writes: I have downloaded your PostgrSQL 7.3.1 installation for windows! We do not distribute any Windows version of PostgreSQL. Please complain to whomever you got it from. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of

Re: [BUGS] Default values for nulls not being set.

2003-03-03 Thread Tom Lane
Donald Fraser [EMAIL PROTECTED] writes: I have a major problem with DEAFAULT values: Consider attaching a default to the view column. As-is, its default is NULL (and I can't see any good argument for the factory default being anything else). tt=# INSERT INTO vu_tbl_test (id, s_desc)

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-03-03 Thread Ross J. Reedstrom
On Mon, Feb 24, 2003 at 11:06:38PM -0500, Tom Lane wrote: Robert Treat [EMAIL PROTECTED] writes: I guess adding 1 day to 1752-09-02 should give us 1752-09-14, but your right, it gives us 1752-09-03. As was pointed out at length just recently, the transition from Julian to Gregorian

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-03-03 Thread Tim Ellis
On Mon, 2003-02-24 at 23:03, Oliver Elphick wrote: different for different countries. There was a discussion of this on the patches list recently (http://archives.postgresql.org/pgsql-patches/2003-02/msg00038.php and the surrounding thread). The SQL spec calls for the Gregorian calendar to