1. Sivaprakash BKR
  2. PowerBuilder
  3. Thursday, 07 November 2019

Hello,

PB 2017 R3, PostgreSQL 11.1

Looks like PB doesn't report an error when there is a violation of uniquess in a table, instead it goes into a infinite loop. Uniqueness created with a  unique index and NOT primary key. 

Removing the unique index, solves this issue.

Have anyone faced this issue before ?

Happiness Always
BKR Sivaprakash

 

 

Who is viewing this page
Sivaprakash BKR Accepted Answer Pending Moderation
0
Votes
Undo

Hello,

Sorry.

It happened to be a issue in our trigger coding.  Somehow the code is missing which deals with UNIQUE KEY (which was there earlier).  We noticed this missing only when we were preparing a fresh project.

Thanks.

Happiness Always
BKR Sivaprakash

 

Comment
Glad to hear that you find the root cause of the issue.
  1. Zhao Kai
  2. Monday, 11 November 2019
There are no comments made yet.
  1. Saturday, 9 November 2019
  2. PowerBuilder
  3. # 1
Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo

Hi Sivaprakash,

   BTW: PB2017R3 and PB2019 currently only support PostGreSQL v10.x

           PB 2019 R2 will support PostGreSQL V11 and higher.

Regards ... Chris

Comment
Just elaborating on what Chris said, although version 11.x is not certified it should work. And since we do plan to certify version 11.x as you can see Zhao Kai is asking for your help to reproduce this issue so if there really is a version 11.x specific issue we can address it in the upcoming PB 2019 R2.
  1. Armeen Mazda
  2. Thursday, 7 November 2019
There are no comments made yet.
  1. Thursday, 7 November 2019
  2. PowerBuilder
  3. # 2
Zhao Kai Accepted Answer Pending Moderation
0
Votes
Undo

Hi Sivaprakash,

I did not reproduce the issue on our end. Please provide information below to us for more study, thanks.
1 The ODBC driver version you are using.
2 A simple PB case and detail steps to reproduce the issue.
3 SQL to create ralated table & data.

Regards,
ZhaoKai

Comment
Thanks ZhaoKai. I'll prepare & post a new pb project with required screen and database soon.
  1. Sivaprakash BKR
  2. Thursday, 7 November 2019
There are no comments made yet.
  1. Thursday, 7 November 2019
  2. PowerBuilder
  3. # 3
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.