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