pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Michael J Davis <michael.j.davis@tvguide.com>
Cc: pgsql-interfaces@postgreSQL.org
Cc: pgsql-hackers@postgreSQL.org
Subject: Re: [HACKERS] Issues with the latest 6.5 source
Date: Wed, 28 Apr 1999 18:29:18 -0400
Message-ID: <12390.925338558@sss.pgh.pa.us> (raw)
In-Reply-To: <93C04F1F5173D211A27900105AA8FCFC145430@lambic.prevuenet.com>

Michael J Davis <michael.j.davis@tvguide.com> writes:
> 1)	The \g option in pgsql is failing.

Fixed.  I had managed to break the empty-query response protocol on
Sunday --- odd that none of the regression tests detected this.  Sigh.

> 2)	My Access97 application using ODBC can't connect to the database.

I now have a strong suspicion that this is caused by the same goof.
ODBC might issue an empty query during startup.  (That used to be a
necessary part of the startup protocol; it isn't anymore, but ODBC
very possibly hasn't been changed.)

If you don't have CVS access and don't want to wait for tonight's
snapshot, here is the patch:

inline patch 1: src/backend/tcop/dest.c (+1/-1 lines) download inline-1.patch*** src/backend/tcop/dest.c~ Wed Apr 28 18:15:07 1999 --- src/backend/tcop/dest.c Wed Apr 28 18:15:45 1999 *************** *** 336,342 **** * tell the fe that we saw an empty query string * ---------------- */ ! pq_putbytes("I", 1); break; case Local: --- 336,342 ---- * tell the fe that we saw an empty query string * ---------------- */ ! pq_putbytes("I", 2); /* note we send I and \0 */ break; case Local:
Let us know if that helps... regards, tom lane

view thread (3+ messages)  latest in thread

Message-ID: <12390.925338558@sss.pgh.pa.us>
Permalink:  ../12390.925338558@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/12390.925338558@sss.pgh.pa.us

 ·  · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-interfaces@postgresql.org
  Cc: tgl@sss.pgh.pa.us, michael.j.davis@tvguide.com, pgsql-hackers@postgreSQL.org
  Subject: Re: [HACKERS] Issues with the latest 6.5 source
  In-Reply-To: <12390.925338558@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox