2008/2/22, Simon Riggs <[EMAIL PROTECTED]>:
> On Thu, 2008-02-21 at 08:01 +0600, Markus Bertheau wrote:
> >
> > Section 24.3.3.1 states about restore_command:
> >
> > "The command will be asked for file names that are not present in the
> > a
(I sent this to -docs already, but it didn't get through for some reason.)
>From the current 8.3 docs:
Section 24.3.3.1 states about restore_command:
"The command will be asked for file names that are not present in the
archive; it must return nonzero when so asked."
Section 24.4.1 further stat
The following bug has been logged online:
Bug reference: 1531
Logged by: Markus Bertheau
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Linux FC3
Description:rotated log truncation broken
Details:
The log truncation is broken for me
The following bug has been logged online:
Bug reference: 1495
Logged by: Markus Bertheau
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.0.1
Operating system: Fedora Core 3
Description:RPM: wrong quoting of error message about old database
format after
Ð ÐÑÐ, 05.11.2004, Ð 16:46, Tom Lane ÐÐÑÐÑ:
> Markus Bertheau <[EMAIL PROTECTED]> writes:
> > Guess what happend here:
> > [EMAIL PROTECTED] pg80]$ bin/pg_ctl -D data -l log start
> > postmaster starting
> > [EMAIL PROTECTED] pg80]$
>
> > No, postmast
course in the log file, but pg_ctl should have
said that the postmaster did not start successfully.
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 8: explain analyze is your friend
key violation should include the schema of the
involved relation.
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
confort.
> Thank for the great work.
> Postgresql is really a wonderfull thing.
> Andrea from Italy
>
> ---(end of broadcast)---
> TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
--
Markus Bert
gt; possible system security compromise. See the documentation for
> more information on how to properly start the server.
> child process was terminated by signal 1
--
Markus Bertheau <[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 3: if
Ð ÐÑÐ, 23.07.2004, Ð 14:02, Peter Eisentraut ÐÐÑÐÑ:
> Am Freitag, 23. Juli 2004 11:49 schrieb Markus Bertheau:
> > Do the following in an installation initdb'd in ru_RU.KOI8-R (It doesn't
> > happen if you initdb'd with UTF-8). You need to run psql in a locale
\i dump.sql
-- here you have to set client_encoding if you chose ru_RU.KOI8-R as the
locale for psql
-- set client_encoding to koi8r;
select * from example_objects where name = 'ÐÑ';
dump.sql is attached, the select statement is included in UTF-8.
Let me know if anything is missing.
ects where name='ÐÑ';
>
> And I recieve the felouwing result set:
>
> object_idname
> 185 ÐÑ
> 574 ÐÑ
I cannot reproduce this. Can you give a self-contained reproducible
example? What is the output of pg_controldata $PGD
rror: `work_mem' undeclared (first use in this function)
xpath.c:653: error: (Each undeclared identifier is reported only once
xpath.c:653: error: for each function it appears in.)
I haven't found a declaration of work_mem anywhere in /usr/include/pgsql
- what am I doing wrong?
--
Markus B
Ð ÐÐÐ, 14.06.2004, Ð 17:25, Tom Lane ÐÐÑÐÑ:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Markus Bertheau wrote:
> >> oocms=# select 'Ñ' ~ '^\\w$';
> >> ?column?
> >> --
> >> f
> >> (1 ÑÑ)
>
oocms=# select 'Ñ' ~ '^\\w$';
?column?
--
f
(1 ÑÑ)
or
oocms=# select 'Ã' ~ '^\\w$';
?column?
--
f
(1 ÑÑ)
both should return true, as does
oocms=# select 'n' ~ '^\\w$';
?column?
--
64) at pg_autovacuum.c:1004
#2 0x40103657 in __libc_start_main (main=0x804a8e4 , argc=1, ubp_av=0xbfffdf64,
init=0x8048b30 <_init>,
fini=0x804afd0 <_fini>, rtld_fini=0x4000dcd4 <_dl_fini>, stack_end=0xbfffdf5c) at
../sysdeps/generic/libc-start.c:129
(gdb)
This is on a i38
.
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list
В Срд, 02.07.2003, в 23:17, Ian Barwick пишет:
> On Wednesday 02 July 2003 00:37, Markus Bertheau wrote:
> > В Срд, 02.07.2003, в 00:27, Ian Barwick пишет:
> > > On Tuesday 01 July 2003 11:01, Wehrle, Daniel wrote:
> > > > Statement:
> > > > SELECT ID FRO
ODE character sequence found (0xc000)
> >
> > Has PostgreSQL a problem with the characters "z_"?
>
> I would doubt it. Can you reproduce this problem with a
> different client, e.g. psql? I have tried using psql on 7.3.2 and 7.4a
> but see no problems.
I ca
On Sun, 2002-09-08 at 21:19, Markus Bertheau wrote:
> I got a sig 11 in an apache child process:
This time with debug symbols:
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1024 (LWP 6943)]
0x403e5425 in _efree (ptr=0x83d7154) at ../../Zend/zend_alloc.c:226
22c) at
../sysdeps/generic/libc-start.c:129
(gdb)
Is that pgsqls fault, phps or apaches?
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
On Fri, 2001-12-14 at 23:31, Tom Lane wrote:
> It looks to me like your postmaster crashed because there were no free
> file descriptors left in the system:
Does 7.1 or 7.2 behave differently when confronted with such a
situation?
Markus Bertheau
msg03318/pgp0.pgp
Descriptio
fail.log
It is 13K.
Can someone tell me what happend and clarify the situation?
Thanks
Markus Bertheau
P.S. I will be reading email for around 1 hour from now on, after that
comes the weekend, and I don't have internet at home. So don't wonder if
I don't answer.
msg03305/p
On Tue, 2001-11-27 at 16:39, TONY J.Y. wrote:
> However, I got a fatal running error. There is an error when my SQL
> string length exceeds 8190 Bytes.
PostgreSQL 7.0.x and earlier have a restriction of 8k for a text field.
7.1.x doesn't. You should upgrade.
Markus Bertheau
On Wed, 2001-11-28 at 11:24, Vicktor wrote:
> Why not exists functions for convert any type to text?
> I can't find text(bool), text(numeric) ...
use type casting:
select column::text from table
after :: comes the type you want.
Markus Bertheau
msg03163/pgp0.pgp
Descr
e CY?) Before, and after it goes "normal", only at this
> interval goes mad. I've tried Postgresql 7.0, and 7.1.3 the bug still exist under
>Red Hat 7.1 in two different machines. I've tested under cygwin, there is NO SUCH BUG!
> At request I can send you t
26 matches
Mail list logo
