Skip to main content

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?

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


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