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

Problems with Access XP and text primary keys

From: "Ben Trewern" <bendottrewern(at)mowlem(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Problems with Access XP and text primary keys
Date: 2005-01-14 16:23:10
Message-ID: cs8rha$2hv9$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
I've been using Postgres 8.0rc5 with the pgsqlODBC 8.00.00.03 driver and am 
having some problems.

The database works correctly for some time but suddenly and for no reason I 
can find I get #Deleted in some of the fields. These tables seem to be those 
which have text primary keys. I've looked at the psqlodbcXXXX.log and it 
seems that I get:

conn=162845400, query='SELECT "mw"."users"."user_name" FROM "mw"."users" '
[ fetched 13 rows ]

conn=162845400, query='SELECT 
"user_name","entered_ts","entered_user","last_changed","last_user","full_name","area_id","xmin" 
FROM "mw"."users" WHERE "user_name" = 'b' OR "user_name" = 'c' OR 
"user_name" = 'm' OR "user_name" = 'b' OR "user_name" = 'p' OR "user_name" = 
't' OR "user_name" = 'j' OR "user_name" = 'r' OR "user_name" = 'f' OR 
"user_name" = 'j''
[ fetched 0 rows ]

conn=162845400, query='SELECT 
"user_name","entered_ts","entered_user","last_changed","last_user","full_name","area_id","xmin" 
FROM "mw"."users" WHERE "user_name" = 'p' OR "user_name" = 'p' OR 
"user_name" = 'j' OR "user_name" = 'j' OR "user_name" = 'j' OR "user_name" = 
'j' OR "user_name" = 'j' OR "user_name" = 'j' OR "user_name" = 'j' OR 
"user_name" = 'j''
[ fetched 0 rows ]

instead of when working correctly:

conn=170998744, query='SELECT "mw"."users"."user_name" FROM "mw"."users" '
[ fetched 13 rows ]

conn=170998744, query='SELECT 
"user_name","entered_ts","entered_user","last_changed","last_user","full_name","area_id","xmin" 
FROM "mw"."users" WHERE "user_name" = 'btrewern' OR "user_name" = 
'chappellj' OR "user_name" = 'mcwilliamsf' OR "user_name" = 'ben' OR 
"user_name" = 'postgres' OR "user_name" = 'timc' OR "user_name" = 'jasonc' 
OR "user_name" = 'robh' OR "user_name" = 'francism' OR "user_name" = 
'janeh''
[ fetched 10 rows ]

conn=170998744, query='SELECT 
"user_name","entered_ts","entered_user","last_changed","last_user","full_name","area_id","xmin" 
FROM "mw"."users" WHERE "user_name" = 'pons_temp' OR "user_name" = 'pauls' 
OR "user_name" = 'jeremyw' OR "user_name" = 'jeremyw' OR "user_name" = 
'jeremyw' OR "user_name" = 'jeremyw' OR "user_name" = 'jeremyw' OR 
"user_name" = 'jeremyw' OR "user_name" = 'jeremyw' OR "user_name" = 
'jeremyw''
[ fetched 3 rows ]

The table "mw"."users" is created as:

CREATE TABLE users
(
  user_name short_text_dom PRIMARY KEY,
  entered_ts timestamp DEFAULT ('now'::text)::timestamp(6) with time zone,
  entered_user short_text_dom DEFAULT "current_user"(),
  last_changed timestamp,
  last_user short_text_dom,
  full_name text,
  area_id int4 NOT NULL
);

and

"mw"."short_text_dom" is:

CREATE DOMAIN short_text_dom
  AS varchar(250);

Does anyone have any ideas?

Regards,

Ben Trewern 



Responses

pgsql-odbc by date

Next:From: lothar.behrensDate: 2005-01-15 10:00:30
Subject: Re: pgsqlODBC problems
Previous:From: LucianoDate: 2005-01-13 22:50:36
Subject: Re: Query with hexadecimal characters

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