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

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