Discussions tagged PostgreSQL
Enhancement request: modify SQLSyntax in transactions SQLPreview event
- Resolved
- Misc
- Last updated 8 months ago
- René Ullrich replied 8 months ago
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 (...
Re: Retrieval argument issue
- Resolved
- How-to
- Last updated 11 months ago
- Mark Goldsmith replied 11 months ago
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...
Postgres commit does not commit changes in the database
- Resolved
- Issue
- Last updated 1 year ago
- Rachid Sbaibi replied 1 year ago
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
...
Re: Active connections to PostgreSQL
- Resolved
- How-to
- Last updated 1 year ago
- mike S replied 1 year ago
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...
Re: Connect to a remote (Web) PostgreSQL database from PB Application
- How-to
- Last updated 1 year ago
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...
Re: Triggering a Powerbuilder event function when there is an insert of data in a table
- How-to
- Last updated 1 year ago
- Brad Mettee replied 1 year ago
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...
Is there a limit on Error message characters with Postgresql?
- Resolved
- Issue
- Last updated 1 year ago
- Karen Gray replied 1 year ago
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....
datawindow retrieval error 42P01 on postgresql
- How-to
- Last updated 2 years ago
- Balu Krishnasamy replied 2 years ago
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...
using two or more dynamic staging area cursors at once
- Resolved
- Advice
- Last updated 2 years ago
- kevin Rowe replied 2 years ago
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...
How to connect PowerBuilder 2019 to a PostgreSQL 10 Database
- Resolved
- How-to
- Last updated 3 years ago
- James Jarratt replied 3 years ago
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...
Postgres and asynchronous retrieve
- Resolved
- Issue
- Last updated 3 years ago
- Miguel Leeuwe replied 3 years ago
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 ...
Increase in column size of datawindow
- Resolved
- Issue
- Last updated 3 years ago
- Michael Kramer replied 3 years ago
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 ...
Postgres and carriage return
- Resolved
- Advice
- Last updated 3 years ago
- Markus Schröder replied 3 years ago
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...
Postgresql 11.1 with Unique index
- Resolved
- Issue
- Last updated 3 years ago
- Sivaprakash BKR replied 3 years ago
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...
Problem with reading large text columns in Postgresql from PowerBuilder
- Resolved
- Issue
- Last updated 3 years ago
- Chris Pollach @Appeon replied 3 years ago
PB 2019 Build 2082 using PostgreSQL 10.8
We have a problem reading values from column that is text data type with a length over 32768 characters. If the length of text is bigger we get only first 32768 characters
We configure ODBC for database ...
Calling a Postgres Procedure
- Resolved
- How-to
- Last updated 4 years ago
- Miguel Leeuwe replied 3 years ago
Hello,
i am migrating a PowerBuilder 2019 Application from Oracle to Postgres.
When i am connected to Oracle, i call the following procedurePROCEDURE p_proc(aol_error_nr OUT NUMBER, aos_error_text OUT VARCHAR2)
in this way:
DECLARE dbp_Proc PROCE...
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...
Postgresql Not Showing Schema Qualified Table / View Names
- Resolved
- How-to
- Last updated 5 years ago
- jeff hersey replied 5 years ago
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...
- Page :
- 1