search

SylvainTI / wwwsqldesigner

Automatically exported from code.google.com/p/wwwsqldesigner
BSD 3-Clause "New" or "Revised" License
0 stars 0 forks source link

foreign keys should be available with "unique" type key #20

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
the foreign key feature should be available on "unique" key

for instance

create table test (
  id bigserial unique
)
create table blah (
  test_id bigint references test(id)
)

works in postgresql

Original issue reported on code.google.com by amaury.j...@gmail.com on 8 Jun 2009 at 2:00

GoogleCodeExporter commented 9 years ago 
Yes, this is a valid point. Any column that has an index on it should offer 
foreign
key creation.

Original comment by ondrej.zara on 8 Jun 2009 at 3:59

GoogleCodeExporter commented 9 years ago

Original comment by ondrej.zara on 8 Jun 2009 at 3:59

GoogleCodeExporter commented 9 years ago 
Fixed in revision 42.

Original comment by ondrej.zara on 9 Jun 2009 at 11:29