Re: Table both does not and does exist! wth?

From: Jim Nasby <jim(at)nasby(dot)net>
To: Melvin Davidson <melvin6925(at)yahoo(dot)com>
Cc: depesz(at)depesz(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: Table both does not and does exist! wth?
Date: 2010-12-19 18:05:04
Message-ID: 64FF30E2-A8A4-4B5C-87A1-C0F905721B97@nasby.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Dec 17, 2010, at 10:34 AM, Melvin Davidson wrote:
> >please don't name your constraint using the same name you named your
> >table.
>
> I can't believe I missed the obvious, but that's why it's better to have someone else
> take a look.
> Thanks for spotting that. I've tacked on _pk to the constraint. Fixed!

FWIW, I find it useful to provide some kind of indication of what fields are in the index in the index name, ie: xtmp_changed_ids__pk_seq_all.
--
Jim C. Nasby, Database Architect jim(at)nasby(dot)net
512.569.9461 (cell) http://jim.nasby.net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2010-12-19 18:07:25 Re: DB files, sizes and cleanup
Previous Message Naoko Reeves 2010-12-19 17:42:23 Unable to kill local COPY