Re: problem on view data

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "jack" <datactrl(at)tpg(dot)com(dot)au>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: problem on view data
Date: 2003-02-05 17:10:02
Message-ID: 03AF4E498C591348A42FC93DEA9661B8259BF0@mail.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi Jack,

After a great deal of testing I've found the cause of this problem. It
is caused by ADO when it finds high or very low ASCII characters in
adLongVarChar columns. The problem occured because newer versions of
pgAdmin set the ODBC drivers UnknownsAsLongVarChar option to 1 which
caused binary data to be presented as a LongVarChar.

If you'd like to test a new version (which also has some other new
features), please try the snapshot build from the binaries directory at
http://cvs.pgadmin.org/. Installation instructions are in the readme.

Regards, Dave.

> -----Original Message-----
> From: jack [mailto:datactrl(at)tpg(dot)com(dot)au]
> Sent: 03 February 2003 01:02
> To: Dave Page
> Subject: Re: [pgadmin-support] problem on view data
>
>
> Dave,
>
> Thank you for the reply. I use an old version of pgAdmin Ver
> 1.1.76 to open the same pg_index. It can open without any
> problem. So is that a problem of ADO? Would you please
> advise. Thank you!
>
> Jack
>
> ----- Original Message -----
> From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
> To: "jack" <datactrl(at)tpg(dot)com(dot)au>; "pgadmin"
> <pgadmin-support(at)postgresql(dot)org>
> Sent: Saturday, February 01, 2003 5:07 AM
> Subject: RE: [pgadmin-support] problem on view data
>
>
>
>
> > -----Original Message-----
> > From: jack [mailto:datactrl(at)tpg(dot)com(dot)au]
> > Sent: 31 January 2003 01:11
> > To: pgadmin
> > Subject: [pgadmin-support] problem on view data
> >
> >
> > Hi,
> >
> > Using: pgAdmin II V1.4.12
> > When view data of table pg_index, it will close down pgAdmin
> > automatically. Thank you very much !
>
> Yes, unfortunately this appears to be a problem in
> Microsoft's ADO which has trouble wit some array types. The
> pg_trigger table will do it as well iirc.
>
> Regards, Dave.
>
>
>

Browse pgadmin-support by date

  From Date Subject
Next Message Tom Sandford 2003-02-07 14:10:40 Update wizard out of date (pgadmin v 1.4.12)
Previous Message Macropac 2003-02-04 10:46:09 help