Re: upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found

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(at)flex(dot)ro>
>To: Chris Haas <haasjc(at)hotmail(dot)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.