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

Re: invalid input syntax for type tid: '(,)'

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Jose' Cruanyes" <cruanyes(at)cegroup(dot)it>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: invalid input syntax for type tid: '(,)'
Date: 2004-04-05 13:08:09
Message-ID: 03AF4E498C591348A42FC93DEA9661B889F956@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgsql-odbc
Thanks Jose, patch applied.

Regards, Dave. 

> -----Original Message-----
> From: Jose' Cruanyes [mailto:cruanyes(at)cegroup(dot)it] 
> Sent: 05 April 2004 12:21
> To: Dave Page
> Cc: pgsql-odbc(at)postgresql(dot)org
> Subject: Re: [ODBC] invalid input syntax for type tid: '(,)'
> 
> 
> On Apr 5, 2004, at 11:32 AM, Dave Page wrote:
> 
> > It's rumoured that Jose Cruanyes once said:
> >>
> >> I've found three, two on "convert.c" and one on "results.c"
> >>
> >> now if some one can put the changes upstream...
> >>
> >
> > Can you post a patch?
> >
> --------------<cut>--------------8<----------------8<-------------
> -8<------------------
> diff -Naur psqlodbc-old/convert.c psqlodbc-new/convert.c
> --- psqlodbc-old/convert.c      Mon Oct 20 02:37:42 2003
> +++ psqlodbc-new/convert.c      Sun Apr  4 19:39:39 2004
> @@ -2059,7 +2059,7 @@
>                                   * 1st query is for field information
>                                   * 2nd query is keyset gathering
>                                   */
> -                               CVT_APPEND_STR(qb, " where ctid =  
> '(,)';select ctid, oid from ");
> +                               CVT_APPEND_STR(qb, " where ctid =
> '(0,0)';select ctid, oid from ");
>                                  CVT_APPEND_DATA(qb, qp->statement +  
> qp->from_pos + 5, npos - qp->from_pos - 5);
>                          }
>                  }
> @@ -2102,7 +2102,7 @@
>                  qb->load_stmt_len = qb->npos;
>                  if (0 != (qb->flags & FLGB_KEYSET_DRIVEN))
>                  {
> -                       CVT_APPEND_STR(qb, "where ctid = 
> '(,)';select  
> CTID, OID from ");
> +                       CVT_APPEND_STR(qb, "where ctid = 
> '(0,0)';select
> CTID, OID from ");
>                          CVT_APPEND_DATA(qb, qp->statement +  
> qp->from_pos + 5, qp->where_pos - qp->from_pos - 5);
>                  }
>          }
> diff -Naur psqlodbc-old/results.c psqlodbc-new/results.c
> --- psqlodbc-old/results.c      Mon Oct 20 02:37:42 2003
> +++ psqlodbc-new/results.c      Sun Apr  4 20:33:47 2004
> @@ -1827,7 +1827,7 @@
>          {
>                  len += 50;
>                  selstr = malloc(len);
> -               sprintf(selstr, "%s where ctid = currtid(0, 
> '(,)') and  
> oid = %u", stmt->load_statement, oid);
> +               sprintf(selstr, "%s where ctid = currtid(0, '(0,0)')
> and oid = %u", stmt->load_statement, oid);
>          }
>          else
>          {
> --------------<cut>--------------8<----------------8<-------------
> -8<------------------
> 
> 
> 
> 
> 
> Pax et Bonum
> 
> # dott. Jose' Cruanyes Aguilar  -  C.E. Soft srl
> #  Pzza. Firenze,4 MILANO  -  XX Settembre 10, CREMONA
> #   02,33603122                0372,460602
> 
> 

pgsql-odbc by date

Next:From: Ray AspeitiaDate: 2004-04-05 13:13:19
Subject: Re: odbc and mac os x
Previous:From: Jose' CruanyesDate: 2004-04-05 13:05:16
Subject: Re: odbc and mac os x

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