Received: from danum.ids.org.my (danum.ids.org.my [202.185.241.1]) by hub.org (8.9.2/8.9.1) with SMTP id DAA90714 for ; Wed, 24 Mar 1999 03:01:24 -0500 (EST) (envelope-from daniel@ids.org.my) Received: from dvader (unverified [202.185.241.135]) by danum.ids.org.my (EMWAC SMTPRS 0.83) with SMTP id ; Wed, 24 Mar 1999 15:57:42 +0800 Message-ID: <001901be7653$06b15280$87f1b9ca@dvader.ids.org.my> From: "Daniel" To: "Byron Nikolaidis" Cc: Subject: Re: [INTERFACES] why there's only char type? Date: Wed, 24 Mar 1999 16:03:14 -0800 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0013_01BE760F.D2C70D40" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3110.5 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 This is a multi-part message in MIME format. ------=_NextPart_000_0013_01BE760F.D2C70D40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit After many times of reconfiguring the ODBC connection profile, recreating the database, and even re-installing the postODBC, I think the problem lies on the fact that Powerbuilder needs a set of its own system (or 'catalog') tables in order to work properly in the *visual* mode. Because right now Powerbuilder reports an error ("Catalog table could not be created and are not available for use") everytime I start a connection to the database. Interestingly, I could create a table with INT4 and CHAR fields from Powerbuilder's text mode and it worked, but in visual mode, it could only see the 1st field and ignored the 2nd. Anyway, thanks for suggesting looking into the odbc trace log. The log files attached with this mail created right after the following process: 1) Re-create the database test. 2) In Powerbuilder, delete & then re-configure the ODBC connection profile, uncheck 'ReadOnly'. 3) Start the trace log (from ODBC Data Source Admin). 4) Connect to the database, and got the error msg "Catalog...." as mentioned above. 5) Still can connect to the database. At this point if I am to create a new table, Powerbuilder will show me only the 'char' type. But as far as the log files are conecerned, I didnt do anything. 6) Disconnect from the database (by connecting to another db, i.e. Sybase). If you examine the Sql.log, it did call SQLGetTypeInfo(). But the error occured when exiting SQLSetStmtOption. Could that be the whole problem? Is that a problem of PostODBC or Powerbuilder? Thanks for any help. Daniel -----Original Message----- From: Byron Nikolaidis To: Daniel Cc: pgsql-interfaces@hub.org Date: Monday, March 22, 1999 11:31 AM Subject: Re: [INTERFACES] why there's only char type? > > >Daniel wrote: > >> Last week I got PostgreSQL 6.3.x running with -i switch and then created a >> test database. On Win95 end, postODBC was installed and my PowerBuilder >> could connect to the database. Then I tried to transfer the data from Sybase >> SQL Anywhere to Postgres via Powerbuilder's pipeline mechanism. In >> Powerbuilder I did notice that there were some unfamiliar database type in >> Postgres such as INT4 to represent Sybase's INTEGER type and got me really >> excited. However I couldnt create anything in Postgres because I forgot to >> uncheck the "read-only" option when i setup the odbc connection, but that's >> different story. >> >> After coming back from weekend, I tried to do the transfer of data again, >> and I did make sure the "read-only" option has been unchecked. But right now >> I encounter a new problem: I found that I could no longer see other data >> type in Postgres except CHAR. I've tried all the possible setting in odbc >> connection but it still doesn't help. What seems to be the problem? Please >> help. >> > >I'm not sure why you would only see 'char'. If the application is using the >odbc function SQLGetTypeInfo() to retrieve the data types, then maybe it is >looking for data types that support a certain feature. Maybe this is >configurable. I'm not really sure what your application is doing. > >If you want, you could send an odbc trace log of the session so we could at >least see if it is calling SQLGetTypeInfo() and retrieving the results. >Otherwise, there is nothing else I can do. > >Byron > > ------=_NextPart_000_0013_01BE760F.D2C70D40 Content-Type: application/octet-stream; name="Sql.log" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="Sql.log" PC0tIHNuaXBwZWQsIHRvIHRyaW0gZG93biB0aGUgc2l6ZSBvZiBtYWlsIC0tPg0KDQoNClBCMDUw ICAgICAgICAgICBmZmZiNzA2MzpmZmZjMmI3MwlFTlRFUiBTUUxHZXRUeXBlSW5mbyANCgkJSFNU TVQgICAgICAgICAgICAgICAweDAxM2EwZDQ0DQoJCVNXT1JEICAgICAgICAgICAgICAgICAgICAg ICAgMCA8U1FMX0FMTF9UWVBFUz4NCg0KUEIwNTAgICAgICAgICAgIGZmZmI3MDYzOmZmZmMyYjcz CUVYSVQgIFNRTEdldFR5cGVJbmZvICB3aXRoIHJldHVybiBjb2RlIDAgKFNRTF9TVUNDRVNTKQ0K CQlIU1RNVCAgICAgICAgICAgICAgIDB4MDEzYTBkNDQNCgkJU1dPUkQgICAgICAgICAgICAgICAg ICAgICAgICAwIDxTUUxfQUxMX1RZUEVTPg0KDQpQQjA1MCAgICAgICAgICAgZmZmYjcwNjM6ZmZm YzJiNzMJRU5URVIgU1FMR2V0RnVuY3Rpb25zIA0KCQlIREJDICAgICAgICAgICAgICAgIDB4MDE0 OWZmYTANCgkJVVdPUkQgICAgICAgICAgICAgICAgICAgICAgIDU5IA0KCQlVV09SRCAqICAgICAg ICAgICAgIDB4MDA2M2UzMTYNCg0KUEIwNTAgICAgICAgICAgIGZmZmI3MDYzOmZmZmMyYjczCUVY SVQgIFNRTEdldEZ1bmN0aW9ucyAgd2l0aCByZXR1cm4gY29kZSAwIChTUUxfU1VDQ0VTUykNCgkJ SERCQyAgICAgICAgICAgICAgICAweDAxNDlmZmEwDQoJCVVXT1JEICAgICAgICAgICAgICAgICAg ICAgICA1OSANCgkJVVdPUkQgKiAgICAgICAgICAgICAweDAwNjNlMzE2ICgxKQ0KDQpQQjA1MCAg ICAgICAgICAgZmZmYjcwNjM6ZmZmYzJiNzMJRU5URVIgU1FMU2V0U3RtdE9wdGlvbiANCgkJSFNU TVQgICAgICAgICAgICAgICAweDAxM2EwZDQ0DQoJCVVXT1JEICAgICAgICAgICAgICAgICAgICAg ICAgOSA8U1FMX1JPV1NFVF9TSVpFPg0KCQlVRFdPUkQgICAgICAgICAgICAgICAgICAgIDE2DQoN ClBCMDUwICAgICAgICAgICBmZmZiNzA2MzpmZmZjMmI3MwlFWElUICBTUUxTZXRTdG10T3B0aW9u ICB3aXRoIHJldHVybiBjb2RlIDEgKFNRTF9TVUNDRVNTX1dJVEhfSU5GTykNCgkJSFNUTVQgICAg ICAgICAgICAgICAweDAxM2EwZDQ0DQoJCVVXT1JEICAgICAgICAgICAgICAgICAgICAgICAgOSA8 U1FMX1JPV1NFVF9TSVpFPg0KCQlVRFdPUkQgICAgICAgICAgICAgICAgICAgIDE2DQoNCgkJRElB RyBbMDFTMDJdIFJlcXVlc3RlZCB2YWx1ZSBjaGFuZ2VkLjsKRHJpdmVyIGRvZXMgbm90IHN1cHBv cnQgc2V0dGluZyB0aGlzIGNvbm5lY3Qgb3B0aW9uICgxNikgDQoNClBCMDUwICAgICAgICAgICBm ZmZiNzA2MzpmZmZjMmI3MwlFTlRFUiBTUUxFcnJvclcgDQoJCUhFTlYgICAgICAgICAgICAgICAg MHgwMTQ5ZmNmYw0KCQlIREJDICAgICAgICAgICAgICAgIDB4MDE0OWZmYTANCgkJSFNUTVQgICAg ICAgICAgICAgICAweDAxM2EwZDQ0DQoJCVdDSEFSICogICAgICAgICAgICAgMHgwMDYzZTJlMCAo TllJKSANCiAJCVNEV09SRCAqICAgICAgICAgICAgMHgwMDYzZTMzMA0KCQlXQ0hBUiAqICAgICAg ICAgICAgIDB4MDA2M2RlZTAgDQoJCVNXT1JEICAgICAgICAgICAgICAgICAgICAgIDUxMiANCgkJ U1dPUkQgKiAgICAgICAgICAgICAweDAwNjNlMzI2DQoNClBCMDUwICAgICAgICAgICBmZmZiNzA2 MzpmZmZjMmI3MwlFWElUICBTUUxFcnJvclcgIHdpdGggcmV0dXJuIGNvZGUgMCAoU1FMX1NVQ0NF U1MpDQoJCUhFTlYgICAgICAgICAgICAgICAgMHgwMTQ5ZmNmYw0KCQlIREJDICAgICAgICAgICAg ICAgIDB4MDE0OWZmYTANCgkJSFNUTVQgICAgICAgICAgICAgICAweDAxM2EwZDQ0DQoJCVdDSEFS ICogICAgICAgICAgICAgMHgwMDYzZTJlMCAoTllJKSANCiAJCVNEV09SRCAqICAgICAgICAgICAg MHgwMDYzZTMzMCAoMTYpDQoJCVdDSEFSICogICAgICAgICAgICAgMHgwMDYzZGVlMCBbICAgICAg NzddICJSZXF1ZXN0ZWQgdmFsdWUgY2hhbmdlZC47XCBhRHJpdmVyIGRvZXMgIg0KCQlTV09SRCAg ICAgICAgICAgICAgICAgICAgICA1MTIgDQoJCVNXT1JEICogICAgICAgICAgICAgMHgwMDYzZTMy NiAoNzcpDQoNClBCMDUwICAgICAgICAgICBmZmZiNzA2MzpmZmZjMmI3MwlFTlRFUiBTUUxHZXRT dG10T3B0aW9uIA0KCQlIU1RNVCAgICAgICAgICAgICAgIDB4MDEzYTBkNDQNCgkJVVdPUkQgICAg ICAgICAgICAgICAgICAgICAgICA5IA0KCQlQVFIgICAgICAgICAgICAgICAgMHgwMDRkZDY5Yw0K DQpQQjA1MCAgICAgICAgICAgZmZmYjcwNjM6ZmZmYzJiNzMJRVhJVCAgU1FMR2V0U3RtdE9wdGlv biAgd2l0aCByZXR1cm4gY29kZSAwIChTUUxfU1VDQ0VTUykNCgkJSFNUTVQgICAgICAgICAgICAg ICAweDAxM2EwZDQ0DQoJCVVXT1JEICAgICAgICAgICAgICAgICAgICAgICAgOSANCgkJUFRSICAg ICAgICAgICAgICAgIDB4MDA0ZGQ2OWMNCg0KDQo8LS0gc25pcHBlZCwgdG8gdHJpbSBkb3duIHRo ZSBzaXplIG9mIG1haWwgLS0+DQoNCg0KUEIwNTAgICAgICAgICAgIGZmZmI3MDYzOmZmZmMyYjcz CUVOVEVSIFNRTEV4ZWNEaXJlY3QgDQoJCUhTVE1UICAgICAgICAgICAgICAgMHgwMTNhMGQ0NA0K CQlVQ0hBUiAqICAgICAgICAgICAgIDB4MDA0ZTg5NzQgWyAgICAgNDAzXSAiQ1JFQVRFIFRBQkxF IHBiY2F0Y29sIChwYmNfdG5hbSBjaGFyKDMzKSBOT1QgTlVMTCxwYmNfdGlkID8/Pz8/ICxwYmNf b3duciBjaGFyKDMzKSBOT1QgTlVMTCxwYmNfY25hbSBjaGFyKDMzKSBOT1QgTlVMTCxwYmNfY2lk ID8/Pz8/ICxwYmNfbGFibCBjaGFyKDI1NCkgLHBiY19scG9zID8/Pz8/ICxwYmNfaGRyIGNoYXIo MjU0KSAscGJjX2hwb3MgPz8/Pz8gLHBiY19qdGZ5ID8/Pz8/ICxwYmNfbWFzayBjaGFyKDMxKSAs cGJjX2Nhc2UgPz8/Pz8gLHBiY19oZ2h0ID8/Pz8/ICxwYmNfd2R0aCA/Pz8/PyAscGJjX3B0cm4g Y2hhcigzMSkgLHBiY19ibWFwIGNoYXIoMSkgLHBiY19pbml0IGNoYXIoMjU0KSAscGJjX2NtbnQg Y2hhcigyNTQpICxwYmNfZWRpdCBjaGFyKDMxKSAscGJjX3RhZyBjaGFyKDI1NCkgKSINCgkJU0RX T1JEICAgICAgICAgICAgICAgICAgIDQwMw0KDQpQQjA1MCAgICAgICAgICAgZmZmYjcwNjM6ZmZm YzJiNzMJRVhJVCAgU1FMRXhlY0RpcmVjdCAgd2l0aCByZXR1cm4gY29kZSAtMSAoU1FMX0VSUk9S KQ0KCQlIU1RNVCAgICAgICAgICAgICAgIDB4MDEzYTBkNDQNCgkJVUNIQVIgKiAgICAgICAgICAg ICAweDAwNGU4OTc0IFsgICAgIDQwM10gIkNSRUFURSBUQUJMRSBwYmNhdGNvbCAocGJjX3RuYW0g Y2hhcigzMykgTk9UIE5VTEwscGJjX3RpZCA/Pz8/PyAscGJjX293bnIgY2hhcigzMykgTk9UIE5V TEwscGJjX2NuYW0gY2hhcigzMykgTk9UIE5VTEwscGJjX2NpZCA/Pz8/PyAscGJjX2xhYmwgY2hh cigyNTQpICxwYmNfbHBvcyA/Pz8/PyAscGJjX2hkciBjaGFyKDI1NCkgLHBiY19ocG9zID8/Pz8/ ICxwYmNfanRmeSA/Pz8/PyAscGJjX21hc2sgY2hhcigzMSkgLHBiY19jYXNlID8/Pz8/ICxwYmNf aGdodCA/Pz8/PyAscGJjX3dkdGggPz8/Pz8gLHBiY19wdHJuIGNoYXIoMzEpICxwYmNfYm1hcCBj aGFyKDEpICxwYmNfaW5pdCBjaGFyKDI1NCkgLHBiY19jbW50IGNoYXIoMjU0KSAscGJjX2VkaXQg Y2hhcigzMSkgLHBiY190YWcgY2hhcigyNTQpICkiDQoJCVNEV09SRCAgICAgICAgICAgICAgICAg ICA0MDMNCg0KCQlESUFHIFtTMDAwMV0gRXJyb3IgY3JlYXRpbmcgdGhlIHRhYmxlOwpFUlJPUjog IHBhcnNlcjogcGFyc2UgZXJyb3IgYXQgb3IgbmVhciAiIiAoMTcpIA0KDQpQQjA1MCAgICAgICAg ICAgZmZmYjcwNjM6ZmZmYzJiNzMJRU5URVIgU1FMRXJyb3JXIA0KCQlIRU5WICAgICAgICAgICAg ICAgIDB4MDE0OWZjZmMNCgkJSERCQyAgICAgICAgICAgICAgICAweDAxNDlmZmEwDQoJCUhTVE1U ICAgICAgICAgICAgICAgMHgwMTNhMGQ0NA0KCQlXQ0hBUiAqICAgICAgICAgICAgIDB4MDA2M2U3 YmMgKE5ZSSkgDQogCQlTRFdPUkQgKiAgICAgICAgICAgIDB4MDA2M2U4MGMNCgkJV0NIQVIgKiAg ICAgICAgICAgICAweDAwNjNlM2JjIA0KCQlTV09SRCAgICAgICAgICAgICAgICAgICAgICA1MTIg DQoJCVNXT1JEICogICAgICAgICAgICAgMHgwMDYzZTgwMg0KDQpQQjA1MCAgICAgICAgICAgZmZm YjcwNjM6ZmZmYzJiNzMJRVhJVCAgU1FMRXJyb3JXICB3aXRoIHJldHVybiBjb2RlIDAgKFNRTF9T VUNDRVNTKQ0KCQlIRU5WICAgICAgICAgICAgICAgIDB4MDE0OWZjZmMNCgkJSERCQyAgICAgICAg ICAgICAgICAweDAxNDlmZmEwDQoJCUhTVE1UICAgICAgICAgICAgICAgMHgwMTNhMGQ0NA0KCQlX Q0hBUiAqICAgICAgICAgICAgIDB4MDA2M2U3YmMgKE5ZSSkgDQogCQlTRFdPUkQgKiAgICAgICAg ICAgIDB4MDA2M2U4MGMgKDE3KQ0KCQlXQ0hBUiAqICAgICAgICAgICAgIDB4MDA2M2UzYmMgWyAg ICAgIDY3XSAiRXJyb3IgY3JlYXRpbmcgdGhlIHRhYmxlO1wgYUVSUk9SOiAiDQoJCVNXT1JEICAg ICAgICAgICAgICAgICAgICAgIDUxMiANCgkJU1dPUkQgKiAgICAgICAgICAgICAweDAwNjNlODAy ICg2NykNCg0KUEIwNTAgICAgICAgICAgIGZmZmI3MDYzOmZmZmMyYjczCUVOVEVSIFNRTEZyZWVT dG10IA0KCQlIU1RNVCAgICAgICAgICAgICAgIDB4MDEzYTBkNDQNCgkJVVdPUkQgICAgICAgICAg ICAgICAgICAgICAgICAxIDxTUUxfRFJPUD4NCg0KUEIwNTAgICAgICAgICAgIGZmZmI3MDYzOmZm ZmMyYjczCUVYSVQgIFNRTEZyZWVTdG10ICB3aXRoIHJldHVybiBjb2RlIDAgKFNRTF9TVUNDRVNT KQ0KCQlIU1RNVCAgICAgICAgICAgICAgIDB4MDEzYTBkNDQNCgkJVVdPUkQgICAgICAgICAgICAg ICAgICAgICAgICAxIDxTUUxfRFJPUD4NCg0KDQo8LS0gc25pcHBlZCwgdG8gdHJpbSBkb3duIHRo ZSBzaXplIG9mIG1haWwgLS0+DQoNCg0KUEIwNTAgICAgICAgICAgIGZmZmI3MDYzOmZmZmMyYjcz CUVOVEVSIFNRTEV4ZWNEaXJlY3QgDQoJCUhTVE1UICAgICAgICAgICAgICAgMHgwMTNhMGQ0NA0K CQlVQ0hBUiAqICAgICAgICAgICAgIDB4MDA2M2YyNjAgWyAgICAgIC0zXSAic2VsZWN0IHBiZV9u YW1lLCBwYmVfZWRpdCwgcGJlX3R5cGUsIHBiZV9jbnRyLCBwYmVfd29yaywgcGJlX3NlcW4sIHBi ZV9mbGFnIGZyb20gcGJjYXRlZHQgb3JkZXIgYnkgcGJlX25hbWUsIHBiZV9zZXFuXCAwIg0KCQlT RFdPUkQgICAgICAgICAgICAgICAgICAgIC0zDQoNClBCMDUwICAgICAgICAgICBmZmZiNzA2Mzpm ZmZjMmI3MwlFWElUICBTUUxFeGVjRGlyZWN0ICB3aXRoIHJldHVybiBjb2RlIC0xIChTUUxfRVJS T1IpDQoJCUhTVE1UICAgICAgICAgICAgICAgMHgwMTNhMGQ0NA0KCQlVQ0hBUiAqICAgICAgICAg ICAgIDB4MDA2M2YyNjAgWyAgICAgIC0zXSAic2VsZWN0IHBiZV9uYW1lLCBwYmVfZWRpdCwgcGJl X3R5cGUsIHBiZV9jbnRyLCBwYmVfd29yaywgcGJlX3NlcW4sIHBiZV9mbGFnIGZyb20gcGJjYXRl ZHQgb3JkZXIgYnkgcGJlX25hbWUsIHBiZV9zZXFuXCAwIg0KCQlTRFdPUkQgICAgICAgICAgICAg ICAgICAgIC0zDQoNCgkJRElBRyBbMDhTMDFdIEVycm9yIHdoaWxlIGV4ZWN1dGluZyB0aGUgcXVl cnk7CkVSUk9SOiAgcGJjYXRlZHQ6IFRhYmxlIGRvZXMgbm90IGV4aXN0LiAoMSkgDQoNClBCMDUw ICAgICAgICAgICBmZmZiNzA2MzpmZmZjMmI3MwlFTlRFUiBTUUxFcnJvclcgDQoJCUhFTlYgICAg ICAgICAgICAgICAgMHgwMTQ5ZmNmYw0KCQlIREJDICAgICAgICAgICAgICAgIDB4MDE0OWZmYTAN CgkJSFNUTVQgICAgICAgICAgICAgICAweDAxM2EwZDQ0DQoJCVdDSEFSICogICAgICAgICAgICAg MHgwMDYzZjE0OCAoTllJKSANCiAJCVNEV09SRCAqICAgICAgICAgICAgMHgwMDYzZjE5OA0KCQlX Q0hBUiAqICAgICAgICAgICAgIDB4MDA2M2VkNDggDQoJCVNXT1JEICAgICAgICAgICAgICAgICAg ICAgIDUxMiANCgkJU1dPUkQgKiAgICAgICAgICAgICAweDAwNjNmMThlDQoNClBCMDUwICAgICAg ICAgICBmZmZiNzA2MzpmZmZjMmI3MwlFWElUICBTUUxFcnJvclcgIHdpdGggcmV0dXJuIGNvZGUg MCAoU1FMX1NVQ0NFU1MpDQoJCUhFTlYgICAgICAgICAgICAgICAgMHgwMTQ5ZmNmYw0KCQlIREJD ICAgICAgICAgICAgICAgIDB4MDE0OWZmYTANCgkJSFNUTVQgICAgICAgICAgICAgICAweDAxM2Ew ZDQ0DQoJCVdDSEFSICogICAgICAgICAgICAgMHgwMDYzZjE0OCAoTllJKSANCiAJCVNEV09SRCAq ICAgICAgICAgICAgMHgwMDYzZjE5OCAoMSkNCgkJV0NIQVIgKiAgICAgICAgICAgICAweDAwNjNl ZDQ4IFsgICAgICA3Ml0gIkVycm9yIHdoaWxlIGV4ZWN1dGluZyB0aGUgcXVlcnk7XCBhRVJSIg0K CQlTV09SRCAgICAgICAgICAgICAgICAgICAgICA1MTIgDQoJCVNXT1JEICogICAgICAgICAgICAg MHgwMDYzZjE4ZSAoNzIpDQoNCg0KPC0tIHNuaXBwZWQsIHRvIHRyaW0gZG93biB0aGUgc2l6ZSBv ZiBtYWlsIC0tPg0KDQoNCg== ------=_NextPart_000_0013_01BE760F.D2C70D40 Content-Type: application/octet-stream; name="psqlodbc.log" Content-Transfer-Encoding: quoted-printable Content-Disposition: attachment; filename="psqlodbc.log" conn=3D26282108, SQLDriverConnect( in)=3D'DSN=3Dpgsql test;', = fDriverCompletion=3D1 DSN info: DSN=3D'pgsql = test',server=3D'foo',port=3D'5432',dbase=3D'test',user=3D'tester',passwd=3D= 'testing' = readonly=3D'0',protocol=3D'',showoid=3D'0',fakeoidindex=3D'0',showsystabl= e=3D'0' conn_settings=3D'' translation_dll=3D'',translation_option=3D'' conn=3D26282108, SQLDriverConnect(out)=3D'DSN=3Dpgsql = test;DATABASE=3Dtest;SERVER=3Dtux;PORT=3D5432;UID=3Dtester;PWD=3Dtesting;= READONLY=3D0;PROTOCOL=3D;FAKEOIDINDEX=3D0;SHOWOIDCOLUMN=3D0;ROWVERSIONING= =3D0;SHOWSYSTEMTABLES=3D0;CONNSETTINGS=3D' Global Options: Version=3D'06.30.0250', fetch=3D100, socket=3D4096, = unknown_sizes=3D0, max_varchar_size=3D254, max_longvarchar_size=3D4094 disable_optimizer=3D1, unique_index=3D0, = use_declarefetch=3D0 text_as_longvarchar=3D1, unknowns_as_longvarchar=3D0, = bools_as_char=3D1 extra_systable_prefixes=3D'dd_;', conn_settings=3D'' conn=3D26282108, query=3D' ' conn=3D26282108, query=3D'set DateStyle to 'ISO'' conn=3D26282108, query=3D'set geqo to 'OFF'' conn=3D26282108, query=3D'select oid from pg_type where typname=3D'lo'' [ fetched 0 rows ] CONN ERROR: func=3DSQLSetConnectOption, desc=3D'fOption=3D1041, = vParam=3D351504640', errnum=3D5, errmsg=3D'Driver does not support = setting this connect option' ------------------------------------------------------------ henv=3D27328644, conn=3D26282108, status=3D1, num_stmts=3D16 sock=3D27328660, stmts=3D27328700, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D23, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D26288400, buffer_out=3D26292500 buffer_filled_in=3D28, buffer_filled_out=3D0, = buffer_read_in=3D28 CONN ERROR: func=3DSQLSetConnectOption, desc=3D'fOption=3D1042, = vParam=3D351504652', errnum=3D5, errmsg=3D'Driver does not support = setting this connect option' ------------------------------------------------------------ henv=3D27328644, conn=3D26282108, status=3D1, num_stmts=3D16 sock=3D27328660, stmts=3D27328700, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D23, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D26288400, buffer_out=3D26292500 buffer_filled_in=3D28, buffer_filled_out=3D0, = buffer_read_in=3D28 conn=3D26282108, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname like 'pbcattbl' and = relname !~ '^pg_|^dd_' and relname !~ '^xinv[0-9]+' and = int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 0 rows ] conn=3D26282108, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname like 'PBCATTBL' and = relname !~ '^pg_|^dd_' and relname !~ '^xinv[0-9]+' and = int4out(usesysid) =3D int4out(relowner)order by relname' [ fetched 0 rows ] conn=3D26282108, query=3D'BEGIN' conn=3D26282108, query=3D'CREATE TABLE pbcattbl (pbt_tnam char(33) NOT = NULL)' conn=3D26282108, query=3D'COMMIT' conn=3D26282108, query=3D'BEGIN' conn=3D26282108, query=3D'CREATE UNIQUE INDEX pbcatt_x ON pbcattbl = (pbt_tnam ,pbt_ownr )' ERROR from backend during send_query: 'ERROR: DefineIndex: attribute = "pbt_ownr" not found' conn=3D26282108, query=3D'COMMIT' STATEMENT ERROR: func=3DSC_execute, desc=3D'', errnum=3D17, = errmsg=3D'Error creating the table' = ------------------------------------------------------------ hdbc=3D26282108, stmt=3D26296600, result=3D0 manual_result=3D0, prepare=3D0, internal=3D0 bindings=3D0, bindings_allocated=3D0 parameters=3D0, parameters_allocated=3D0 statement_type=3D4, statement=3D'CREATE UNIQUE INDEX = pbcatt_x ON pbcattbl (pbt_tnam ,pbt_ownr )' stmt_with_params=3D'CREATE UNIQUE INDEX pbcatt_x ON = pbcattbl (pbt_tnam ,pbt_ownr )' data_at_exec=3D-1, current_exec_param=3D-1, = put_data=3D0 currTuple=3D-1, current_col=3D-1, lobj_fd=3D-1 maxRows=3D0, rowset_size=3D1, keyset_size=3D0, = cursor_type=3D0, scroll_concurrency=3D1 cursor_name=3D'SQL_CUR01914118' ----------------QResult Info = ------------------------------- CONN ERROR: func=3DSC_execute, desc=3D'', errnum=3D10, errmsg=3D'ERROR: = DefineIndex: attribute "pbt_ownr" not found' ------------------------------------------------------------ henv=3D27328644, conn=3D26282108, status=3D1, num_stmts=3D16 sock=3D27328660, stmts=3D27328700, lobj_type=3D-999 ---------------- Socket Info ------------------------------- socket=3D23, reverse=3D0, errornumber=3D0, = errormsg=3D'(null)' buffer_in=3D26288400, buffer_out=3D26292500 buffer_filled_in=3D2, buffer_filled_out=3D0, = buffer_read_in=3D2 conn=3D26282108, query=3D'select relname, usename, relhasrules from = pg_class, pg_user where relkind =3D 'r' and relname !~ '^pg_|^dd_' and = relname !~ '^xinv[0-9]+' and int4out(usesysid) =3D = int4out(relowner)order by relname' [ fetched 1 rows ] conn=3D26282108, SQLDisconnect ------=_NextPart_000_0013_01BE760F.D2C70D40--