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

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