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
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:
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
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]',' ');
2010/2/26 Anton Maksimenkov anton...@gmail.com:
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
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
2010/2/27 seil...@so-net.net.tw:
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
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 sequence for
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:
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.
FYI, I am working on
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
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
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
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-27
14 matches
Mail list logo
