Return-Path: postarch
Received: by postgres.Berkeley.EDU (5.61/1.29)
	id AA29012; Thu, 30 Apr 92 00:17:29 -0700
Message-Id: <9204300717.AA29012@postgres.Berkeley.EDU>
From: postarch (Postgres Mailing Archive)
Subject: Re: Problem with retrieving data
To: postgres@postgres.berkeley.edu
Sender: pg_adm@postgres.berkeley.edu
Reply-To: mer@postgres.berkeley.edu
In-Reply-To: Your message of "Wed, 22 Apr 92 06:32:07 PDT."
             <9204221332.AA22062@postgres.Berkeley.EDU> 
Date: Thu, 30 Apr 92 00:16:50 PDT

you write:
> Dear Postgres-Group,
> 
> I installed the folloeing relations in postgres :

...
> create E_cell (
> 	wname               = text,
> 	wviewname           = text,
> 	wcell_status        = text,
> 	wcell_list          = int4,
> 	wbb_lower_left_x    = float8,
> 	wbb_lower_left_y    = float8,
> 	wWZS_SHORT0         = float8,
> 	wWZS_SHORT1         = float8,
> 	witem_counter       = int4,
> 	wsim_model          = text,
> 	wproperties         = text,
> 	wtime               = text,
> 	wcontains_net       = oid[],
> 	wcontains_port      = oid[],
> 	wcontains_inst      = oid[])\g

> Due to the reason of 16 chracters per row, we generate the names wWZS_SHORTxxx
> The creation terminates without any error message.
> 
> Retriving data out of some of the tables (E_inst and E_cell) produce the 
> following error :
> 
> * retrieve (E_cell.all)\g
> 
> Query sent to backend is "retrieve (E_cell.all)"
> Error: Unexpected identfier in dump_data: w
> 
> After this message the monitor terminates. So, what is wrong in the 
> table definitions?

There appears to be a bug with attribute names that are 16 characters long
(in E_cell wbb_lower_left_x and wbb_lower_left_y).

If you shorten those that are 16 to be 15 then the retrieves work.


Jeff Meredith
mer@postgres.berkeley.edu