On Saturday 27 February 2010 @ 22:18, Greg Smith wrote:
> Ed L. wrote:
> > 2010-02-27 20:11:10.426 CST [23134]LOG: database system
> > was not properly shut down; automatic recovery in progress
> > 2010-02-27 20:11:10.497 CST [23134]LOG: record with
> > zero length at 8BC/63F6020 2010-02-
Ed L. wrote:
2010-02-27 20:11:10.426 CST [23134]LOG: database system was not properly
shut down; automatic recovery in progress
2010-02-27 20:11:10.497 CST [23134]LOG: record with zero length at
8BC/63F6020
2010-02-27 20:11:10.497 CST [23134]LOG: redo is not required
If the
Need some help.
My PostgreSQL 8.3.6 and now 8.3.9 postmaster is hanging.
No idea why, been running like a top for a year.
Can't do "select version()", even hung after system reboot.
SIGINT/QUIT/TERM have no effect, only SIGKILL can stop it.
This is Linux 2.6.18-92.1.22.el5 SMP x86_64
Here's
On Feb 27, 2010, at 12:25 AM, Greg Smith wrote:
So far, if anybody has done that, they're not talking about it and/
or not releasing it as open-source that I know of.
Thanks Greg, it's good to get confirmation of this. I can certainly
understand how implementing this feature to a point tha
Hiroshi Inoue wrote:
> Bruce Momjian wrote:
> > Hiroshi Inoue wrote:
> >> Bruce Momjian wrote:
> >>> Where are we on this issue?
> >> Oops I forgot it completely.
> >> I have a little improved version and would post it tonight.
> >
> > Ah, very good. Thanks.
>
> Attached is an improved version.
Hello,
Due to lack of support for partial (conditional) multi-column foreign
keys in 8.3, can before-triggers be used to implement them in terms of
data consistency and speed?
Thanks.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
seil...@so-net.net.tw writes:
> Data type of table1.c1 is bytea. That column stores binary data. The
> following matchings do not work. What is the right syntax?
> TIA
> CN
> ---
> select c1 ~ E'\000' from table1;
> select c1 LIKE E'%\000%' from table1;
> ERROR: invalid byte sequenc
2010/2/27 :
> Hi!
>
> I am trying to replace characters '\r', '\n', or '\t' with space character '
> '. As an example, I want string "A\t\n\rB" becomes "AB". The following
> statement seems to be not working. What mistake have I made?
>
> TIA
>
> CN
>
>
> select regexp_replace(E'A\r\n\
seil...@so-net.net.tw wrote:
> Data type of table1.c1 is bytea. That column stores binary data. The
> following matchings do not work. What is the right syntax?
>
> TIA
> CN
> ---
> select c1 ~ E'\000' from table1;
> select c1 LIKE E'%\000%' from table1;
selection position(E
2010/2/26 Anton Maksimenkov :
> When I try it in pgAdmin, first time it show me error:
> --
> ERROR: value out of range: underflow
> CONTEXT: PL/pgSQL function "myf_convert_phone18digits" line 12 at assignment
> --
> SECOND (and consequences) time it works and just show result
> 77150600
Hi!
I am trying to replace characters '\r', '\n', or '\t' with space character ' '.
As an example, I want string "A\t\n\rB" becomes "AB". The following statement
seems to be not working. What mistake have I made?
TIA
CN
select regexp_replace(E'A\r\n\tB',E'[\r\n\t]',' ');
regexp_rep
Hi!
Data type of table1.c1 is bytea. That column stores binary data. The following
matchings do not work. What is the right syntax?
TIA
CN
---
select c1 ~ E'\000' from table1;
select c1 LIKE E'%\000%' from table1;
ERROR: invalid byte sequence for encoding "UTF8": 0x00
HINT: This e
Bill Karwin wrote:
When I searched for a solution for PostgreSQL, Gurjeet Singh's name
came up as the designer of an index adviser patch for PG. But the
latest information I found was in 2007.
Sort of. That was originally written by Kai-Uwe Sattler:
http://archives.postgresql.org/pgsql-pat
Marc G. Fournier wrote:
We are mainly a nagios / cacti environment, and I came across...
Why start with Cacti then? There's way more Nagios integration
available; the little check_pgsql that comes with it (I think it's still
there), and the whole list at
http://exchange.nagios.org/directory
14 matches
Mail list logo
