Re: [BUGS] JDBC Driver can't read UUID from database
On Tue, 5 Jun 2012, Dean Schulze wrote: > > I'm using Hibernate (3.6 and 4.0) with Postgresql 9.1. Our tables have > UUIDs in them and your driver is trying to convert UUIDs to longs: > This is a hibernate mapping problem, not a JDBC Driver problem. If you have a plain ResultSet and call getString() on a UUID field, it will certainly work. Mapping the UUID to BLOB or CLOB is incorrect. I'm not sure why your attempt to map it to a String didn't work, but you are not convincing Hibernate to use a plain getString call. Kris Jurka -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] version of postgreSQL
On Tue, Jun 5, 2012 at 10:21 AM, luigi pinna wrote: > Hello! > which version of postgreSQL is compatible with Window 7? > > for example 8.2, 8.4 or 9.1 > this question is certainly not a bug and should have been done on one of the users lists listed in http://archives.postgresql.org/ most probably pgsql-general o pgsql-novice. Please direct any new question that doesn't report a bug to one of those lists. Now, about your question: I can't be sure because i haven't used windows in a long time, but the buildfarm shows versions 9.0 and 9.1 passing all tests on windows 7 home premium... http://pgbuildfarm.org/cgi-bin/show_status.pl?member=chough&member=pitta -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #6676: checkpointer does not work by SIGINT.
katsumata.tomon...@po.ntts.co.jp writes: > Now I'm testing the behavior of checkpointer, > and I found a difference with PostgreSQL9.1 behavior. > When I send SIGINT signal to writer process on PostgreSQL9.1, > writer process starts checkpoint. > But, when I send SIGINT signal to checkpointer on PostgreSQL9.2beta2, > checkpointer doesn't start checkpoint. AFAICT, the checkpointer does consider starting a checkpoint, but it decides not to do one, because of this recent change: http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724 If you had done enough updates since the last checkpoint, it would do one. So this isn't a bug, but an intentional reduction in checkpoint frequency. (Note that sending SIGINT is not, and never has been, equivalent to forcing a checkpoint.) regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder
On Wed, Jun 6, 2012 at 8:04 PM, Basil Peace wrote: > In my case invalid argument (root directory instead of specified data > directory) was passed by installer to icacls. That's what I saw. It wasn't > problem of icacls, it was a problem in pgsql installer. That's supposed to happen. It sets the permissions on the data directory and then recurses back up to the root directory, ensuring the postgres account is able to read all the parent directories - otherwise, even if it has write permissions on the data directory itself, it cannot access it. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #6652: Installer grants postgres user rights for the whole disk, not specified subfolder
In my case invalid argument (root directory instead of specified data directory) was passed by installer to icacls. That's what I saw. It wasn't problem of icacls, it was a problem in pgsql installer. 05.06.2012, 22:38, "Dave Page" : > On Sun, May 20, 2012 at 7:05 PM, Alvaro Herrera > wrote: > >> Excerpts from grv87's message of sáb may 19 10:28:47 -0400 2012: >>> The following bug has been logged on the website: >>> >>> Bug reference: 6652 >>> Logged by: Basil Peace >>> Email address: gr...@yandex.ru >>> PostgreSQL version: 9.1.3 >>> Operating system: Windows 7 x64 >>> Description: >>> >>> I have been installing PostgreSQL 9.1.3.2, and I've noted that 'creating >>> database cluster' is too long. I have been waiting for a half of hour, and >>> it hasn't finished. >>> I've noted that installer calls icacls.exe with arguments: >>> D:\ /grant "postgres":RX >> This seems to be reported every once in a while. It looks like the >> one-clunk installer is to blame. Maybe it's been fixed in some more >> recent version -- Dave Page would probably know. > > Just as an FYI, we are working on this. We've been able to reproduce > it, and it appears that icacls (a Microsoft utility) will sometimes > look at the ACL of every file/directory recursively when it grants the > required privileges on higher level directories. The good news is that > in none of the test we've done has it ever modified the ACL on the > wrong thing - it just takes a long time if there are a lot of items on > the filesystem. We've looked at third party alternatives to icacls, > and they seem to exhibit similar traits. We're also going to look into > other ways around the root problem. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #6676: checkpointer does not work by SIGINT.
Hi, Thank you for explanation about it. I've understood that it is intended thing. Sorry to bother you. regards, (2012/06/07 2:05), Tom Lane wrote: > katsumata.tomon...@po.ntts.co.jp writes: >> Now I'm testing the behavior of checkpointer, >> and I found a difference with PostgreSQL9.1 behavior. >> When I send SIGINT signal to writer process on PostgreSQL9.1, >> writer process starts checkpoint. >> But, when I send SIGINT signal to checkpointer on PostgreSQL9.2beta2, >> checkpointer doesn't start checkpoint. > AFAICT, the checkpointer does consider starting a checkpoint, but it > decides not to do one, because of this recent change: > http://git.postgresql.org/gitweb/?p=postgresql.git&a=commitdiff&h=18fb9d8d21a28caddb72c7ffbdd7b96d52ff9724 > > If you had done enough updates since the last checkpoint, it would do > one. So this isn't a bug, but an intentional reduction in checkpoint > frequency. (Note that sending SIGINT is not, and never has been, > equivalent to forcing a checkpoint.) > > regards, tom lane > -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] BUG #6676: checkpointer does not work by SIGINT.
Tomonari Katsumata writes: > Thank you for explanation about it. > I've understood that it is intended thing. > Sorry to bother you. No, actually it's a good thing you brought it up, because we're now reconsidering whether that patch was a good idea or not ... http://archives.postgresql.org/pgsql-hackers/2012-06/msg00160.php regards, tom lane -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
