Re: [BUGS] BUG #5269: postgres backend terminates with SIGSEGV

2010-01-12 Thread Kris Jurka
On Tue, 12 Jan 2010, Tom Lane wrote: preparing something as trivial as a ROLLBACK is pretty silly so nobody does it. Actually the JDBC driver has been preparing BEGIN, COMMIT, and ROLLBACK since the 8.0 release. http://archives.postgresql.org/pgsql-jdbc/2006-10/msg00149.php Kris Jurka -

Re: [BUGS] BUG #5269: postgres backend terminates with SIGSEGV

2010-01-12 Thread Tom Lane
Justin Pitts writes: > It went seriously heisenbug since I added %p. It took all day to crash it > since I added that to the configuration. Except this latest crash is > completely different - signal 6 ABRT, different place. Specifically: 2010-01-13 01:50:42 UTC 5455 ERROR: snapshot reference

Re: [BUGS] BUG #5273: Unexpected function behavior/failure

2010-01-12 Thread Robert Haas
On Tue, Jan 12, 2010 at 7:45 PM, Tom Lane wrote: > "Vee" writes: >> -- The problem query >> select data, regexp_matches(data, '(h..l)') >> from test; > >>> hello        {hell} > >> Since I have no "where" clause, I would expect to see all the rows in the >> result of the second case, with possibl

Re: [BUGS] BUG #5273: Unexpected function behavior/failure

2010-01-12 Thread Tom Lane
"Vee" writes: > -- The problem query > select data, regexp_matches(data, '(h..l)') > from test; >> hello{hell} > Since I have no "where" clause, I would expect to see all the rows in the > result of the second case, with possibly a NULL value for the non-matched > rows. No. regexp_matc

[BUGS] BUG #5273: Unexpected function behavior/failure

2010-01-12 Thread Vee
The following bug has been logged online: Bug reference: 5273 Logged by: Vee Email address: se...@hotmail.com PostgreSQL version: 8.4.2 Operating system: Linux Description:Unexpected function behavior/failure Details: Hi, I have an odd problem using certain regular

[BUGS] BUG #2197: PostgreSQL error- 'could not read block 0 of relation'

2010-01-12 Thread Ted Clark
BUG #2197: PostgreSQL error- 'could not read block 0 of relation' I found this bug has nothing to do with hardware. I was attemping to copy large amounts of data from text files into tables with a primary and many foreign keys. I found that upon truncating the tables not all key references had b

Re: [BUGS] Bug report: Wrong version in pg_config

2010-01-12 Thread Dimitri Fontaine
Tom Lane writes: > You would need to take that up with whoever packages Postgres for > Ubuntu. It sounds like they have some glitch in the package setup. > AFAIK, whoever that is doesn't read this list, which is mainly for > upstream Postgres development. I think Martin Pitt reads this list, he'

Re: [BUGS] Bug report: Wrong version in pg_config

2010-01-12 Thread Tom Lane
Adam Matan writes: > I'm using postgresql 8.3 in my Ubuntu 8.04 dekstop computer. I have tried to > install postgresql 8.4 for some testing, and removed it afterwards > using *apt-get purge*. > But still, pg_config remains with the removed version, after postresql > restart and even total reboot:

Re: [BUGS] Bug report: Wrong version in pg_config

2010-01-12 Thread Dimitri Fontaine
Adam Matan writes: > But still, pg_config remains with the removed version, after postresql > restart and even total reboot: > > $  pg_config > BINDIR = /usr/lib/postgresql/8.4/bin [...] > This creates confusion with external software packages trying to use pgxs, > for example. > Any ideas how t

[BUGS] Bug report: Wrong version in pg_config

2010-01-12 Thread Adam Matan
Hi, I'm using postgresql 8.3 in my Ubuntu 8.04 dekstop computer. I have tried to install postgresql 8.4 for some testing, and removed it afterwards using *apt-get purge*. There are currently no 8.4 packages installed: *$ dpkg --get-selections | grep postgresql* postgresql-8.3

Re: [BUGS] Failed to run initdb - not resolved bug 5130

2010-01-12 Thread Thomas Specker
Hi all after a long time of trying to install PostgreSQL with ... Computer: - Windows2000 (Jurassic Parc, I know ...) - PostGreSQL 8.3.9 and msi-file or PostGreSQL 8.4.2 and one click installer - Data in /8.4/data (default path) or D:\PostgresDaten (wi