pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Difference between insert a tuple in a table by function and by datasheet
6+ messages / 5 participants
[nested] [flat]

* Difference between insert a tuple in a table by function and by datasheet
@ 2001-06-22 07:23 DI Hasenöhrl <i.hasenoehrl@aon.at>
  2001-06-22 08:02 ` RE: Difference between insert a tuple in a table by function and by datasheet Cyril Slucki <cslucki@cyberworkers.com>
  2001-06-22 08:17 ` RE: Difference between insert a tuple in a table by function and by datasheet Hiroshi Inoue <Inoue@tpf.co.jp>
  2001-06-22 08:25 ` Re: Difference between insert a tuple in a table by function and by datasheet Dariusz Pietrzak <dariush@ajax.umcs.lublin.pl>
  0 siblings, 3 replies; 6+ messages in thread

From: DI Hasenöhrl @ 2001-06-22 07:23 UTC (permalink / raw)
  To: pgsql-sql; pgsql-odbc@postgresql.org

Hi,

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.

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.

Thanks
Irina

E-Mail: i.hasenoehrl@aon.at

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* RE: Difference between insert a tuple in a table by function and by datasheet
  2001-06-22 07:23 Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl <i.hasenoehrl@aon.at>
@ 2001-06-22 08:02 ` Cyril Slucki <cslucki@cyberworkers.com>
  2001-06-22 16:08   ` Re: Difference between insert a tuple in a table by function and by datasheet Richard Huxton <dev@archonet.com>
  2 siblings, 1 reply; 6+ messages in thread

From: Cyril Slucki @ 2001-06-22 08:02 UTC (permalink / raw)
  To: pgsql-sql

REMOVE
  -----Message d'origine-----
  De : pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org]De la part de DI Hasenöhrl
  Envoyé : vendredi 22 juin 2001 09:23
  À : pgsql-sql@postgresql.org; pgsql-odbc@postgresql.org
  Objet : [SQL] Difference between insert a tuple in a table by function and
by datasheet


  Hi,

  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.

  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.

  Thanks
  Irina

  E-Mail: i.hasenoehrl@aon.at


----------------------------------------------------------------------------
--
  Incoming mail is certified Virus Free.
  Checked by AVG anti-virus system (www.grisoft.com).
  Version: 6.0.262 / Virus Database: 132 - Release Date: 12/06/2001

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Difference between insert a tuple in a table by function and by datasheet
  2001-06-22 07:23 Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl <i.hasenoehrl@aon.at>
  2001-06-22 08:02 ` RE: Difference between insert a tuple in a table by function and by datasheet Cyril Slucki <cslucki@cyberworkers.com>
@ 2001-06-22 16:08   ` Richard Huxton <dev@archonet.com>
  2001-06-25 10:26     ` Re: [SQL] Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl <i.hasenoehrl@aon.at>
  0 siblings, 1 reply; 6+ messages in thread

From: Richard Huxton @ 2001-06-22 16:08 UTC (permalink / raw)
  To: cslucki@cyberworkers.com; pgsql-sql

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







^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: [SQL] Difference between insert a tuple in a table by function and by datasheet
  2001-06-22 07:23 Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl <i.hasenoehrl@aon.at>
  2001-06-22 08:02 ` RE: Difference between insert a tuple in a table by function and by datasheet Cyril Slucki <cslucki@cyberworkers.com>
  2001-06-22 16:08   ` Re: Difference between insert a tuple in a table by function and by datasheet Richard Huxton <dev@archonet.com>
@ 2001-06-25 10:26     ` DI Hasenöhrl <i.hasenoehrl@aon.at>
  0 siblings, 0 replies; 6+ messages in thread

From: DI Hasenöhrl @ 2001-06-25 10:26 UTC (permalink / raw)
  To: Richard Huxton <dev@archonet.com>; +Cc: pgsql-odbc@postgresql.org; pgsql-sql

Thank you for your information!
  ----- Original Message ----- 
  From: Richard Huxton 
  To: cslucki@cyberworkers.com ; pgsql-sql@postgresql.org 
  Sent: Friday, June 22, 2001 6:08 PM
  Subject: Re: [SQL] Difference between insert a tuple in a table by function and by datasheet


  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 put it in the pgsql-odbc list too

  >   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?
  no
  2. If you insert tuples then quit and restart Access can you edit them at
  that time?
  no
  3. Can you edit all tuples from psql?
  yes
  4. If you write a pass-through query to update tuples does that work?
  yes
  5. If you write a function to update tuples does that work?
  yes

  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.

  I use the same settings

  Now, I have located the problem, but I can't solve it.
  In my function, I make the following calculation:
      ...............
      update KalkPreislisten_float8 SET  kp_ep = rkontingent.k_ep::float8        -- this works correct

  but I have to calculate with a numeric type too (rwaehrung.w_euro is numeric(9,5))
  ....................
  update KalkPreislisten_float8 SET  kp_ep = rkontingent.k_ep::float8 *rwaehrung.w_euro::float8         -- this doesn't work

  I discovered, that a calculation float * float causes, that I can't update tuples in datasheet view.
  float * integer works correct

  What I'm doing wrong?????
  Please, let me know, how to realize calculations with type: float * float

  Thanks in advance
  Irina

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* RE: Difference between insert a tuple in a table by function and by datasheet
  2001-06-22 07:23 Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl <i.hasenoehrl@aon.at>
@ 2001-06-22 08:17 ` Hiroshi Inoue <Inoue@tpf.co.jp>
  2 siblings, 0 replies; 6+ messages in thread

From: Hiroshi Inoue @ 2001-06-22 08:17 UTC (permalink / raw)
  To: DI Hasen?rl <i.hasenoehrl@aon.at>; +Cc: pgsql-sql; pgsql-odbc@postgresql.org

-----Original Message-----
From: DI Hasenöhrl

> 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.

Don't your table have float columns ?

regards,
Hiroshi Inoue




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Difference between insert a tuple in a table by function and by datasheet
  2001-06-22 07:23 Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl <i.hasenoehrl@aon.at>
@ 2001-06-22 08:25 ` Dariusz Pietrzak <dariush@ajax.umcs.lublin.pl>
  2 siblings, 0 replies; 6+ messages in thread

From: Dariusz Pietrzak @ 2001-06-22 08:25 UTC (permalink / raw)
  To: DI Hasenöhrl <i.hasenoehrl@aon.at>; +Cc: pgsql-odbc@postgresql.org




> 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.
 Answer to that is actually in a FAQ.
Try setting 'row versioning' in your ODBC source, and remember to overload
'=' operator for int4 and xid. You'll find implementation in the FAQ.
 Oh, and maybe someone knows - when in access I do 'refresh linked tables'
it's very very slow, and doesen't work the way I want ( ie - when I
changed say 'row versioning' in driver acces won't notice until I delete
and re-add linked tables). 

--
Dariusz Pietrzak
Certified Nobody




^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2001-06-25 10:26 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-06-22 07:23 Difference between insert a tuple in a table by function and by datasheet DI Hasenöhrl <i.hasenoehrl@aon.at>
2001-06-22 08:02 ` Cyril Slucki <cslucki@cyberworkers.com>
2001-06-22 16:08   ` Richard Huxton <dev@archonet.com>
2001-06-25 10:26     ` DI Hasenöhrl <i.hasenoehrl@aon.at>
2001-06-22 08:17 ` Hiroshi Inoue <Inoue@tpf.co.jp>
2001-06-22 08:25 ` Dariusz Pietrzak <dariush@ajax.umcs.lublin.pl>

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