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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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