Discussions tagged PostgreSQL

Hello, Need to execute 'update .... ' statement, when data found while 'inserting data...', from datawindow PB 2017, Postgresql 10. Giving facility to import records from XML and Excel.  While importing records, few records might already available...
Windows 10 PB 2017 R3 Postgresql 9.6 ODBC Connection   -----   Hi, When connecting to Postgresql, table names are not schema qualified.  PB assumes the user that I am connecting with, is the schema / owner of all tables.     I have confirme...
Hello, Using PB 11.5, PostgreSQL 10 When showing error while updating dw / ds, it shows ? in places of field values.  It would be better if values are shown, to identify and correct those values.   We used to see values while using SQL Server, but ...
I'm having an issue where opening any datawindow in the powerbuilder IDE will turn on ODBC database logging causing application testing to run extremely slowly. Logging is not turned on in the ODBC DSN or in the properties of the connection in th...
Good morning We are experimenting on porting some of our applications from Oracle to PostgreSQL. A strange situation happens to me: If I do a select on a table or view that does not exist, the connection drops. It also turns to you? Also I ...
PB 2017 R2 Build 1756   using PostgreSQL I am unable to get a datawindow to create with source of stored procedure to work if the function (procedure) uses parameters. " Error:   Cannot create datawindow, Error column "myparameter" does not exi...
Hello, PB 2017, Postgresql 10.1 I want to connect to postgresql without creating any DSN, which didn't succeed with the following code. Sqlca.DBMS =ODBC Sqlca.DBParm="Driver={PostgreSQL ODBC Driver(UNICODE)};DATABASE=db;SERVER=192.168.x...
HI - our PB 12.6 app is currently running on SQL Anywhere V16 and we are considering a move to PostGresql or MariaDB for the future with PB2017 Can anyone comment on usability and stability of PB2017 with MariaDB or PostgreSQL? ...
I'm reading the "Supported Features for Appeon Web" document and it says that bytea is an unsupported data type. We use that to store images in our application. Would there be a work-around for that, other than choosing a different DB? I had some...
  • Page :
  • 1