Re: [BUGS] Postgres bug (working with iserverd)

2001-05-12 Thread Tom Lane
"A.V.Shutko" <[EMAIL PROTECTED]> writes: > Your server have a bug that sometimes cause coredumps. > Tom Lane> What version of postgres? > # ./postgres -V > postgres (PostgreSQL) 7.1 Okay, I think I understand the scenario here. Are you using table inheritance? I can produce a crash in the

Re: [BUGS] Postgres bug (working with iserverd)

2001-05-12 Thread Tom Lane
"A.V.Shutko" <[EMAIL PROTECTED]> writes: > Your server have a bug that sometimes cause coredumps. What version of postgres? What is the query being processed? regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'ki

Re: [BUGS] create unique index doesn't work properly

2001-05-12 Thread Tom Lane
Domingo Alvarez Duarte <[EMAIL PROTECTED]> writes: > when executing the code bellow: > create table test_unique(i1 integer, i2 integer, unique(i1,i2)); > insert into test_unique(1,null); > insert into test_unique(1,null); > insert into test_unique(1,null); > all "inserts" terminate sucefully, if

[BUGS] Re: Irix build failes (PSQL 7.1.1)

2001-05-12 Thread Erik Hofman
Thomas Lockhart wrote: > > > > I'm unable to build on Irix (6.5.9) using the MipsPro compiler (Vs 7.3). The >output is this: > > > cc-1092 cc: ERROR File = ../../../../src/include/utils/nabstime.h, Line = 157 > > > Identifier-list parameters can only be used in a function definition. > > > e

[BUGS] Bug with timestamp !!!

2001-05-12 Thread Alexander Dederer
Look this: create table tmp (create_datetimestamp); #insert into tmp values('2001-04-01 02:29:52'); INSERT 1021715 1 #select * from tmp; create_data 2035-05-29 01:33:36-05 (1 row) ! ! ! ! It's work on FreeBSD 4.2. PostgreSQL install from: postgresql-7.1.1.tar

[BUGS] Postgres bug (working with iserverd)

2001-05-12 Thread A.V.Shutko
Hello , mans Your server have a bug that sometimes cause coredumps. System:FreeBSD 4.2-20001127-STABLE Compiler: gcc 2.95.2 Platform: x86 (PII-600) Ram: 256 Mb With server work only one program - IServerd, there is 10 parallel processes that have db connection. Here information

[BUGS] create unique index doesn't work properly

2001-05-12 Thread Domingo Alvarez Duarte
when executing the code bellow: --- create table test_unique(i1 integer, i2 integer, unique(i1,i2)); insert into test_unique(1,null); insert into test_unique(1,null); insert into test_unique(1,null); --- all "inserts" terminate sucefully, if there isn't "null" values it works fine.

[BUGS] Documentation problem in postgresql-7.0.2

2001-05-12 Thread John Summerfield
My application runs slower than a month of Sundays. I found, quite by accident, that I need to "Turn off auto-commit." Nowhere, and I've even resorted to running grep over the documentation, can I find any cluse as to ahow I "Turn off auto-commit." I don't understand why I should have to "Tur

[BUGS] Re: Irix build failes (PSQL 7.1.1)

2001-05-12 Thread Tom Lane
Erik Hofman <[EMAIL PROTECTED]> writes: > Well I've managed to get rid of this error message (remove old header > files), What do you mean by that, exactly? If you had header files from another version of Postgres cluttering your include path, maybe there are still some left.

[BUGS] PG 7.1.1 version for SuSE 7.0

2001-05-12 Thread pgsql-bugs
Iván Baldo ([EMAIL PROTECTED]) reports a bug with a severity of 4 The lower the number the more severe it is. Short Description PG 7.1.1 version for SuSE 7.0 Long Description Here we are having some problems with Postgres 7.0 and we would like to try out 7.1.1 before trying to analyze further t