Re: [BUGS] BUG #1636: Foreign key referencing inherited table fails.

2005-04-28 Thread Michael Fuhr
On Thu, Apr 28, 2005 at 04:31:45PM +0100, Fredrik Olsson wrote: > > Description:Foreign key referencing inherited table fails. This is a documented limitation of inheritance. Fixing inheritance shortcomings is on the developers' TODO list; I'm sure a patch would be welcome :-) http://ww

Re: [BUGS] BUG #1637: age() function is giving different results

2005-04-28 Thread Andrew - Supernews
On 2005-04-28, "J.Simon Goodall" <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 1637 > Logged by: J.Simon Goodall > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.4.2 > Operating system: Linux > Description:age() fu

Re: [BUGS] BUG #1637: age() function is giving different results

2005-04-28 Thread Tom Lane
"J.Simon Goodall" <[EMAIL PROTECTED]> writes: > With the same query the age function is giving me two results, one as it > should be (34 years) and the other one is off by 1 hour, Daylight-savings time shift? regards, tom lane ---(end of broadcast)

[BUGS] BUG #1637: age() function is giving different results

2005-04-28 Thread J.Simon Goodall
The following bug has been logged online: Bug reference: 1637 Logged by: J.Simon Goodall Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.2 Operating system: Linux Description:age() function is giving different results Details: With the same query the age fu

Re: [BUGS] BUG #1635: Failed to create process for initdb

2005-04-28 Thread Mike G.
Did you remove the postgres user account before reinstalling? On Wed, Apr 27, 2005 at 06:49:59PM +0100, Tom wrote: > > The following bug has been logged online: > > Bug reference: 1635 > Logged by: Tom > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.0 > Operating sy

[BUGS] Patch for Bug#1611

2005-04-28 Thread Ingolf Knopf
My patch once more, based on 'postgresql-jdbc-8.0-311.src.tar.gz'. (Sorry, my last version of this patch made a NullPointerException!) Using this patch, I still have not found any more problems with my application. With kind regards, Ingolf. diff -cr postgresql-jdbc-8.0-311.src/org/postgresql/jd

[BUGS] BUG #1635: Failed to create process for initdb

2005-04-28 Thread Tom
The following bug has been logged online: Bug reference: 1635 Logged by: Tom Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Operating system: Windows 2000 Description:Failed to create process for initdb Details: I'm trying to reinstall PostgreSQL and durin

[BUGS] BUG #1636: Foreign key referencing inherited table fails.

2005-04-28 Thread Fredrik Olsson
The following bug has been logged online: Bug reference: 1636 Logged by: Fredrik Olsson Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0.2 Operating system: Max OS X 10.3.9 Description:Foreign key referencing inherited table fails. Details: Some SQL statemen