Skip to main content

More than 100 columns with postgreSQL database

  • July 12, 2021
  • 2 replies
  • 2 views

We are working on making our application compatible with PostGreSQL. 

As the data in postgresSQL is updated/inserted using function we are getting the error from postgresSQL when trying to create table with more than 100 columns. Has anyone seen this situation? what is the best way to resolve it?

2 replies

Forum|alt.badge.img

We are working on making our application compatible with PostGreSQL. 

As the data in postgresSQL is updated/inserted using function we are getting the error from postgresSQL when trying to create table with more than 100 columns. Has anyone seen this situation? what is the best way to resolve it?

Hi

Next year, we want to  choose postgresql to migrate from solid server,

Which database are you migrating from.I will be interested by your experience.

when you say "using function"  , what do you mean ?


Dominique


Ingo Stiller
Forum|alt.badge.img+3
  • Participating Frequently
  • July 21, 2021

We are working on making our application compatible with PostGreSQL. 

As the data in postgresSQL is updated/inserted using function we are getting the error from postgresSQL when trying to create table with more than 100 columns. Has anyone seen this situation? what is the best way to resolve it?

Hi Mita, hi Dominique

If I'm right, Mita's database access use procedures:
https://documentation.uniface.com/10/uniface/dbmsSupport/dbmsDrivers/_common/options/procedures.htm

: Just give "procedures=off" a try. 🙂

Ingo