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

Re: unique constraints on foreign keys

From: Jaime Casanova <systemguards(at)yahoo(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: unique constraints on foreign keys
Date: 2004-09-20 23:18:52
Message-ID: 20040920231852.9042.qmail@web50002.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
 --- Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
escribió: 
> 
> On Mon, 20 Sep 2004, Jaime Casanova wrote:
> 
> > There is a way to not enforce the creation of a
> > primary or unique index on a referenced table?
> 
> Not really. It's not the index that's important
> per-se, it's the uniqueness that is implied.

OK. What about to teach the planner always do a
seq on that table and do not ask for use the
index? but not using "set" instructions. can i do
that?


_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com

In response to

Responses

pgsql-admin by date

Next:From: Stephan SzaboDate: 2004-09-20 23:27:50
Subject: Re: unique constraints on foreign keys
Previous:From: Ramiro Batista da LuzDate: 2004-09-20 21:28:49
Subject: unsubscribe

pgsql-general by date

Next:From: Stephan SzaboDate: 2004-09-20 23:27:50
Subject: Re: unique constraints on foreign keys
Previous:From: Tom LaneDate: 2004-09-20 23:07:50
Subject: Re: using database for queuing operations?

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