Re: [BUGS] Function Round() on 7.3 and 7.4

2004-09-22 Thread Tom Lane
"Emerson Tobar Silva" <[EMAIL PROTECTED]> writes: > I have always used the numeric function round on 7.2 version but on the > 7.3 and 7.4 versions its not there. What's happening ? Define "not there". 7.2: regression=# \df round List of functions Result data type | Name | Argumen

Re: [BUGS] sql function returning composite type

2004-09-22 Thread Tom Lane
Ivan <[EMAIL PROTECTED]> writes: > Still have the same error - ERROR: function returning row cannot return null value I've applied a patch to fix this for 8.0. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and

Re: [BUGS] Error with PostgreSQL 8.0 beta 2, in "make check" on Mac OS

2004-09-22 Thread Gaetano Mendola
Reuven M. Lerner wrote: I downloaded beta 2, unpacked it into its own directory, became (via sudo) the "postgres" user, and did the whole "configure" and "make" business. When I ran "make check", all of the tests passed successfully, except for the "geometry" test, which failed. Looking at reg

[BUGS] Function Round() on 7.3 and 7.4

2004-09-22 Thread Emerson Tobar Silva
Hi everyone,   I have always used the numeric function round on 7.2 version but on the 7.3 and 7.4 versions its not there. What's happening ?   Can I copy the source from 7.2 and compile on 7.3 or 7.4 version ? Do I have another choice to solve this ?   Thanks in advance   Emerson Tobar

[BUGS] Error with PostgreSQL 8.0 beta 2, in "make check" on Mac OS X (10.3.5)

2004-09-22 Thread Reuven M. Lerner
I downloaded beta 2, unpacked it into its own directory, became (via sudo) the "postgres" user, and did the whole "configure" and "make" business. When I ran "make check", all of the tests passed successfully, except for the "geometry" test, which failed. Looking at regression.diffs (enclosed

Re: [BUGS] Error starting service on Win2k

2004-09-22 Thread Conal Tuohy
> >OK. It turns out that the problem there was that the installer > >(postgresql-8.0-beta2-dev3.msi) actually created a user > >account which WAS a member of "Power Users", because my "Power > >Users" group included the group "NT AUTHORITY\Authenticated > >Users" (according to the MS website [1

Re: [BUGS] 8.0 beta service won't start

2004-09-22 Thread Mike Hornick
Thanks guy's - I'll try it. Michael Hornick Insurance Systems Inc. [EMAIL PROTECTED] -Original Message- From: Magnus Hagander [mailto:[EMAIL PROTECTED] Sent: September 11, 2004 11:43 AM To: Bruce Momjian Cc: Mike Hornick; [EMAIL PROTECTED] Subject: SV: [BUGS] 8.0 beta service won't start

Re: [BUGS] BUG #1265: sorting by (ORDER BY) result of an operation for names assigned by AS does not work

2004-09-22 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > The query: > SELECT id, lang as name, (SELECT lang FROM participants WHERE id = > event.participant) as pname FROM event ORDER BY name || pname; > returns an error: > ERROR: column "name" does not exist It's not a bug. Per http://www.postgr

[BUGS] BUG #1265: sorting by (ORDER BY) result of an operation for names assigned by AS does not work

2004-09-22 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1265 Logged by: Ansis Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.2 Operating system: Gentoo Linux Description:sorting by (ORDER BY) result of an operation for names assigned by AS does not wor