Subject: repeating groups

From: [email-masked] (Raymond D. Frost)
Date: Mon, 24 Feb 92 20:18:32 -0800

The following three queries were made against the video database.
The first two queries below work while the third one does not.  Why not?

More broadly I'm looking for a way to have a repeating group appear
in a field for a record.  Any suggestions?

* 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 = "berkeley" "
---------------
| 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 city.name = "berkeley" "
WARN:Feb 24 23:02:24:HeapTupleGetRuleLock: Invalid buffer

Raymond Frost
University of Miami

---

From: postarch (Postgres Mailing Archive)
Date: Mon, 02 Mar 92 17:28:41 PST

you write:
> Query sent to backend is "retrieve (city.residents.name) where city.name = "b
 +erkeley" "
> 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
[email-masked]