The following bug has been logged online:
Bug reference: 5027
Logged by: Dmitry
Email address: mas...@hsdesign.ru
PostgreSQL version: 8.3.5
Operating system: ALT Linux
Description:SQL query error?
Details:
Hello,
I try to make user rating by this query:
"
The following bug has been logged online:
Bug reference: 3555
Logged by: Dmitry
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1
Operating system: Linux Slackware 11
Description:does not work VACUUM
Details:
[EMAIL PROTECTED]:~# su postgres
[EMAIL PROTECTED
ini I uncomment line
extension=php_pgsql.dll
I have php 4.3.7
and I restart Apache, but it still does not work.
I don't understand what I need to do else.
Could you help me?
--
Sincerely,
Dmitry Shirokovskiy.
Web-developer of 1ADW Co.
www.1adw.com
RUSSIA
---(end of
The following bug has been logged online:
Bug reference: 6101
Logged by: Dmitry
Email address: y4gr5...@gmail.com
PostgreSQL version: 9.0.4
Operating system: Debian i686 2.6.32-5-686-bigmem
Description:ALTER TABLE hangs with AccessExclusiveLock
Details:
ALTER locks
The following bug has been logged online:
Bug reference:
Logged by: Dmitry Orlov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.4
Operating system: Linux dorlov-laptop 2.6.24-19-rt #1 SMP PREEMPT RT Thu
Aug 21 02:08:03 UTC 2008 i686 GNU/Linux
Description
The following bug has been logged online:
Bug reference: 4461
Logged by: Dmitry Orlov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3
Operating system: Ubuntu Hardy 8.04.1
Description:Should avoid create tblspcs in system location
Details:
if I issue
The following bug has been logged online:
Bug reference: 4861
Logged by: Dmitry Ryabov
Email address: dmitry-rya...@mail.ru
PostgreSQL version: 8.4rc1
Operating system: Windows
Description:Incorrect log_line_prefix default value in
postgresql.conf
Details
The following bug has been logged online:
Bug reference: 4997
Logged by: Dmitry Samokhin
Email address: s...@mail.ru
PostgreSQL version: 8.3.7
Operating system: Windows 2003 Server
Description:Expression evaluation rules
Details:
As described in section "4
in
separate SQL queries and server procedures.
Thanks for reply,
closed.
Dmitry.
--
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: 5466
Logged by: Dmitry Funk
Email address: dif...@gmail.com
PostgreSQL version: 8.4.4
Operating system: Windows 2003 R2
Description:Asia/Novosibirsk timezone problem
Details:
Current system timezone: Asia
ached.
Dmitry Gercog.
mybase=# select version();
version
--
PostgreSQL 7.0.2 on i686-pc-linux-gnulibc1, compiled by gcc egcs-2.91.66
(1 row)
mybase=# CREATE FUNCTION tst_func(int4, int4) RETURNS IN
em SuSe Linux 7.0
PostgreSQL version 7.0.3
When I use system command "date":
date +%w -d '2001-03-25'
I'm get correct result = '0'!
Dmitry Gercog.
---(end of broadcast)---
TIP 3: if posting/reading through
27;rs', 123);
FETCH ALL IN rs;
COMMIT;
everything works fine. Am I missing something here? Workaround?
The OS is Linux Red Hat 7.1, kernel 2.4.5, glibc 2.2.4
Thanks for your help!
Dmitry Fomichev
---(end of broadcast)---
TIP 3: if posting/readi
roblem.
Can you suggest something?
--
Best regards,
Dmitry mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
POSTGRESQL BUG REPORT TEMPLATE
Your name : Dima Tkach
Your email address : [EMAIL PROTE
Ok, this sit around for a while, and, because there was no responses, I assume, that
nothing jumps out
at you as being terribly with my logic...
Here is the patch (see the original problem description in the bottom)... It seems to
be working (at least that query,
that used to be running out of m
Tom Lane wrote:
>Dmitry Tkach <[EMAIL PROTECTED]> writes:
>
>>*** nodeIndexscan.c.origFri Apr 19 10:29:57 2002
>>--- nodeIndexscan.c Fri Apr 19 10:30:00 2002
>>***
>>*** 505,510
>>--- 505,514
>>
gt; (1 row)
>
I think it's a limitation of floating point numbers representation, not a PostgreSQL
bug. Use NUMERIC type, if you need an "exact" precision:
org=> SELECT 3088.8::numeric(8,3) - (2847.64::numeric(8,3) + 241.16::numeric(8,3)) AS
silly;
silly
---
The following bug has been logged online:
Bug reference: 3048
Logged by: Dmitry Koterov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0
Operating system: Linux
Description:pg_dump dumps intarray metadata incorrectly
Details:
Steps to reproduce:
1
ked, if we
remove DEFAULT keyword, a dump is restored correctly.
On 2/23/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Dmitry Koterov" <[EMAIL PROTECTED]> writes:
> [ pg_restore fails with ]
> ERROR: could not make operator class "gin__int_ops" be default for ty
The following bug has been logged online:
Bug reference: 3233
Logged by: Dmitry Belyavsky
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.6
Operating system: FreeBSD 6
Description:Trigger checks failed on concurrent transactions
Details:
Greetings!
I have
The following bug has been logged online:
Bug reference: 3309
Logged by: Dmitry Dmitriev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.3.-1
Operating system: Windows XP
Description:The limitation for number of connection with ODBC driver
Details:
We have
The following bug has been logged online:
Bug reference: 3314
Logged by: Dmitry Maksyoma
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4-1 Debian
Operating system: Debian unstable, 2.6.18-4-686
Description:DOMAIN NOT NULL constraint enforced in plPgSQL
The following bug has been logged online:
Bug reference: 3910
Logged by: Dmitry Afanasiev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.19
Operating system: FreeBSD 7.0 / 5.5
Description:Incorrect behavior of UPDATE statement on tables with
constraints
'group by' must be your problem.
If you remove that clause from your second query, you should then get
the same result (77) sum'ing the temp table...
I hope, it helps...
Dima
Marco Kienzle wrote:
>The following problem occur using the sum() function (see the attached
>file for all the details
Did you vacuum it?
I hope, it helps...
Dima
[EMAIL PROTECTED] wrote:
>Markus Grill ([EMAIL PROTECTED]) reports a bug with a severity of 2
>The lower the number the more severe it is.
>
>Short Description
>creating indices after data insertion
>
>Long Description
>Hello,
>
>in my opinion there i
ist) :-(
Perhaps, somebody, familiar with this code could come up with a patch
for this problem?
This would be really great!
Dima
>
>
>Jie Liang
>
>-Original Message-
>From: Dmitry Tkach [mailto:[EMAIL PROTECTED]]
>Sent: Friday, July 12, 2002 7:34 AM
>To: Jie Liang
The attached patch fixes 'Bad Timestamp format' exception when timestamp value is
'ininity' or '-ininity'.
I hope, it helps...
Dima.
Index: AbstractJdbc1ResultSet.java
===
RCS file:
/projects/cvsroot/pgsql/src/interfaces/jdbc/org/
uot; and only then "-lpq"
only with such order of liraries, programs began work again.
I think that library "pq" replace standart function with own.
If it's true, it's wrong.
Dmitry Gertsog.
---(end of broadcast)
Here is a trouble I am having, that looks like a bug to me:
create table abc (a int, b int, c int);
create index abc_idx on abc (a,b,c);
set enable_seqscan=off;
explain select * from abc where a in (1,2,3);
QUERY
PLAN
Hi, everybody!
I have run into a couple of problems having to do with parsing text
arrays in jdbc (Array.getArray ()):
- First of all, it skips backslashes, but does not really use them as
escape characters
(for example, if the array element has a string, looking like \"blah\",
it will (incorr
Don't you have old jdbc drivers in the classpath by any chance?
Dima
Jeffrey Babb wrote:
Hello,
I am trying to install PostgreSQL 7.3.3 from source on Mac OS X and
having some difficulty.
My configure command is as follows:
./configure --enable-multibyte --enable-unicode --enable-odbc
--w
I am experiencing database server crashes quite frequently (sometimes,
*daily*), and I am having hard time identifying what could possibly be
causing them :-(
They seem to be happenning kinda randomly, I was unable to attribute
them to any specific database activity going on at the time...
The p
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
I am experiencing database server crashes quite frequently
2003-06-10 13:53:32 [14551] FATAL 1: LWLockAcquire: can't wait without
a PROC structure
This is 7.2.1 - I know, I need to upgrade.
Yes, you do.
Makes sense. Thanks!
One more thing to clarify - when you said it was fixed in .3 and .4 did
you mean 7.3 or 7.2.3?
Thanks!
Dima
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
2003-06-10 13:53:32 [14551] FATAL 1: LWLockAcquire: can't wait without
a PRO
You must have some environment setting (like LD_LIBRARY_PATH?) in your
.login or .bashrc (or whatever shell you are using), that tells psql
where to find that library. When you run it via cron, that environment
isn't being set and causes it to fail.
I hope, it helps...
Dima
Serge Obeuf wrot
I am not sure if this is really a bug, but it certainly looks like one
to me...
I have a table that looks something like this:
create table huge_table
(
int x,
int y
);
create index huge_table_idx on huge_table (x,y);
It contains about 80 million rows...
I am trying to get those rows that
... and here is another bug I ran into while trying to investigate my
earlier problem with views a little more:
testdb=# drop rule skip_test;
ERROR: parser: parse error at or near ";" at character 20
testdb=# \h drop rule
Command: DROP RULE
Description: remove a rewrite rule
Syntax:
DROP RUL
Here is a problem a ran into:
testdb=# create table test (x int);
CREATE TABLE
testdb=# create table test_view as select * from test;
SELECT
testdb=# create rule insert_test as on insert to test_view do instead
insert into test values (new.*);
CREATE RULE
testdb=# create rule skip_test as on inse
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
testdb=# create table test_view as select * from test;
SELECT
That is not a view, it's only a static copy of the original table.
regards, tom lane
I know... That was a typo in my sql :-)
But for this example it doe
Tom Lane wrote:
Oh, I see what you're on about. Sorry, a "DO INSTEAD NOTHING" only
suppresses the original command, it does not suppress other rules.
I think what you want is to make the insert_test rule conditional
on x being not null.
Yeah... that's what I was afraid of :-(
The problem is
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
The problem is that in the 'real life' situation the condition is a lot
more complicated than this simple is null test... I hate having to
duplicate it, and I hate even more having to evaluate it twice on every
ins
Oh, I see what you're on about. Sorry, a "DO INSTEAD NOTHING" only
suppresses the original command, it does not suppress other rules.
I think what you want is to make the insert_test rule conditional
on x being not null.
regards, tom lane
Ok... What's wrong with this one then (three rules
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
Ok... What's wrong with this one then
testdb=# insert into test values (null, null);
ERROR: ExecInsert: Fail to add null value in not null attribute x
Try inserting into test_view ...
regards, tom lane
lues (null, null);
It looks like the UNION in the 'not null' rule is the problem.
If I change it to just insert ... select (without the union), or to two
inserts, then it works.
But union always fails, even if I add a 'where false' to the end, so
that it only returns one
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
create rule insert_test as on insert to test_view where new.x is not
null and new.y is not null do instead
(
insert into test
select new.* union
select new.*;
);
Mmm. In CVS tip that throws
ERROR: UNION/INTERSECT/
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
Something like
insert into test
select null,null union select 1,2 where false
has the same problem... and it doesn't refer to any relations.
But that's parsed as
insert into test
(select null,null) union (select 1,2
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
Sure, but it is inside the rule that has 'where x is not null and y is
not null' on it as a qualifier, so
with my test example it should just never get executed in the first place.
You're confusing rules with
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
It would have saved a lot of trouble if it just complained about that
union thing right away and refuse to create the rule...
That's what happens in CVS tip.
I thought you said it was only complaining about references
Yep ... looks like it got broken in 7.3.
7.2.4 works fine, but 7.3 (and CVS tip) doesn't.
This is because in 7.2, timestamp_date () and timestamptz_date () do the
same thing -
convert the time to Julian date and then subtruct the offset for Y2K,
and both work.
In 7.3 (and 7.4) timestamptz_date (
Thanks a lot for the reply!
The applications uses the jdbc driver with autocommit turned off,
commit and rollback. Do you know if the jdbc driver just starts
a new transaction as soon as the last one was ended with commit/
rollback ?
Yes, it does.
You have to explictly setAutocommit(true) in
Hi, everybody!
I am getting some weird behaviour trying to use a partial index in 7.3:
testdb=# create table a (x int, y int, z int);
CREATE
testdb=# create index a_idx on a(x,y) where z is null;
CREATE
testdb=# create index b_idx on a (x,y);
CREATE
testdb=# explain select * from a where x=1 and
and sort_mem in conf
file, but this seems not help.
--
Best regards,
Dmitry mailto:[EMAIL PROTECTED]
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
The following bug has been logged online:
Bug reference: 1790
Logged by: Dmitry Karasik
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1-devel
Operating system: freebsd 5.4
Description:coredump in postgres
Details:
pgsql is 8.1-devel, cvsup-latest
The following bug has been logged online:
Bug reference: 1998
Logged by: Dmitry Panov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.4
Operating system: Linux
Description:transaction locks parent record when it shouldn't
Details:
Hi,
I discovered
The following bug has been logged online:
Bug reference: 6077
Logged by: Dmitry Grebeniuk
Email address: gds...@gmail.com
PostgreSQL version: 9.1beta2
Operating system: any; documentation issue
Description:documentation on PQfmod for numeric data types
Details
The following bug has been logged online:
Bug reference: 6230
Logged by: Dmitry Ryabov
Email address: dmitry-rya...@mail.ru
PostgreSQL version: 9.1
Operating system: Windows x64
Description:strange changes in behavior of string functions
Details:
In the version 9.1
The following bug has been logged on the website:
Bug reference: 8289
Logged by: Dmitriy Potapov
Email address: potapov.dmi...@gmail.com
PostgreSQL version: 9.2.4
Operating system: Scientific Linux 6.3
Description:
pg_stat_statements view contains incorrectly normali
POSTGRESQL BUG REPORT TEMPLATE
Your name : Dmitry G. Mastrukov
Your email address : [EMAIL
POSTGRESQL BUG REPORT TEMPLATE
Your name : Dmitry G. Mastrukov
Your email address : [EMAIL
The following bug has been logged online:
Bug reference: 2870
Logged by: Dmitry D. Khlebnikov
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2
Operating system: Openwall GNU/*/Linux
Description:incorrect man page for postgres
Details:
The man page for
Euler,
On Wed, Jan 03, 2007 at 09:50:15PM -0200, Euler Taveira de Oliveira wrote:
> Dmitry D. Khlebnikov wrote:
>
> > The man page for postgres(1) has a wrong description of the '-S' option.
> > Previously, the '-S' option means that postgres will start in
62 matches
Mail list logo
