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

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!

All Packages (Tcl 8.3.1, TclX 8.2.0, Tk 8.3.1, pgaccess 0.98.5, postgres 
7.0.2, etc) including install-procedures are those from Suse Linux 7.0 
professional (from CD-distributution).

thank you for giving a hand - 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: Thu, 21 Sep 2000 11:54:58 +0300
>
>Chris Haas wrote:
> >
> > Hi,
> > I tried to gain access via pgaccess version 0.98 to an already existing 
>db
> > which got designed with pgaccess version 0.96. With pgaccess v0.98 (also
> > with v0.98.5) I get the following message:
> > fatal error - attribute querytables not found
> > whereelse with pgaccess v0.96 there is no problem at all!!
> > how comes that???
>
>When does that error appear?
>What are you trying to do?
>
>There's no other bug report on 0.98 so I presume it's a local problem.
>
>Please include a detailed error report containing versions for Tcl/Tk ,
>PostgreSQL backend, OS type and version.
>
>Best regards,
>Constantin Teodorescu
>Braila, ROMANIA

_________________________________________________________________________
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.

I am having some trouble attaching tables from postgres 7.0.2 to access 97.

when I attemp to attach a table I sometimes get this error message. 
"Invalid field definition 'UNKNOWN' in definition of index or relation" 
this only happens on some tables including some system tables.

For some tables I can attach but when I attempt to open it  i get 'ODBC 
call Failed' and then all the data in the table whows up as #Name?

Any clues?

:wq
Tim Uckun
Due Diligence Inc. http://www.diligence.com/   Americas Background 
Investigation Expert.
If your company isn't doing background checks, maybe you haven't considered 
the risks of a bad hire.

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.