Domain data types
am 26.02.2008 17:12:51 von LuizThis is a multi-part message in MIME format.
------=OPENWEBMAIL_ATT_0.872410221814306
Content-Type: text/plain;
charset=iso-8859-1
Hi,
Odbc 8.01.300 don´t resolve domain data types and so return unexpected results.
I guess that this modification on PGAPI_Columns function can solve this.
It´s based on information_schema.columns view
I don´t have a compiler enviroment to test. I will be glad if someone can test
this.
PS.: I posted this on the bug track system, then I realized that post in the
BTS first might not be the correct procedure. Sorry for the noise.
Best Regards
Luiz
--
Plan IT Tecnologia Informatica Ltda.
------=OPENWEBMAIL_ATT_0.872410221814306
Content-Type: application/octet-stream;
name="info.diff"
Content-Disposition: attachment; filename="info.diff"
Content-Transfer-Encoding: base64
SW5kZXg6IGluZm8uYw0KPT09PT09PT09PT09PT09PT09PT09PT09PT09PT09
PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PT09PQ0KUkNTIGZp
bGU6IC9jdnNyb290L3BzcWxvZGJjL3BzcWxvZGJjL2luZm8uYyx2DQpyZXRy
aWV2aW5nIHJldmlzaW9uIDEuMTQ4DQpkaWZmIC1yMS4xNDggaW5mby5jDQoy
MDU1LDIwNThjMjA1NSwyMDYwDQo8IAkJCSJzZWxlY3Qgbi5uc3BuYW1lLCBj
LnJlbG5hbWUsIGEuYXR0bmFtZSwgYS5hdHR0eXBpZCINCjwgCSAgIAkJIiwg
dC50eXBuYW1lLCBhLmF0dG51bSwgYS5hdHRsZW4sIGEuYXR0dHlwbW9kLCBh
LmF0dG5vdG51bGwiDQo8IAkJCSIsIGMucmVsaGFzcnVsZXMsIGMucmVsa2lu
ZCwgYy5vaWQsIGQuYWRzcmMgZnJvbSAoKChwZ19jYXRhbG9nLnBnX2NsYXNz
IGMiDQo8IAkJCSIgaW5uZXIgam9pbiBwZ19jYXRhbG9nLnBnX25hbWVzcGFj
ZSBuIG9uIG4ub2lkID0gYy5yZWxuYW1lc3BhY2UiLA0KLS0tDQo+IAkJCSJz
ZWxlY3Qgbi5uc3BuYW1lLCBjLnJlbG5hbWUsIGEuYXR0bmFtZSINCj4gCQkJ
IiwgY2FzZSB3aGVuIHQudHlwdHlwZSA9ICdkJyB0aGVuIHQudHlwYmFzZXR5
cGUgZWxzZSBhLmF0dHR5cGlkIGVuZCBhcyBhdHR0eXBpZCINCj4gCQkJIiwg
Y29hbGVzY2UoYnQudHlwbmFtZSwgdC50eXBuYW1lICkgQVMgdHlwbmFtZSwg
YS5hdHRudW0sIGEuYXR0bGVuIg0KPiAJCQkiLCBjYXNlIHdoZW4gdC50eXB0
eXBlID0gJ2QnIHRoZW4gdC50eXB0eXBtb2QgZWxzZSBhLmF0dHR5cG1vZCBl
bmQgYXMgYXR0dHlwbW9kIg0KPiAJCQkiLCBhLmF0dG5vdG51bGwsIGMucmVs
aGFzcnVsZXMsIGMucmVsa2luZCwgYy5vaWQsIGQuYWRzcmMiDQo+IAkJCSIg
ZnJvbSAoKChwZ19jYXRhbG9nLnBnX2NsYXNzIGMgaW5uZXIgam9pbiBwZ19j
YXRhbG9nLnBnX25hbWVzcGFjZSBuIG9uIG4ub2lkID0gYy5yZWxuYW1lc3Bh
Y2UiLA0KMjA4MCwyMDgyYzIwODIsMjA4NQ0KPCAJCQkiIGFuZCBhLmF0dHJl
bGlkID0gYy5vaWQpIGlubmVyIGpvaW4gcGdfY2F0YWxvZy5wZ190eXBlIHQi
DQo8IAkJCSIgb24gdC5vaWQgPSBhLmF0dHR5cGlkKSBsZWZ0IG91dGVyIGpv
aW4gcGdfYXR0cmRlZiBkIg0KPCAJCQkiIG9uIGEuYXR0aGFzZGVmIGFuZCBk
LmFkcmVsaWQgPSBhLmF0dHJlbGlkIGFuZCBkLmFkbnVtID0gYS5hdHRudW0i
KTsNCi0tLQ0KPiAJCQkiIGFuZCBhLmF0dHJlbGlkID0gYy5vaWQpIg0KPiAJ
CQkiIGlubmVyIGpvaW4gcGdfY2F0YWxvZy5wZ190eXBlIHQgb24gdC5vaWQg
PSBhLmF0dHR5cGlkKSINCj4gCQkJIiBsZWZ0IG91dGVyIGpvaW4gcGdfYXR0
cmRlZiBkIG9uIGEuYXR0aGFzZGVmIGFuZCBkLmFkcmVsaWQgPSBhLmF0dHJl
bGlkIGFuZCBkLmFkbnVtID0gYS5hdHRudW0iDQo+IAkJCSIgbGVmdCBvdXRl
ciBqb2luIHBnX3R5cGUgYnQgb24gdC50eXB0eXBlID0gJ2QnIGFuZCB0LnR5
cGJhc2V0eXBlID0gYnQub2lkIiApOw0K
------=OPENWEBMAIL_ATT_0.872410221814306
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
------=OPENWEBMAIL_ATT_0.872410221814306--