Re: Psycopg Documentation

2009-03-29 Thread Albert Hopkins
On Sun, 2009-03-29 at 11:35 +0100, taliesin wrote: > Hi, > > I'm probably being very dense so apologies in advance, but I can't find > any decent documentation for the psycopg module for PostgreSQL interfacing. > > Google and Yahoo don't seem to return much for any of the queries I gave > them an

Re: Psycopg Documentation

2009-03-29 Thread taliesin
Diez B. Roggisch wrote: > taliesin schrieb: >> Hi, >> >> I'm probably being very dense so apologies in advance, but I can't find >> any decent documentation for the psycopg module for PostgreSQL >> interfacing. >> >> Google and Yahoo don't seem to return much for any of the queries I gave >> them a

Re: Psycopg Documentation

2009-03-29 Thread Diez B. Roggisch
taliesin schrieb: Hi, I'm probably being very dense so apologies in advance, but I can't find any decent documentation for the psycopg module for PostgreSQL interfacing. Google and Yahoo don't seem to return much for any of the queries I gave them and what's listed as the homepage for psycopg i

Re: psycopg

2007-12-12 Thread J. Clifford Dyer
On Wed, Dec 12, 2007 at 09:08:44AM -0500, Calvin Spealman wrote regarding Re: psycopg: > >Don't do that, for a number of reasons. String concatenation is really >never a good idea and formatting your own query strings is exactly what >leads to things like sql inje

Re: psycopg

2007-12-12 Thread Calvin Spealman
Don't do that, for a number of reasons. String concatenation is really never a good idea and formatting your own query strings is exactly what leads to things like sql injection. Let the db library handle it for you: cur.execute('insert into seq(id,sequence) values(3, %s)', (content,)) Not

Re: psycopg simplest problem

2005-07-08 Thread Gerhard Häring
Glauco wrote: > [...] > Gerhard thank you very much, this example explain me some idea, but > anyway don't resolve the core question. > In you example when dateVal is a None or textVal is none. > argument x must be DateTime, not None. > so i must manipulate for the empty string or None cases No,

Re: psycopg simplest problem

2005-07-08 Thread Glauco
Gerhard Haering wrote: > On Fri, Jul 08, 2005 at 04:23:50PM +0200, Glauco wrote: > >>[...] >>My problem is to do a middle layer over pycopg for eliminate type >>casting problem in postgres in all direction. >> >>i've resolved this doing a C extension in python and manipulating only >>string and

Re: psycopg simplest problem

2005-07-08 Thread Gerhard Haering
On Fri, Jul 08, 2005 at 04:23:50PM +0200, Glauco wrote: > [...] > My problem is to do a middle layer over pycopg for eliminate type > casting problem in postgres in all direction. > > i've resolved this doing a C extension in python and manipulating only > string and int in my application. > >

Re: psycopg authentication

2005-03-12 Thread [EMAIL PROTECTED]
Thanks for the reply. I figured it out, the problem was with my postgresql configuration. the following seemed to do the trick. localall md5 host all 0.0.0.0 0.0.0.0 md5 -- http://mail.python.org/mailman/listinfo/python-list

Re: psycopg authentication

2005-03-12 Thread [EMAIL PROTECTED]
I did, the pg_hba conf is a big tricky to me. I've tried the following things.. the commented out lines I also tried. #localall ident sameuser localall md5 host all 127.0.0.1 255

Re: psycopg authentication

2005-03-12 Thread Lee Harr
On 2005-03-12, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hello, I'm new to both PostgreSQL and psycopg and I'm trying to connect > to my database running on localhost. I have postgres setup to do md5 > authentication and this works when using a db admin tool on my local > network. For some rea

Re: Psycopg 1.1.17 compiled binaries for windows, postgre 8.0.0-beta4 and python 2.3

2004-12-09 Thread Max M
Eino Mäkitalo wrote: I had Visual C++ 6.0, so I compiled those libpq.dll and psycopg.pyd. if there are anyone to play with Windows, Python 2.3 and Postgre-8.0.0-beta4 for windows like me. You cat get those from: http://eino.net/html/python.html Original psycopg source code is available in: http://