On Tue, Feb 10, 2004 at 12:03:36 -0500, [EMAIL PROTECTED] wrote: > Hi all i am using postgres and torque > I have a column x in Table A of type varchar and NOT NULL. I want to > impose a unique key constraint on that table and column y is the primary > key. > I have another Table B with column x. can i make this column x as a > foreign key on column x in table A.
Yes. The reference will need to specify column x, since the primary key column (y) will be the default. > or Can i have varchar types of size 50 as primary keys in Postgres. Yes. But unless the 50 character limit comes from a business rule, you might want to use the type 'text'. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
