PostgreSQL with PowerBuilder, and Identity keys (serials)

From: "Dan Cooperstock at Software4Nonprofits" <info(at)software4nonprofits(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL with PowerBuilder, and Identity keys (serials)
Date: 2017-08-05 20:09:49
Message-ID: 00aa01d30e26$cb06e850$6114b8f0$@software4nonprofits.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm trying to get a Postgres DB version of an application I write in
PowerBuilder working. The thing I'm stuck on is Identity keys - what you set
up with the SERIAL attribute or SEQUENCEs / GENERATORs in Postgres.

I have the sequence set up and clearly working. And in PowerBuilder, I have
added a section I found online to a file it uses to know how to deal with
different aspects of different DBs (PBODBxxx.INI) for Postgres, including
the following line for retrieving an identity key after saving a record,
when the DB automatically fills in the value:

GetIdentity="Select currval('GEN_&TableName')"

That obviously depends on the generator being named "GEN_" plus the table's
name - which is true in our case.

But nothing like that is happening. Does anyone else have PostgresSQL
working with PowerBuilder and identity keys, who can give me some pointers
on how get this to work?

Thanks.

--------------------------------------------------------

Dan Cooperstock
DONATION and ACCOUNTS web site: http://www.Software4Nonprofits.com
Email: info(at)Software4Nonprofits(dot)com <mailto:info(at)Software4Nonprofits(dot)com>
Phone: 416-423-7722
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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2017-08-05 20:45:39 Re: PostgreSQL with PowerBuilder, and Identity keys (serials)
Previous Message Tom Lane 2017-08-05 18:30:03 Re: Lifetime of PQexecPrepared() returned value