Skip site navigation (1) Skip section navigation (2)

Re: Cannot update PGSQL databes via ODBC

From: Joe Shevland <shevlandj(at)kpi(dot)com(dot)au>
To: Steve Holmes <sholmes(at)primenet(dot)com>
Cc: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Cannot update PGSQL databes via ODBC
Date: 2000-05-11 05:53:24
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-interfaces
One possible cause of this is not having a unique index or
primary key defined on the table which requires updating. To be able
to insert/update/delete there'll need to be at least one of the above.

And threats to go to Access are ultimately only going to hurt yourself :)


Steve Holmes wrote:
> When using the latest version of PSQLODBC to connect to a linux
> machine running postgresql 6.5.2, I keep getting read-only mode.  I
> have the privs wide open on the linux side and I even turned off the
> read-only flag in the DSN's advanced driver settings.  When using VB6
> to attempt updating a table, I get the error telling me that update is
> not allowed and that select is the only allowed operations.  BTW, I
> can do a select with it and that part works fine.
> I can successfully update these tables just fine over in the linux
> side from the same user-id that I connect the ODBC with.  The log file
> created by the ODBC driver also indicates that read-only is = 1 even
> though I have that checkbox unchecked.
> I think others have experienced a similar problem but I never could
> find any solutions.  I posted a message or two recently to this list
> but got no responses.  Is there anywhere I can turn for help if this
> list can't do it?
> I really need to figure out something or I will have to set up
> microsoft access database and I really don't want to have to go there
> if I can help it.:)
> Thanks for any help if possible.
> --
> <Steve> Holmes
> Tempe, Arizona  USA

In response to

pgsql-interfaces by date

Next:From: Michael MeskesDate: 2000-05-11 08:14:11
Subject: Re: ECPG failed and Postmaster getting bigger in using perl Pg
Previous:From: Thomas LockhartDate: 2000-05-11 05:51:59
Subject: Re: Cannot update PGSQL databes via ODBC

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group