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

2017-08-06 Thread Dan Cooperstock at Software4Nonprofits
G. Johnston Sent: August 6, 2017 3:47 AM To: Dan Cooperstock at Software4Nonprofits Cc: Forums postgresql Subject: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials) On Saturday, August 5, 2017, Dan Cooperstock at Software4Nonprofits > wrote: As I have mentioned in several

[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

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

2017-08-05 Thread Igor Korot
Hi, Dan, On Sat, Aug 5, 2017 at 8:52 PM, Dan Cooperstock at Software4Nonprofits 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 w

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

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

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

2017-08-05 Thread Karl Czajkowski
> 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()

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

2017-08-05 Thread Rick Widmer
On 8/5/2017 6:06 PM, Dan Cooperstock at Software4Nonprofits wrote: (I wish Postgres had a web-based community board, rather than just this mailing list with no history available!) I will post it to Appeon as an actual bug if I get stuck. Have you looked here? https://www.postgresql.org/list/

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

2017-08-05 Thread Dan Cooperstock at Software4Nonprofits
Cc: Dan Cooperstock at Software4Nonprofits ; Rob Sargent ; Forums postgresql Subject: Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials) On Sat, Aug 5, 2017 at 6:26 PM, Igor Korot mailto:ikoro...@gmail.com> > wrote: Hi, Did you try bringing it to SAP? Thank you. On

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

2017-08-05 Thread Melvin Davidson
;UNSUBSCRIBE", and we will immediately remove you from our mailing list, if > you are on it. > > > > > > -Original Message- > > From: Rob Sargent [mailto:robjsarg...@gmail.com] > > Sent: August 5, 2017 5:30 PM > > To: Dan Cooperstock at Software4Nonprofi

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

2017-08-05 Thread Igor Korot
a >> >> 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

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

2017-08-05 Thread Dan Cooperstock at Software4Nonprofits
[mailto:robjsarg...@gmail.com] Sent: August 5, 2017 5:30 PM To: Dan Cooperstock at Software4Nonprofits Cc: Forums postgresql Subject: Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys (serials) > On Aug 5, 2017, at 3:12 PM, Dan Cooperstock at Software4Nonprofits > wrote: > &g

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

2017-08-05 Thread Rob Sargent
gt; Sent: August 5, 2017 4:46 PM > To: Dan Cooperstock at Software4Nonprofits > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity keys > (serials) > > >GetIdentity="Select currval('GEN_&TableName')" > &g

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

2017-08-05 Thread Dan Cooperstock at Software4Nonprofits
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 Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] PostgreSQL with PowerBuilder, and Identity

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

2017-08-05 Thread Melvin Davidson
>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 cas

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

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