Re: Table with Field Serial - Problem

On 10/31/2013 11:12 AM, Yostin Vargas wrote:
> i really dont need a number generator, only a unique PK. but i want that
> this PK be generate automatically
>
> for example i have a Category calling Computer in English but i have the
> same Category in Spanish (Computadora)  i assigned the ID->1 for both

So table1 is the category table:

id serial
category varchar

or

Why not just make your PK a natural one (category, language)?


In the end whatever works for you, works. I am just asking because I
could not follow the logic and I needed guidance.


>
> So if i put the Pk ID  in the table2 number i have error for unique
> violation when i want  INSERT another name in a diferent language for
> the same category
>
> For that reason i declare ID in the table2  like a FK from ID in the table1
>
>



--
Adrian Klaver
adrian.klaver@gmail.com