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

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