Discussions tagged PostgreSQL
Fun Times with PostgreSQL - RPC issue
- Resolved
- How-to
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...
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 (...
Re: Retrieval argument issue
- Resolved
- How-to
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
...
Re: Active connections to PostgreSQL
- Resolved
- How-to
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...
Postgres and asynchronous retrieve
- Resolved
- Issue
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
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
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...
Find Questions by Tag
.EXE
.NET 6.0
.NET Assembly
.NET Core 3.1
.NET Core Framework
.NET DataStore
.NET Std Framework
32-bit
64-bit
ADO.NET
AEM
AI
Algorithm
Amazon AWS
Android
Apache
API
APK
App Store
App Store (Apple)
Appeon Workspace
Appeon Xcelerator Plug-in
Architecture
Array
ASE
Asynchronous Methods
Authentication
AutoBuild
AutoCompiler
Automated Testing
Automation
AutoScript
Azure
Barcode
Base64
Batch
BigData
BLOB
Branch & Merge
Browser
Bug
Build
Button
C#
C# Class Importer
C# Editor
C# Model generator
Calendar
Camera
Certificate
Chrome
Citrix
Class
Client
Client/Server
Cloud
Cluster
Collection
COM
Command Line
Compiler
Compression
Computed Field
Configuration
Controls
Cookies
Cordova
Crash
Cross-Platform
Crosstab
CSharpAssembly
CSharpObject
CSS
CSV
Cursor
Data
Database
Database Driver
Database Painter
Database Profile
Database Provider
DataObject
DataSource
DataStore
DataStore (C#)
DataStore (PS)
DataType
DataWindow
DATE
DATETIME
DB2
Debug
Debugger
Debugging
Deployment
Design
DLL
DO-WHILE
Dockable
Docker
Documentation
DOUBLE
Download
DragDrop
Edge
Edit Style
Editor
Elevate Conference
Email
Embedded SQL
Emulator
Encoding
Encryption
Enhancement Request
Entity
Entity Framework
ERP
Error
Event
Event Handler
Event Handling
Excel
Exception
Export
Expression
External Functions
F#
Field
File
File Access
Filter
Firefox
Firewall
Font
FOR-NEXT
Foreground
Format
Function
Garbage Collection
GeoLocation
Git
Graph
HANA
Hash
Header
HTML/5
HTTP/S
HTTPClient
Icon
IDE
Identity
IIS
IMAPI
Import
InfoMaker
Inheritance
Installation
Integer
IntelliSense
Interface
Internet
Internet Explorer
iOS
IPA
iPad
iPhone
IWA
J#
Java
JavaScript
JBoss
JDBC
JOIN
JSON
JSONGenerator
JSONParser
Kestrel
Label
Lambda
Large File
LDAP
Library
License
LINQ
Linux OS
Load Balancing
Localization
Localized PBVM
Log In
Log Out
Logging
LONG
LONGLONG
macOS
MAPI
Maps
MDI
Memory
Memory Leak
Menu
Merge
MessageBox
Messagging
Method
Migration
MIME TYPE
Mobile
Model
ModelStore
ModelStore (C#)
MSOLEDBSQL
Multi Threading
MVC
MySQL
n-Tier
Namespace
NativePDF
NVO
OAuth
ODATA
ODBC
Office
Offline
OLE
OLEDB
Online
Open Source
OpenAPI
OpenSSL
Oracle
OrcaScript
Other
Outlook
Output
Package
Parameter
Patch
PayPal
PB Classic
PB Native
PB.NET
PBC
PBD
PBDOM
PBG
PBJVM
PBL
PBNI
PBORCA
PBVM
PBX
PDF
Performance
Permission
PFC
Picture
Pipeline
Play Store (Google)
Plugin
Popup
Port
POST
PostgreSQL
PowerBuilder
PowerBuilder (Appeon)
PowerBuilder (SAP)
PowerBuilder Compiler
PowerBuilder Runtime
PowerClient
PowerScript (PS)
PowerScript IDE
PowerScript Migrator
PowerServer
PowerServer Mobile
PowerServer Toolkit
PowerServer Web
PowerServerLabel
Print
Properties
Proxy
Publish
PULL
PUSH
Query
Regression
Release
Renew
Resize
Response
REST
Retrieve
RibbonBar
RibbonBar Builder
Rich Text
Roadmap
RPC
Runtime Packager
SaaS
Scaffolding
Script
SDI
SDK
Security
Server
Service
Session
Single Sign-on
Size
SMTP
SMTPClient
SnapDevelop
SOAP
Sort
Source Code
Speech Recognition
SQL
SQL Anywhere
SQL Server
SqlBuilder
SqlExecutor
SQLite
SqlModelMapper
Storage
Stored Procedure
Subscription
SVN
Swagger
Syntax
TabbedBar
TabbedView
Tablet
TabPage
Target
TE Control
Testing
Text
TFS
Theme
TIME
Timer
TLS/SSL
Tomcat
TortoiseGit
TortoiseSVN
Transaction
Transparency
Trial
Trigger
TRY-CATCH
TX Control
Type
UI
ULONG
UltraLite
Uninstall
Unit Test
Unit Testing
UNIX OS
Update
Upgrade
Upload
URL
User Center
User Object
UWP
Validation
VARCHAR
Variable
Versioning
Visual Studio
Visual Studio Code
VM
Voice
Warning
WCF
Web API
Web Extensions
Web Service
WebBrowser
WebForms
WebLogic
WebSphere
WildFly
WinAPI
Window
Windows OS
WinForms
Wizard
Workgroup
Workspace
WPF
XCODE
XHTML
XML
Zoom