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
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
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
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
> 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()
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/
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
;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
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
[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
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
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
>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
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
14 matches
Mail list logo