X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 34C4047638A
	for <pgsql-sql@postgresql.org>; Tue, 29 Apr 2003 05:19:01 -0400 (EDT)
Received: from shop.sme.sk (episoftware.casablanca.sk [217.11.230.150])
	by postgresql.org (Postfix) with ESMTP id 8607A4762D7
	for <pgsql-sql@postgresql.org>; Tue, 29 Apr 2003 05:18:25 -0400 (EDT)
Received: from [193.58.192.97] (helo=juice)
	by shop.sme.sk with esmtp (Exim 3.35 #1 (Debian)) id 19AR0r-00019U-00
	for <pgsql-sql@postgresql.org>; Tue, 29 Apr 2003 11:02:58 +0200
Received: from localhost.localdomain ([192.168.1.25]) by juice
	for pgsql-sql@postgresql.org; Tue, 29 Apr 2003 11:14:24 +0200
Subject: ALERT column
From: Rado Petrik <r.p@szm.sk>
To: PostgreSQL-mailinglist <pgsql-sql@postgresql.org>
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
X-Mailer: Ximian Evolution 1.0.8 
Date: 29 Apr 2003 11:14:25 +0200
Message-Id: <1051607665.777.12.camel@caj>
Mime-Version: 1.0
X-Spam-Status: No, hits=-10.2 required=5.0
	tests=BAYES_10,NO_DNS_FOR_FROM,UPPERCASE_25_50,USER_AGENT_XIMIAN
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/422
X-Sequence-Number: 13123


Hi , 


I have column dt_created  type "timestamptz"

and I need set default value  "now()"  in exist database. No new !!

This example is not good .

ALTER TABLE user ALERT COLUMN dt_created SET DEFAULT=now();

Thanks.

Rado.