Uniface User Forum

 View Only

  • 1.  More than 100 columns with postgreSQL database

    PARTNER
    Posted 07-12-2021 12:28

    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.  RE: More than 100 columns with postgreSQL database

    Posted 07-20-2021 10:34

    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



  • 3.  RE: More than 100 columns with postgreSQL database

    Posted 07-21-2021 07:30

    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

    <ac:link><ri:user ri:userkey="2c91b23364a8b42b01660c0cd5e700bd"></ri:user></ac:link> : Just give "procedures=off" a try. 🙂

    Ingo