Re: [BUGS] BUG #2993: The program "postgres" is needed by initdb but was not found ...

2007-02-14 Thread Magnus Hagander
On Mon, Feb 12, 2007 at 09:08:11PM +0100, Filippo Toso wrote: > Dear Magnus, > > > Can you check the permissions on your pgsql directory? If your account > > only has permissions through the admin or power users group, you will > > need to grant it explicit permissions (since it gives up admin and

Re: [BUGS] BUG #2998: Installation Failed due to Permissions

2007-02-14 Thread Magnus Hagander
On Tue, Feb 13, 2007 at 05:22:01AM +, Michael wrote: > > The following bug has been logged online: > > Bug reference: 2998 > Logged by: Michael > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.3 > Operating system: Windows XP SP2 > Description:Installa

Re: [BUGS] BUG #2975: UNIQUE INDEX doesn't work

2007-02-14 Thread Michael Fuhr
On Wed, Feb 14, 2007 at 10:01:58AM +0100, Steven Lambert wrote: > You are right, the index has more columns and one of them have most of the > time the value NULL. > It is the date when the record has been "deleted" See "Unique Constraints" in the documentation, in particular the last paragraph:

Re: [BUGS] BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)

2007-02-14 Thread Bruce Momjian
Floyd Shackelford wrote: > > The following bug has been logged online: > > Bug reference: 2997 > Logged by: Floyd Shackelford > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.2.0 > Operating system: windows xp > Description:parse error: > setObject("2004-Aug

Re: [BUGS] BUG #2993: The program "postgres" is needed by initdb but was not found ...

2007-02-14 Thread Magnus Hagander
On Wed, Feb 14, 2007 at 01:49:43PM +0100, Filippo Toso wrote: > Dear Magnus, > > > > The pgsql directory privileges are set to Everyone (Full Control). > > > > Hmm. Bummer. I really thought that was it. Can you check the full > > directory tree up to the root directory as well, to see if there's

Re: [BUGS] BUG #2997: parse error: setObject("2004-August-15",java.sql.Types.DATE)

2007-02-14 Thread Bruce Momjian
Bruce Momjian wrote: > Floyd Shackelford wrote: > > > > The following bug has been logged online: > > > > Bug reference: 2997 > > Logged by: Floyd Shackelford > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 8.2.0 > > Operating system: windows xp > > Description:

[BUGS] Segfaults and assertion failures with not too extraordinary views and queries

2007-02-14 Thread Phil Frost
I have been attempting to migrate my application from 8.1 to 8.2.3. In doing so, I found some queries would always cause the postgres backend to die with a segfault. I was advised to rebuild with -- enable-debug --enable-cassert, and so I did. The same query would now cause an assertion fail

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

2007-02-14 Thread Tom Lane
Phil Frost <[EMAIL PROTECTED]> writes: > I have been attempting to migrate my application from 8.1 to 8.2.3. > In doing so, I found some queries would always cause the postgres > backend to die with a segfault. I was advised to rebuild with -- > enable-debug --enable-cassert, and so I did. The

Re: [BUGS] Segfaults and assertion failures with not too extraordinary views and queries

2007-02-14 Thread Tom Lane
I wrote: > Hm, I see the assert failure, but this example doesn't seem to crash > when asserts are off, and I'd not expect it to: it should either work or > elog(ERROR) in ExecRestrPos. So maybe you've found more than one issue. The attached patch fixes the failure you exhibited, but I still don'