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) VALUES

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 broadcast)-

[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"

[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 in

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 -

[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 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 allowin

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 >

[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 s

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 Gregori

[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 /usr/include/math.