[GENERAL] wriring a file to a database

2007-12-08 Thread Roger Mason
Hello, I want to write a file into a database from python using psycopg. I have tried several ways to insert the file, each gives a different error. File "write_images_to_db.py", line 43, in insert curs.execute("INSERT INTO diamonds VALUES (%s, lo_import %s)",(iname, image)) psycopg2.P

[GENERAL] can't compile Pl/Java

2007-10-23 Thread Roger Mason
27; before 'pljavaEntryFence' Then follow many other errors. The first error (not finding postgres.h) is puzzling because gcc is looking in the right place: /usr/include/postgresql/server/postgres.h Thanks for any help, Roger Mason ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] psycopg problem

2006-08-10 Thread Roger Mason
Volkan YAZICI <[EMAIL PROTECTED]> writes: > On Aug 10 07:57, Roger Mason wrote: >> run = "S90040" >> curs.execute("create table %s (date text, tset text)",(run,)) > > Please see this[1] and this[2]. > > [1] http://archives.postgre

[GENERAL] psycopg problem

2006-08-10 Thread Roger Mason
g is messed up. Could someone please tell me what I'm doing wrong? Thanks, Roger Mason ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings