Re: [BUGS] BUG #7575: "between" does not work properly with inet/cidr addresses

2012-10-12 Thread Dimitri Fontaine
Mr Dash Four writes: > That isn't possible in my case, because on the right side I have IP ranges > (from-to) and currently there isn't a PostgreSQL function which converts IP > ranges to cidr/inet, but even if there was such function available, this may > produce more than one cidr/inet ranges, s

Re: [BUGS] BUG #7575: "between" does not work properly with inet/cidr addresses

2012-10-12 Thread Mr Dash Four
Have you tried using the ip4r extension yet? First time I am seeing this - well done, exactly what I needed. That doesn't address the above bug though - the "between" functionality is still wrong and needs to be corrected. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)

[BUGS] BUG #7601: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-12 Thread devenmthaker
The following bug has been logged on the website: Bug reference: 7601 Logged by: Deven Email address: devenmtha...@gmail.com PostgreSQL version: 9.0.3 Operating system: Windows 2008 R2 WITH SP1 (64 BITS) Description: We are installing our application which internally

Re: [BUGS] BUG #7601: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-12 Thread Ashesh Vashi
Can you please share the log file, found under temp directory? -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi* On Fri, Oct 12, 2012 at 7:23 PM,

Re: [BUGS] BUG #7601: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-12 Thread Dave Page
Hang on... please see if you can reproduce with 9.0.10 first. There have been numerous fixes to the permissions code in those 7 releases since 9.0.3. On Fri, Oct 12, 2012 at 2:55 PM, Ashesh Vashi wrote: > Can you please share the log file, found under temp directory? > > -- > > Thanks & Regards,

Re: [BUGS] BUG #7601: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-12 Thread Deven Thaker
Hi Dave,Ashesh Thanks for your prompt response. Since Dave suggested to upgrade version from 9.0.3 to 9.0.10. We will do that. One question is, it was very difficult for us to reproduce an issue even in 9.0.3, after upgrading to 9.0.10 i am not sure whether i will be able to reproduce an issue. B

Re: [BUGS] BUG #7601: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-12 Thread Deven Thaker
Hi, Since i am planning to move to 9.0.10. Can someone provide the change log where it is mentioned that this issue is addressed. I went to all feature details of each releases from 9.0.3 to 9.0.10 but i did not find any details which states improvement with respect to fixing an issue with permiss

Re: [BUGS] BUG #7601: Installation of PostGresql at c:\Progam files folder does not create right permission on data folder

2012-10-12 Thread Dave Page
http://git.postgresql.org/gitweb/?p=edb-installers.git;a=log;h=refs/heads/REL-9_0 On Fri, Oct 12, 2012 at 3:16 PM, Deven Thaker wrote: > Hi, > > Since i am planning to move to 9.0.10. Can someone provide the change log > where it is mentioned that this issue is addressed. > I went to all feature

[BUGS] Sorry to bother you. Please tell me exactly how the compiler was built ODBC

2012-10-12 Thread Копыченко Павел
Sorry to bother you. Please tell me exactly how the compiler was built ODBC driver psqlodbc-09.01.0200 architecture for Windows 64? What exact version of the compiler? please -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgres

[BUGS] BUG #7600: Database crash with data corruption

2012-10-12 Thread hankiewicz
The following bug has been logged on the website: Bug reference: 7600 Logged by: Database crash with data corruption Email address: hankiew...@gmail.com PostgreSQL version: 9.2.1 Operating system: Linux Description: We experienced database crash. Our configuration: S

Re: [BUGS] BUG #7600: Database crash with data corruption

2012-10-12 Thread Tom Lane
hankiew...@gmail.com writes: > The list of steps to reproduce bug: > 1) Create two database on single server instance (production and sandbox) > 2) On production perform normal operations (we use Trac with over 50 active > users) > 3) on the sandbox database start explain plan of query > 4) while e

Re: [BUGS] BUG #7598: Loss of view performance after dump/restore of the view definition

2012-10-12 Thread Tom Lane
vaclav.j...@xitee.com writes: > when a view (with the below properites) is dump and restored (no matter if > using pg_dump, copied from pg_admin or using pg_views) it's performance is > worse than before. The view was using tables with columns of type "character > varying(xx)" and the dump inserts