From 2a7ab4d91683314b7ac2afc3851a628f5233f8da Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 27 Jan 2001 18:34:38 +0000 Subject: [PATCH] Update to pgaccess 0.98.7. --- src/bin/pgaccess/README | 5 +- src/bin/pgaccess/demo/formdemo.sql | 29 +- src/bin/pgaccess/doc/html/download.html | 25 +- src/bin/pgaccess/doc/html/main.html | 6 +- src/bin/pgaccess/doc/html/whatsnew.html | 18 ++ src/bin/pgaccess/lib/forms.tcl | 1 + src/bin/pgaccess/lib/help/create_database.hlp | 2 +- src/bin/pgaccess/lib/help/vacuum.hlp | 2 +- src/bin/pgaccess/lib/languages/czech | 2 +- src/bin/pgaccess/lib/languages/deutsch | 2 +- src/bin/pgaccess/lib/languages/francais | 284 +++++++++++------- src/bin/pgaccess/lib/languages/italiano | 2 +- src/bin/pgaccess/lib/languages/magyar | 2 +- src/bin/pgaccess/lib/languages/portugues | 2 +- src/bin/pgaccess/lib/languages/romana | 2 +- src/bin/pgaccess/lib/languages/russian.koi8r | 2 +- src/bin/pgaccess/lib/languages/russian_win | 2 +- src/bin/pgaccess/lib/languages/spanish | 2 +- src/bin/pgaccess/lib/mainlib.tcl | 2 +- src/bin/pgaccess/lib/preferences.tcl | 1 + src/bin/pgaccess/lib/schema.tcl | 123 ++++---- src/bin/pgaccess/lib/tables.tcl | 4 +- src/bin/pgaccess/pgaccess.sh | 2 +- 23 files changed, 299 insertions(+), 223 deletions(-) diff --git a/src/bin/pgaccess/README b/src/bin/pgaccess/README index 3771708a3d..818116ff44 100644 --- a/src/bin/pgaccess/README +++ b/src/bin/pgaccess/README @@ -22,7 +22,7 @@ PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS. --------------------------------------------------------------------------- -PGACCESS 0.98.4 29 January 2000 +PGACCESS 0.98.7 27 January 2001 ================================ 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 @@ -32,8 +32,7 @@ time far from them. 1. How to INSTALL ? -You will need a Tcl/Tk package, at least Tcl 7.6 and Tk 4.2, recommended -Tcl/Tk 8.x +You will need a Tcl/Tk package greater than 8.0 For Unix users, unpack the pgaccess-xxx.tar.gz archieve in you preferred directory (usually /usr/local). diff --git a/src/bin/pgaccess/demo/formdemo.sql b/src/bin/pgaccess/demo/formdemo.sql index c802abdc56..92a7d20be7 100644 --- a/src/bin/pgaccess/demo/formdemo.sql +++ b/src/bin/pgaccess/demo/formdemo.sql @@ -1,5 +1,5 @@ CREATE SEQUENCE "cities_id_seq" start 7 increment 1 maxvalue 2147483647 minvalue 1 cache 1 ; -SELECT nextval ('cities_id_seq'); +SELECT nextval ('"cities_id_seq"'); CREATE TABLE "pga_queries" ( "queryname" character varying(64), "querytype" character, @@ -7,41 +7,50 @@ CREATE TABLE "pga_queries" ( "querytables" text, "querylinks" text, "queryresults" text, - "querycomments" text); + "querycomments" text +); CREATE TABLE "pga_forms" ( "formname" character varying(64), - "formsource" text); + "formsource" text +); CREATE TABLE "pga_scripts" ( "scriptname" character varying(64), - "scriptsource" text); + "scriptsource" text +); CREATE TABLE "pga_reports" ( "reportname" character varying(64), "reportsource" text, "reportbody" text, "reportprocs" text, - "reportoptions" text); + "reportoptions" text +); CREATE TABLE "phonebook" ( "name" character varying(32), "phone_nr" character varying(16), "city" character varying(32), "company" bool, - "continent" character varying(16)); + "continent" character varying(16) +); CREATE TABLE "pga_layout" ( "tablename" character varying(64), "nrcols" int2, "colnames" text, - "colwidth" text); + "colwidth" text +); CREATE TABLE "pga_schema" ( "schemaname" character varying(64), "schematables" text, - "schemalinks" text); + "schemalinks" text +); REVOKE ALL on "pga_schema" from PUBLIC; GRANT ALL on "pga_schema" to PUBLIC; CREATE TABLE "cities" ( - "id" int4 DEFAULT nextval ( '"cities_id_seq"' ) NOT NULL, + "id" int4 DEFAULT nextval('cities_id_seq'::text) NOT NULL, "name" character varying(32) NOT NULL, - "prefix" character varying(16) NOT NULL); + "prefix" character varying(16) NOT NULL +); REVOKE ALL on "cities" from PUBLIC; +GRANT INSERT,SELECT,RULE on "cities" to "teo"; CREATE FUNCTION "getcityprefix" (int4 ) RETURNS varchar AS 'select prefix from cities where id = $1 ' LANGUAGE 'SQL'; COPY "pga_queries" FROM stdin; Query that can be saved as view S select * from phonebook where continent='usa' \N \N \N \N diff --git a/src/bin/pgaccess/doc/html/download.html b/src/bin/pgaccess/doc/html/download.html index adc8286f86..ba585dcf5c 100644 --- a/src/bin/pgaccess/doc/html/download.html +++ b/src/bin/pgaccess/doc/html/download.html @@ -10,30 +10,11 @@ Download
-
The primary site for PgAccess downloads is: +
The primary site for PgAccess download is: - -

Another one (just with a little bit faster, try this one first) would -be : -

diff --git a/src/bin/pgaccess/doc/html/main.html b/src/bin/pgaccess/doc/html/main.html index afb7a1fc1a..722b60e49e 100644 --- a/src/bin/pgaccess/doc/html/main.html +++ b/src/bin/pgaccess/doc/html/main.html @@ -14,7 +14,7 @@ PgAccess has been written by Constantin Teodorescu< using Visual Tcl, the best tool for developing Tcl/Tk applications I've ever seen.

Last version -
Last stable version is 0.98.5 , released on 30 March 2000. Read what's +
Last stable version is 0.98.7 , released on 27 January 2001. Read what's new .

Portability issues
PgAccess is available for every platform where PostgreSQL was ported @@ -27,9 +27,7 @@ on :
- HPUX
- Irix
- Windows 95,98,NT -

PgAccess needs Tcl/Tk versions 8.0.x and higher thought PgAccess. For -win32 platforms there are some special DLL's that have to be downloaded -and installed, more information here. +

PgAccess needs Tcl/Tk versions 8.0.x and higher. For win32 platforms there are some special DLL's that have to be downloaded and installed, more information here.

PgAccess is protected by the following copyright. diff --git a/src/bin/pgaccess/doc/html/whatsnew.html b/src/bin/pgaccess/doc/html/whatsnew.html index 187677f3ac..1da66e68ed 100644 --- a/src/bin/pgaccess/doc/html/whatsnew.html +++ b/src/bin/pgaccess/doc/html/whatsnew.html @@ -5,6 +5,24 @@ +27 January 2001 - PgAccess 0.98.7 +

+ +1 May 2000 - PgAccess 0.98.6 + 30 March 2000 - PgAccess 0.98.5