From: Michael Glaesemann <grzm@myrealbox.com>
To: Maciej Piekielniak <piechcio@isb.com.pl>
Cc: pgsql-sql@postgresql.org
Subject: Re: alter table
Date: Thu, 16 Feb 2006 09:54:10 +0900
Message-ID: <7F00B433-6977-4340-841A-2084DD9736D4@myrealbox.com> (raw)
In-Reply-To: <1113783300.20060215191156@isb.com.pl>
References: <1113783300.20060215191156@isb.com.pl>
On Feb 16, 2006, at 3:11 , Maciej Piekielniak wrote:
> How can i modify few fields with alter?
I think you need to alter columns one at a time. If you need them to
go into effect at the same time, you can wrap the multiple ALTER
TABLE statements in a transaction. For example,
begin;
ALTER TABLE fv_wystawione ALTER id_fv SET DEFAULT nextval
('id_fv_seq'::text);
ALTER TABLE fv_wystawione ALTER imie SET DEFAULT '';
commit;
Michael Glaesemann
grzm myrealbox com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: grzm@myrealbox.com, piechcio@isb.com.pl
Subject: Re: alter table
In-Reply-To: <7F00B433-6977-4340-841A-2084DD9736D4@myrealbox.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox