From: Sam S. <sd...@gn...> - 2008-05-11 17:11:03
|
> * Reini Urban <eh...@k-...> [2008-05-11 11:39:19 +0200]: > > > Form: (SQL:with-sql-connection (CONN :NAME "template1" :LOG > *STANDARD-OUTPUT*) (SQL:PQtrace CONN *TRACE*) (SQL:sql-transaction > CONN "BEGIN" SQL:PGRES_COMMAND_OK) (SQL:sql-transaction CONN "DECLARE > mycursor CURSOR FOR select * from pg_database" SQL:PGRES_COMMAND_OK) > (SQL:with-sql-transaction (RES CONN "FETCH ALL in mycursor" > SQL:PGRES_TUPLES_OK) (LET* ((NFIELDS (SQL:PQnfields RES)) (NTUPLES > (SQL:PQntuples RES)) (NAMES (MAKE-ARRAY NFIELDS))) (FORMAT T " + ~D > field~:P; ~D ntuple~:P~%" NFIELDS NTUPLES) (DOTIMES (II NFIELDS) > (FORMAT T "~3:D: ~S~%" II (SETF (AREF NAMES II) (SQL:PQfname RES > II)))) (DOTIMES (II NTUPLES) (FORMAT T "~%<<~D>>~%" II) (DOTIMES (JJ > NFIELDS (TERPRI)) (FORMAT T "~3:D ~15@S = ~S~%" JJ (AREF NAMES JJ) > (SQL:PQgetvalue RES II JJ)))))) (SQL:sql-transaction CONN "CLOSE > mycursor" SQL:PGRES_COMMAND_OK) (SQL:sql-transaction CONN "COMMIT" > SQL:PGRES_COMMAND_OK) (SQL:PQuntrace CONN) NIL) > CORRECT: NIL > CLISP : ERROR > FFI::FOREIGN-CALL-OUT: #<FOREIGN-POINTER #x00AB4DEC> cannot be > converted to the foreign type FFI:C-POINTER this sucks. I wish I could test postgresql myself - alas, I get [SQL-ERROR]: [CONNECTION] SQL:sql-connect(NIL,NIL,NIL,NIL,"template1","postgres","postgres"): "FATAL: Ident authentication failed for user \"postgres\" " any ideas? -- Sam Steingold (http://sds.podval.org/) on Fedora release 8 (Werewolf) http://dhimmi.com http://memri.org http://mideasttruth.com http://openvotingconsortium.org http://pmw.org.il http://honestreporting.com Failure is not an option. It comes bundled with your Microsoft product. |