Received: from hotmail.com (law2-f130.hotmail.com [216.32.181.130])
	by hub.org (8.10.1/8.10.1) with ESMTP id e8MLmGs87143
	for <pgsql-interfaces@postgresql.org>;
	Fri, 22 Sep 2000 17:48:16 -0400 (EDT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Fri, 22 Sep 2000 13:00:49 -0700
Received: from 129.206.202.109 by lw2fd.hotmail.msn.com with HTTP;
	Fri, 22 Sep 2000 20:00:49 GMT
X-Originating-IP: [129.206.202.109]
From: "Chris Haas" <haasjc@hotmail.com>
To: pgsql-interfaces@postgresql.org
Subject: Re: upgrade pgaccess v0.96 to v0.98 fatal error: attribute
	querytables not found
Date: Fri, 22 Sep 2000 20:00:49 GMT
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Message-ID: <LAW2-F130Xd4Fm5Oeg300001b83@hotmail.com>
X-OriginalArrivalTime: 22 Sep 2000 20:00:49.0664 (UTC)
	FILETIME=[CDD74000:01C024CF]
X-Archive-Number: 200009/96

Hi,
I did add the missing fields to table pga_queries (not pgq-queries!). 
Starting pgacees as postgres superuser resulted in the same error. But I 
haven't tried to delete the table mentioned above.

Big Thank's to Teo - Chris


>From: Constantin Teodorescu <teo@flex.ro>
>To: Chris Haas <haasjc@hotmail.com>
>Subject: Re: [INTERFACES] upgrade pgaccess v0.96 to v0.98 fatal error: 
>attribute querytables not found
>Date: Fri, 22 Sep 2000 08:24:08 +0300
>
>Chris Haas wrote:
> >
> > Hi,
> > the error appears when I try to open the database with pgaccess v0.98
> > (after clicking on the 'open' button of the form for 
>db-name,-username...).
> >
> > window with error-message like: 'fatal error upgrading pgaccess table
> > pga_queries:error: attribute 'querytables' not found' status
> > pgres_fatal_error
> > after pressing 'ok' the window closes and the db is not accessed 
>'(pgaccess
> > is still running).
> >
> > Left everything unchanged except the change of pgaccess-packages the 
>same
> > database can be accessed via pgaccess v0.96!
>
>Ok. I got the error.
>
>In earlier versions of PgAccess pqq_queries table didn't have the
>querytables field!
>When 0.98 tries to add that field it seems that you don't have ALTER
>TABLE rights to that database and table.
>Try running PgAccess once for that database as postgres user (the master
>user of the database).
>Other sollution: if you don't have important queries in pgq_queries (in
>Query tab in PgAccess) delete the pgq_queries tables (drop table ...)
>with psql.
>Other sollution is to add manually (with psql) the following fields to
>your old pgq_queries table:
>querytables text, querylinks text, queryresults text, querycomments text
>
>Tell me which one works for you (the best is to open PgAccess as
>postgres user).
>
>Best regards,
>Teo

_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

Share information about yourself, create your own public profile at 
http://profiles.msn.com.