pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: jwieck@debis.com
To: jproseve@arcavia.com
Cc: pgsql-sql@postgreSQL.org
Cc: djackson@cpsgroup.com
Subject: Re: [SQL] More view problems
Date: Thu, 14 Jan 1999 09:16:04 +0100 (MET)
Message-ID: <m100hwj-000EBQC@orion.SAPserv.Hamburg.dsh.de> (raw)
In-Reply-To: <369D7A93.EA0FC796@arcavia.com>

>
> 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.

    There  are still bugs in the rewrite system about handling of
    GROUP BY in views. It is because views aren't implemented  in
    a  form of subselect. Instead they replace expressions in the
    original query. I don't want to explain  it  in  detail  here
    (RTF-programmers-M).   However deep you nest views, the final
    rewritten statement is still something you could  have  typed
    as  a  legal  SQL  statement - and such has only one possible
    grouping.

    Don't use GROUP BY in view definitions for now.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#======================================== jwieck@debis.com (Jan Wieck) #





view thread (2+ messages)

Message-ID: <m100hwj-000EBQC@orion.SAPserv.Hamburg.dsh.de>
Permalink:  ../m100hwj-000EBQC@orion.SAPserv.Hamburg.dsh.de/
Also on:    postgresql.org/message-id/m100hwj-000EBQC@orion.SAPserv.Hamburg.dsh.de

 · 

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: jwieck@debis.com, jproseve@arcavia.com, djackson@cpsgroup.com
  Subject: Re: [SQL] More view problems
  In-Reply-To: <m100hwj-000EBQC@orion.SAPserv.Hamburg.dsh.de>
  References: <369D7A93.EA0FC796@arcavia.com> <m100hwj-000EBQC@orion.SAPserv.Hamburg.dsh.de>

* 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