Обсуждение: Hoping - is there a 'automagically' way to emulate the PK/FK, etc settings in PostgreSQL in the relationships in Access?
Hello, Hoping - is there a 'automagically' way to emulate the PK/FK, etc settings in PostgreSQL in the relationships in Access? Maybe lookups to emulate that built in MS Access natively to emulate the FK relationships in the PostgreSQL linked tables? Just thought I would ask! ☺ ---------- Regards, GREG COCKS GIS Analyst V gcocks |at| stoller.com S. M. Stoller Corp 105 Technology Drive, Suite 190 Broomfield, CO 80021 www.stoller.com 303-546-4300 303-443-1408 fax 303-546-4422 direct 303-828-7576 cell
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Wed, 28 Nov 2007 16:24:54 -0700 "Greg Cocks" <gcocks@stoller.com> wrote: > Hello, > > Hoping - is there a 'automagically' way to emulate the PK/FK, etc > settings in PostgreSQL in the relationships in Access? What do you mean automagically? I haven't used Access in about 7 years but I seem to recall that if you had the relationship built, access would pick it up via odbc (at least with other databases). Joshua D. Drake > > Maybe lookups to emulate that built in MS Access natively to emulate > the FK relationships in the PostgreSQL linked tables? > > Just thought I would ask! ☺ > > ---------- > Regards, > GREG COCKS > GIS Analyst V > gcocks |at| stoller.com > S. M. Stoller Corp > 105 Technology Drive, Suite 190 > Broomfield, CO 80021 > www.stoller.com > 303-546-4300 > 303-443-1408 fax > 303-546-4422 direct > 303-828-7576 cell > > > ---------------------------(end of > broadcast)--------------------------- TIP 6: explain analyze is your > friend > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHTfoyATb/zqfZUUQRAtrrAKCMby0YPQSNL71Um2CTcPZvqurIOQCeMLbj B0SMoUMFC/HdW4dRlUNSZ24= =KArq -----END PGP SIGNATURE-----
Joshua D. Drake schrieb: > On Wed, 28 Nov 2007 16:24:54 -0700 > "Greg Cocks" <gcocks@stoller.com> wrote: > >> Hoping - is there a 'automagically' way to emulate the PK/FK, etc >> settings in PostgreSQL in the relationships in Access? >> > > What do you mean automagically? I haven't used Access in about 7 years > but I seem to recall that if you had the relationship built, access > would pick it up via odbc (at least with other databases). > Maybe he refers to the graphical representation of relations between tables within access MDBs. Then the answer was no. There is no automatic way for all I know. Access can mind fk-constraints only within one mdb file but one can manually draw simple connections between linked in external tables though those are just added sugar that will commodize query design a wee bit. AFAIK Access will use indexes within a postgresql db and is obviously bound to fk-constraints within the backend, though it won't fetch those constraints to use them for any magic like in the query builder. The query builder would know of relations in an MDB and autoconnect tables with such links as soon as they are dropped into the query graph. Cute ... but well ... you know ;) >> aybe lookups to emulate that built in MS Access natively to emulate >> the FK relationships in the PostgreSQL linked tables? >> Like mentioned above you may draw those links yourself. I wouldn't rule out that it might be possible to peek through odbc and analyse the backend to recreate the simple links within Access by VBA. Well, pgAdmin lists the table constraints so why shouldn't Access see them (somehow), too? This might prove to be "interesting" for a winter weekend without anything decent in the telly ;) Regards Andreas
|Joshua D. Drake schrieb: |> On Wed, 28 Nov 2007 16:24:54 -0700 |> "Greg Cocks" <gcocks@stoller.com> wrote: |>> Hoping - is there a 'automagically' way to emulate the PK/FK, etc |>> settings in PostgreSQL in the relationships in Access? |> What do you mean automagically? I haven't used Access in about 7 years |> but I seem to recall that if you had the relationship built, access |> would pick it up via odbc (at least with other databases). |> |Maybe he refers to the graphical representation of relations between |tables within access MDBs. |Then the answer was no. There is no automatic way for all I know. Exactly, that is it... I reconstructed manually off my ERD from PostgreSQL but always worried that I will miss something, etc Don't get me wrong though, I love that someone/s (sic) has made these drivers in the first instance, much appreciated... |Access can mind fk-constraints only within one mdb file but one can |manually draw simple connections between linked in external tables |though those are just added sugar that will commodize query design a wee |bit. And THAT is the main beauty, for me at least, of having the FK / relationships emulated in the Access front end, in the GUI Query Builder... whatever you say about Access, that IMHO is a sweet, sweet feature... |AFAIK Access will use indexes within a postgresql db and is obviously |bound to fk-constraints within the backend, though it won't fetch those |constraints to use them for any magic like in the query builder. |The query builder would know of relations in an MDB and autoconnect |tables with such links as soon as they are dropped into the query graph. |Cute ... but well ... you know ;) In my experience, not huge, Access can get a little 'confused' when running queries if there is a FK that is not emulated in the relationship ERD (sic) in Access... |>> Maybe lookups to emulate that built in MS Access natively to emulate |>> the FK relationships in the PostgreSQL linked tables? |>> |Like mentioned above you may draw those links yourself. |I wouldn't rule out that it might be possible to peek through odbc and |analyse the backend to recreate the simple links within Access by VBA. |Well, pgAdmin lists the table constraints so why shouldn't Access see |them (somehow), too? |This might prove to be "interesting" for a winter weekend without |anything decent in the telly ;) Yep, went through and drew them - but worried I missed some AND when I change my design I need to remember to propagate those changes 'down the line'... (interesting to see how Access handles those multiple links...) Shall I come over and unplug your telly? You can miss East Enders one weekend? GDR Cheers: GREG COCKS Gcocks |at| stoller.com
Greg Cocks schrieb: > |Joshua D. Drake schrieb: > |> On Wed, 28 Nov 2007 16:24:54 -0700 > |> "Greg Cocks" <gcocks@stoller.com> wrote: > > |>> Hoping - is there a 'automagically' way to emulate the PK/FK, etc > |>> settings in PostgreSQL in the relationships in Access? > > > In my experience, not huge, Access can get a little 'confused' when > running queries if there is a FK that is not emulated in the > relationship ERD (sic) in Access... > See ... the point is ... you are proposing development for an Access feature that might use pgodbc but isn't odbc driver functionality at all. So I may predict that the exitement in this discussion group here will be somewhat limited. > Yep, went through and drew them - but worried I missed some AND when I > change my design I need to remember to propagate those changes 'down the > line'... (interesting to see how Access handles those multiple links...) > It's really rather an Access topic. Hint: At least Access 2000 keeps such simple links and even real fk constraints in some cases even when the graph doesn't show them anymore. It works nicely if you explicitely delete a constraint in the graph. The irritation starts SOMETIMES when you drop or rename a connected table or even just change a column name that is part of a constraint. The next time you open the constraint-graph this constraint might have disappeared, though you still get the integrity-errors as if the constraint was still there. Try to find a tool that migrates real DBs to Access. Well, usually it's the other way round but maybe you are lucky. > Shall I come over and unplug your telly? You can miss East Enders one > weekend? Never heared of "East Enders" but thanks anyway. ;)