From: Richard Huxton <dev@archonet.com>
To: cslucki@cyberworkers.com
To: pgsql-sql@postgresql.org
Subject: Re: Difference between insert a tuple in a table by function and by datasheet
Date: Fri, 22 Jun 2001 17:08:25 +0100
Message-ID: <003201c0fb35$956d9880$1001a8c0@archonet.com> (raw)
References: <JJEDKCAELJIBHLIPIDHGOEBGCBAA.cslucki@cyberworkers.com>
From: "Cyril Slucki" <cslucki@cyberworkers.com>
> this is my 2nd attempt to get some links for my problem.
> I don't know whether my question is so stupid or difficult or I'm in the
> wrong list. Please let me know.
You might try the pgsql-odbc or pgsql-interfaces lists - it's also worth
checking the archives for similar issues. I think the reason you've had no
success here is we're all waiting for someone with an answer to pipe up.
> I have the following situation: ( I use MsAccess97 as frontend, ODBC
> 7.1.0003)
> I insert tuples in a table with a plpgsql-function, called in a form via
> VBA-code. It works fine, but I can't update these tuples in datasheet
view.
> ERROR: an other user has changed in the meantime.....but I'm the only.
> When I insert tuples via datasheet view, I can update these tuples, but
> only these.
>
> I can't see a difference between the tuples inserted by the function and
> datasheet, but it looks like, that the tuples are *marked*.
>
> Please, give me some information to solve my problem.
Well - I can think out loud FWIW.
Access thinks something has changed the values, so there are a couple of
things you can try:
1. Are you experiencing any timezone/clock-related problems elsewhere?
2. If you insert tuples then quit and restart Access can you edit them at
that time?
3. Can you edit all tuples from psql?
4. If you write a pass-through query to update tuples does that work?
5. If you write a function to update tuples does that work?
If it's any use here are the ODBC settings I use:
Database, Server, User Name, Password - set as required
Port: 5432
On the Advanced Options (Driver) dialogue...
Disable Genetic Optimiser: Y
KSQO: Y
Recognize Unique Indexes: Y
Use Declare/Fetch: N
CommLog: N
ReadOnly: N
Parse Statements: N
Cancel as FreeStmt: N
Unknown Sizes: Maximum
Text as LongVarChar: Y
Unknowns as LongVarChar: N
Bools as Char: Y
Cache size: 100
Max Varchar: 1024
Max LongVarChar: 8190
Systable prefix: pg_;
Connect Settings: (blank)
Advanced Options (Postgresql) dialogue
Protocol: 7.X,6.4
all other items unticked/blank.
HTH
- Richard Huxton
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-sql@postgresql.org
Cc: dev@archonet.com, cslucki@cyberworkers.com
Subject: Re: Difference between insert a tuple in a table by function and by datasheet
In-Reply-To: <003201c0fb35$956d9880$1001a8c0@archonet.com>
* 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