Re: [ODBC] Driver issue ? Default value not recognized in access - Mailing list pgsql-odbc
As a long time Access - linked - to -Postgres user, it is my experience that Access never shows the default values of a Postgres table. Whether this is an ODBC issue or an Access issue I don't know, but I always display the Postgres table properties in psql if I need to know the default value of a column.
Fred Parkinson
Application Programmer
Association of Bay Area Governments
415-820-7931
>>> <patrick.le-calvez@engie.com> 1/17/2017 7:39 AM >>>
Hello,
Thanks for your answer,
Here are the elements you asked :
1) How is the table in Access linked to the Postgres database?
I create tables linked through a ODBC connection.
Here are the parameters of the connection.
2) Where do you except the default value to show up?
I expect the default value to appear in 2 places.
First, I would like to see it there :
Second (and most of all), when I run my vba subs, I need to use the default values of some fields. At this state, vba does see any.
3) Is the default value created in the database when you INSERT a value without specifying it?
Yes it is.
More specifically, most of my records are inserted via a vba sub. That’s where I need those default values the most.
Have a good day,
Patrick
-----Message d'origine-----
De : Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Envoyé : mardi 17 janvier 2017 01:34
À : Le Calvez Patrick (INEO INFRACOM); pgsql-odbc@postgresql.org
Objet : Re: [ODBC] Driver issue ? Default value not recognized in access
De : Adrian Klaver [mailto:adrian.klaver@aklaver.com]
Envoyé : mardi 17 janvier 2017 01:34
À : Le Calvez Patrick (INEO INFRACOM); pgsql-odbc@postgresql.org
Objet : Re: [ODBC] Driver issue ? Default value not recognized in access
> Hello,
>
>
>
> I’ve installed a few weeks back a driver obdc, linking my access file
> to my postgresql database.
>
> Thank you for that.
>
> psqlodbc_09_05_0300-x64.zip
>
>
>
> I’ve a problem, and I think maybe it’s within the driver.
>
>
>
> Access doesn’t recognize the default values registered in my postgre
> database.
You are going to need to be more specific about this:
1) How is the table in Access linked to the Postgres database?
2) Where do you except the default value to show up?
3) Is the default value created in the database when you INSERT a value without specifying it?
>
> Do you have any intel about that issue ?
>
> Do you anyway to solve it ? Or another way to pass over it ?
>
>
>
> Thanks in advance,
>
>
>
> *Patrick LE CALVEZ*
> *Chef de projet*
>
> *Agence Nord-Est*
>
> *INEO INFRACOM*
>
>
> Tel. 03 80 73 74 03
>
> Mob. 06 84 85 33 13
>
>
>
> Logo <http://cofelyineo-gdfsuez.com/>
>
> Curseur
>
> engie-ineo.fr
>
> *Ineo Infracom*
>
> *5 rue Lavoisier - CS 20089
> 21603 LONGVIC Cedex
>
> **Pensez à l'environnement avant d'imprimer ce message.*
>
>
> Curseur Flux
>
>
>
> ENGIE Mail Disclaimer:
>
--
Adrian Klaver
ENGIE Mail Disclaimer: http://www.engie.com/disclaimer/disclaimer-fr.html
Attachment
pgsql-odbc by date: