---------------------------------------------------------------------------

PGACCESS 0.98 29August 1999

PGACCESS 0.98.4 29January 2000

================================

I dedicate this program to my little daughters Ana-Maria and Emilia and to my

wife for their understanding. I hope they will forgive me for spending so many

REVOKE ALLon"pga_schema"from PUBLIC;

GRANT ALLon"pga_schema" to PUBLIC;

CREATETABLE "cities" (

"id" int4 DEFAULT nextval('"cities_id_seq"')NOT NULL,

"id" int4 DEFAULT nextval ('"cities_id_seq"')NOT NULL,

"name"character varying(32)NOT NULL,

"prefix"character varying(16)NOT NULL);

REVOKE ALLon"cities"from PUBLIC;

GRANTUPDATE,DELETE,SELECT,RULEon"cities" to"fane";

GRANT ALLon"cities" to"liviu";

CREATEFUNCTION "getcityprefix" (int4 ) RETURNSvarcharAS'select prefix from cities where id = $1' LANGUAGE'SQL';

COPY"pga_queries"FROM stdin;

Query that can be savedas viewSselect*from phonebookwhere continent='usa' \N\N\N\N

<ul><ahref="ftp://ftp.flex.ro/pub/pgaccess">ftp://ftp.flex.ro/pub/pgaccess</a>

<ahref="ftp://ftp.flex.ro/pub/pgaccess/pgaccess-0.98.tar.gz">Unix tar.gz

<ahref="ftp://ftp.flex.ro/pub/pgaccess/pgaccess-0.98.5.tar.gz">Unix tar.gz

file</a></li>

<ahref="ftp://ftp.flex.ro/pub/pgaccess/pgaccess-0.98.zip">Windows .zip

<ahref="ftp://ftp.flex.ro/pub/pgaccess/pgaccess-0.98.5.zip">Windows .zip

file</a></li>

<ul><ahref="ftp://speedy.flex.ro/pub/pgaccess">ftp://speedy.flex.ro/pub/pgaccess</a>

<ahref="ftp://speedy.flex.ro/pub/pgaccess/pgaccess-0.98.tar.gz">Unix tar.gz

<ahref="ftp://speedy.flex.ro/pub/pgaccess/pgaccess-0.98.5.tar.gz">Unix tar.gz

file</a></li>

<ahref="ftp://speedy.flex.ro/pub/pgaccess/pgaccess-0.98.zip">Windows .zip

<ahref="ftp://speedy.flex.ro/pub/pgaccess/pgaccess-0.98.5.zip">Windows .zip

file</a></li>

<metahttp-equiv="Content-Type"content="text/html; charset=iso-8859-1">

<metaname="GENERATOR"content="Mozilla/4.61 [en] (X11; I; Linux 2.2.12 i586) [Netscape]">

<metaname="GENERATOR"content="Mozilla/4.7 [en] (X11; I; Linux 2.2.12-20 i586) [Netscape]">

<bodybgcolor="#FEFEDF">

name "namespace" while executing "namespace eval Mainlib</tt>&nbsp; ..."</b>

<blockquote>That means 100% that you have an older version of Tcl/Tk that

don't recognize namespaces command. Please upgrade to Tcl/Tk 8.0.x minimum</blockquote>

<b>9. When saving big forms with a lot of widgets and code inside, a big

error message appears, PgAccess crashes, cannot recover old form, pga_forms

table appears to be corrupted.</b>

<blockquote>Your form source is exceeding 8000 bytes. A PostgreSQL record

cannot hold more than 8 Kb and pga_forms table is corrupted. Sorry for

