Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (3)

Resolved Postgresql 11.1 with Unique index

  1. Issue
0
Votes
Undo
  1. Sivaprakash BKR
    Sivaprakash BKR
  2. PowerBuilder
  3. Thursday, 7 November 2019 05:40 AM UTC

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

 

 

  1. PostgreSQL
  2. PowerBuilder (Appeon)
Authenticate a user with Windows credentials
Masive MSI deploy with gpo
Accepted Answer
Sivaprakash BKR
Sivaprakash BKR Accepted Answer Pending Moderation
  1. Saturday, 9 November 2019 11:05 AM UTC
  2. PowerBuilder
  3. # Permalink

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
Kai Zhao @Appeon
  1. Kai Zhao @Appeon
  2. Monday, 11 November 2019 00:36 AM UTC
Glad to hear that you find the root cause of the issue.
  1. Helpful
There are no comments made yet.
Responses (3)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 7 November 2019 19:43 PM UTC
  2. PowerBuilder
  3. # 1

Hi Sivaprakash,

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

           PB 2019 R2 will support PostGreSQL V11 and higher.

Regards ... Chris

Comment
Armeen Mazda @Appeon
  1. Armeen Mazda @Appeon
  2. Thursday, 7 November 2019 21:51 PM UTC
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. Helpful
There are no comments made yet.
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Thursday, 7 November 2019 08:24 AM UTC
  2. PowerBuilder
  3. # 2

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
Sivaprakash BKR
  1. Sivaprakash BKR
  2. Thursday, 7 November 2019 11:02 AM UTC
Thanks ZhaoKai. I'll prepare & post a new pb project with required screen and database soon.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.