Activity (RSS)

Have another test: I suspect if _psycopg.so is in the same directory of the executable you don't even need the sys.path hack, but I may be wrong.

Unfortunatel...

Hi Christian,

I consider the refactoring I've made to _psycopg.so generally useful and I've tested it more yesterday. If there is no surprise from the test grid...

Daniele, thanks.

Your code sys.path Manipulation works with the version from

cd /scratch
git clone https://github.com/dvarazzo/psycopg -b freeze
cd psycopg
pyth...

Christian, I've taken a look at your problem.

Freeze cannot freeze psycopg just because it cannot work with C extension. This should be enough to rule out what ...

Christian, I've taken a look at your problem.

Freeze cannot freeze psycopg just because it cannot work with C extension. This should be enough to rule out what ...

In this case you should create your data as a specific python type, it cannot be a generic tuple, and register a typecaster for it. For instance:

Comp = namedt...

No, I want autocast, because I use sqlalchemy and I work througth sqlalchemy interface.

Try adding an explicit cast after your placeholder specifying that the type you are passing is an array of test_comp_type. This should work:

cur.execute("INSER...

Submitted by: Nikita Kuznetsov

import psycopg2
import psycopg2.extras


conn = psycopg2.connect("dbname=test user=y")
cur = conn.cursor()
cur.execute("DROP TAB...

Submitted by: Nikita Kuznetsov

import psycopg2
import psycopg2.extras


conn = psycopg2.connect("dbname=test user=y")
cur = conn.cursor()
cur.execute("DROP TAB...

Please explain better.

Submitted by: rcorzogutierrez

We can install via Wheels

https://github.com/psycopg/psycopg2/pull/7

See https://github.com/psycopg/psycopg2/pull/7

This is not a bug. If you are a beginner and learning how the library works please use the mailing list.

Transaction isn't rolling back in case of error. Please check the file attached.

how to reprocude error:

run the tornado instance;
access localhost:8080/signup/...

Fixed in psycopg 2.5.4. The class init now attempts a conversion to int.

Implemented into my github branch, waiting a few days before pushing to official repo.

Thank you for the report: yes, jsonb is to be supported. It is enough to register the already existing adapter to the new oids.

More info in this ML message.

Thank you for the report: yes, jsonb is to be supported. It is enough to register the already existing adapter to the new oids.

More info in this ML message.

Submitted by: Comte

hi,
not sure you're not aware of that, if not here is a strange behaviour with jsonb.
http://stackoverflow.com/questions/25263736/jsonb-wit...

Reducing to empty is not the only normalization rule Postgres uses. PG for instance normalizes [10,20] to [10,21).

Psycopg doesn't apply the rules PG uses becau...

Reducing to empty is not the only normalization rule Postgres uses. PG for instance normalizes [10,20] to [10,21).

Psycopg doesn't apply the rules PG uses becau...

Reducing to empty is not the only normalization rule Postgres uses. PG for instance normalizes [10,20] to [10,21).

Psycopg doesn't apply the rules PG uses becau...

When using a NumericRange, such as [16,16), this should as the postgres documentation says, normalise to empty.

It should also report as isempty in psycopg2.

It...

You can attach gcc to the stuck process

sorry, "gdb"

You can attach gcc to the stuck process, or kill it generating a core.

You can also try to make the process responsive again (killable at python level) switchin...

With aws. How do I get the c stack trace? I have a strace of the issue.

With AWS or with regular Postgres?

You may be bumping in some quirkiness of AWS pooling or throttling that the libpq is not prepared to handle. Getting a C stac...

Daniele-
Why would the process still hang with a connect_timeout set? The process definitely hangs!

Thanks!

Ticket #112 you reference is about queries, not about connections.

The driver is not referencing a deallocated object: it destroyed one and allocated a new one ...

I am not sure how you can claim the server is causing this error. The process hangs infinitely. I have since implemented connection pooling which seems to help,...

For what I can see here it's the server not completing the connection. I tend to blame the AWS servers, not the client side.

If you want to perform operation "s...

A way to make the query interruptable is to work in green mode with a wait callback that can tolerate being broken by ctrl-c:

from select import select
from ps...

A way to make the query interruptable is to work in green mode with a wait callback that can tolerate being broken by ctrl-c:

from select import select
from ps...

Please install python-dev package (and libpq-dev too).

Submitted by: jonathan

creating build/temp.linux-x86_64-2.7

creating build/temp.linux-x86_64-2.7/psycopg

x86_64-linux-gnu-gcc -pthread -fno-strict-aliasing -DND...

[4420] pint_setup: init pint object at 0x7f31c51558b8, refcnt = 1
[4420] pint_setup: good pint object at 0x7f31c51558b8, refcnt = 1
[4420] microprotocol_getquo...

[4420] pint_setup: init pint object at 0x7f31c51558b8, refcnt = 1
[4420] pint_setup: good pint object at 0x7f31c51558b8, refcnt = 1
[4420] microprotocol_getquo...

Reposting the code for formatting

  def _execute(self, query, params=None, fetch=False):
    self.logger.debug("starting _execute...")
    with psycopg2.connec...

Submitted by: Brad

I am using:
Python 3.4.1
psycopg 2.5.3

I have an issue where I am making a lot of updates super fast (100ish per second) on a single thread. ...

You are observing PostgreSQL's behaviours, not psycopg.

piro=> select '[1,10]'::int4range;
 int4range 
-----------
 [1,11)
(1 row)

Check the docs about the c...

Submitted by: Brian Findlay

'[1,10]' coerced to '[1,11)'

See tests at https://gist.github.com/bfin/a6e0cce630f38d85c090

Hello,

yes, I know the issue. No, it's not fixed in the master and I don't know how to fix it; actually I don't think it's generally fixable in psycopg: you may...

Submitted by: TimRex

I seem to have a problem running psycopg2 version 2.4.5-1 (debian stable) against Python 3 v3.2.3-6

I'm unable to signal any python process...

Submitted by: bhazuka@usgs.gov

While working with connection pools the AbstractConnectionPool(minconn, maxconn, args, **kwargs), SimpleConnectionPool(minconn, m...

Fixed: the segfault was caused by a missing check in a path normally not used, triggered executing a COPY statement via execute().