X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8A106DACDE for ; Tue, 15 Nov 2005 12:17:36 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 47246-06 for ; Tue, 15 Nov 2005 16:17:33 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 18854DAAAA for ; Tue, 15 Nov 2005 12:17:33 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id jAFGHWaq035383 for ; Tue, 15 Nov 2005 16:17:32 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id jAFFwReb017599 for pgsql-admin@postgresql.org; Tue, 15 Nov 2005 15:58:27 GMT (envelope-from news) From: "codeWarrior" X-Newsgroups: pgsql.admin Subject: Re: Timestamp not working Date: Tue, 15 Nov 2005 08:01:03 -0800 Organization: Hub.Org Networking Services Lines: 25 Message-ID: References: <88odf.2261$fN5.887@newsfe6-gui.ntli.net> X-Complaints-To: usenet@news.hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2670 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2670 X-RFC2646: Format=Flowed; Original To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=-0.891 required=5 tests=[ALL_TRUSTED=-1.44, FORGED_HOTMAIL_RCVD2=0.549] X-Spam-Score: -0.891 X-Spam-Level: X-Archive-Number: 200511/188 X-Sequence-Number: 19561 CREATE TABLE mytable ( id serial not null primary key, myvalue varchar(50), create_dt timestamp not null default now() ); INSERT INTO mytable (myvalue) VALUES ('When was this record inserted ?'); SELECT * FROM mytable; "Si" wrote in message news:88odf.2261$fN5.887@newsfe6-gui.ntli.net... >I have added a field to one of my PostgreSQL tables in the "Timestamp" >datatype, but when I add a row to that table I don't get the date and time >inserted into that column? Do I need to put a default value into the column >too? >