Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 091C9475EC7 for ; Sat, 25 Jan 2003 06:52:33 -0500 (EST) Received: from mail.computer-systeme.de (unknown [62.145.19.133]) by postgresql.org (Postfix) with ESMTP id 54EB7475E45 for ; Sat, 25 Jan 2003 06:52:32 -0500 (EST) Received: from computer-systeme.de (pD9517805.dip.t-dialin.net [217.81.120.5]) by mail.computer-systeme.de (Postfix) with ESMTP id AC84FA441; Sat, 25 Jan 2003 12:52:33 +0100 (CET) Message-ID: <3E327A54.8030800@computer-systeme.de> Date: Sat, 25 Jan 2003 12:51:48 +0100 From: Philipp Ottlinger Organization: Computer & Systeme GmbH, Berlin User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3b) Gecko/20021220 X-Accept-Language: en-us, en, de, ja, zh MIME-Version: 1.0 To: ryanne cruz Cc: pgsql-php@postgresql.org Subject: Re: not null References: <1043495560.3e327a8815907@mail.up.edu.ph> In-Reply-To: <1043495560.3e327a8815907@mail.up.edu.ph> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200301/68 X-Sequence-Number: 1813 ryanne cruz wrote: > > hi list. > > i have a column that has a "not null" as its modifier. is there a way that i > can remove that? or better yet to make it a "serial not null"? > It depends on your entitiy-relationship schema - usually it makes sense to define things as "not null" and it shouldn't be considered to be taken away just by chance !!! Usually you can alter the TABLE to remove such constraints ... SERIAL - if I'm not too mistaken - is automatically maintained by postgres as an implicit sequence whose values are generated by calling sequence.nextval autonomously everytime you "need" a value! Yours, Phil