Thread: Visio not able to retrieve foreign keys against 8.3

Visio not able to retrieve foreign keys against 8.3

From

Mike Traum

Date:

23 March 2008, 20:43:39

MS Visio 2000 (and Visio 2003 according to http://www.postgresqlforums.com/forums/viewtopic.php?f=29&t=600&sid=16bea6222cbc9edf1dc5681a3ba9a939 )

is unable to extract foreign keys from Postgres 8.3.1 using it's reverse engineer capabilities. I've tried a number of odbc drivers (8.02.0100, 8.02.0200, 8.02.0400, 8.03.0100) against Postgres 8.3.1 and none work. However, it works with odbc 8.02.0400 against Postgres 8.2.7.

I'm not sure if this is an odbc issue or a postgres issue, but I thought I'd try here first.

Thanks,
Mike

Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.