[BUGS] some problem when installing postgresql

2008-05-29 Thread Yu Qun
hey: I am the new one to use PostgreSql, when I install the MoteView including postgresql and postgresqlODBC and so on, I met a problem about PostgreSql installation, it shew that "Failed to set permissions on the installed files. Please see the logfile in "C:\Program Files\PostgreSql\8.0.0-rc 1\t

Re: [BUGS] BUG #4209: openSSL undefined symbols.

2008-05-29 Thread Tom Lane
"Andrew SG Rojek" <[EMAIL PROTECTED]> writes: > Make produced the following error messages: > Undefined symbols: > "_SSL_write", referenced from: > _SOCK_SSL_send in socket.o > "_SSL_get_error", referenced from: > _SOCK_SSL_send in socket.o > _SOCK_get_next_byte in socket.o >

[BUGS] BUG #4210: signedness of pointer targets

2008-05-29 Thread Andrew SG Rojek
The following bug has been logged online: Bug reference: 4210 Logged by: Andrew SG Rojek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: OSX 10.5.2 Description:signedness of pointer targets Details: Whilst making psqlodbc-08.03.0200, mak

[BUGS] BUG #4209: openSSL undefined symbols.

2008-05-29 Thread Andrew SG Rojek
The following bug has been logged online: Bug reference: 4209 Logged by: Andrew SG Rojek Email address: [EMAIL PROTECTED] PostgreSQL version: 8.3.1 Operating system: OSX 10.5.2 Description:openSSL undefined symbols. Details: Make produced the following error message

Re: [BUGS] BUG #4208: Server crashes on insert into gist index

2008-05-29 Thread Tom Lane
Ron Mackley <[EMAIL PROTECTED]> writes: > Thanks for the quick response. No: > sp_hub_production=# select distinct cube_dim(attribute_vector) from > user_attribute_vectors; > cube_dim > -- > 5 > (1 row) > In the past we had a problem where runt vectors found their way into

Re: [BUGS] BUG #4208: Server crashes on insert into gist index

2008-05-29 Thread Ron Mackley
Tom, Thanks for the quick response. No: sp_hub_production=# select distinct cube_dim(attribute_vector) from user_attribute_vectors; cube_dim -- 5 (1 row) In the past we had a problem where runt vectors found their way into the table, but we deleted them and try to detect t

Re: [BUGS] BUG #4208: Server crashes on insert into gist index

2008-05-29 Thread Tom Lane
"Ron Mackley" <[EMAIL PROTECTED]> writes: > We've been seeing infrequent crashes of the postgres. This is version 8.2.6 > running on Red Hat Enterprise 5.1 on x64 using redhat issued RPMs. > We captured a core file and here is the stack trace: > (gdb) bt > #0 0x00615b5a in pfree (pointer

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-05-29 Thread Tom Lane
Magnus Hagander <[EMAIL PROTECTED]> writes: > Thomas H. wrote: >> so at least that explains the "changed" behaviour. nevertheless, >> LC_MESSAGES seems to be defunct - with the "locale" folder present, >> pg always picks the os' language and ignores the lc_message value. > This looks like I can r

[BUGS] BUG #4208: Server crashes on insert into gist index

2008-05-29 Thread Ron Mackley
The following bug has been logged online: Bug reference: 4208 Logged by: Ron Mackley Email address: [EMAIL PROTECTED] PostgreSQL version: 8.2.6 Operating system: Linux {hostname removed} 2.6.18-53.1.13.el5 #1 SMP Mon Feb 11 13:27:27 EST 2008 x86_64 x86_64 x86_64 GNU/Linux Des

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-05-29 Thread Magnus Hagander
Thomas H. wrote: > From: Thomas H. <[EMAIL PROTECTED]> > > what i noticed: if i delete the folder share/locale/de/ the system > > messages are back to english - but that can't be THE solution, can > > it? :) > > well, it actually was the solution, at least to the weird part of the > problem: >

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-05-29 Thread Dave Page
On Thu, May 29, 2008 at 12:23 PM, Thomas H. <[EMAIL PROTECTED]> wrote: > i was under the obviously wrong impression a zip-file upgrade would be the > same as an msi-upgrade. Eeep - don't do that!! That is a *very* good way to annoy the Windows Installer and trick it into thinking things need to b

Re: [BUGS] BUG #4207: EXTRACT function

2008-05-29 Thread Sam Mason
On Thu, May 29, 2008 at 07:01:46AM +, Jeferson Kasper wrote: > the EXTRACT(field FROM source) function allows to use some kind of 'fields', > and i need to know if a time (like '07:00') is after the midday(12:00) or > not. > I know i can resolve it implementing some function like "select > ('07

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-05-29 Thread Thomas H.
From: Dave Page <[EMAIL PROTECTED]> On Thu, May 29, 2008 at 2:05 AM, Thomas H. <[EMAIL PROTECTED]> wrote: From: Thomas H. <[EMAIL PROTECTED]> i've just verified that the 8.3.1 msi version provided on postgres.org also does NOT contain the "locale" folder & files. should i report this as a separa

Re: [BUGS] BUG #4186: set lc_messages does not work

2008-05-29 Thread Dave Page
On Thu, May 29, 2008 at 2:05 AM, Thomas H. <[EMAIL PROTECTED]> wrote: > From: Thomas H. <[EMAIL PROTECTED]> >> > i've just verified that the 8.3.1 msi version provided on postgres.org also > does NOT contain the "locale" folder & files. should i report this as a > separate bug/problem? How exactly

[BUGS] BUG #4207: EXTRACT function

2008-05-29 Thread Jeferson Kasper
The following bug has been logged online: Bug reference: 4207 Logged by: Jeferson Kasper Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1.5 Operating system: Windows XP and Linux Redhat Description:EXTRACT function Details: Hello. First... sorry for poor eng