[PyKDE] Trouble with sql examples from Qt 3.x.
hpj at urpla.net
Thu May 27 13:22:01 BST 2004
On Thursday 27 May 2004 09:46, Denis Bitouzé wrote:
> I created testdb database for user 'bitouze' who is a
> postgresql super-user and is allowed to create databases:
> [bitouze at drums SQL]$ psql -U bitouze template1 -f testdb_pg.sql
I've grabbed this sql script from trolltechs SQL examples..
> psql:testdb_pg.sql:141: ERROR: invalid input syntax for type
> money: "$123,450.50" CONTEXT: COPY staff, line 1, column salary:
> "$123,450.50" setval
Well, obviously pg doesn't like the currency format.
Two options, first you can try:
LANG=C psql -U bitouze template1 -f testdb_pg.sql
If that fails also, remove the "$" and the thousand formatter ","
from all values. You may want to remove the incompleted test database
> when I try:
> python dbconnect.py
> I get the following error message when cliking on 'OK':
> Cannot open testdb database on localhost!
> QMYSQL3: Unable to connect
> Unknown database 'testdb'
Please edit dbpar.py to fit your needs, or create a local_dbpar.py in
that folder from dbpar.py.
Note the DB_DRIVER parameter (you need QPSQL7 for pg).
More information about the PyQt