Re: [GENERAL] SERIAL and Primary Key

On Fri, Feb 29, 2008 at 2:28 PM, Mike Gould <[EMAIL PROTECTED]> wrote: > > > CREATE TABLE "fav5"."batchnumber" ( > "batchnumberid" SERIAL NOT NULL, > "processtype" SMALLINT NOT NULL, > "termloc" CHAR(3) NOT NULL, > "batchno" INTEGER NOT NULL > ) WITHOUT OIDS; > > With the above table defini

Re: [GENERAL] SERIAL and Primary Key

On Fri, Feb 29, 2008 at 03:28:11PM -0500, Mike Gould wrote: > CREATE TABLE "fav5"."batchnumber" ( > "batchnumberid" SERIAL NOT NULL, > "processtype" SMALLINT NOT NULL, > "termloc" CHAR(3) NOT NULL, > "batchno" INTEGER NOT NULL > ) WITHOUT OIDS; > With the above table definition, is bat

Re: [GENERAL] SERIAL and Primary Key

On Feb 29, 2008, at 2:28 PM, Mike Gould wrote: CREATE TABLE "fav5"."batchnumber" ( "batchnumberid" SERIAL NOT NULL, "processtype" SMALLINT NOT NULL, "termloc" CHAR(3) NOT NULL, "batchno" INTEGER NOT NULL ) WITHOUT OIDS; With the above table definition, is batchnumberid by default also

[GENERAL] SERIAL and Primary Key

CREATE TABLE "fav5"."batchnumber" ( "batchnumberid" SERIAL NOT NULL, "processtype" SMALLINT NOT NULL, "termloc" CHAR(3) NOT NULL, "batchno" INTEGER NOT NULL ) WITHOUT OIDS; With the above table definition, is batchnumberid by default also defined as the primary key or do I still need