Re: [BUGS] BUG #4041: error in Application Stack Builder

2008-03-18 Thread Dave Page
On Tue, Mar 18, 2008 at 12:23 AM, Chan, Keith (LESA IT) <[EMAIL PROTECTED]> wrote: > I can. OK, please try StackBuilder again in case it was a glitch. If it still doesn't work, perhaps you need to feed it some proxy server info on the first page? -- Dave Page EnterpriseDB UK Ltd: http://www.en

[BUGS] lc_messages to_char('2007/01/01'::date,'TMMonth') does not work.

2008-03-18 Thread jcrada
Hi, I'm having trouble displaying date names in other locales: central=# show lc_messages; lc_messages - fr_FR.ISO8859-1 (1 row) central=# select to_char('2007/01/01'::date,'TMMonth'); to_char - January (1 row) This result is not the expected result, since my locale

Re: [BUGS] BUG #3983: pgxs files still missing in win32 install (8.3.1)

2008-03-18 Thread Dave Page
On Tue, Mar 18, 2008 at 12:47 AM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > Mike Leahy wrote: > > Is this actually a bug, or is there a specific reason that the pgxs > > files omitted in the windows installer? I noticed the 8.3.1 installer > > has been posted (as the updates had appeared on m

Re: [BUGS] lc_messages to_char('2007/01/01'::date,'TMMonth') does not work.

2008-03-18 Thread Heikki Linnakangas
jcrada wrote: Hi, I'm having trouble displaying date names in other locales: central=# show lc_messages; lc_messages - fr_FR.ISO8859-1 (1 row) central=# select to_char('2007/01/01'::date,'TMMonth'); to_char - January (1 row) This result is not the expected result,

Re: [BUGS] BUG #3818: Cross compilation problems

2008-03-18 Thread Bruce Momjian
Richard, would you send us patches for the cross compile variables you needed changed? Thanks. --- Richard Evans wrote: > > The following bug has been logged online: > > Bug reference: 3818 > Logged by: Rich

[BUGS] BUG #4043: Unrecognized node type: using plpgsql

2008-03-18 Thread Reinier Suurenbroek
The following bug has been logged online: Bug reference: 4043 Logged by: Reinier Suurenbroek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.0 Operating system: SuSE Linux Enterprise Server 10sp1 Description:Unrecognized node type: using plpgsql Details: Ch

Re: [BUGS] BUG #4041: error in Application Stack Builder

2008-03-18 Thread Chan, Keith (LESA IT)
Can you tell me what I need to enter at HTTP proxy and Port, FTP proxy and Port? Thanks Keith -Original Message- From: Dave Page [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2008 1:28 AM To: Chan, Keith (LESA IT) Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #4041: error

Re: [BUGS] BUG #4043: Unrecognized node type: using plpgsql

2008-03-18 Thread Alvaro Herrera
Reinier Suurenbroek wrote: > - Output - > select trecht(); > ERROR: unrecognized node type: 1835557747 > CONTEXT: SQL statement "ALTER SCHEMA schm1 OWNER TO reino" > PL/pgSQL function "trecht" line 2 at EXECUTE statement Yup, that's a known bug (#3940) fixed in 8.3.1.

Re: [BUGS] BUG #4041: error in Application Stack Builder

2008-03-18 Thread Dave Page
On Tue, Mar 18, 2008 at 3:52 PM, Chan, Keith (LESA IT) <[EMAIL PROTECTED]> wrote: > Can you tell me what I need to enter at HTTP proxy and Port, FTP proxy > and Port? No idea - those details (if required) are specific to your network. You should check with your local administrator. -- Dave Page

[BUGS] BUG #4044: Incorrect RegExp substring Output

2008-03-18 Thread Rui Martins
The following bug has been logged online: Bug reference: 4044 Logged by: Rui Martins Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3 Operating system: Win2000 Description:Incorrect RegExp substring Output Details: To setup for test, run these SQL commands

Re: [BUGS] BUG #4041: error in Application Stack Builder

2008-03-18 Thread Chan, Keith (LESA IT)
I did enter them, but got the same problem. Actually what I want is to install PostGIS for the PostgreSQL 8.3. I did install PostGIS for PostgreSQL 8.2. That was easy. But PostGIS said I need to do this way to install PostGIS for PostgreSQL 8.3. I don't know why make the installation so troubleso

Re: [BUGS] BUG #4044: Incorrect RegExp substring Output

2008-03-18 Thread Tom Lane
"Rui Martins" <[EMAIL PROTECTED]> writes: > Description:Incorrect RegExp substring Output >SUBSTRING( BedNo FROM '^[[:digit:]]+[a-zA-Z]*(:[[:digit:]]+)?$' ) Interesting. It had never occurred to me that it's possible for the whole pattern to have a match when some parenthesized