Thanks, David, this was actually the most helpful suggestion. Using logging of
SQL statements in Postgres, I was able to first determine that the style of
quoting I was using in the PowerBuilder INI file wasn’t working, and then that
the &TableName variable wasn’t being expanded by PowerBuilder before sending
the SQL to Postgres. The latter of which is a clear PowerBuilder problem, so I
have submitted it to them as a bug.
So I think we can now put this to rest on this mailing list. Thanks, all.
DONATION and ACCOUNTS web site: <http://www.Software4Nonprofits.com>
Email: <mailto:i...@software4nonprofits.com> i...@software4nonprofits.com
Mail: 57 Gledhill Ave., Toronto ON M4C 5K7, Canada
If you do not want to receive any further emails from Software4Nonprofits,
please reply to this email with the subject line "UNSUBSCRIBE", and we will
immediately remove you from our mailing list, if you are on it.
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of David G. Johnston
Sent: August 6, 2017 3:47 AM
To: Dan Cooperstock at Software4Nonprofits <i...@software4nonprofits.com>
Cc: Forums postgresql <firstname.lastname@example.org>
Subject: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)
On Saturday, August 5, 2017, Dan Cooperstock at Software4Nonprofits
As I have mentioned in several replies, I have tested all of this code
directly in SQL statements and they work perfectly. It's only the
interaction with PowerBuilder that isn't working right, which is why I keep
saying that further answers from anyone that hasn't solved this problem of
using Postgres with PowerBuilder, and getting identity retrieval to work in
PowerBuilder, are not at this point worthwhile.
If it is PostgreSQL's problem you should be able to setup statement logging on
the server and see what is happening at the SQL level.