Request a Demo
Home   >   mailing lists

Re: Table both does not and does exist! wth? - Mailing list pgsql-general

From Jim Nasby
Subject Re: Table both does not and does exist! wth?
Date
Msg-id 64FF30E2-A8A4-4B5C-87A1-C0F905721B97@nasby.net
Whole thread Raw
In response to Re: Table both does not and does exist! wth?  (Melvin Davidson <melvin6925@yahoo.com>)
List pgsql-general
Tree view 
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@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

pgsql-general by date:

Previous
From: Naoko Reeves
Date:
Subject: Unable to kill local COPY
Next
From: Jim Nasby
Date:
Subject: Re: DB files, sizes and cleanup