[clisp-list] Re: connect to database postgresql

[Sam S. <sd...@gn...>]

> * Kania Potter <xnavn_cbggre@lnubb.pbz> [2005-09-01 02:20:29 -0700]:
>
> [4]> (load (compile-file "/root/LISP/sample1.lisp"))
>
> Compiling file /root/LISP/sample1.lisp ...
> WARNING in (WITH-PG-CONNECTION (CONN "table" "kania"
> ...) (WITH-PG-TRANSACTION CONN # ...))-2 in lines
> 8..14 :
> CONN is neither declared nor bound,
> it will be treated as if it were declared SPECIAL.

this means that WITH-PG-CONNECTION you are used hear is not defined,
i.e., it is not PG:WITH-PG-CONNECTION but CL-USER::WITH-PG-CONNECTION.

> The following functions were used but not defined:
>  WITH-PG-CONNECTION CONN WITH-PG-TRANSACTION PG-TABLES
> PG-EXEC
> The following special variables were not defined:
>  CONN
> 0 errors, 4 warnings

yep, I was right.

> ;; Loading file /root/LISP/sample1.fas ...
> ** - Continuable Error
> 4 name conflicts while executing USE-PACKAGE of
> (#<PACKAGE POSTGRESQL>) into package #<PACKAGE
> COMMON-LISP-USER>.

too late. you must USE-PACKAGE _before_ using it!

> If you continue (by typing 'continue'): You may choose
> for every conflict in favour of which symbol to
> resolve it.
> Break 1 [5]>

you need to make sure that sample1.lisp has (use-package "PG") _before_
the first use of a PG macro.

> Where Iam wrong???

you are asking the wrong list.
please talk to the pg-sql maintainer.

-- 
Sam Steingold (http://www.podval.org/~sds) running w2k
<http://www.jihadwatch.org/> <http://www.mideasttruth.com/>
<http://truepeace.org> <http://ffii.org/> <http://pmw.org.il/>
I just forgot my whole philosophy of life!!!