Hi there,
we are trying to get the Postgresql database
> going on
> knoppix linux.
> This is the error we get when we try to use the pgaccess GUI to create
> a
> table.The error is at the end of the process. Perhaps you may be able
> to guide
> us where we are going wrong when you look through the process.
>
> root(at)MA-1:~# cd /usr/local/
> root(at)MA-1:/usr/local# ls
> bin include lib man pgaccess pgsql sbin share src tcl
> root(at)MA-1:/usr/local# cd pgaccess
> root(at)MA-1:/usr/local/pgaccess# ls
> pgaccess-0.98.8.20030520 pgaccess-0.98.8.20030520.tar
> root(at)MA-1:/usr/local/pgaccess# cd pgaccess-0.98.8.20030520
> root(at)MA-1:/usr/local/pgaccess/pgaccess-0.98.8.20030520# ls
> Makefile changelog demo extra known_bugs osx pgmonitor
> win32
> README copyright doc images lib pgaccess.tcl todo
> root(at)MA-1:/usr/local/pgaccess/pgaccess-0.98.8.20030520# ./pgaccess.tcl
> Parsing the command line parameters:
> Couldn't find cmdline package elsewhere on your machine.
> Now trying to load the cmdline package from PgAccess.
> But first I need to load some default values to find it...
>
> Setting the default values:
> PgAcVar(currentdb,host):
> PgAcVar(query,links):
> CurrentDB:
> PgAcVar(query,tables):
> PgAcVar(mwcount): 0
> PgAcVar(PGACCESS_CONNLOAD): 0
> PgAcVar(PGACCESS_NOAUTO): 0
> PgAcVar(currentdb,pgport): 5432
> PgAcVar(PGACCESS_LOGIN): 0
> PgAcVar(opendb,host): localhost
> PgAcVar(opendb,dbname):
> PgAcVar(tablist): Tables Queries Views Sequences Functions
> Reports
> Graphs Forms Scripts Images Usergroups Diagrams
> PgAcVar(activetab):
> PgAcVar(opendb,username):
> PgAcVar(query,results):
> PgAcVar(PGACCESS_HIDDEN): 0
> PgAcVar(opendb,password):
> PgAcVar(opendb,pgport): 5432
> PgAcVar(PGACCESS_SMLOGIN): 0
> PgAcVar(PGACCESS_NOSCRIPT): 0
> PGACCESS_HOME: /usr/local/pgaccess/pgaccess-0.98.8.20030520/.
> PGLIB: /usr/lib
>
> cmdline: 1.1.1
> Got cmdline package supplied by PgAccess !
>
>
> Loading the enviroment variables:
>
> Loading the /root/.pgaccess/pgaccess.cfg config file:
>
> Setting the default values:
>
> Loading namespaces: mainlib stack syntax database debug tables queries
> visualqb forms views functions reports scripts usergroups sequences
> diagrams
> help preferences printer importexport connections graphs pgackages
> images
>
> Loading plugins: pgin-(NOT LOADED) pgmonitor
>
> Loading the required packages:
> tablelist: 2.7
> BWidget: 1.4.1
> icons: 1.0
> base64: 2.2
> csv: 0.3
> fileutil: 1.4
> tkwizard: 1.0
>
> Tcl error executing pg_exec create database trial
>
> is not a valid postgresql connection
Thanks in advance.
Yours faithfully,
Muramira Paul
Uganda Martyrs University
P.O.Box 5498, Kampala Uganda E.A.