your work :-( , your old form cannot be recovered anymore if you don't

have a backup (dumped) database. Upgrade to PgAccess 0.98.3 that will prevent

saving of those big forms. In order to make your form sources smaller,

define some scripts for your form initialize routines or for other big

portions of code and call them from the form code with the command<tt>Scripts::execute

"Your space saving code script name"</tt></blockquote>

<p><br><b>10. I have a dual boot machine with Linux and Windows 9x installed.

PgAccess works fine from Linux but when trying to connect under Windows

it says something about wrong access rights to the same database. Tcl/Tk

version and PostgreSQL server version matches libpgtcl and libpq DLL's.</b>

<blockquote>Check your Windows TCP/IP configuration. If you configured

the Windows TCP/IP machine address to by dynamic allocated by the server

then it got another IP address, different from Linux. If you have host

based authentication then you have no rights for the database. Change the

Windows TCP/IP configuration and set up manually the same TCP/IP address

as from Linux installation or change the pg_hba.conf configuration file

from the server to allow access to the database from the whole domain not

from a single IP address.</blockquote>

<br>&nbsp;

<br>&nbsp;

<br>&nbsp;

<br>&nbsp;

<metahttp-equiv="Content-Type"content="text/html; charset=iso-8859-1">

<metaname="GENERATOR"content="Mozilla/4.61 [en] (X11; I; Linux 2.2.12 i586) [Netscape]">

<metaname="GENERATOR"content="Mozilla/4.72 [en] (X11; I; Linux 2.2.14 i586) [Netscape]">

<bodybgcolor="#FEFEDF">

using Visual Tcl, the best tool for developing Tcl/Tk applications I've

ever seen.

<p><b>Last version</b>

<br>Last stable version is 0.98 , released on29 August 1999. Read<ahref="whatsnew.html">what's

new</a>in 0.98.

<br>Last stable version is 0.98.5 , released on30 March 2000. Read<ahref="whatsnew.html">what's

new</a> .

<p><b>Portability issues</b>

<br>PgAccess is available for every platform where PostgreSQL was ported

and where a Tcl/Tk package is available. PgAccess has been reported running

on :

<br>- Linux

<br>- FreeBSD

<br>- NetBSD

<br>- Solaris

<br>- HPUX

<br>- Irix

<metahttp-equiv="Content-Type"content="text/html; charset=iso-8859-1">

<metaname="GENERATOR"content="Mozilla/4.61 [en] (X11; I; Linux 2.2.11 i586) [Netscape]">

<metaname="GENERATOR"content="Mozilla/4.72 [en] (X11; I; Linux 2.2.14 i586) [Netscape]">

<bodybgcolor="#FEFEDF">

<b>30 March 2000 - PgAccess 0.98.5</b>

added the "new database" feature</li>

added the czech and spanish message file</li>

<b>29 January 2000 - PgAccess 0.98.4</b>

fixed a problem granting or revoking rights from PUBLIC</li>

added the portuguese message file translation</li>

fixed the preferences window problems for big screens 1280x1024</li>

<b>17 January 2000 - PgAccess 0.98.3</b>

prevent saving of big forms that source size has more than 8000 bytes so

pga_forms table does not crash anymore, read<ahref="faq.html">FAQ</a>

how to make your form sources smaller</li>

other very small bug fixes (less important)</li>

some windows can resize now up to 1280x1024 on big screens</li>

deutsh, russian and magyar message file available</li>

FAQ updates</li>

<b>29 August 1999</b> - PgAccess 0.98 has been released!

}

lappend info [list$PgAcVar(fdobj,$i,class)$PgAcVar(fdobj,$i,name)$PgAcVar(fdobj,$i,coord)$PgAcVar(fdobj,$i,command)$PgAcVar(fdobj,$i,label)$PgAcVar(fdobj,$i,variable)$PgAcVar(fdobj,$i,value)$PgAcVar(fdobj,$i,relief)$PgAcVar(fdobj,$i,fcolor)$PgAcVar(fdobj,$i,bcolor)$PgAcVar(fdobj,$i,borderwidth)$wfont]

}

if {[string length$info]>8000} {

tk_messageBox -title [intlmsg Error] -message [intlmsg"Form too big!\nSource size[string length$info] bytes\nCannot save !"]

return 0

}

sql_exec noquiet"delete from pga_forms where formname='$PgAcVar(fdvar,formtitle)'"

regsub -all"'"$info "''" info

sql_exec noquiet"insert into pga_forms values ('$PgAcVar(fdvar,formtitle)','$info')"

showError [intlmsg"You must supply the function language!"]

}else {

set funcbody [.pgaw:Function.fs.text1 get 1.0 end]

regsub -all"\n"$funcbody " " funcbody

regsub -all{'}$funcbody {''} funcbody

if {$PgAcVar(function,nametodrop) !=""} {

if {! [sql_exec noquiet"drop function$PgAcVar(function,nametodrop)"]} {

set x [expr {($sw - 640)/2}]

set y [expr {($sh - 480)/2}]

wm geometry$base 640x480+$x+$y

wm maxsize$base1009 738

wm maxsize$base1280 1024

wm minsize$base 1 1

wm overrideredirect$base 0

wm resizable$base 1 1

We recommend that active production databases be cleaned nightly, in order to keep statistics relatively current. The VACUUM query may be executed at any time, however. In particular, after copying a large class into Postgres or after deleting a large number of records, it may be a good idea to issue a VACUUM query. This will update the system catalogs with the results of all recent changes, and allow the Postgres query optimizer to make better choices in planning user queries.

If the server crashes during a VACUUM command, chances are it will leave a lock file hanging around. Attempts to re-run the VACUUM command result in an error message about the creation of a lock file. If you are sure VACUUM is not running, remove the pg_vlock file in your database directory (i.e. PGDATA/base/dbname/pg_vlock).

" {} "Synopsis" {bold} "

VACUUM \[ VERBOSE \] \[ ANALYZE \] \[ table \]

VACUUM \[ VERBOSE \] ANALYZE \[ table \[ (column \[, ...\] ) \] \]