Re: [BUGS] BUG #4037: Manual bug: 2.5. Querying a Table

2008-03-14 Thread Tom Lane
"Daniel Cristian Cruz" <[EMAIL PROTECTED]> writes: > Where it says: > "Notice how the AS clause is used to relabel the output column. (The AS > clause is optional.)" > It's wrong, because it causes an error if executed without it. Hmm? You can leave off the AS clause if you want: SELECT city,

[BUGS] BUG #4037: Manual bug: 2.5. Querying a Table

2008-03-14 Thread Daniel Cristian Cruz
The following bug has been logged online: Bug reference: 4037 Logged by: Daniel Cristian Cruz Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Windows Description:Manual bug: 2.5. Querying a Table Details: Where it says: "Notice how the AS

[BUGS] BUG #4036: Nested xpath() calls lose namespace support

2008-03-14 Thread Matt Magoffin
The following bug has been logged online: Bug reference: 4036 Logged by: Matt Magoffin Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: OS X, Linux Description:Nested xpath() calls lose namespace support Details: I was trying to extract X

[BUGS] BUG #4035: sql table aliases do not work

2008-03-14 Thread RGF
The following bug has been logged online: Bug reference: 4035 Logged by: RGF Email address: [EMAIL PROTECTED] PostgreSQL version: latest Operating system: Windows XP Description:sql table aliases do not work Details: the following sql code throws the following error

Re: [BUGS] BUG #4030: Inconsistency: ORDER BY clauses involving column aliases

2008-03-14 Thread Tom Lane
"Dave Gurnell" <[EMAIL PROTECTED]> writes: > Run a query ordered on an expression involving these aliases: > test=# select x.a as xa, x.b as xb, x.c as xc from numbers as x order by > (xa + xb + xc); > ERROR: column "xa" does not exist > LINE 1: ... x.b as xb, x.c as xc from numbers a

[BUGS] Further problems

2008-03-14 Thread divya shree
Hi, As you said, I removed the docs from ADDLOCAL. Then the installation procedure started. But after that I got an error telling unknown username or bad password .can u help me with this problem.here is the entire code msiexec /i postgresql-8.3-int.msi /qr INTERNALLAUNCH=1 ADDLO

[BUGS] BUG #4030: Inconsistency: ORDER BY clauses involving column aliases

2008-03-14 Thread Dave Gurnell
The following bug has been logged online: Bug reference: 4030 Logged by: Dave Gurnell Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.5 Operating system: Mac OS X / Debian Description:Inconsistency: ORDER BY clauses involving column aliases Details: Hi, I'

Re: [BUGS] problem with silent installation

2008-03-14 Thread acordner
Remove the "docs" feature from ADDLOCAL. This will prevent error 2711 (installation package could not be opened). I also had problems using the SERVICEDOMAIN="%COMPUTERNAME% argument - it seems to cause MSI to report errors 1708 and 1709 and aborts the installation. divya shree wrote: > > hi