Darcy,
> It has to do somewhat with database theory. There is a basic
> distinction
> between a unique index and a primary key. Ideally, the primary key
> should
> never change but a unique key can as long as the new value is also
> unique.
> PostgreSQL doesn't enforce this (I think it should)
Thus spake Gonzo Rock
> Why would one need a Primary Key... which can only be declared at table creation if
>one can create a Unique Index post table creation?
>
> ie: I deleted my primary key... is that a big deal? What's the purpose of the
>Primary Key if it's function can be duplicated with
Why would one need a Primary Key... which can only be declared at table creation if
one can create a Unique Index post table creation?
ie: I deleted my primary key... is that a big deal? What's the purpose of the Primary
Key if it's function can be duplicated with another Unique Index?
thanks,
