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
-
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
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
"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
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
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
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'
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:
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
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
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
11 matches
Mail list logo