http://blog.gmane.org/gmane.comp.python.db.pypgsql.user hourly 1 1901-01-01T00:00+00:00 http://gmane.org/img/gmane-25t.png http://gmane.org http://permalink.gmane.org/gmane.comp.python.db.pypgsql.user/561 <pre>Hello, It appears that pyPgSQL has been abandoned and Postgresql is starting to pass it by. I've worked up some changes to the quoting to allow it to use the new to 9.0 hex encoding for bytea fields. At the same time, I've changed the string and bytea quoting to use PQescapeStringConn and PQescapeByteaConn so that they properly quote the incoming items based on the connection settings. Code is at: https://github.com/wiredfool/PyPgSQL thanks eric ------------------------------------------------------------------------------ uberSVN's rich system and user administration capabilities and model configuration take the hassle out of deploying and managing Subversion and the tools developers use with it. Learn more about uberSVN and get a free download at: http://p.sf.net/sfu/wandisco-dev2dev </pre> Eric Soroos 2011-08-22T22:51:23 http://permalink.gmane.org/gmane.comp.python.db.pypgsql.user/560 <pre>My postgres server has at least 10 databases/users. I want to forbid table creation/access from users who aren't the owner of the database. I actually do know a way to set this by using the psql 'interface' and the phppgadmin, but I can't make it work with pypgsql!! What I do with psql is this: I log in with postgres user (the superuser), and use the '\c database-i-want-to-configure' command. When i'm connected to the database, I run the following commands: revoke create, usage on schema public from public; grant create, usage on schema public to user-from-connected-database; By doing this, no one can visualize/create/drop tables from any database, except if the database was set to the user, on the above grant command.. and that's what I want to do on pypgsql. What I've tried: On pypgsql I connect with the database I want to set the privileges, run the commands above, and it run well, but makes no change... And just to make sure i'm connected with the database, I used the select current_database() function and it returns the right db. Is there any other way to make this happen? Thanks, Matheus ------------------------------------------------------------------------------ Xperia(TM) PLAY It's a major breakthrough. An authentic gaming smartphone on the nation's most reliable network. And it wants your games. http://p.sf.net/sfu/verizon-sfdev_______________________________________________ Pypgsql-users mailing list Pypgsql-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/pypgsql-users </pre> Matheus Fernandes 2011-04-05T20:54:06 http://permalink.gmane.org/gmane.comp.python.db.pypgsql.user/559 <pre> ... UTC *is* +0000 ? Karsten </pre> Karsten Hilbert 2011-01-13T07:32:42 http://permalink.gmane.org/gmane.comp.python.db.pypgsql.user/558 <pre>Hi, I'm confused as to what's going on with a PostgreSQL "timestamp" type converted back to string. The field in question is a "timestamp without time zone". Selecting my timestamp from PostgreSQL via psql gives: 2011-01-12 21:54:11 Yet in my code, when I str() or mx.DateTime.ISO.strUTC() the mx.DateTime representation of the field returned by pyPgSQL, I get 2011-01-13 08:01:04.00 2011-01-13 08:54:11+0000 I'm currently in UTC+11 (10+summer) Any suggestions as to what might be happening here? When I first connect to PostgreSQL, I always SET TIME ZONE 'UTC'. cheers, -Kingsley PS&gt; Cross-posted to the Egenix mailing list ------------------------------------------------------------------------------ Protect Your Site and Customers from Malware Attacks Learn about various malware tactics and how to avoid them. Understand malware threats, the impact they can have on your business, and how you can protect your company and customers by using code signing. http://p.sf.net/sfu/oracle-sfdevnl_______________________________________________ Pypgsql-users mailing list Pypgsql-users-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f&lt; at &gt;public.gmane.org https://lists.sourceforge.net/lists/listinfo/pypgsql-users </pre> Kingsley Turner 2011-01-12T22:56:49 http://permalink.gmane.org/gmane.comp.python.db.pypgsql.user/557 <pre> El 04/09/10 23:47, QBox Linux Admin escribió: Ok, Finally I build pypgsql from tar. I installed various packages and reboot, I'm not sure what of them are really required: python-setuptools, python-tools, python-devel, postgresql-devel, postgresql-libs, postgresql-python. Thank You anyway, ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd </pre> QBox Linux Admin 2010-09-05T01:21:24 http://permalink.gmane.org/gmane.comp.python.db.pypgsql.user/556 <pre> Hi, I'm trying to install pypgsql into a Centos 5 distribution. I don't see pypgsql package. I have downloaded RedHat .rpm package but itd don't install. Also I tried downloading .tar.gz and build it. But I get some errors: in libpqmodule.c:74:20: error: Python.h: File or Directory doesn't exist. (also same error with structmember.h and fileobject.h) Other errors are: pgboolean.h:44: error: expected specifier-qualifier-list before 'PyObject_HEAD' pgboolean.h:48: error: expected '=' , ',' , ';' ... Is there an easy way to install an rpm package for Centos 5? do you have an idea of the necesary paths or mising installation files for build the .tar.gz ? Thank you, S.R.Parda ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd </pre> QBox Linux Admin 2010-09-04T21:47:08 http://permalink.gmane.org/gmane.comp.python.db.pypgsql.user/555 <pre>Am 18.06.2010 18:23, schrieb Dietmar Schwertberger: Hi Dietmar, hmm, that's sad! Thanks, but I'm working with linux. Tested now pypgsql-2.5 with python-2.6 on openSUSE 11.2 and it seems to work! Regards, Ivan ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo </pre> Ivan De Masi 2010-06-21T12:14:18 http://permalink.gmane.org/gmane.comp.python.db.pypgsql.user/554 <pre>Ivan De Masi schrieb: Almost... I'm still using pypgsql. If you want to have a binary for win32, I can email it it to you. Regards, Dietmar ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo </pre> Dietmar Schwertberger 2010-06-18T16:23:59 http://permalink.gmane.org/gmane.comp.python.db.pypgsql.user/553 <pre>Hi, is the project dead? It would be a pity! Still no pypgsql for python 2.6 available... Regards, Ivan ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo </pre> Ivan De Masi 2010-06-18T07:21:48 Search the mailing list at Gmane query http://search.gmane.org/?group=$group=gmane.comp.python.db.pypgsql.user