From: Joe Shevland <shevlandj@kpi.com.au>
To: Steve Holmes <sholmes@primenet.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Cannot update PGSQL databes via ODBC
Date: Thu, 11 May 2000 15:53:24 +1000
Message-ID: <391A4AD4.EC3AC9ED@kpi.com.au> (raw)
References: <p0gkhs01tmll030ospl4ehmd3l98d36loe@4ax.com>
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 :)
Regards,
Joe
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: shevlandj@kpi.com.au, sholmes@primenet.com
Subject: Re: Cannot update PGSQL databes via ODBC
In-Reply-To: <391A4AD4.EC3AC9ED@kpi.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox