I realize that the prescribed technique for creating the Extended Attribute system tables (pbcatcol, pbcatedt, pbcatfmt, pbcattbl & pbcatvld) is to allow PB to do this auto-magically the first time a connection is made to the database via the Database Painter. However, yesterday's posting from Olan Knight about creating these tables in a PostgreSQL database, as well as similar questions from others that appear here from time to time have made me wonder "what alternative is there when the prescribed process doesn't work?"... because it does not always work.
To be clear: I am not experiencing this issue at this time. It just seems to be a process that is subject to failure on occasion.
I presume there are SQL scripts that PB runs to create and configure these tables. If so, where do they reside and why are they not listed and briefly explained in the product documentation? If not, shouldn't they exist and be documented so that we could troubleshoot and resolve an issue when it occurs? I've coded similar scripts for various databases over my career, and it's not rocket science.
Thank you so much for your valuable feedback. It is important for us to receive these type of incidents as support tickets. So, for example, if you consider this to be a documentation bug, then our team can consider adding that info into the documentation but we do require a ticket. The tickets are our internal process for following up on these type of cases.
Thanks again John and Olan!
I am NOT very knowledgeable about the PB Extended Attribute tables, as I've only used them once and that was almost 30 years ago in PB 4. I found some information in the PB User's Guide publication about the Extended Attribute tables in Appendix A: https://docs.appeon.com/pb2022r3/pbug/ug66510.html
You may wish to review this information.
I believe the data in these tables gets populated manually via the Database Painter as you create/modify the tables/columns in your application's database.
Since your follow-on question is really not related to the creation of the Extended Attribute tables (the topic of this thread) and since this thread is four years old, I suggest you post a new question specific to your issue. Best wishes and good luck!