Access 'field too long' error

From: Randall Perry <rgp(at)systame(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Access 'field too long' error
Date: 2002-08-29 17:31:10
Message-ID: B993D29E.19750%rgp@systame.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Getting the error:
The size of a field is too long

From access when trying to link to a view. Discovered the problem field is
of type numeric(7,2). But, if I try linking to the table the view is based
on, I don't get the error. So, somehow this numeric field in a view looks
different to Access than the same numeric field in a table.

Any ideas?

--
Randy Perry
sysTame
Mac Consulting/Sales

http://www.systame.com/

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-08-29 17:37:31 Re: delete with referential integrity
Previous Message Murthy Kambhampaty 2002-08-29 17:11:06 Re: Interpretting WAL debug.

Browse pgsql-general by date

  From Date Subject
Next Message Diogo Biazus 2002-08-29 17:49:23 Re: join problem or maybe group :(
Previous Message Ben-Nes Michael 2002-08-29 16:34:51 Re: join problem or maybe group :(