pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: JP Rosevear <jproseve@arcavia.com>
To: pgsql-sql@postgresql.org, "Jackson, DeJuan" <djackson@cpsgroup.com>
Subject: More view problems
Date: Thu, 14 Jan 1999 00:03:15 -0500
Message-ID: <369D7A93.EA0FC796@arcavia.com> (raw)

Building on DeJuan's suggestion, we have arrived at the following code
(using the extra view because from queries don't seem to allow sub
queries):

create view tab021temp as select fldkey as fldkey2, fld000 as fld000,
fld001 as fld001 from tab000 group by fld001, fld000, fldkey2;

create view tab021 as select count(1) as fldkey, a.fldkey2, a.fld000,
a.fld001 from tab021temp a, tab021temp b where a.fld001 > b.fld001 or
(a.fld001 = b.fld001 and a.fld000 > b.fld000) or a.fld000 = b.fld000
grouPQexec() -- Request was sent to backend, but backend closed the
channel before rp by fld001, fld000, fldkey2;

select * from tab021;

This terminates in psql with the following error after the select
statement is made:

PQexec() -- Request was sent to backend, but backend closed the channel
before r
esponding. This probably means the backend terminated abnormally before
or while pr ocessing the request.

What is going on here? Multi level views seem to work if they are
simple.  Why is the connection being dropped?  JDBC gives up a similar
broken pipe error.

-JP




view thread (2+ messages)  latest in thread

Message-ID: <369D7A93.EA0FC796@arcavia.com>
Permalink:  ../369D7A93.EA0FC796@arcavia.com/
Also on:    postgresql.org/message-id/369D7A93.EA0FC796@arcavia.com

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: jproseve@arcavia.com, djackson@cpsgroup.com
  Subject: Re: More view problems
  In-Reply-To: <369D7A93.EA0FC796@arcavia.com>
  References: <369D7A93.EA0FC796@arcavia.com>

* 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