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

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