pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedupgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found
3+ messages / 1 participants
[nested] [flat]
* upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found
@ 2000-09-18 20:17 Chris Haas <haasjc@hotmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Chris Haas @ 2000-09-18 20:17 UTC (permalink / raw)
To: pgsql-interfaces
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???
Thanks for getting help - Chris
PS I dumped out the db (via pgdump) from postgres 6.4 from SUSE6.2
distribution and put it back (via pgsql) to postgres (v?) from SUSE7.
_________________________________________________________________________
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found
@ 2000-09-21 16:01 Chris Haas <haasjc@hotmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Chris Haas @ 2000-09-21 16:01 UTC (permalink / raw)
To: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found
@ 2000-09-22 20:00 Chris Haas <haasjc@hotmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Chris Haas @ 2000-09-22 20:00 UTC (permalink / raw)
To: pgsql-interfaces
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-09-22 20:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-09-18 20:17 upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found Chris Haas <haasjc@hotmail.com>
2000-09-21 16:01 upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found Chris Haas <haasjc@hotmail.com>
2000-09-22 20:00 Re: upgrade pgaccess v0.96 to v0.98 fatal error: attribute querytables not found Chris Haas <haasjc@hotmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox