Re: 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