Tech Articles


PostgreSQL Enhancements in PowerBuilder 2017 R3


The support for PostgreSQL that was added in R2 was covered in an earlier blog post.  The enhancements in R3 are primarily related to addition entries added to the PBODB170.INI file.  These additional entries provide more support for maintaining tables, views, primary and foreign keys, users and groups in the database painter.  

One minor change with this new version.  If you are going to use identity columns using the GetIdentity syntax I covered in that blog post and/or stored procedure DataWindows using arguments you will need to turn off the "Enclose Table and Column Names in Quotes" option (DelimitIdentifier='No’ in the DBParm for the connection).  With this release, the quote are included in the calls to both those features, resulting in syntax errors.

Summary

Support for PostgreSQL was largely feature complete in R2.  The changes in R3 do make maintenance of the database through the PowerBuilder IDE more feasible.  Normally I would still use pgAdmin for that still, but it does have some idiosyncrasies.  For those not familiar with it, for for making quick and dirty changes, the ability to use the PowerBuilder database painter is welcome.

 

Comments (0)
There are no comments posted here yet

Find Articles by Tag

Database Table Database Table Schema Messagging OrcaScript Debug TLS/SSL Platform Database Profile Database Git License Deployment SqlExecutor XML COM Service PowerBuilder Open Source API PBDOM CrypterObject DLL Database Table Data TortoiseGit Sort DragDrop Elevate Conference RibbonBar Builder Jenkins Database Connection DataType RESTClient JSON Performance SqlModelMapper Repository Encoding Resize Mobile TreeView DevOps Azure Variable SQL Server PFC SDK Encryption CoderObject WebBrowser Import IDE Expression RichTextEdit Control Windows OS Oracle File Script iOS JSONParser Excel Migration DataWindow JSON 64-bit SOAP PowerScript (PS) UI Modernization SnapObjects SnapDevelop Linux OS DataWindow RibbonBar PostgreSQL ODBC driver Branch & Merge Android Charts Testing SVN Icon Window Event Handler Authorization Design Data Installation Debugger Export JSON PDFlib InfoMaker PostgreSQL Database Painter Source Control Debugging Error .NET Std Framework Filter Web API GhostScript 32-bit Event Handling External Functions Authentication C# Event BLOB .NET Assembly PowerServer Web Configuration .NET DataStore Web Service Proxy UI Themes Trial Transaction PowerBuilder (Appeon) ActiveX PowerBuilder Compiler MessageBox Interface Source Code OAuth Menu OLE NativePDF Validation SQL UI PowerServer Mobile Graph Stored Procedure Import JSON Database Object HTTPClient ODBC Outlook Automated Testing Model TFS REST PDF Array Bug JSONGenerator CI/CD Export Syntax OAuth 2.0 Class WinAPI Application Text Windows 10 Icons