Discussions tagged PostgreSQL
Hi my fellow PowerBuilder enthusiast :-)
Can you advise me if PostgreSQL is a good and fast and stable database. Currently using Firebird 2.5 (2.5 is an old version that is really hard to upgrade) and it is unstable sometimes and not fast when datab...
Hello,
Using PB 2022 R2 Build 2819, PostGRESql 15
Need to retrieve string values into a datawindow, whose length varies from 50000 to 100000 characters. Currently it retrieves only 10000 characters with the following settings.
Using DSN-Less conn...
Windows 10 PB Version 6.5.1 Postgres 12psql-ODBC 12.02.01 Connection
Hi,
Error in PB calling stored procedure, The error message is Procedure has already been executed.
I have implemented a minimal use case, see the attachment.
I created the fo...
Windows 10PB Version 6.5.1 Postgres 9.2psql-ODBC 9.02.01 Connection
Hi,
When I connect to postgres database with PB and create a Datawindow, the schema will be automatically generated before the table name.
I found that when I created a ...
Hi all, have a happy new year!
I could not find another way to post an enhancement request for future PB versions, so I'll leave it here. If there is a better way to do so, please let me know.
We develop and maintain a quite large c/s application (...
Hello,
Using PB 2019 R3, PostgreSQL 11.11, compiled by Visual C++ build 1914, 64-bit, PgAdmin 4.27
When I run the below query in PgAdmin, it works correct
SELECT x::time FROM generate_series(timestamp '2000-01-01', timestamp '2000-01-01 23:59', in...
Hi all,
I insert a row in a datawindow, the the datawindow is updated (dw_1.update()). When a commit is triggered in my script no data is inserted in the database and I got no error.
The same code works fine for Oracle database.
dw_rowcount() = 1
...
Hello,
PB 2019 R3, PostgreSQL 11
While querying the PostgreSQL database, with the following query
SELECT username, application_name, client_hostnameFROM pg_stat_activity WHERE datname = 'database' And state = 'active' ;
I get empty in application...
Hello,
Need to connect to a web PostgreSQL database from a PB application, to run DDL statements. Our configuration of pg_hba.conf allows connection from localhost only. I can connect to that database from PGAdmin by configuring SSL Tunnel.
Is...
Hello,
Powerbuilder 2019 R3, Postgresql 11
I want to trigger a function in Powerbuilder (to print, actually) whenever there is an insert of data in a particular table with a particular value in a field. Is it possible ?
In Detail:
Billing data w...
Hi
We are using PB2017R3 against Postgresql version 10 using ODBC driver.
We have a bug where an error message of over 320 chars is being truncated to 255 characters.
Is there a limit set somewhere that can be adjusted please?
e.g. "Yo...
Hi,I want to connect my powerbuilder application to PostGres, Is there any native PostGres driver or should I connect via ODBC/JDBC driver?Right now, I could connect the database painter using ODBC driver.
Regards....
Env: PB 2017 R3, postgres v13 64 bit server, ODBC driver 32bit v13
Hello Experts - We are exploring postgresql as our option as we are trying to move away from sql anywhere.
Would like to get your thoughts on what i am missing or how to go about fi...
I have code that i need to use dynamic cursors for to scan for key values in referential testing.
database is postgres.
the first query must be in sql as the compiler does not recognize the @ character as SQL. it works fine.
the second query canno...
Hello
I have carefully followed Bruce Armstrong' tutorial for connecting PowerBuilder 2017 R2 to PostgreSQL, but I have a trial version of Powerbuilder 2019 R2 which I am trying to connect to a PostgreSQL 10 database. So far, I have not been success...
I'm am testing PostGreSQL and I piped a bunch of tables with no problems but when I tried to update the data I got an error on any table that already existed. If I drop the table first it works fine.
Pipe Error -17 SQLCode = 1 SQLSTATE = 42P01
ERRO...
Hello,
we are migrating a powerbuilder 2019 project from Oracle to Postgres 12.
The async database parameter is set to 1 and the retrieverow event is coded, so i can cancel a retrieve.When i am connected to Oracle (native driver), everything works ...
Hello,
Using PB 2017 R3, Postgresql 11.6
By using the query
Select a.itemcode as code, a.value as value, a.itemname as name, a.version as versionFrom tablex aUnion All
Select '' as codem, 0 as value, b.name as name, '001' as versionFrom tabley ...
Hello,
we are migrating a PowerBuilder project from Oracle to Postgres.
In Oracle a multiline text in a datawindows is saved correctly (with chr(13), chr(10)). In Postgres (version 12 with odbc driver) the carriage return, line feed is replaced wit...
Hello,
PB 2017 R3, PostgreSQL 11.1
Looks like PB doesn't report an error when there is a violation of uniquess in a table, instead it goes into a infinite loop. Uniqueness created with a unique index and NOT primary key.
Removing the unique inde...
- Page :
- 1