Discussions tagged PostgreSQL
Problem with PostgreSQL in PB 22 R
- Issue
- Last updated 1 month ago
- Sivaprakash BKR replied 1 month ago
Hello to all users of this forum.I would like to ask you if any of you have encountered a problem similar to mine?I use three versions of PowerBuilder in my work: 11.5, 19 R3 and 22 R3The problem occurs only in version 22 and consists in the fact tha...
Fun Times with PostgreSQL - RPC issue
- Resolved
- How-to
- Last updated 6 months ago
- Matt Balent replied 5 months ago
Anyone ever do this successfully? (PB 2022 R3)
In the postgres database I have defined this FUNCTION
CREATE OR REPLACE FUNCTION public.rpc_ordersbycustomer(
custid integer DEFAULT 0,
INOUT order_count integer DEFAULT 0)
RETURNS integer
...
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...
Re: PBMaxTextSize equivalent for PostgreSQL
- Issue
- Last updated 11 months ago
- Matt Balent replied 4 months ago
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...
Error in PB calling stored procedure
- Issue
- Last updated 1 year ago
- Andreas Mykonios replied 1 year ago
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...
Automatically generate schema for Datawindow
- How-to
- Last updated 1 year ago
- hoshea hashub replied 1 year ago
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 ...
Enhancement request: modify SQLSyntax in transactions SQLPreview event
- Resolved
- Misc
- Last updated 1 year ago
- René Ullrich replied 1 year 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 2 years ago
- Mark Goldsmith replied 2 years 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 2 years ago
- Rachid Sbaibi replied 2 years 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 2 years ago
- mike S replied 2 years 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 2 years 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 3 years ago
- Brad Mettee replied 3 years 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 3 years ago
- Karen Gray replied 3 years 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 3 years ago
- Balu Krishnasamy replied 3 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 4 years ago
- kevin Rowe replied 4 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 4 years ago
- James Jarratt replied 4 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 4 years ago
- Miguel Leeuwe replied 4 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 5 years ago
- Michael Kramer replied 4 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 ...
- Page :
- 1