lysis).
Thus, I have events with two different instances of PG.
Something being imported by plain DML operations?
A strange idea by itself anyway.
Still clueless...
Rainer
Am 17.08.2011 13:33, schrieb Pavel Stehule:
> Hello
>
> 2011/8/17 Rainer Pruy :
>> This is strange and as
tion?
Not much input I can give for decent analysis,
but either someone can point me to the obvious
or it is something thats worth being watched for somehow....
Rainer
Sequnce of steps:
a) As can be seen from the trigger function below. we need a value from a
sequence. This is getting su
ea on what actually caused a
false from to end up there.....
Rainer
Am 28.03.2011 16:05, schrieb Alvaro Herrera:
> Rainer, any idea? Please see
> http://archives.postgresql.org/message-id/4d906269.6060...@commandprompt.com
>
>
> Excerpts from Alvaro Herrera's message of
I digged into my sent folder,
and the outgoing message already dat the false headers.
So probably my MUA (thunderbird) got confused on something and caused
that blunder.
Sorry for that
Rainer
Am 28.03.2011 16:05, schrieb Alvaro Herrera:
> Rainer, any idea? Please see
>
ver investigated this, because I thought that Postgres was not supposed to
support the Standby mode, since a database server normally runs 24 hour a day.
Rainer
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pg
fault number : 101.
I guess the last question in the Windows FAQ is answering your question:
<http://wiki.postgresql.org/wiki/Running_%26_Installing_PostgreSQL_On_Native_Windows>
Rainer
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
Hello Bruce,
Thursday, November 20, 2008, 3:20:42 PM, you wrote:
BM> Rainer Bauer wrote:
>> I have reported this bug about a month ago:
>> <http://archives.postgresql.org/pgsql-bugs/2008-10/msg00026.php> but never
>> got
>> any response.
BM> Yep, we know it
;
>in freebsd i have no this bug.
I have reported this bug about a month ago:
<http://archives.postgresql.org/pgsql-bugs/2008-10/msg00026.php> but never got
any response.
Rainer
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
I wrote:
>I have read <http://www.postgresql.org/docs/8.3/static/locale.html> and
><http://www.postgresql.org/docs/8.3/static/functions-formatting.html>. But
>setting LC_NUMERIC has no effect: it always returns "1.3" instead of "1,3"
>(see ouput f
The following bug has been logged online:
Bug reference: 4454
Logged by: Rainer Bauer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.4
Operating system: WinXPSP3
Description:LC_MESSAGES and LC_NUMERIC not working on Windows
Details:
Hello,
This is an
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hello Tom,
On 4 Sep 2008 at 12:53, Tom Lane wrote:
>
> "Rainer Glueck" <[EMAIL PROTECTED]> writes:
> > How can backslashes be stopped from escaping themselves in like-statements
>
> Use ESCAPE ''. There
tatement, which I do not need in the case of an equal:
this works fine, too:
select * from tbl_test_escaping where
test_comment like '%<\''\>%' escape '';
I'm just looking for any way of configuration where I get this behaviour
but have not to add the esca
The following bug has been logged online:
Bug reference: 4398
Logged by: Rainer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.3.3 /b1400
Operating system: Windows XP
Description:Backslashes get escaped despite of backslash_quote=off
Details:
Subject to
;
Maybe Magnus or some other Win32 hacker can shed some light on it.
Rainer
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
ck if Autovacuum should
ever crash again. What value do you want it to be?
And should I also adjust log_min_error_statement or any other setting (I have
enough space left on the log partition, so there shouldn't be a problem).
Rainer
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
The following bug has been logged online:
Bug reference: 3427
Logged by: Rainer Bauer
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.2.4
Operating system: WinXP SP2
Description:Autovacuum crashed server
Details:
Hello,
My server was running now without any
ter varying
date
inet
integer
name
numeric
oid
real
regproc
smallint
text
time without time zone
timestamp with time zone
xid
(22 rows)
Greetings,
Rainer
--
--
Rainer J. H. Brandt
Brandt & Brandt Computer GmbH
Emai
Peter Eisentraut schrieb:
Am Donnerstag, 3. Februar 2005 16:11 schrieb Rainer Frey:
A select should not lock a table even when it is not committed.
The SELECT obtains a read (shared) lock on the table, but the ALTER TABLE
requires a write (exclusive) lock. This is certainly necessary because
The following bug has been logged online:
Bug reference: 1459
Logged by: Rainer Frey
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Redhat Linux 9, Kernel 2.4.20-8, AMD Sempron 2500+, 1GB
RAM
Description:Connection hangs when other
onstrains are
exported is not coerect.
Postgres tries to import the tables in the wrong order.
Example:
Table A depends on table B.
Unfortunately table B will be imported AFTER table A.
Result: table A will not be imported; the date from table A will not be importet.
Bye
Rainer Tammer
--
I posted this about 2 weeks ago and saw no further follow ups. Is this
timestamp thing not considered a bug? Or am I just doing something wrong?
Thanks,
--Rainer
> -Original Message-
> Sorry to reopen this issue but I still think there is a bug
> somewhere,
> perhaps
rom the code is (the computer's time was 03:23:49):
1850-Jan-01 03:23:49 JST
1850-Jan-01 06:23:49 JST
Thanks,
--Rainer
SimpleDateFormat format = new SimpleDateFormat( "-MMM-dd hh:mm:ss zz" );
Calendar cal = new GregorianCalendar();
cal.set( 1850, 00, 01 );
jav
problem is having
a check, in our code, to see if the dates are earlier than Postgres' magic
cutoff day, and, if so, do timezone fixes. This is bad. Is there a better
way. Is there, perhaps, a bug in the JDBC driver?
Thanks,
--Rainer
---(e
accounted for. Specifically, if I insert (via JDBC) '1-Jan-1900 :00:00:00'
and then select it back out I get '31-Dec-1900:15:00:00'. This is not a good
thing.
Should I enter a new bug?
Thanks,
--Rainer
> -Original Message-
> From: [EMAIL PROTECTED]
> [mail
I saw the problem in 2 different (but mirrored and therefore identical)
7.1.2 databases. The data was created in the db before 7.1.2 but it has
since been upgraded and the dump was via 7.1.2. Was the bug in the dump code
or did it have to do with db creation?
Thanks,
--Rainer
> -Origi
I posted yesterday regarding a memory leak I found in the JDBC driver in
7.1. I didn't check but it is quite likely it also existed in 7.0. The patch
I created hasn't been checked by anyone else yet so I don't know if it helps
for others or not. Feel free to try it.
--Rainer
Sorry that I have no answer but I just loved this line...
> Even if I type it slowly and hit the keys very hard.
--Rainer
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
y guess is that some part of Postgres' UTF-8 conversion routines are
wrong. I looked at the code but couldn't find the relavant parts.
I hope this is clearer.
Thanks,
--Rainer
> -Original Message-
> From: Peter T Mount [mailto:[EMAIL PROTECTED]]
> Sent: Friday, April
I noticed that 7.1 has officially been released. Does anyone know the status
of the bug I reported regarding encoding problems when dumping a 7.0 db an
restoring on 7.1?
Thanks,
--Rainer
---(end of broadcast)---
TIP 2: you can get off all lists
I tried to submit the results of my regression tests and got this:
Warning: PostgreSQL query failed: ERROR: parser: parse error at or near "t"
in
/home/projects/pgsql/developers/vev/public_html/regress/regress.php on line
359
Database write failed.
--Rainer
ocal/pgsql
/bin/pg_encoding: undefined symbol: pg_char_to_encoding
initdb: pg_encoding failed
Perhaps you did not configure PostgreSQL for multibyte support or
the program was not successfully installed.
--Rainer
---(end of broadcast)---
TIP 5
trace (and lack of line numbers) but the
rest of it shouldn't matter. BTW, I am using the new 7.1 JDBC driver.
I'll try to look at the Java code tomorrow but I'm hoping someone
already has a fix.
--Rainer
.
Best regards,
--Rainer
date;
}
Best regards,
--Rainer
Hi, here's a bug report.
Below is a reply to a message I posted on pgsql-admin. I'm quoting it to
demonstrate that others have also seen this bug. Below it is my original
message regarding the bug.
--Rainer
-Original Message-
From: Paul Breen [mailto:[EMAIL PROTEC
this form.
POSTGRESQL BUG REPORT TEMPLATE
Your name : Rainer Tammer
Your email address : [EMAIL PROTECTED]
System Configuration
-
Ar
36 matches
Mail list logo
