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

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