RE: Re: pgdump

Have you used pgaccess on template1 database.  I assume that it creates
these tables in any db it sees.  After that 'create database' will make
these tables as you describe.

Remove them from template1 should fix this.

Ben 

> -----Original Message-----
> From: Andreas Tille [mailto:tillea@rki.de]
> Sent: 19 September 2000 09:18
> To: Michael Meskes
> Cc: PostgreSQL General
> Subject: [GENERAL] Re: pgdump
> 
> 
> On Tue, 19 Sep 2000, Michael Meskes wrote:
> 
> > pga_* are not really internal tables. The internal tables 
> are named pg_*.
> > pga_* are tables created by pgaccess.
> This is what I thought, but the following script:
> 
> #!/bin/sh
> echo "create database test ;" | psql
> pg_dump -n -c test
> 				    
> creates the output:
> 
> \connect - postgres
> DROP TABLE pga_queries;
> CREATE TABLE pga_queries (
> 	queryname character varying(64),
> 	querytype character,
> 	querycommand text,
> 	querytables text,
> 	querylinks text,
> 	queryresults text,
> 	querycomments text
> );
> REVOKE ALL on pga_queries from PUBLIC;
> GRANT ALL on pga_queries to PUBLIC;
> DROP TABLE pga_forms;
> CREATE TABLE pga_forms (
> 	formname character varying(64),
> 	formsource text
> );
> REVOKE ALL on pga_forms from PUBLIC;
> GRANT ALL on pga_forms to PUBLIC;
> DROP TABLE pga_scripts;
> CREATE TABLE pga_scripts (
> 	scriptname character varying(64),
> 	scriptsource text
> );
> REVOKE ALL on pga_scripts from PUBLIC;
> GRANT ALL on pga_scripts to PUBLIC;
> DROP TABLE pga_reports;
> CREATE TABLE pga_reports (
> 	reportname character varying(64),
> 	reportsource text,
> 	reportbody text,
> 	reportprocs text,
> 	reportoptions text
> );
> REVOKE ALL on pga_reports from PUBLIC;
> GRANT ALL on pga_reports to PUBLIC;
> DROP TABLE pga_schema;
> CREATE TABLE pga_schema (
> 	schemaname character varying(64),
> 	schematables text,
> 	schemalinks text
> );
> REVOKE ALL on pga_schema from PUBLIC;
> GRANT ALL on pga_schema to PUBLIC;
> DROP FUNCTION plpgsql_call_handler ();
> CREATE FUNCTION plpgsql_call_handler ( ) RETURNS opaque AS 
> '/usr/lib/postgresql/lib/plpgsql.so' LANGUAGE 'C';
> DROP PROCEDURAL LANGUAGE 'plpgsql';
> CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER 
> plpgsql_call_handler LANCOMPILER 'PL/pgSQL';
> COPY pga_queries FROM stdin;
> \.
> COPY pga_forms FROM stdin;
> \.
> COPY pga_scripts FROM stdin;
> \.
> COPY pga_reports FROM stdin;
> \.
> COPY pga_schema FROM stdin;
> \.
> 
> That's really annoying.
> 
> > > create it via "create database " those tables are created
> > > automatically.  Restoring the old content of the database using
> > 
> > What version are you using? On my 7.0.2 (actual Debian 
> package, so I guess
> > you are using the same) they are definitely not created 
> autiomatically.
> Hmm, yes I use also the Debian-Packages from woody.
> 
> ~> dpkg --status postgresql
> Package: postgresql
> Status: install ok installed
> Priority: optional
> Section: misc
> Installed-Size: 1932
> Maintainer: Oliver Elphick 
> Version: 7.0.2-4
> 
> Kind regards
> 
>         Andreas.
>