Home > mailing lists

General question - Mailing list pgsql-general

From	salah jubeh
Subject	General question
Date	March 23, 2011 09:18:32
Msg-id	592812.2119.qm@web52701.mail.re2.yahoo.com Whole thread Raw
Responses	Re: General question
List	pgsql-general

Hello,

Some times the primary key is the same as the foreign key such as in the following design. which is used to model 1-1 relationship.

In the database books, such as database fundamentals(Masri), the 1-1 relation is modeled by having two separate key.

when this kind of design (shared key) is preferable and is there any anomalies to it.

create table Table1

( T1_Id integer not null primary key

, T1_Data varchar(9) not null

)

create table Table2

( T2_Id integer not null primary key

, T2_Data varchar(37) not null

, foreign key (T2_Id) references Table1 (T1_Id)

)

Thanks in advance

From: Adrian Schreyer
Date: 23 March 2011, 08:55:15
Subject: Re: Weird problems with C extension and bytea as input type

From: Martín Marqués
Date: 23 March 2011, 09:33:19
Subject: pg_dump problems