Hi, Dan, On Sat, Aug 5, 2017 at 8:52 PM, Dan Cooperstock at Software4Nonprofits <info@xxxxxxxxxxxxxxxxxxxxxxx> wrote: > No, Carl, when I created the sequence, I didn't put its name in double > quotes, so therefore its name wasn't being forced to stay upper case. So in > the nextval() command, putting it only in single quotes works - Postgres > converts both the original creation and the reference to it to lower case. > > 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. Do you have this DW inside some Window object? Further do you have those queey in responce to an event for DW or Window? If yes - what kind? Can you post a complete script? You can do a PM if anything. I didn't work with PB + PG, but I do have some PB knowledge... Thank you. > > -------------------------------------------------------- > Dan Cooperstock > DONATION and ACCOUNTS web site: http://www.Software4Nonprofits.com > Email: info@xxxxxxxxxxxxxxxxxxxxxxx > 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. > > > -----Original Message----- > From: Karl Czajkowski [mailto:karlcz@xxxxxxx] > Sent: August 5, 2017 8:25 PM > To: Dan Cooperstock at Software4Nonprofits <info@xxxxxxxxxxxxxxxxxxxxxxx> > Cc: 'Rob Sargent' <robjsargent@xxxxxxxxx>; 'Forums postgresql' > <pgsql-general@xxxxxxxxxxxxxx> > Subject: Re: PostgreSQL with PowerBuilder, and Identity keys (serials) > > >> Select currval('GEN_&TableName') >> > > From the above, I am assuming you did something like: > > CREATE SEQUENCE "GEN_&TableName" ...; > > and are trying to access this sequence? If so, you actually have to include > the SQL quoted identifier syntax within the text argument to > currval() or nextval(), e.g. > > SELECT nextval('"GEN_&TableName"'); > > With these sorts of identifier-as-argument parameters in Postgres, you can > also include schema-qualification syntax: > > SELECT nextval('"My Schema"."GEN_&TableName"'); > > > Karl > > > > > -- > Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
