Unix Technical Forum

Re: New libpq based driver snapshot 08.01.0003 available

This is a discussion on Re: New libpq based driver snapshot 08.01.0003 available within the pgsql Interfaces odbc forums, part of the PostgreSQL category; --> > I rebooted the machine, installed 7.03.02.00 and relinked the tables. > > I still have the "#Deleted" problem. ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces odbc

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2008, 02:20 AM
Merlin Moncure
 
Posts: n/a
Default Re: New libpq based driver snapshot 08.01.0003 available

> I rebooted the machine, installed 7.03.02.00 and relinked the tables.
>
> I still have the "#Deleted" problem. The problem seem to occour only
> with tables where a varchar(255) column is part of the primary key.
>
> In another table all the cells are filled with label "#Error", the
> problem seem to be a decimal truncation or something like that.
>
> These problems seem to be related with MSAccess 2000, a colleague of
> mine with Access97 doesn't seem to face this problems.
>
> I will try to investigate these problems further and if I find

someting
> interesting I will let you know.
>
> Thank you. Kind regards,


Probably access has some kind of key limitation. Another way of getting
this problem is using high precision timestamps inside the primary key
since access can't deal with them on the clientside.

Good luck, AFAIK there is no solution to this problem except to work
around it. It is more a limitation of access than anything else.

Merlin

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:01 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com