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

Resolved Automatically generate schema for Datawindow

  1. How-to
0
Votes
Undo
  1. hoshea hashub
    hoshea hashub
  2. PowerBuilder
  3. Wednesday, 11 October 2023 03:38 AM UTC

Windows 10
PB Version 6.5.1
Postgres 9.2
psql-ODBC 9.02.01 Connection

 

Hi,


When I connect to postgres database with PB and create a Datawindow, the schema will be automatically generated before the table name.

 

I found that when I created a new Datawindow, the schema was already in it.

I tried to set PBCatalogOwner, but the Datawindow still has a schema.

 

When I delete the schema manually, the DBname in ROWS -> ColumnSpecifications will have no table name.

 

I can manually set search_path in the database or odbc to specify it. Why is the schema automatically added in PB?

How can I make PB not generate schema, modify PB settings or ODBC configuration, Or in other ways?

 

Thanks!

 

  1. DataWindow
  2. ODBC
  3. PostgreSQL
  4. PowerBuilder
Creating pdf documents in format pdf/ua
Table name in syntax from syntaxfromsql
Responses (2)
hoshea hashub
hoshea hashub Accepted Answer Pending Moderation
  1. Friday, 10 November 2023 07:10 AM UTC
  2. PowerBuilder
  3. # 1

Hi,

All I know is that Postgresql was not supported in pb 6.5.1

regards

Thank you for your reply.

I now put the schema name in front of all the tables.

Comment
There are no comments made yet.
Miguel Leeuwe
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Wednesday, 11 October 2023 11:25 AM UTC
  2. PowerBuilder
  3. # 2

Hi,

All I know is that Postgresql was not supported in pb 6.5.1

regards

Comment
Andreas Mykonios
  1. Andreas Mykonios
  2. Friday, 10 November 2023 13:40 PM UTC
That's the only issue? Neither Powerbuilder is supported. :-)
  1. Helpful 1
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.