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.kla...@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
