| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2004-09-20 23:27:50 | Re: unique constraints on foreign keys |
| Previous Message | Ramiro Batista da Luz | 2004-09-20 21:28:49 | unsubscribe |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephan Szabo | 2004-09-20 23:27:50 | Re: unique constraints on foreign keys |
| Previous Message | Tom Lane | 2004-09-20 23:07:50 | Re: using database for queuing operations? |