Обсуждение: 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.  ;)