Hoping - is there a "automagically" way to emulate the PK/FK, etc settings in PostgreSQL in the rela

SGVsbG8sDQoNCkhvcGluZyAtIGlzIHRoZXJlIGEgJ2F1dG9tYWdpY2FsbHkn
IHdheSB0byBlbXVsYXRlIHRoZSBQSy9GSywgZXRjIHNldHRpbmdzIGluIFBv
c3RncmVTUUwgaW4gdGhlIHJlbGF0aW9uc2hpcHMgaW4gQWNjZXNzPw0KDQpN
YXliZSBsb29rdXBzIHRvIGVtdWxhdGUgdGhhdCBidWlsdCBpbiBNUyBBY2Nl
c3MgbmF0aXZlbHkgdG8gZW11bGF0ZSB0aGUgRksgcmVsYXRpb25zaGlwcyBp
biB0aGUgUG9zdGdyZVNRTCBsaW5rZWQgdGFibGVzPw0KDQpKdXN0IHRob3Vn
aHQgSSB3b3VsZCBhc2shICAg4pi6DQoNCi0tLS0tLS0tLS0NClJlZ2FyZHMs
DQpHUkVHIENPQ0tTDQpHSVMgQW5hbHlzdCBWDQpnY29ja3MgfGF0fCBzdG9s
bGVyLmNvbQ0KUy4gTS4gU3RvbGxlciBDb3JwDQoxMDUgVGVjaG5vbG9neSBE
cml2ZSwgU3VpdGUgMTkwDQpCcm9vbWZpZWxkLCBDTyA4MDAyMQ0Kd3d3LnN0
b2xsZXIuY29tDQozMDMtNTQ2LTQzMDANCjMwMy00NDMtMTQwOCBmYXgNCjMw
My01NDYtNDQyMiBkaXJlY3QNCjMwMy04MjgtNzU3NsKgY2VsbA0KDQoKLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKGVuZCBvZiBicm9hZGNhc3QpLS0t
LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tClRJUCA2OiBleHBsYWluIGFuYWx5
emUgaXMgeW91ciBmcmllbmQK

Re: Hoping - is there a "automagically" way to emulate thePK/FK, etc settings in PostgreSQL in the r

