Re: Table Relationships - Mailing list pgsql-sql

From Curtis Scheer
Subject Re: Table Relationships
Date
Msg-id 031936836C46D611BB1B00508BE7345D04C02FAE@gatekeeper.daycos.com
Whole thread Raw
In response to Table Relationships  (Curtis Scheer <Curtis@DAYCOS.com>)
List pgsql-sql

Thanks for the help.

 


From: Aaron Bono [mailto:postgresql@aranya.com]
Sent: Tuesday, October 31, 2006 2:44 PM
To: A. Kretschmer
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Table Relationships

 

On 10/31/06, A. Kretschmer <andreas.kretschmer@schollglas.com> wrote:

am  Tue, dem 31.10.2006, um 21:08:24 +0100 mailte A. Kretschmer folgendes:
> am  Tue, dem 31.10.2006, um 13:32:59 -0600 mailte Aaron Bono folgendes:
> > I would go further by adding a type table like this:
> >
> > operation_type (
> >     operation_type_id bigserial (PK),
>
> You are sure, that you need bigserial?

Hey, your idea is okay, but i think, we don't need *BIG*serial for this.
Okay?


Andreas


Sorry, just force of habbit.  Serial works or you can just drop the id and use the code as the primary key.  You should at the very least put a unique constraint on the code field.

--
==================================================================
   Aaron Bono
   Aranya Software Technologies, Inc.
   http://www.aranya.com
   http://codeelixir.com
==================================================================

pgsql-sql by date:

Previous
From: Volkan YAZICI
Date:
Subject: Re: record datatype comparisons
Next
From: roopa perumalraja
Date:
Subject: Re: Add calculated fields from one table to other table