The following bug has been logged on the website:
Bug reference: 6478
Logged by: Roman Chmela
Email address: ro...@chmela.sk
PostgreSQL version: 9.1.2
Operating system: 1) Windows 7 pro, 2) Ubuntu
Description:
Hello
I have setup successfully foreign table, fully
The following bug has been logged online:
Bug reference: 6268
Logged by: Roman Lytovchenko
Email address: roman.lytovche...@gmail.com
PostgreSQL version: 9.1.1
Operating system: Mac OS X 10.6.8
Description:multiple update with on cascade
Details:
create table t2
The following bug has been logged online:
Bug reference: 6202
Logged by: Roman
Email address: zo...@oe-it.ru
PostgreSQL version: 9.0.4
Operating system: Win7x64
Description:type of union column selection bug
Details:
Query
select null union select 4
is Ok but
The following bug has been logged online:
Bug reference: 6075
Logged by: Roman
Email address: roman_...@hotmail.com
PostgreSQL version: 9.0.3
Operating system: Red Hat 4.4.1-2, 64-bit
Description:mergejoin early termination estimates bug or defficiency
Details
The following bug has been logged online:
Bug reference: 5542
Logged by: Roman
Email address: zo...@oe-it.ru
PostgreSQL version: 9.0
Operating system: Win7 x64
Description:Query optimization problem
Details:
I have a query:
SELECT d1.ID, d2.ID
FROM DocPrimary d1
I don't know what SQL2008 says about SUBSTRING, but SQL2003 says in
ISO/IEC 9075-2:2003 (E), 6.29 , General Rules,
5), page 261:
d) If R [the regular expression] does not contain exactly two
occurrences of the two-character sequence consisting of E [the escape
character], each immediately fol
The following bug has been logged online:
Bug reference: 5257
Logged by: Roman Kononov
Email address: kono...@ftml.net
PostgreSQL version: 8.4.2
Operating system: GNU/Linux x86_64
Description:wrong results of SUBSTRING with SQL regular expressions
Details:
test
The bitfromint8() and bitfromint4() are hosed. They produce wrong
results when the BIT size is more than 64 and 32 respectively, and the
BIT size is not multiple of 8, and the most significant byte of the
integer value is not 0x00 or 0xff.
For example:
test=# select (11::int4<<23 | 11::int4):
The following bug has been logged online:
Bug reference: 5237
Logged by: Roman Kononov
Email address: kono...@ftml.net
PostgreSQL version: 8.4.1
Operating system: GNU/Linux x86_64
Description:strange int->bit and bit->int conversions
Details:
test=# sele
Hello,
yes, I have been using UTF-8. Shouldn't this behaviour be at least
documented in the postgresql documentation? I am aware that it is a bug, but
if it is not likely to be fixed soon IMHO it should be documented somehow.
Regards,
Kamil Roman
2009/10/22 Tom Lane
> Robert Haas
The following bug has been logged online:
Bug reference: 5126
Logged by: Roman Kapusta
Email address: roman.kapu...@gmail.com
PostgreSQL version: 8.3.8-1
Operating system: fedora 11 i586 (32bit)
Description:convert_to preventing index scan
Details:
I have table
The following bug has been logged online:
Bug reference: 5039
Logged by: Kamil Roman
Email address: kamil.lech.ro...@gmail.com
PostgreSQL version: 8.3.7
Operating system: Windows XP
Description:'i' flag i in regexp_replace ignored for polish letters
Details
The following bug has been logged online:
Bug reference: 4926
Logged by: Roman Kononov
Email address: kono...@ftml.net
PostgreSQL version: 8.4.0
Operating system: Linux x86_64
Description:too few pathkeys for mergeclauses
Details:
test=# create table junk(i int
The following bug has been logged online:
Bug reference: 4874
Logged by: Roman Galeev
Email address: i...@ncom-ufa.ru
PostgreSQL version: 8.1
Operating system: Debian Sarge
Description:vacuum doest work
Details:
I've constantly got messages like this:
2009-
On 2009-04-03 23:32 Tom Lane said the following:
Roman Kononov writes:
On 2009-04-03 14:57 Tom Lane said the following:
I think we could fix this by having interval_hash() duplicate the
total-span calculation done by interval_cmp_internal, and then return
the hash of the resulting TimeOffset
On 2009-04-03 14:57 Tom Lane said the following:
I think we could fix this by having interval_hash() duplicate the
total-span calculation done by interval_cmp_internal, and then return
the hash of the resulting TimeOffset. This is going to break existing
hash indexes on intervals, but there seem
The following bug has been logged online:
Bug reference: 4748
Logged by: Roman Kononov
Email address: kono...@ftml.net
PostgreSQL version: 8.3.7
Operating system: GNU/Linux x86_64
Description:hash join and sort-merge join make different results
Details:
test-std
ar project"). I think that a quarter is 1/4 year and
that is it.
Regards,
Roman
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
The following bug has been logged online:
Bug reference: 4739
Logged by: Roman Kononov
Email address: kono...@ftml.net
PostgreSQL version: 8.3.7
Operating system: GNU/Linux x86_64
Description:strange behavior of EXTRACT(quarter from INTERVAL)
Details:
test=# select
The following bug has been logged online:
Bug reference: 4718
Logged by: Roman Kononov
Email address: kono...@ftml.net
PostgreSQL version: 8.3.7
Operating system: GNU/Linux x86_64
Description:"select +'8:00'::interval;" gives an error
Details:
The following bug has been logged online:
Bug reference: 4702
Logged by: Roman Kononov
Email address: kono...@ftml.net
PostgreSQL version: 8.3.6 and older
Operating system: GNU/Linux x86_64
Description:refusal to compute date_trunc('week', '0001-12-0
The following bug has been logged online:
Bug reference: 4114
Logged by: Roman Kononov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.1
Operating system: x86_64 GNU/Linux
Description:Inconsistent shift operator
Details:
The below test cases show the
The below test cases show the obvious inconsistency between different
integer types.
Regards,
Roman
test=# \t
Showing only tuples.
test=# select 1::int2 << 17;
0
test=# select 1::int4 << 33;
2
test=# select 1::int8 << 65;
2
test=# select 2::int
The following bug has been logged online:
Bug reference: 3892
Logged by: Roman
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: FC6
Description:Invalid week determination
Details:
Hello
Today is 2007-01-21.
select to_char(now(),'y
The following bug has been logged online:
Bug reference: 2979
Logged by: Roman Grigorovich
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.7
Operating system: FreeBSD 5.4-RELEASE
Description:Functional indexes ERROR while updating table
Details:
create
The following bug has been logged online:
Bug reference: 2913
Logged by: Roman Nowak
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.1
Operating system: Windows XP
Description:Subscript on multidimensional array yields no value
Details:
SELECT (ARRAY[[1,2
The following bug has been logged online:
Bug reference: 2846
Logged by: Roman Kononov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0 and older
Operating system: linux 2.6.15-27-amd64 ubuntu
Description:inconsistent and confusing handling of underflows
The following bug has been logged online:
Bug reference: 2754
Logged by: Roman Shterenzon
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.3
Operating system: RHEL3
Description:cache lookup failed for function 8470229
Details:
We receive:
"ERROR:
The following bug has been logged online:
Bug reference: 1577
Logged by: Roman Schayuk
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.2.2
Operating system: RedHat Linux 8.0 x86
Description:round(dp) function does not round to nearest integer
properly
Details
Do I understand correctly that you cannot roll back sequences?
JDBC example:
connect();
db.setAutoCommit(false);
Statement stmt=db.createStatement();
stmt.executeQuery("select nextval('test_seq')");
... other table updates ...
stmt.close();
db.rollba
> "Rick Roman" <[EMAIL PROTECTED]> writes:
>> I am running PostgreSQL 7.4.7 on Fedora Core 3. I get a lot of
>> warnings from pgAdmin III:
>
>> relation "pg_user" does not exist
>
> You've probably been bit by the problems with SELinux
I am running PostgreSQL 7.4.7 on Fedora Core 3. I get a lot of
warnings from pgAdmin III:
relation "pg_user" does not exist
but it doesn't seem to prevent me from doing most operations. More
seriously, I cannot execute a backup. I get the following message:
**
Hi!
Use RH Linux90.
Try configure postgresql-7.4.1
Type ./configure
Error is
checking for readline... no
configure: error: readline library not found
If you have readline already installed, see config.log for details on the
failure. It is possible the compiler isn't looking in the proper director
some values when i try
to use it from anywhere else.
I will attach the code i am trying to build, you
can run it and see what happnes, i have used Jbuilder 5.0 to run this
code.
Thanks in advance,
Roman Levandovsky.
UserInterface.java
Description: java/
ImageCanvas.java
Description: java
34 matches
Mail list logo