LS0tLS1CRUdJTiBQR1AgU0lHTkVEIE1FU1NBR0UtLS0tLQ0KSGFzaDogU0hB
MQ0KDQpPbiBXZWQsIDI4IE5vdiAyMDA3IDE2OjI0OjU0IC0wNzAwDQoiR3Jl
ZyBDb2NrcyIgPGdjb2Nrc0BzdG9sbGVyLmNvbT4gd3JvdGU6DQoNCj4gSGVs
bG8sDQo+IA0KPiBIb3BpbmcgLSBpcyB0aGVyZSBhICdhdXRvbWFnaWNhbGx5
JyB3YXkgdG8gZW11bGF0ZSB0aGUgUEsvRkssIGV0Yw0KPiBzZXR0aW5ncyBp
biBQb3N0Z3JlU1FMIGluIHRoZSByZWxhdGlvbnNoaXBzIGluIEFjY2Vzcz8N
Cg0KV2hhdCBkbyB5b3UgbWVhbiBhdXRvbWFnaWNhbGx5PyBJIGhhdmVuJ3Qg
dXNlZCBBY2Nlc3MgaW4gYWJvdXQgNyB5ZWFycw0KYnV0IEkgc2VlbSB0byBy
ZWNhbGwgdGhhdCBpZiB5b3UgaGFkIHRoZSByZWxhdGlvbnNoaXAgYnVpbHQs
IGFjY2Vzcw0Kd291bGQgcGljayBpdCB1cCB2aWEgb2RiYyAoYXQgbGVhc3Qg
d2l0aCBvdGhlciBkYXRhYmFzZXMpLg0KDQpKb3NodWEgRC4gRHJha2UNCg0K
PiANCj4gTWF5YmUgbG9va3VwcyB0byBlbXVsYXRlIHRoYXQgYnVpbHQgaW4g
TVMgQWNjZXNzIG5hdGl2ZWx5IHRvIGVtdWxhdGUNCj4gdGhlIEZLIHJlbGF0
aW9uc2hpcHMgaW4gdGhlIFBvc3RncmVTUUwgbGlua2VkIHRhYmxlcz8NCj4g
DQo+IEp1c3QgdGhvdWdodCBJIHdvdWxkIGFzayEgICDimLoNCj4gDQo+IC0t
LS0tLS0tLS0NCj4gUmVnYXJkcywNCj4gR1JFRyBDT0NLUw0KPiBHSVMgQW5h
bHlzdCBWDQo+IGdjb2NrcyB8YXR8IHN0b2xsZXIuY29tDQo+IFMuIE0uIFN0
b2xsZXIgQ29ycA0KPiAxMDUgVGVjaG5vbG9neSBEcml2ZSwgU3VpdGUgMTkw
DQo+IEJyb29tZmllbGQsIENPIDgwMDIxDQo+IHd3dy5zdG9sbGVyLmNvbQ0K
PiAzMDMtNTQ2LTQzMDANCj4gMzAzLTQ0My0xNDA4IGZheA0KPiAzMDMtNTQ2
LTQ0MjIgZGlyZWN0DQo+IDMwMy04MjgtNzU3NsKgY2VsbA0KPiANCj4gDQo+
IC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLShlbmQgb2YNCj4gYnJvYWRj
YXN0KS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSBUSVAgNjogZXhwbGFp
biBhbmFseXplIGlzIHlvdXINCj4gZnJpZW5kDQo+IA0KDQoNCi0gLS0gDQoN
CiAgICAgID09PSBUaGUgUG9zdGdyZVNRTCBDb21wYW55OiBDb21tYW5kIFBy
b21wdCwgSW5jLiA9PT0NClNhbGVzL1N1cHBvcnQ6ICsxLjUwMy42NjcuNDU2
NCAgIDI0eDcvRW1lcmdlbmN5OiArMS44MDAuNDkyLjIyNDANClBvc3RncmVT
UUwgc29sdXRpb25zIHNpbmNlIDE5OTcgIGh0dHA6Ly93d3cuY29tbWFuZHBy
b21wdC5jb20vDQoJCQlVTklRVUUgTk9UIE5VTEwNCkRvbmF0ZSB0byB0aGUg
UG9zdGdyZVNRTCBQcm9qZWN0OiBodHRwOi8vd3d3LnBvc3RncmVzcWwub3Jn
L2Fib3V0L2RvbmF0ZQ0KUG9zdGdyZVNRTCBSZXBsaWNhdGlvbjogaHR0cDov
L3d3dy5jb21tYW5kcHJvbXB0LmNvbS9wcm9kdWN0cy8NCg0KLS0tLS1CRUdJ
TiBQR1AgU0lHTkFUVVJFLS0tLS0NClZlcnNpb246IEdudVBHIHYxLjQuNiAo
R05VL0xpbnV4KQ0KDQppRDhEQlFGSFRmb3lBVGIvenFmWlVVUVJBdHJyQUtD
TWJ5MFlQUVNOTDcxVW0yQ1RjUFp2cXVySU9RQ2VNTGJqDQpCMFNNb1VNRkMv
SGRXNGRSbFVOU1oyND0NCj1LQXJxDQotLS0tLUVORCBQR1AgU0lHTkFUVVJF
LS0tLS0NCgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0oZW5kIG9mIGJy
b2FkY2FzdCktLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0KVElQIDc6IFlv
dSBjYW4gaGVscCBzdXBwb3J0IHRoZSBQb3N0Z3JlU1FMIHByb2plY3QgYnkg
ZG9uYXRpbmcgYXQKCiAgICAgICAgICAgICAgICBodHRwOi8vd3d3LnBvc3Rn
cmVzcWwub3JnL2Fib3V0L2RvbmF0ZQo=

Re: Hoping - is there a "automagically" way to emulate thePK/FK, etc settings in PostgreSQL in the r

Joshua D. Drake schrieb:
> On Wed, 28 Nov 2007 16:24:54 -0700
> "Greg Cocks" 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




---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: Hoping - is there a "automagically" way to emulate the PK/FK, etc settings in PostgreSQL in the

|Joshua D. Drake schrieb:
|> On Wed, 28 Nov 2007 16:24:54 -0700
|> "Greg Cocks" 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).
|> =20
|Maybe he refers to the graphical representation of relations between=20
|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=20
|manually draw simple connections between linked in external tables=20
|though those are just added sugar that will commodize query design a
wee=20
|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=20
|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=20
|tables with such links as soon as they are dropped into the query
graph.=20
|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?
|>> =20
|Like mentioned above you may draw those links yourself.
|I wouldn't rule out that it might be possible to peek through odbc and=20
|analyse the backend to recreate the simple links within Access by VBA.=20
|Well, pgAdmin lists the table constraints so why shouldn't Access see=20
|them (somehow), too?
|This might prove to be "interesting" for a winter weekend without=20
|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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Re: Hoping - is there a "automagically" way to emulate thePK/FK, etc settings in PostgreSQL in the r

Greg Cocks schrieb:
> |Joshua D. Drake schrieb:
> |> On Wed, 28 Nov 2007 16:24:54 -0700
> |> "Greg Cocks" 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. ;)



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend