Skip site navigation (1) Skip section navigation (2)

N-to-N implementation

From: "Filipe Knoedt" <filipe(at)brasilenergia(dot)com(dot)br>
To: "PG LIST" <pgsql-admin(at)postgresql(dot)org>
Subject: N-to-N implementation
Date: 2005-07-21 15:38:18
Message-ID: 010901c58e0a$37e50420$1300a8c0@brasilenergia (view raw or flat)
Thread:
Lists: pgsql-admin
Hi all,

I'd like to set up a discussion (if necessary) about two different ways to implement N-to-N relationships: using a N-to-N intermediary table or, suppose an A and B tables situation, creating the primary key of the table B with the A.id plus a sequencer.

I'm thinking on going the second way, but decided to ask the list if anybody sees any potencial problem in it, like for performance or anything.

Filipe Knoedt

Responses

pgsql-admin by date

Next:From: Oleg BartunovDate: 2005-07-21 16:02:10
Subject: Re: N-to-N implementation
Previous:From: Bruce MomjianDate: 2005-07-21 14:50:24
Subject: Re: Statement logging per connection

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group