> On Aug 5, 2017, at 3:12 PM, Dan Cooperstock at Software4Nonprofits > <i...@software4nonprofits.com> wrote: > > I’m on PostgreSQL 9.6, 64-bit Windows. > > That really is the correct name for the sequence, because I’m not using > SERIAL. (I needed everything to match the naming in my existing DB I’m using > for the app, Firebird SQL, so the changes to make it work with either DB > would be as minimal as possible.) The setup of tables I’m using with this > sort of thing are like the following example: > > CREATE SEQUENCE GEN_CATEGORY MINVALUE 0; > > CREATE TABLE CATEGORY( > CATEGORYNUM SMALLINT NOT NULL DEFAULT NEXTVAL('GEN_CATEGORY'), > DESCRIPTION VARCHAR(20) NOT NULL, > CONSTRAINT PK_CATEGORY PRIMARY KEY (CATEGORYNUM) > ); > > So as you can see GEN_ plus the tablename is indeed correct. The default on > the CATEGORYNUM column is definitely working, which I tested with direct SQL > commands: after inserting a row (with the CATEGORYNUM not specified in the > INSERT), if I SELECT currval(‘GEN_CATEGORY’), it gives me the correct value, > which is also what got saved in that column. > > -------------------------------------------------------- > Dan Cooperstock > DONATION and ACCOUNTS web site: http://www.Software4Nonprofits.com > Email: i...@software4nonprofits.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. > > > From: Melvin Davidson [mailto:melvin6...@gmail.com] > Sent: August 5, 2017 4:46 PM > To: Dan Cooperstock at Software4Nonprofits <i...@software4nonprofits.com> > Cc: firstname.lastname@example.org > Subject: Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys > (serials) > > >GetIdentity="Select currval('GEN_&TableName')" > > FYI, it would be helpful to specify the PostgreSQL version & O/S, but > generically speaking, in PostgreSQL, when you generate a sequence > by specifying serial as data type, the name takews the form of > tablename_columnname_seq, so in your case, try > > https://www.postgresql.org/docs/9.4/static/datatype-numeric.html#DATATYPE-SERIAL > > GetIdentity="Select currval('tablename_column_seq')". > > BTW, in PostgreSQL, it is NOT recommended to use mixed case object names, as > all names are converted to lowercase unless enclosed in double quotes. > > > On Sat, Aug 5, 2017 at 4:09 PM, Dan Cooperstock at Software4Nonprofits > <i...@software4nonprofits.com> wrote: >> 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: i...@software4nonprofits.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. >> >> > > > > -- > Melvin Davidson > I reserve the right to fantasize. Whether or not you > wish to share my fantasy is entirely up to you.
I don’t see that you posted any sort of error message? Also don’t test that sequence more than 64K times as you’ll certainly get a number too big for smallest :) Did your direct sql testing actually use ALL CAPS? -- Sent via pgsql-general mailing list (email@example.com) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general