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

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