Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

2017-08-06 Thread Dan Cooperstock at Software4Nonprofits
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

Re: [GENERAL] Data checksum with pg upgradecluster

2017-08-06 Thread Karsten Hilbert
> I'm updating my database from 9.4 to 9.6 (Debian Jessie to Stretch). I > think that it is a good opportunity to turn on data checksum. > > I don't have experience with cluster creation or moving a DB to a new cluster. > > I'll use pg_upgradecluster, but I don't see any option to turn of data >

[GENERAL] Data checksum with pg upgradecluster

2017-08-06 Thread Dan
Hi, I'm updating my database from 9.4 to 9.6 (Debian Jessie to Stretch). I think that it is a good opportunity to turn on data checksum. I don't have experience with cluster creation or moving a DB to a new cluster. I'll use pg_upgradecluster, but I don't see any option to turn of data checksum.

[GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials)

2017-08-06 Thread David G. Johnston
On Saturday, August 5, 2017, Dan Cooperstock at Software4Nonprofits < i...@software4nonprofits.com > wrote: > > 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 worki