t; Date: Sun Jun 23 11:05:02 2013 +0100
Good news, thank you.
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (901) 903-0499, +7 (988) 888-1979
gray...@gmail.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresq
On Tue, Jun 11, 2013 at 6:50 AM, Tom Lane wrote:
> Sergey Konoplev writes:
>> Just curious, what is the planned date for the next minor release, and
>> BTW where is it possible to see the roadmap for minor releases?
>
> There is no planned date, and certainly no &quo
7 23:00:51 tms2 kernel: : [] ?
system_call_fastpath+0x16/0x1b
Except these messages everything is just fine. The server is a passive
(very rarely queried) hot standby.
Are there any ideas of why and what could it be?
Thank you.
On Tue, Jun 11, 2013 at 6:50 AM, Tom Lane wrote:
> Sergey Kon
On Mon, Jun 10, 2013 at 11:43 PM, Simon Riggs wrote:
> On 11 June 2013 04:36, Sergey Konoplev wrote:
>> Are there any plans to commit this patch and what version it is going
>> to be done to?
>
> I'll be committing this soon, since we're likely coming up to the ne
Hi,
On Thu, May 9, 2013 at 7:28 PM, Sergey Konoplev wrote:
> On Tue, Apr 2, 2013 at 11:26 AM, Andres Freund wrote:
>> The attached patch fixes this although I don't like the way it knowledge of
>> the
>> point up to which StartupSUBTRANS zeroes pages is handled.
>
nvironment and can confirm that everything works perfect.
Thank you very much for your prompt help, Andres.
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gr
re no any
errors in logs before it.
--
Kind regards,
Sergey Konoplev
Database and Software Consultant
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988) 888-1979
Skype: gray-hemp
Jabber: gray...@gmail.com
--
Sent via pgsql-bugs mai
with exit code 1
2013-04-05 17:26:36 MSK 2110 @ from [vxid: txid:0] [] LOG:
terminating any other active server processes
--
Kind regards,
Sergey Konoplev
Database and Software Consultant
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988)
again and I am going to make a copy of the
cluster to be able to provide you some extra information. Do you still
need it?
--
Kind regards,
Sergey Konoplev
Database and Software Consultant
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-0499, +7 (988)
p of the
broken one. I thought you might find something useful in it.
Can I test your guess some other way? And what was the guess?
--
Kind regards,
Sergey Konoplev
Database and Software Consultant
Profile: http://www.linkedin.com/in/grayhemp
Phone: USA +1 (415) 867-9984, Russia +7 (901) 903-049
39 28040 28041 28042 28043
>>28044 28045 28046 28047 28048 28049 28050
>>28051 28052 28053 28054 28055 28056 28057
>>28058 28059 28060 28061 28062 28063 28064
>>28065 28055
557577
280557578 280557579 280557580 280557581 280557582 280557583
2013-03-27 10:43:03 MSK 1532 @ from [vxid: txid:0] [] LOG: startup
process (PID 1535) exited with exit code 1
2013-03-27 10:43:03 MSK 1532 @ from [vxid: txid:0] [] LOG:
terminating any other active server processes
Thank you in adv
en a very optimistic calculation puts the space needed
> for 70 10-element integer arrays at forty-some MB, and when I try
> it I see more like 100MB consumed thanks to hashtable overhead.
Yes you are right, Tom. My mistake.
--
Sergey Burladyan
--
Sent via pgsql-bugs mailing
| txid_current | ?column?
---+--+-
2012-11-30 19:51:06.302396+04 | 439 | -4294966857
(1 row)
Note this previous threads: Standbys, txid_current_snapshot,
wraparound http://archives.postgresql.org/pgsql-hackers/2012-06/msg00888.php
--
Sergey Burladyan
--
Sent via
p_rule_test();
NOTICE: rule "test1" for relation "" does not exist, skipping
CONTEXT: SQL statement "DROP RULE IF EXISTS invalid_rule ON test1"
PL/pgSQL function drop_rule_test() line 3 at SQL statement
Thanks,
Sergey
On 11/8/2012 10:14 AM, Tom Lane wrote:
ser...@
The following bug has been logged on the website:
Bug reference: 7641
Logged by: Sergey
Email address: ser...@booksys.com
PostgreSQL version: 9.2.1
Operating system: Windows XP / Ubuntu 10.04 (Lucid)
Description:
Postgres 9.2.1
Reproduced the problem on Windows XP
The following bug has been logged on the website:
Bug reference: 6690
Logged by: sergey
Email address: sergey-1...@yandex.ru
PostgreSQL version: 9.1.2
Operating system: FreeBSD 8.1
Description:
As I see in documentation,
http://www.postgresql.org/docs/current/static
Tom Lane writes:
> Ah, nevermind --- I re-read the patch and realized that it was already
> doing exactly what I said. Committed, sorry for the noise.
Great, thank you, Tom!
--
Sergey Burladyan
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes t
y possibility of libc doing something
> other than what we intend.
Sorry, I'm going on vacation for four days. Can't answer right now...
--
Sergey Burladyan
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
Peter Eisentraut writes:
> On ons, 2012-02-22 at 22:37 +0400, Sergey Burladyan wrote:
> > eshkin...@gmail.com writes:
> >
> > > The following bug has been logged on the website:
> > >
> > > Bug reference: 6480
> > > Logged by:
eshkin...@gmail.com writes:
> The following bug has been logged on the website:
>
> Bug reference: 6480
> Logged by: Sergey Burladyan
> Email address: eshkin...@gmail.com
> PostgreSQL version: 9.1.2
> Operating system: Debian testing
> Descriptio
Sergey Burladyan writes:
> #1 0x7fe1efbbc2b2 in get_leftop (clause=0x7fe1f1d85230) at
> /home/martin/debian/psql/9.1/build-area/postgresql-9.1-9.1.2/build/../src/backend/optimizer/util/clauses.c:189
I set breakpoint at src/backend/optimizer/util/clauses.c:188 and do some trace,
testyle = 'iso, dmy'
lc_messages = 'ru_RU.UTF-8' # locale for system error
message
lc_monetary = 'ru_RU.UTF-8' # locale for monetary formatting
lc_numeric = 'ru_RU.UTF-8' # locale for number formatting
lc
The following bug has been logged online:
Bug reference: 6242
Logged by: Sergey
Email address: sergey-1...@yandex.ru
PostgreSQL version: 8.4.4
Operating system: FreeBSD 8.1-RELEASE
Description:ERROR: unexpected CASE WHEN clause: 333
Details:
create view test_view
n HEAD:
Not fully. There are also two cases with Segmentation fault
(from sql.ru forum):
1.
create table t ();
alter table t add childs t;
create table selfchield_new (like t);
2.
create table t ();
alter table t add childs t;
create table selfchield_new as select * from t;
I have segmentation fault wi
The following bug has been logged online:
Bug reference: 5900
Logged by: Sergey Aleynikov
Email address: sergey.aleyni...@gmail.com
PostgreSQL version: 8.4.1
Operating system: FreeBSD 7.3-STABLE amd64
Description:Coredump on executing query
Details:
I've a
[ OK ] Cancel│
└────────┘
--
Sergey Burladyan
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Jan 7, 1:32 pm, dp...@pgadmin.org (Dave Page) wrote:
> On Fri, Jan 7, 2011 at 5:52 AM, Gabe Nell wrote:
> >> If you install libtermcap then it will start working good. We have
> >> tested it at our end.
>
> > Thanks Dharmendra, however in Ubuntu there is no package called
> > libtermcap, though
uot;));
/* postgres do this at starting */
printf("LC_CTYPE: %s\n", setlocale(LC_CTYPE, ""));
/* can be fixed like this, but _libc_intl_domainname is private :( */
//printf("bind_textdomain_codeset: %s\n", bind_textdomain_codeset(/*_libc_intl_domainname*/"lib
on't know, may be this is expected behavior.
--
Sergey Burladyan
--
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: 5553
Logged by: Sergey
Email address: s...@mail.ur.ru
PostgreSQL version: 9 beta 2
Operating system: Windows XP
Description:Repeating the keyword DECLARE in the CREATE FUNCTION
statement
Details:
Is it a
The following bug has been logged online:
Bug reference: 5484
Logged by: Sergey
Email address: vi...@yandex.ru
PostgreSQL version: 8.4.4
Operating system: FreeBSD 7.3
Description:sum() bug
Details:
Function sum() bug.
8849.15+6464.57=15313.72
But sum()=15313.7
[r
The following bug has been logged online:
Bug reference: 5360
Logged by: Sergey Manakov
Email address: vial...@gmail.com
PostgreSQL version: 8.4.2
Operating system: Fedora Core 8
Description:system column named "text"
Details:
Hi! I'am from Russia an
The following bug has been logged online:
Bug reference: 5234
Logged by: Sergey Burladyan
Email address: eshkin...@gmail.com
PostgreSQL version: 8.3.8
Operating system: Debian GNU/Linux 5.0.3 (lenny) + testing
Description:ALTER TABLE ... RENAME COLUMN change view
Thank you. Will try.
On Mon, Nov 2, 2009 at 8:40 PM, Stefan Kaltenbrunner
wrote:
> Sergey Konoplev wrote:
>>
>> On Mon, Nov 2, 2009 at 8:25 PM, Stefan Kaltenbrunner
>> wrote:
>>>
>>> Sergey Konoplev wrote:
>>>>
>>>> Thanx, Tom.
&g
On Mon, Nov 2, 2009 at 8:25 PM, Stefan Kaltenbrunner
wrote:
> Sergey Konoplev wrote:
>>
>> Thanx, Tom.
>>
>> So I just need to checkout REL8_4_STABLE and install it to fix my
>> problem, right?
>
> that should work if it is indeed the same issue.
>
Wh
Thanx, Tom.
So I just need to checkout REL8_4_STABLE and install it to fix my
problem, right?
On Mon, Nov 2, 2009 at 7:48 PM, Tom Lane wrote:
> "Sergey Konoplev" writes:
>> After migration to 8.4.1 from 8.3.7 our server worked normally for half our
>> and then become
The following bug has been logged online:
Bug reference: 5159
Logged by: Sergey Konoplev
Email address: gray...@gmail.com
PostgreSQL version: 8.4.1
Operating system: CentOS release 5.4 (Final)
Description:8.4.1 Segmentation fault
Details:
Hello
Contribs
The following bug has been logged online:
Bug reference: 5094
Logged by: Sergey Tomoulevitch
Email address: phoinix.pub...@gmail.com
PostgreSQL version: 8.4
Operating system: any
Description:bad result in dblink_get_result when async command
sending
Details:
Good
The following bug has been logged online:
Bug reference: 5078
Logged by: Sergey Manakov
Email address: vial...@gmail.com
PostgreSQL version: 8.4.1
Operating system: Fedora Core 11
Description:returns setof functions fails after table structure
altered
Details:
Hi
The following bug has been logged online:
Bug reference: 4922
Logged by: Sergey Konoplev
Email address: gray...@gmail.com
PostgreSQL version: 8.3.5
Operating system: CentOS 5.2 x86-64
Description:Segmentation fault on high-loaded server (+coredump
backtrace)
Details
Sergey Burladyan writes:
> Alvaro Herrera writes:
>
> > Michael Tenenbaum wrote:
> >
> > > If I have a stored procedure that returns a set of records of a table, I
> > > get
> > > an error message that the procedure's record is the wrong t
ed column count
(2).
КОНТЕКСТ: PL/pgSQL function "foo" line 1 at RETURN QUERY
РАСПОЛОЖЕНИЕ: validate_tupdesc_compat, pl_exec.c:5143
--
Sergey Burladyan
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ing=0x88991bc "select
xpath('count(//)', ''::xml);") at postgres.c:1004
#31 0x0823f7fc in PostgresMain (argc=4, argv=0x8810cf4, username=0x8810cc4
"seb") at postgres.c:3631
#32 0x0820973f in ServerLoop () at postmaster.c:3207
#33 0x0820a6c3 in PostmasterMain
free (pointer=0x0) at mcxt.c:580
#5 0xb7e6e5d2 in ?? () from /usr/lib/libxml2.so.2
#6 0x in ?? ()
--
Sergey Burladyan
--
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: 4758
Logged by: sergey
Email address: op...@ydk.com.ua
PostgreSQL version: 8.4beta1
Operating system: Linux 2.6.25-gentoo-r8
Description:deadlock.c:944
Details:
i have table with 15 records
Table
Dave Page writes:
--
С уважением, Сергей Бурладян
--
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: 4700
Logged by: Sergey Burladyan
Email address: eshkin...@gmail.com
PostgreSQL version: 8.3.6
Operating system: Debian GNU/Linux 5.0 (lenny)
Description:SIGSEGV with incorrect input to to_char function
Details
The following bug has been logged online:
Bug reference: 4622
Logged by: Sergey Burladyan
Email address: eshkin...@gmail.com
PostgreSQL version: 8.3.5
Operating system: Debian testing
Description:xpath only work in utf-8 server encoding
Details:
hello, all !
i am
Hello, all
> not important, is it one rule like:
> create rule v_del as on delete to v do instead (
>delete from o1 where id = old.o1_id;
>delete from o2 where id = old.o2_id;
> );
>
> or split into two rule like:
> create rule v_del1 as on delete to v do instead (
>delete
Hello, all
From sql.ru forum:
not important, is it one rule like:
create rule v_del as on delete to v do instead (
delete from o1 where id = old.o1_id;
delete from o2 where id = old.o2_id;
);
or split into two rule like:
create rule v_del1 as on delete to v do instead (
dele
Thursday 20 March 2008 01:16:34 Heikki Linnakangas:
Thanks for answer, Heikki !
> You'd need to modify the mic->ISO-8859-5 translation table as well, for
> converting in the other direction.
oops, i have not thought about it %)
> Here's a patch that does the conversion in the other direction as
Hi, all !
i'm find the problem.
src/backend/utils/mb/conversion_procs/cyrillic_and_mic/cyrillic_and_mic.c
does not have cyrillic letter 'IO' in ISO-8859-5 to mule internal code
translation table (function iso2mic(const unsigned char *l, unsigned char *p,
int len)). this is bug, because it is wi
Hi, all !
I can't convert with convert(bytea, name, name)::bytea from 'iso-8859-5'
to 'windows-1251' or any other cyrillic 8-bit encoding.
seb=> show client_encoding ;
client_encoding
-
UTF8
seb=> show server_encoding;
server_encoding
-
UTF8
seb=> select ver
Hi, all
seb=> select version();
version
PostgreSQL 8.3.0 on x86_64-pc-linux-gnu, compiled by GCC
x86_64-pc-linux-gnu-gcc (GCC
.0, compiled by Visual C++ build 1400"
---
Sergey Zubkovsky
The following bug has been logged online:
Bug reference: 3919
Logged by: Sergey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3RC2
Operating system: Windows 2003 SP2
Description:Service Privileges Bug
Details:
Postgre can't run under restricted u
The following bug has been logged online:
Bug reference: 3820
Logged by: Sergey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.beta4
Operating system: Windows Vista x64
Description:auto-installer-failed
Details:
I have 8.2 version work and running, also I
. ~/.psqlrc)
The workaround would be to disable password requirement, but this is a
security risk I want to avoid.
Why no to add an option --password="" to command-line options of pg_dump?
--
Sincerely,
Sergey Litvinenko
-
[EMAIL PROTECTED]
icq#: 34161555
http://www.rsu.
The following bug has been logged online:
Bug reference: 3494
Logged by: Sergey Burladyan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.9
Operating system: CentOS release 5 (Final)
Description:may be Query Error: subplan does not executed
Details:
i have
The following bug has been logged online:
Bug reference: 3396
Logged by: Sergey Burladyan
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.9
Operating system: CentOS release 5 (Final)
Description:strange error report for 'create domain ... default
The following bug has been logged online:
Bug reference: 3328
Logged by: Sergey Morgalev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: windows xp, free bsd
Description:initialization complex types with domain column
Details:
Hello
: Zubkovsky, Sergey
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] ERROR: tuple concurrently updated
"Zubkovsky, Sergey" <[EMAIL PROTECTED]> writes:
> create table t1 ( id int );
> create temp view v1 as select * from t1;
> C1: begin; drop view v1;
> C2: drop table t1;
It was Kaspersky antivirus with its on-fly "*:KAVICHS" NTFS-streams.
Thanks.
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 28, 2007 11:36 AM
To: Magnus Hagander
Cc: Zubkovsky, Sergey; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] "Pe
Hello.
Testing of the concurrent access to database objects leaded to the following
error:
ERROR: tuple concurrently updated
SQL state: XX000
According to the "PostgreSQL Error Codes" table in the documentation, "XX000"
is the PostgreSQL internal error code.
How to reproduce
Group_sp" line 32 at execute
statement
-
2007-03-20 17:21:46 ERROR: could not open relation 16405/16406/26881:
Permission denied
2007-03-20 17:21:46 CONTEXT: SQL statement "ALTER TABLE "Billing" ADD CHECK(
"UTC" IS NULL )"
PL/pgSQL function "andbRegisterPartitionedTable_sp" line 6 at execute
statement
-
Regards
Sergey Zubkovsky
select version();
"PostgreSQL 8.2.1 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC)
3.4.2 (mingw-special)"
pg_log:
2007-01-12 16:41:23 STATEMENT: EXPLAIN COPY "MsgRoot" TO 'C:/Program
Files/PostgreSQL/8.2/data/MsgRoot.txt'
2007-01-12 17:16:04 LOG: checkpoints are occurring too frequen
The following bug has been logged online:
Bug reference: 2862
Logged by: Sergey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.0-1
Operating system: Windows XP Pro SP2
Description:ERROR: failed to build any 7-way joins
Details:
After migrating to 8.2 I
Hi,
SELECT to_char(
'2006-01-01'::timestamp, 'IYYY-MM-DD' ) AS strange,
to_char( '2006-01-02'::timestamp, 'IYYY-MM-DD' ),
to_char( '2006-01-01'::timestamp, '-MM-DD' );
does produce unexpected result for column ‘strange’:
strange
| to_char | to_char
-
The following bug has been logged online:
Bug reference: 2517
Logged by: Sergey Konoplev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: SUSE LINUX Enterprise Server 9
Description:Trouble with cx_Oracle and Plpython
Details:
Good day
The following bug has been logged online:
Bug reference: 2293
Logged by: Sergey Rosenfeld
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.3
Operating system: Debian GNU/Linux (sid)
Description:primary key and cyrillic
Details:
postgres:~$ /usr/lib
Tom Lane wrote:
"Sergey Koshcheyev" <[EMAIL PROTECTED]> writes:
I'm trying to optimize "is null" queries, since PgSQL doesn't index null
values. I have found that creating an expression index on (column is null)
could work, but it doesn't get used
The following bug has been logged online:
Bug reference: 1510
Logged by: Sergey Koshcheyev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.7
Operating system: Debian Linux
Description:Indexes on boolean fields
Details:
Hi,
this is an addition to my bug
RenameLanguage procedure in src/backend/commands/proclang.c open
and update pg_catalog.pg_shadow table instead pg_catalog.pg_language.
--
Sergey N. Yatskevich <[EMAIL PROTECTED]>
diff -Naur postgresql-8.0.0/src/backend/commands/proclang.c postgresql-8.0.0.new/src/backend/commands/proc
The following bug has been logged online:
Bug reference: 1470
Logged by: Sergey Koshcheyev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system: Linux (Debian)
Description:Boolean expression index not used when it could be
Details:
I'm t
The following bug has been logged online:
Bug reference: 1471
Logged by: Sergey Koshcheyev
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.4.6
Operating system: Linux (Debian)
Description:Corrected e-mail address - bug 1470
Details:
Sorry for this dummy
3. Try to start service. It will refuse.
Suggested solution: Change service detection logic. May be not just
looking for the pid file, but parsing it and finding the service
process itself and testing it for existance.
Sorry if it is already fixed in new version.
--
Best regard
)
--
Sergey N. Yatskevich <[EMAIL PROTECTED]>
GosNIIAS
start.sh
Description: application/shellscript
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include
#include
EXEC SQL INCLUDE sqlca;
EXEC SQL BEGIN DECLARE SECTION;
int n;
extern in
.
P.P.S. Sorry for my bad english, but I hope You understand me.
--
Sergey N. Yatskevich <[EMAIL PROTECTED]>
GosNIIAS
-- Test view/rule privileges
SET client_min_messages = ERROR;
\! echo "Show full PostgreSQL version."
SELECT version ();
\! echo "Create user with name user1
-- contains test data :-))
--
Sergey N. Yatskevich <[EMAIL PROTECTED]>
GosNIIAS
/**
* @file
* @brief This test show bug in byteaout PostgreSQL code
* @author Sergey N. Yatskevich
*
* If we have a different client and server encodings and client and server locales are
* not C(ASCII) then p
I try to explain this bug. Attached files contains example and patch
for libpq.
I hope, that you look at it and replay me what you think.
---
Segey N. Yatskevich <[EMAIL PROTECTED]>
#
# $Id$
#
ssl-async-query: ssl-async-query.cc
c++ -g -I`pg_config --includedir` /usr/lib/libpq.so.3 -o ssl
I attach bug.template file with description of my problem.
Please fix it asap.
--
Keep in touch.
Sergey Mavrinsky.
Solvo Ltd.
If PostgreSQL failed to compile on your computer or you found a bug that
is likely to be specific to one platform then please fill out this form
and e-mail it to
-+
... One child is not enough, but two are far too many.|FreeBSD|
| The power to serve! |
Mikheev Sergey <[EMAIL PROTECTED]> |http://www.FreeBSD.org/|
+===+
83 matches
Mail list logo
