Hello, I've been using pygresql and it's been working great. Recently I
hit a snag. As part of my project I have to find out what the server's
time is every once in a while. I use "SELECT now()" for this. The
problem is that unless another completely different connection comes in
and changes the database the result (database time) will not change. The
same happens for SELECT CURRENT_TIMESTAMP as well. If i do this
connected to the same database with psql it works properly (gives the
actual time). I've also tried getting a new cursor every time i fetch
the date. If does not change anything. Here are the (what i think)
relevant versions of libraries/server I'm using.
The server: PostgreSQL 8.1.11 on x86_64-redhat-linux-gnu, compiled by
GCC gcc (GCC) 4.1.2 20070626 (Red Hat 4.1.2-14)
The client libraries: 8.2.14 (on gentoo)
The pygresql module: 4.0 (on gentoo)
If this where a bug I would be willing do cooperate in fixing it. Just
don't know where to start, or if it's even a bug at all. Could not find
anything in google so if anybody has some insight into this any advice
is welcome.
Thanks,
Julio
_______________________________________________
PyGreSQL mailing list
[email protected]
http://mailman.vex.net/mailman/listinfo/pygresql
