[BUGS] fkey+inheritance issue

2006-12-13 Thread Gergely CZUCZY
Hello i had written a bug report on the web-based for, but it hadn't accepted my email address, so i'm trying to report this here. PostgreSQL version: PostgreSQL 8.2.0 on i386-portbld-freebsd6.1, compiled by GCC cc (GCC) 3.4.4 [FreeBSD] 20050518 OS: FreeBSD 6.1-RELEASE-p10 Short descr: fkey ca

[BUGS] the bug report form doesn't accepts the email address

2006-12-13 Thread Gergely CZUCZY
hello the bug reporting form on the website does not accept any valid email address i fill it with. http://wwwmaster.postgresql.org/system/handleform.php i had tried [EMAIL PROTECTED]'' and [EMAIL PROTECTED]''. both are valid, working email addresses. Bye, Gergely Czuczy mailto: [EMAIL PROTECTE

Re: [BUGS] ERROR: failed to build any 4-way joins

2006-12-13 Thread Teodor Sigaev
went up in smoke, and I ended up just having have_relevant_joinclause() Thank you a lot, I was near around it :) -- Teodor Sigaev E-mail: [EMAIL PROTECTED] WWW: http://www.sigaev.ru/ --

Re: [BUGS] postgresql installation on centOS not working

2006-12-13 Thread Tom Lane
Heikki Linnakangas <[EMAIL PROTECTED]> writes: > Danish Siddiqui wrote: >> it configures and shows statements that its creating the make file and >> checking all the dependencies..but then when I do >> #make >> it again starts checking for all the dependencies and this keeps on >> repeating... >

Re: [BUGS] 8.1.2 -32768::smallint

2006-12-13 Thread Jean-Gérard Pailloncy
> select -(32768::smallint) > > which is why you're getting "smallint out of range." This should work: > > select (-32768)::smallint Exact. Thank you for the answer. But really conter-intuitive. Cordialement, Jean-Gérard Pailloncy ---(end of broadcast)---

Re: [BUGS] 8.1.2 -32768::smallint

2006-12-13 Thread Michael Fuhr
On Wed, Dec 13, 2006 at 08:34:38AM -0700, Michael Fuhr wrote: > On Wed, Dec 13, 2006 at 03:03:43PM -, Jean-Gérard Pailloncy wrote: > > On PostgreSQL 8.1.2 > > select -32768::smallint > > throws the error > > ERROR: smallint out of range > > I think the cast is binding tighter than the unary m

Re: [BUGS] 8.1.2 -32768::smallint

2006-12-13 Thread Michael Fuhr
On Wed, Dec 13, 2006 at 03:03:43PM -, Jean-Gérard Pailloncy wrote: > On PostgreSQL 8.1.2 > select -32768::smallint > throws the error > ERROR: smallint out of range I think the cast is binding tighter than the unary minus, so the above is equivalent to select -(32768::smallint) which is why

[BUGS] 8.1.2 -32768::smallint

2006-12-13 Thread Jean-Gérard Pailloncy
Hi, On PostgreSQL 8.1.2 select -32768::smallint throws the error ERROR: smallint out of range select -32767::smallint is OK. The documentation states that -32768 is OK. http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-NUMERIC Cordialement, Jean-Gérard Pailloncy -

Re: [BUGS] postgresql installation on centOS not working

2006-12-13 Thread Heikki Linnakangas
Danish Siddiqui wrote: Heikki Linnakangas wrote: Danish Siddiqui wrote: Im not able to install postgresql-8.1.2 on CentOS 4.1 What's the error you're getting? When I do #./configure it configures and shows statements that its creating the make file and checking all the dependencies..but t