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

Re: Problems with Access XP and text primary keys

From: "Ben Trewern" <bendottrewern(at)mowlem(dot)com>
To: pgsql-odbc(at)postgresql(dot)org
Subject: Re: Problems with Access XP and text primary keys
Date: 2005-01-20 15:12:26
Message-ID: csohjv$2506$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-odbc
Is this just me?


"Ben Trewern" <bendottrewern(at)mowlem(dot)com> wrote in message 
news:cs8rha$2hv9$1(at)news(dot)hub(dot)org(dot)(dot)(dot)
> 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
> 



In response to

pgsql-odbc by date

Next:From: Joost KraaijeveldDate: 2005-01-20 19:25:29
Subject: How to call a stored procedure in PostgreSQL
Previous:From: Kevin PuetzDate: 2005-01-20 14:53:19
Subject: Re: 'No Current Record' using Access linked to Postgres via ODBC - A possible resolution

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