Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA19374; Mon, 2 Mar 92 17:29:16 -0800
Message-Id: <9203030129.AA19374@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: repeating groups
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Mon, 24 Feb 92 20:18:32 PST."
             <9202250418.AA16819@postgres.Berkeley.EDU> 
Date: Mon, 02 Mar 92 17:28:41 PST

you write:
> The following three queries were made against the video database.
> The first two queries below work while the third one does not.  Why not?
> 
> * retrieve (city.name) where city.name = "berkeley" \g
> 
> Query sent to backend is "retrieve (city.name) where city.name = "berkeley" "
> ---------------
> | name        |
> ---------------
> | berkeley    |
> ---------------
> 
> Go 
> * retrieve (city.residents.name) where city.name = "berkeley" \g
> 
> Query sent to backend is "retrieve (city.residents.name) where city.name = "b
 +erkeley" "
> ---------------
> | name        |
> ---------------
> | mike        |
> ---------------
> | joe         |
> ---------------
> | greg        |
> ---------------
> | bob         |
> ---------------
> | sam         |
> ---------------
> | jeff        |
> ---------------
> | linda       |
> ---------------
> 
> Go 
> * retrieve (city.name, city.residents.name) where city.name = "berkeley" \g
> 
> Query sent to backend is "retrieve (city.name, city.residents.name) where cit
 +y.name = "berkeley" "
> WARN:Feb 24 23:02:24:HeapTupleGetRuleLock: Invalid buffer

I can run this no problem.  It could well be the case that this bug has
been fixed since 3.1 went out.


Jeff Meredith
mer@postgres.berkeley.edu