Received: from yuubin.games.no (yuubin.link.no [193.213.36.89]) by hub.org (8.8.8/8.7.5) with ESMTP id HAA10928 for ; Wed, 10 Jun 1998 07:43:49 -0400 (EDT) Received: from sleeper.games.no (pere@sleeper.link.no [193.213.36.74]) by yuubin.games.no (8.8.7/8.8.7) with ESMTP id NAA09626; Wed, 10 Jun 1998 13:44:42 +0200 Received: (from pere@localhost) by sleeper.games.no (8.8.7/8.8.7) id NAA11630; Wed, 10 Jun 1998 13:43:25 +0200 Date: Wed, 10 Jun 1998 13:43:25 +0200 Message-Id: <199806101143.NAA11630@sleeper.games.no> To: pgsql-sql@postgresql.org Cc: kenrsc@games.no Subject: Re: [SQL] Problems with default date 'now' From: Petter Reinholdtsen Reply-to: pere@td.org.uit.no > replace your field definition with this one: > > received_date DATE DEFAULT CURRENT_DATE > > it works fine. Nope, that did not work. I get this reply from psql: WARN:parser: parse error at or near "current_date" What is wrong. Is this something new in PostgreSQL after v6.2.1? I don't follow the SQL mailinglist, so please send me a copy when you reply. -- ##> Petter Reinholdtsen <## | pere@td.org.uit.no O- http://www.hungry.com/~pere/ | Go Mozilla, go! Go!