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

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