FAQ

Search Discussions

186 discussions - 916 posts

  • I am trying to work with PostgreSQL CTE to deal with a hierarchical question. I have a group who's members are people or other groups. Groups are identified by negative number and real people with a ...
    Clinton JamesClinton James
    Jan 8, 2013 at 10:47 pm
    Jan 9, 2013 at 3:02 am
  • Federico, are you going to merge the released 2.4.6 into master on the official repository? Or do you want to give me push permission on it? Or shall we move the official repos to ...
    Daniele VarrazzoDaniele Varrazzo
    Jan 8, 2013 at 2:48 pm
    Jan 8, 2013 at 2:48 pm
  • Hi, Following my last post on this psycopg/ZPsycoPGDA ticket <http://psycopg.lighthouseapp.com/projects/62710/tickets/142 I wille be pleased to contribute to ZPyscopgDA ...
    Gaël PegliascoGaël Pegliasco
    Jan 8, 2013 at 10:48 am
    Jan 8, 2013 at 3:15 pm
  • Hi, A couple of years ago, when I first studied the possibility of using a Python ORM for a project, I rapidly got the impression that they were (1) too heavy and complicated and (2) abstracting away ...
    Christian JauvinChristian Jauvin
    Dec 18, 2012 at 5:27 pm
    Dec 19, 2012 at 5:12 pm
  • Is there any timeline of when the date range and json support will make it into the devel branch? I'd love to start testing the date range features. Thanks, Mike -- Michael Robellard
    Robellard, MichaelRobellard, Michael
    Dec 13, 2012 at 7:07 pm
    Dec 13, 2012 at 7:58 pm
  • I'm happy to announce the release of Psycopg 2.4.6: a huge thank you to the many contributors. This is a bugfix release, introducing no new feature. There are several small corrections in different ...
    Daniele VarrazzoDaniele Varrazzo
    Dec 12, 2012 at 11:39 am
    Dec 12, 2012 at 11:39 am
  • Hello, I've created a ZPsycopgDA project on its own. it has got its own setup.py so it can be submitted to PyPI (it was actually already released on PyPI, but only thanks to somebody else ...
    Daniele VarrazzoDaniele Varrazzo
    Dec 11, 2012 at 1:33 am
    Dec 11, 2012 at 1:33 am
  • Hi, I noticed some (imho) odd behaviour while using composite data types. Empty strings will be returned as None instead of '' in Python. For example: sql CREATE TYPE testtype AS (id INT, label ...
    Christian von KietzellChristian von Kietzell
    Dec 3, 2012 at 12:15 pm
    Dec 4, 2012 at 8:28 am
  • Hi, When using executemany to do a bulk insert, psycopg2 generates an INSERT for each item in the given sequence of items. This is a lot slower than a single INSERT using Postgres multirow VALUES ...
    Idan KamaraIdan Kamara
    Nov 26, 2012 at 10:53 am
    Nov 26, 2012 at 12:15 pm
  • When I run the SQL directly from psycopg and from a plpgsql function each produces different results. One returns two columns and the other only returns one column. For example. def sql_test1(): cur ...
    Neil TiffinNeil Tiffin
    Nov 20, 2012 at 8:33 pm
    Nov 20, 2012 at 9:27 pm
  • 0

    hi

    I am a newer.
    Yuyan zhangYuyan zhang
    Oct 26, 2012 at 4:07 am
    Oct 26, 2012 at 4:07 am
  • I think we are gathering too many changes just for a 2.4.6 release. I think we should release only bugfixes in 2.4.6 and release all the good things in a 2.5 instead. As a test, I've forked master ...
    Daniele VarrazzoDaniele Varrazzo
    Oct 9, 2012 at 12:22 am
    Oct 9, 2012 at 11:05 am
  • Hello, Ticket #113 shows psycopg blocked because of an error during async communication with green threads ...
    Daniele VarrazzoDaniele Varrazzo
    Oct 6, 2012 at 12:10 pm
    Oct 6, 2012 at 12:10 pm
  • Hello: I am using psycopg2 and multiprocessing (and have been for quite some time). However, my application recently needed a connection to a new database. After adding this connection, I am ...
    Ryan KellyRyan Kelly
    Sep 28, 2012 at 7:01 pm
    Sep 28, 2012 at 11:33 pm
  • I think pretty much everything on the cursor is useful: you can also select from a prepared statement, so you need fetch*, description... I've played a little bit with the idea and made a cursor ...
    Daniele VarrazzoDaniele Varrazzo
    Sep 28, 2012 at 1:33 am
    Sep 28, 2012 at 10:58 am
  • Hi, I am looking for a mechanism (usable from Psycopg2) that allows me to call stored procedures while having a per-transaction state set. I have a connection pool serving web sessions, and I want to ...
    Tobias ObersteinTobias Oberstein
    Sep 26, 2012 at 4:56 pm
    Sep 27, 2012 at 8:22 am
  • I have implemented adaptation between Postgres range types and Python. Usage is documented at: <http://initd.org/psycopg/docs/extras.html#range-data-types There is a basic Range class, completely ...
    Daniele VarrazzoDaniele Varrazzo
    Sep 24, 2012 at 8:56 am
    Sep 24, 2012 at 5:54 pm
  • Hello, after a change in Python 3.3 memoryview, accessing memoryview items (i.e. what returned by default reading bytea fields in Python 3) returns ints instead of bytes. In order to make Py 3.3 ...
    Daniele VarrazzoDaniele Varrazzo
    Sep 21, 2012 at 12:08 am
    Sep 21, 2012 at 12:08 am
  • Hi, I'd like to implement a certain type adaption/casting scheme and struggle with the right approach. Maybe someone can give me a hint? Would be great and welcome! Context: I am _only_ concerned ...
    Tobias ObersteinTobias Oberstein
    Sep 20, 2012 at 9:50 pm
    Sep 22, 2012 at 6:57 pm
  • Hi, I am using range types in an application I am writing and am planning on writing some mapping to have support with built-in Python ranges, and some simple extensions for dealing with date ...
    Jonathan S. KatzJonathan S. Katz
    Sep 18, 2012 at 4:57 pm
    Sep 20, 2012 at 7:46 am
  • In a bug report open today [1] an user is reporting bad interaction between an old version of zope and old version of psycopg2. But what added is: """ I tried the newest version of psycopg2 and ...
    Daniele VarrazzoDaniele Varrazzo
    Sep 18, 2012 at 11:33 am
    Sep 18, 2012 at 11:33 am
  • Hi, I am adding a SQL to Python type caster for the new native JSON type in Postgres. This seems to work, but I wonder if it's really complete / done right and should maybe already built into ...
    Tobias ObersteinTobias Oberstein
    Sep 18, 2012 at 7:51 am
    Sep 19, 2012 at 11:42 pm
  • Hi, Are there any commercial license that is sold for psycopg driver. LGPL V3 seems very restrictive. Kindly let me know ASAP. Thanks, Vishnu
    Vishnu VVVishnu VV
    Sep 14, 2012 at 5:14 pm
    Sep 15, 2012 at 12:55 pm
  • Greetings list, I'm using psycopg2, python2.7.3 threading along with pgsql 9.1.5. I noticed that if I have my python process query against the database kind of frequently, say more than 1 query per ...
    David RoidDavid Roid
    Sep 14, 2012 at 4:45 pm
    Sep 18, 2012 at 1:59 am
  • Hi all, I'm trying to debug an issue I'm seeing in production, whereby traceback information about an exception is missing. This is incredibly frustrating as it makes it extremely difficult to track ...
    Oliver BeattieOliver Beattie
    Sep 6, 2012 at 3:09 pm
    Sep 7, 2012 at 10:05 am
  • Hi all, I have now repeated the operation enough time to be almost convinced to have isolated the point : I am running on Mac OS X Python 2.7 + PostgreSql 9 + virtualenv where I do later on a 'pip ...
    Matthieu RigalMatthieu Rigal
    Aug 24, 2012 at 12:16 pm
    Aug 24, 2012 at 12:16 pm
  • Hi I am trying to use the notify/listen features of postgres and psycopg2, however when using example code from the documents and running notify.py script in: /psycopg2-2.4.5/examples$ python ...
    Hassan, AydinHassan, Aydin
    Aug 22, 2012 at 9:11 am
    Aug 22, 2012 at 9:11 am
  • Hi, it is impossible to INSERT or UPDATE with ZSQL from external methods. The first statement after a INSERT/UPDATE ends with an ROLLBACK. Example: 2012-08-03 14:58:16.821 CEST ...
    Lutz SteinbornLutz Steinborn
    Aug 3, 2012 at 1:33 pm
    Sep 19, 2012 at 7:29 am
  • Hi I am trying to build and install psycopg2-2.4.5 source distribution on CentOS 5.8 VPS. Installation ends without errors, but on Python interpreter, import psycopg2 returns: Python 2.7.3 (default, ...
    Alan EtkinAlan Etkin
    Jul 26, 2012 at 10:22 pm
    Jul 30, 2012 at 11:53 am
  • Hey All, I'm getting inconsistent results when looking up the age of db entries. For items that were added only minutes ago, I get answers like 12 or 13 hours ago. In my troubleshooting attempts I ...
    Raheem SarcarRaheem Sarcar
    Jul 26, 2012 at 6:11 am
    Jul 26, 2012 at 10:16 am
  • Hi, for your information, I have resurrected that old idea, and tried to produce some working code here: https://github.com/xrg/psycopg/tree/execparams2 welcome = ANY([feedback]) -- Say NO to spam ...
    P. ChristeasP. Christeas
    Jul 20, 2012 at 4:45 pm
    Jul 21, 2012 at 11:34 am
  • Hi all. I was wondering if somenone can help me. I needed to do a cursor.execute of a function writen in sql. The function is: cursor.execute("""BEGIN IF (TG_OP = 'UPDATE') THEN select NEW.test ...
    Filipe BrandãoFilipe Brandão
    Jul 11, 2012 at 12:12 pm
    Jul 11, 2012 at 1:51 pm
  • Hi folks, To make it very simple, I want to save a dictionary to a database. I have a function that is reading various entries and returns a dictionary. But the content of this dictionary depends on ...
    Matthieu RigalMatthieu Rigal
    Jul 3, 2012 at 9:59 am
    Jul 4, 2012 at 9:11 am
  • Hi all Using Psycopg2 in a Centos 6 / Zope 2.10 / Postgres 9 setup but getting some strange behaviour after upgrading from Psycopg1/PG8. In a python script if I run two methods that interact with the ...
    Richard HarleyRichard Harley
    Jul 1, 2012 at 4:06 pm
    Jul 1, 2012 at 4:06 pm
  • PGRpdj5IaSB0aGVyZSE8L2Rpdj48ZGl2Ppo8L2Rpdj48ZGl2PkkndmUgZmFjZWQgd2l0aCBhIHZl cnkgc3RyYW5nZSBwcm9ibGVtIG9uIG15IExpbnV4LXNlcnZlciAoTGludXggW2hvc3RuYW1lXSAz ...
    Никитин КонстантинНикитин Константин
    Jun 29, 2012 at 6:03 am
    Jun 29, 2012 at 3:30 pm
  • From the docs: datetime.datetime(2010, 2, 8, 1, 40, 27, 425337) "SELECT '2010-02-08T01:40:27.425337', '2010-02-08', '01:40:27.425337';" Current (2.4.3) behavior: dt Out[28]: datetime.datetime(2012, ...
    Adrian KlaverAdrian Klaver
    Jun 27, 2012 at 11:20 pm
    Jul 3, 2012 at 1:26 am
  • Hi, I am developing some apps with pyramid and I am having performance problems. I really suspect that the issue is the fact that I am not using a persistent connection to the database, thus for each ...
    Ottavio CampanaOttavio Campana
    Jun 19, 2012 at 7:52 am
    Jun 19, 2012 at 11:24 am
  • I have some code that looks sort of like this:: cursor.execute(""" select user_email_address from my_user_table """) my_users = cursor.fetchall() and my_users is a list of one-element lists. Now I ...
    W. Matthew WilsonW. Matthew Wilson
    Jun 17, 2012 at 3:55 pm
    Jun 19, 2012 at 8:19 pm
  • Hello all, I have a written a script which does what I want it to do on a table with 999 records. I was wondering if there is anything I need to consider if I run this script on a table with 1.1 ...
    Bill HouseBill House
    Jun 17, 2012 at 3:32 pm
    Jun 19, 2012 at 2:24 am
  • Tox (http://tox.testrun.org/) is a nice tool for testing a package against multiple Python distributions. If you want to pull my 2 commits for adding support for this, fetch from the "tox" branch ...
    Marc AbramowitzMarc Abramowitz
    Jun 15, 2012 at 3:17 pm
    Jun 20, 2012 at 1:18 pm
  • This works just fine: cursor.execute("""select email_address from customer where email_address like '%matt%'""") But when I move the "matt" part out and use a %s symbol instead, I get this error ...
    W. Matthew WilsonW. Matthew Wilson
    May 28, 2012 at 10:00 pm
    May 31, 2012 at 4:26 am
  • Hello psycopg implements the connection.reset() method using the commands RESET ALL and SET SESSION AUTHORIZATION DEFAULT. Reading pgpool2 docs [1], I see that from PG 8.3 "DISCARD ALL" would be more ...
    Daniele VarrazzoDaniele Varrazzo
    May 17, 2012 at 3:06 pm
    May 18, 2012 at 1:18 pm
  • I am writing a small python script and I'd like to get the output I would get as if I executed the commands from psql. Let's make an example, suppose you have a small table such as create table ...
    Ottavio CampanaOttavio Campana
    May 16, 2012 at 7:04 am
    May 16, 2012 at 8:18 am
  • Hi! Thank for great library. Dear group users, please help me with understanding of situation. in psycopg2 extras.py in 2.4.4 was: 89 def __iter__(self): 90 if self._prefetch: 91 res = ...
    Kryklia AlexKryklia Alex
    May 15, 2012 at 4:59 pm
    May 16, 2012 at 1:36 pm
  • Hi there, I have used psycopg2's adapters and converters in the past with numeric[] arrays in PostgreSQL, and now I'm trying to use them with binary data types (bytea). I've outlined my problem in ...
    Andy CaseyAndy Casey
    May 10, 2012 at 8:27 am
    May 21, 2012 at 8:51 am
  • Hi! I was thinking of a connection object fetching dicts and reporting slow queries. However, the way the connections classes are implemented make me think its impossible to create ...
    Alexey LuchkoAlexey Luchko
    May 9, 2012 at 9:46 am
    May 9, 2012 at 10:23 am
  • Hi! lib/extras.py lines 123 and 128 refer to _cursor, but the class is inherited from DictCursorBase ...
    Alexey LuchkoAlexey Luchko
    May 8, 2012 at 2:23 pm
    May 8, 2012 at 3:08 pm
  • Hi all, I'm investigating some occasional slowness in our API servers, and I've hit upon some strange behavior that I can't explain. I'm hoping someone on this list can help. Stack is django 1.3.1, ...
    Russ NeufeldRuss Neufeld
    Apr 30, 2012 at 9:30 pm
    May 1, 2012 at 9:31 pm
  • Hello guys, I am using python 2.7 and psycopg2. How could I find out default charset used by database? I would like to check it and then according to used charset decode returned strings. I tried ...
    Peter IrbizonPeter Irbizon
    Apr 19, 2012 at 12:13 am
    Apr 19, 2012 at 12:30 am
  • Greetings all, newbie here. I'm trying to use the latest release of psycopg2 with Python3 and having no success so far. I'm on Mac OS X Lion (Xcode installed) and I have both 2.7 and 3.2.2 Python ...
    Leon StarrLeon Starr
    Mar 31, 2012 at 10:06 pm
    Apr 1, 2012 at 5:42 pm
Group Navigation
period‹ prev | Latest | first ›
Group Overview
grouppsycopg @
categoriespostgresql, python
discussions186
posts916
users142
websiteinitd.org...
irc#postgresql

Top users

Daniele Varrazzo: 269 posts Federico Di Gregorio: 64 posts Federico Di Gregorio: 64 posts Adrian Klaver: 36 posts Karsten Hilbert: 30 posts Marko Kreen: 24 posts Tobias Oberstein: 22 posts Israel Ben Guilherme Fonseca: 17 posts Jan Urbański: 16 posts W. Matthew Wilson: 14 posts AM: 12 posts Eric Snow: 10 posts Peter Irbizon: 9 posts P. Christeas: 9 posts Nicolas Grilly: 9 posts Joe Abbate: 8 posts Jason Erickson: 8 posts Maplabs: 7 posts Bill House: 7 posts Federico Di Gregorio: 6 posts
show more