Re: Composite UNIQUE across two tables?

From: Rodrigo E(dot) De León Plicet <rdeleonp(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Composite UNIQUE across two tables?
Date: 2008-03-11 20:31:48
Message-ID: a55915760803111331y275fd1e6s24e46ce4aaf73ce0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Tue, Mar 11, 2008 at 2:03 PM, Dirk Jagdmann <jagdmann(at)gmail(dot)com> wrote:
> For my tests, I have modified your posted schema a bit, to
> unify all column names to "name".

OT and IMHO, this is not good practice. Column names should be unique
and descriptive throughout the entire schema.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Emi Lu 2008-03-12 15:47:18 case when... end in update clause?
Previous Message Dirk Jagdmann 2008-03-11 19:03:43 Re: Composite UNIQUE across two tables?