• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to get the Catalog Tables Installed in a PostgreSQL Database?

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

Resolved How to get the Catalog Tables Installed in a PostgreSQL Database?

  1. How-to
0
Votes
Undo
  1. Olan Knight
    Olan Knight
  2. PowerBuilder
  3. Thursday, 13 August 2020 16:50 PM UTC

PB2019R2, b2353
Windows 64 bit platform
PostgreSQL database hosted on a remote server


As per my last post, I got the DSN created for the new "dev12c" PostgreSQL database.
I then created a Database Painter Profile for the new database.... and it works!

However, I get this when the connection is made:


Q:  How do I go about getting the PB Catalog tables installed?


Thank You,

Olan

PS: In case you haven't guessed yet, at this time I'm a complete PostgreSQL novice. Olan

Datawindow Control Name/Tag
syncrt.exe
Accepted Answer
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Friday, 14 August 2020 01:35 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi Olan,

The tables public.pbcatXXX are created when I connect to PostgreSQL with PowerBuilder the first time. Do other databases have the same issue on your end? Please make sure the first person to connect to the database with PowerBuilder has sufficient privileges to create tables and grant permissions to PUBLIC, please refer to the article below for details.
https://docs.appeon.com/pb2019r2/connecting_to_your_database/ch13s06.html

When you are using the DirectConnect interface, the PowerBuilder extended attribute system tables are not created automatically the first time you connect to a database. You must run the DB2SYSPB.SQL script to create the system tables, as described in the article below.
https://docs.appeon.com/pb2019r2/connecting_to_your_database/ch12s07.html#XREF_40958_Using_the_DB2SYSPB

The DB2SYSPB.SQL script is in the Server directory in the PowerBuilder setup program. This directory contains server-side installation components and is not installed with PowerBuilder on your computer. You can use the attached one.

Regards,
ZhaoKai

Attachments (1)
DB2SYSPB.zip
Comment
Olan Knight
  1. Olan Knight
  2. Friday, 14 August 2020 16:40 PM UTC
Thank you, Zhao!
  1. Helpful
There are no comments made yet.
Responses (3)
John Fauss
John Fauss Accepted Answer Pending Moderation
  1. Thursday, 13 August 2020 19:41 PM UTC
  2. PowerBuilder
  3. # 1

Hi, Olan - I'm NOT a PostgreSQL person, but since nobody has responded yet, here' a link to some info regarding the creation of the extended attribute tables (the PB catalog tables):

https://docs.appeon.com/pb2019r2/connecting_to_your_database/ch13s06.html

Maybe it will help?

Update: I see mention in the documentation that support for stored procedure in PostgreSQL is limited. Perhaps this is keeping the extended attribute tables from being created. They are supposed to be created automatically when you connect to the database for the first time via the Database Painter.

Appeon: Where is the SQL script that creates the extended attribute tables? Not documented anywhere that I can find...

Comment
Olan Knight
  1. Olan Knight
  2. Friday, 14 August 2020 16:39 PM UTC
Thank you, John!
  1. Helpful
There are no comments made yet.
Kai Zhao @Appeon
Kai Zhao @Appeon Accepted Answer Pending Moderation
  1. Saturday, 15 August 2020 02:05 AM UTC
  2. PowerBuilder
  3. # 2

Hi John,

The DB2SYSPB.SQL script is in the Server directory in the PowerBuilder setup program. This directory contains server-side installation components and is not installed with PowerBuilder on your computer. You can use the attached one.

Please refer to article below for details.
https://docs.appeon.com/pb2019r2/connecting_to_your_database/ch12s07.html#XREF_40958_Using_the_DB2SYSPB

Regards,
ZhaoKai

Attachments (1)
DB2SYSPB.zip
Comment
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.