From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gregory W Burnham <gburnham@sfu.ca>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] Error Message
Date: Thu, 22 Oct 1998 21:52:44 -0400
Message-ID: <8003.909107564@sss.pgh.pa.us> (raw)
In-Reply-To: <003001bdfde4$5f26efc0$3d063a8e@apemantus.educ.sfu.ca>
"Gregory W Burnham" <gburnham@sfu.ca> writes:
> I'm getting the error:
> FATAL 1: Socket command type
> But I can't find any referance to it anywhere. This is for an INSERT
> query and the result returned from PQexec is NULL.
This is coming out of src/backend/tcop/postgres.c; it looks like the
backend got a NULL character at the point where it expected to read
the first byte of a new command string from the frontend.
My guess is that the frontend and backend got out of sync. The easiest
way to make that happen is to mess up a COPY IN or COPY OUT sequence,
but it could also be that you have a broken frontend that's sending
garbage.
What frontend software are you using, anyway? And what version?
What were you doing *before* the command on which you noticed the
failure?
regards, tom lane
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, gburnham@sfu.ca
Subject: Re: [INTERFACES] Error Message
In-Reply-To: <8003.909107564@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