Re: Driver issue ? Default value not recognized in access

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(dot)le-calvez(at)engie(dot)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(dot)klaver(at)aklaver(dot)com]
Envoyé : mardi 17 janvier 2017 01:34
À : Le Calvez Patrick (INEO INFRACOM); pgsql-odbc(at)postgresql(dot)org
Objet : Re: [ODBC] Driver issue ? Default value not recognized in
access

On 01/16/2017 02:49 AM, patrick(dot)le-calvez(at)engie(dot)com wrote:
> 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*
>
> _patrick(dot)le-calvez(at)engie(dot)com <mailto:patrick(dot)le-calvez(at)engie(dot)com>_
>
> 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:
> http://www.engie.com/disclaimer/disclaimer-fr.html
( http://www.engie.com/disclaimer/disclaimer-fr.html)
>


--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
ENGIE Mail Disclaimer:
http://www.engie.com/disclaimer/disclaimer-fr.html