Re: [BUGS] oid2name core dump

2004-12-01 Thread Neil Conway
On Wed, 2004-12-01 at 21:41 -0700, Michael Fuhr wrote: > % oid2name -d test -f 173181 > From database "test": > oid2name in free(): warning: junk pointer, too low to make sense > oid2name in free(): warning: junk pointer, too low to make sense > Filenode Table Name > -- >

Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib not in build or package

2004-12-01 Thread Dave Page
> -Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED] > Sent: 01 December 2004 17:39 > To: Dave Page > Cc: Magnus Hagander; Tom O'Connell; [EMAIL PROTECTED] > Subject: Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib > not in build or package > > > We do this for libp

Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib not in build or package

2004-12-01 Thread Dave Page
> -Original Message- > From: Bruce Momjian [mailto:[EMAIL PROTECTED] > Sent: 01 December 2004 20:35 > To: Dave Page > Cc: Magnus Hagander; Tom O'Connell; [EMAIL PROTECTED] > Subject: Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib > not in build or package > > Uh, why can we build

Re: [BUGS] oid2name core dump

2004-12-01 Thread Michael Fuhr
On Wed, Dec 01, 2004 at 09:41:49PM -0700, Michael Fuhr wrote: > The warnings are coming from these two lines (around lines 448 and 449): > > free(comma_oids); > free(comma_tables); > > Apparently the values of comma_oids and comma_tables are bogus. > I haven't looked more closely yet to

[BUGS] oid2name core dump

2004-12-01 Thread Michael Fuhr
PostgreSQL 8.0.0beta5 (CVS HEAD) Solaris 9 gcc 3.4.2 oid2name consistently dumps core: % oid2name -d test -f 77199 >From database "test": Segmentation fault (core dumped) (gdb) where #0 0xfee473ec in realfree () from /usr/lib/libc.so.1 #1 0xfee47cec in cleanfree () from /usr/lib/libc.so.1 #2

Re: [BUGS] Foreign keys referencing parent table fails on insert

2004-12-01 Thread Stephan Szabo
On Wed, 1 Dec 2004, postgresbugs wrote: > Foreign keys referencing parent table fails on insert if the key is in > the table that inherits the parent table. Unfortunately, primary keys, unique constraints and foreign keys do not inherit to children in a meaningful fashion. It's one of the big de

[BUGS] [Fwd: Bug#283856: postgresql: mistakes in src/backend/po/fr.po]

2004-12-01 Thread Oliver Elphick
I think this has been fixed in 8.0beta5, but you may want to apply the patch to the 7.4 tree. I can't access developer.postgresql.org to check the cvs; that server seems to be down at the moment. Forwarded Message From: Julien Cristau <[EMAIL PROTECTED]> Reply-To: Julien Cristau

Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib not in build or package

2004-12-01 Thread Bruce Momjian
Dave Page wrote: > > > > -Original Message- > > From: Bruce Momjian [mailto:[EMAIL PROTECTED] > > Sent: 01 December 2004 17:39 > > To: Dave Page > > Cc: Magnus Hagander; Tom O'Connell; [EMAIL PROTECTED] > > Subject: Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib > > not in build or

Re: [BUGS] BUG #1332: wrong results from age function

2004-12-01 Thread Robert Grabowski
Tom Lane wrote: Bruno Wolff III <[EMAIL PROTECTED]> writes: I think, it should be "1 mon". I get "1 mon" when I try this: So do I. It might be timezone dependent though ... Robert, what timezone setting are you using? regards, tom lane Hi! It is some informactions from

Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib not in build or package

2004-12-01 Thread Dave Page
> -Original Message- > From: Magnus Hagander [mailto:[EMAIL PROTECTED] > Sent: 01 December 2004 09:21 > To: Bruce Momjian; Tom O'Connell > Cc: [EMAIL PROTECTED]; Dave Page > Subject: RE: [BUGS] BUG #1319: Windows LIB file libecpg.lib > not in build or package > > AFAIK, we don't suppo

[BUGS] pgamin installation

2004-12-01 Thread Charlie Bright
Where to I post a pgAdmin III installation question?   Charlie

Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib not in build o

2004-12-01 Thread Tom O'Connell
Title: RE: [BUGS] BUG #1319: Windows LIB file libecpg.lib not in build or package As stated in my original e-mail you do provide a Windows lib file for libpq.  All I am asking is that you provide a lib for libecpg.  I created my own Windows lib file for libecpg and it works.  I can compile and

Re: [BUGS] Beta4 postgres.exe crash "...terminated by signal 5"

2004-12-01 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> "John Kennedy" <[EMAIL PROTECTED]> writes: >>> I am very new to PostgreSQL so apologies in advance if this bug report is a >>> waste of time for some reason. >> >> Not at all. Looks like you've found a mistake in where variables of >

Re: [BUGS] Beta4 postgres.exe crash "...terminated by signal 5"

2004-12-01 Thread Bruce Momjian
Tom Lane wrote: > "John Kennedy" <[EMAIL PROTECTED]> writes: > > I am very new to PostgreSQL so apologies in advance if this bug report is a > > waste of time for some reason. > > Not at all. Looks like you've found a mistake in where variables of > pass-by-reference datatypes get stored. Thank

Re: [BUGS] Ambiguous behaviour of age(timestamp)

2004-12-01 Thread Tom Lane
"Kouber Saparev" <[EMAIL PROTECTED]> writes: > I think the documentation is misleading, because AGE(timestamp) is actually > converted to AGE(current_date, timestamp), and not to AGE(now(), timestamp). Well, it says "Subtract from today", which I'd interpret as meaning "current_date" not "now", bu

[BUGS] Foreign keys referencing parent table fails on insert

2004-12-01 Thread postgresbugs
Foreign keys referencing parent table fails on insert if the key is in the table that inherits the parent table. I am using psql (PostgreSQL) 7.4.2. I have created a trivial case for an example. create table trivial1 (id numeric primary key, numval numeric); create table trivial2 (textval text)

Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib not in build or package

2004-12-01 Thread Bruce Momjian
Dave Page wrote: > > > > -Original Message- > > From: Magnus Hagander [mailto:[EMAIL PROTECTED] > > Sent: 01 December 2004 09:21 > > To: Bruce Momjian; Tom O'Connell > > Cc: [EMAIL PROTECTED]; Dave Page > > Subject: RE: [BUGS] BUG #1319: Windows LIB file libecpg.lib > > not in build or

Re: [BUGS] BUG #1332: wrong results from age function

2004-12-01 Thread Tom Lane
Robert Grabowski <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> So do I. It might be timezone dependent though ... Robert, what >> timezone setting are you using? > tmpl=# show TimeZone; > TimeZone > -- > unknown > (1 row) That's not real helpful :-( ... but guessing that you are i

Re: [BUGS] BUG #1335: Wrong sort result in union queries

2004-12-01 Thread Tom Lane
Stephan Szabo <[EMAIL PROTECTED]> writes: > Union isn't a tool which gives you that ability. Union All is closer, but > still doesn't guarantee an order. The current implementation of UNION ALL will in fact act that way (just append the individual query results together), but if for some reason we

Re: [BUGS] BUG #1332: wrong results from age function

2004-12-01 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: >> I think, it should be "1 mon". > I get "1 mon" when I try this: So do I. It might be timezone dependent though ... Robert, what timezone setting are you using? regards, tom lane ---(end of broadcast)

Re: [BUGS] BUG #1335: Wrong sort result in union queries

2004-12-01 Thread Stephan Szabo
On Wed, 1 Dec 2004, PostgreSQL Bugs List wrote: > Query: > select 2 union select 1 > > Result: > 1 > 2 > > Why? I think the result must be like this: > 2 > 1 If you don't specify an order by (at the top level) the output has no defined order by SQL, so both orders are valid. > Why PostgreSQL so

Re: [BUGS] BUG #1335: Wrong sort result in union queries

2004-12-01 Thread simon
PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote on 01.12.2004, 13:09:23: > > The following bug has been logged online: > > Bug reference: 1335 > Logged by: snaky > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 8.0 Beta > > Operating system: Windows 2003/XP >

[BUGS] BUG #1335: Wrong sort result in union queries

2004-12-01 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1335 Logged by: snaky Email address: [EMAIL PROTECTED] PostgreSQL version: 8.0 Beta Operating system: Windows 2003/XP Description:Wrong sort result in union queries Details: sorry for my english. Query:

Re: [BUGS] Installation fails for postgresql-8.0.0-beta4 on Windo

2004-12-01 Thread Magnus Hagander
Yes. I have done this at least 50 times with no issues. Using a local service account. Have you followed the instructions in questino 3.3 on http://pginstaller.projects.postgresql.org/FAQ_windows.html ? My guess is that you have some rule somewhere (be it local or using Group Policy) that adds Us

Re: [BUGS] Installation fails for postgresql-8.0.0-beta4 on Windo

2004-12-01 Thread Mehul Doshi-A20614
Hi, I and my colleagues are clearly able to install the beta 5 version on Windows 2000. But when the same procedure is followed for Windows XP Professional, it fails as is detailed my previous posts. We have tried it on 4-5 different systems and everywhere the result is the same. Can somebod

Re: [BUGS] BUG #1319: Windows LIB file libecpg.lib not in build or package

2004-12-01 Thread Magnus Hagander
AFAIK, we don't support ecpg with MSVC, only with MingW. Meaning it hasn't been verified to work. But it should be Ok to generate LIB files from the DLL and use those - just not tested. I don't see why it shouldn't work... If it does work we should consider adding MSVC import libraries in the MSI

Re: [BUGS] BUG #1332: wrong results from age function

2004-12-01 Thread Bruno Wolff III
On Mon, Nov 29, 2004 at 11:37:50 +, PostgreSQL Bugs List <[EMAIL PROTECTED]> wrote: > > The following bug has been logged online: > > Bug reference: 1332 > Logged by: Robert Grabowski > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.4.6 > > Operating syst