pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Ansley (UK) <Michael.Ansley@intec-telecom-systems.com>
To: 'William Courtier' <wcourtier@travelprice.com>
Cc: pgsql-sql@postgresql.org
Subject: RE: Re: Are circular REFERENCES possible ?
Date: Tue, 14 Aug 2001 14:16:54 +0100
Message-ID: <7F124BC48D56D411812500D0B747251480F66F@fileserver002.intecsystems.co.uk> (raw)

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

The easiest way out is probably to create a relationship entity
called 'default' between customer and shop for the default
relationship.  This way you only have to have one direct
relationship, because the other is expressed through the 'default'
table.

Just a thought...


MikeA



>> -----Original Message-----
>> From: William Courtier [mailto:wcourtier@travelprice.com]
>> Sent: 07 August 2001 11:10
>> To: pgsql-sql@postgresql.org
>> Subject: [SQL] Re: Are circular REFERENCES possible ?
>> 
>> 
>> I denis,
>> 
>> I don't know if you can use a circular REFERENCES, but why 
>> you try made a
>> references before the table is created (customers). You 
>> should create the
>> references after and use the foreign key if circular 
>> references does not
>> work.
>> 
>> William
>> "Denis Bucher" <dbucher@niftycom.com> a écrit dans le message
>> news: 5.1.0.14.0.20010807114609.00a18490@mail.niftycom.com...
>> >
>> > Hello !
>> >
>> > I have a case where I wanted to do circular REFERENCES, is this
>> > impossible ?
>> >
>> > Just an example where it would be useful :
>> >
>> > We deliver to the *shops* of our *customers*.
>> > We have therefore two tables :
>> >   - customers (enterprise, financial information, and so on...)
>> >   - shop (with a name, street, phone number, name of manager)
>> >
>> > Now, each shop REFERENCES a customer so that we know
>> > to which customer belongs a shop.
>> >
>> > AND, each customer has a DEFAULT shop for deliveries, i.e. most
>> > customers only have one shop, or a main shop and many small
>> > ones. Therefore a customer should REFERENCES the 'main' or 
>> 'default' shop.
>> >
>> > Which leads to :
>> >
>> > CREATE TABLE shops ( id_shop SERIAL PRIMARY KEY, id_cust integer
>> REFERENCES
>> > customers, .......)
>> > CREATE TABLE customers ( id_cust SERIAL PRIMARY KEY,
>> > id_defaultshop 
>> integer
>> > REFERENCES shops, .......)
>> >
>> > But this doesn't work ! Postgres complains like "ERROR: 
>> > Relation 'customers' does not exist"
>> > when creating 'shops'.
>> >
>> > Someone told me I should create a third table, ok, but in 
>> this case I
>> loose
>> > the total
>> > control about my logic... Do you have a suggestion ?
>> >
>> > Thanks a lot in advance !
>> >
>> > Denis
>> >
>> >
>> > ---------------------------(end of 
>> broadcast)---------------------------
>> > TIP 1: subscribe and unsubscribe commands go to 
>> majordomo@postgresql.org
>> 
>> 
>> 
>> ---------------------------(end of 
>> broadcast)---------------------------
>> TIP 2: you can get off all lists at once with the unregister
>> command 
>>     (send "unregister YourEmailAddressHere" to 
>> majordomo@postgresql.org)
>> 

-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com;

iQA/AwUBO3kkqnympNV/C086EQKcWgCfd1Z2Hbi/g7Rj633Myj67HxkjgvkAn1n+
hXvHqca0bqE73XY4tmjDq/7v
=2nf2
-----END PGP SIGNATURE-----

view thread (15+ messages)  latest in thread

Message-ID: <7F124BC48D56D411812500D0B747251480F66F@fileserver002.intecsystems.co.uk>
Permalink:  ../7F124BC48D56D411812500D0B747251480F66F@fileserver002.intecsystems.co.uk/
Also on:    postgresql.org/message-id/7F124BC48D56D411812500D0B747251480F66F@fileserver002.intecsystems.co.uk

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: Michael.Ansley@intec-telecom-systems.com, wcourtier@travelprice.com
  Subject: Re: Are circular REFERENCES possible ?
  In-Reply-To: <7F124BC48D56D411812500D0B747251480F66F@fileserver002.intecsystems.co.uk>
  References: <7F124BC48D56D411812500D0B747251480F66F@fileserver002.intecsystems.co.uk>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox