| From: | Kenneth Gonsalves <lawgon(at)thenilgiris(dot)com> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: unique constraints |
| Date: | 2004-01-08 04:20:22 |
| Message-ID: | 0401080950220V.02497@thenilgiris.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wednesday 07 January 2004 23:01, Michael Fuhr wrote:
> On Wed, Jan 07, 2004 at 07:47:32PM +0530, Kenneth Gonsalves wrote:
> > in 7.4 i'm getting an error message - UNIQUE constraint matching keys for
> > table 'xxx' not found - any clues?
>
> It would be helpful to see the *exact* wording of the error message and
> the SQL statements that can be used to reproduce the error.
ok, got it now - the key in question was a 'serial' key. in older versions of
postgres, since serial keys are anyway unique, apparently we could get away
with not explicitly giving an unique constraint - sigh, a lot of work lies
ahead ...
--
regards
kg
http://www.ootygolfclub.org
poor man's tally: http://avsap.sourceforge.net
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Chris Travers | 2004-01-08 10:02:59 | Re: Calendar Scripts - Quite a complex one |
| Previous Message | Peter Eisentraut | 2004-01-07 18:41:25 | Re: Importation wtih copy generated some wrong registers.. |