Re: [GENERAL] Question on the use of bracket expressions in Postgres

On Dec 15, 2005, at 0:29 , Jimmy Rowe wrote: select * from catalog where file_name like 'abc%def%.200[2-5]%'; The following select keeps returning "(0 rows)". LIKE doesn't consider [2-5] to be a range, but rather the literal characters '[2-5]'. If you're looking for regex, take a lo

[GENERAL] Question on the use of bracket expressions in Postgres

Good morning, I am new to Postgres and I have one question. I am trying to get the following select command to work. select * from catalog where file_name like 'abc%def%.200[2-5]%'; The following select keeps returning "(0 rows)". I know that there are many rows in my database that s

Re: [GENERAL] Installing the latest 8.1.1 rpms question.

On Dec 14, 2005, at 3:15 AM, Richard Huxton wrote: Jerry LeVan wrote: Hi, I just downloaded the 8.1.1 rpms for FC4 from postgresql.org. It appears that removing the existing rpms will require also removing a number of dependencies. (That what Synaptics asserts...) Is it possible to use a "rpm

Re: [GENERAL] Multi-row update w. plpgsql function

Aaron Koning wrote: This might be easier to use this SQL: UPDATE message_table SET status = 'A' WHERE mid IN (1,2,3); The following might work for Cocoon (never used it): UPDATE message_table SET status = 'A' WHERE mid IN (); Aaron On 12/13/05, Daniel Hertz <[EMAIL PROTECTED]> wrot

[GENERAL] unsubscribe pgsql-genera

unsubscribe pgsql-genera  

[GENERAL] New RPM sets are available for download

- PostgreSQL New RPM Sets 2005-12-15 Versions: 8.1.1, 8.0.5, 7.4.10, 7.3.12 Set labels: 8.1.1-1PGDG, 8.0.5-1PGDG, 7.4.10-1PGDG, 7.4.10-2PGDG, 7.3.12-1PGDG -

Re: [GENERAL] outdated (bad) information in pg_stat_activity

I too have had issues with "stuck" entries in the pg_stat_activity view -- the real pid is long gone but postgres still thinks the process is there. It would be real sweet to have a way of cleaning this table with bringing postgres off-line. My $0.02 worth ... Greg Williamson DBA GlobeXplorer

Re: [GENERAL] Recuperar Base de datos

On 12/14/05, Juan Jose Siles Salinas <[EMAIL PROTECTED]> wrote: > Hola tengo un problema serio, my servidor de bases de datos se arruino y no > saque copia de mi base de datos, he instalado otro servidor con las mismas > caracteristicas pero como hago para recuperar toda la base de datos del > ante

Re: [GENERAL] "incomplete startup packet" on SGI

David Rysdam wrote: Tom Lane wrote: David Rysdam <[EMAIL PROTECTED]> writes: Just finished building and installing on *Sun* (also "--without-readline", not that I think that could be the issue): Works fine. So it's something to do with the SGI build in particular. More likely it's

Re: [GENERAL] outdated (bad) information in pg_stat_activity

[EMAIL PROTECTED] (hubert depesz lubaczewski) writes: > On 12/14/05, Tom Lane <[EMAIL PROTECTED]> wrote: > > > hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > > my pg_stat_activity is raporting process working on a query for 12 > hours > > straight! (query_start). >

[GENERAL] Debug user lib for user define data type

Hi,   I am writing a user defined data type in C and want to debug the lib I am creating for this data type. Wondering if somebody knows how to link and debug this lib or any document which can help me to do this? Can I debug this lib without compiling the PostgreSQL source code?   I use

Re: [GENERAL] Recuperar Base de datos

Juan Jose Siles Salinas wrote: Hola tengo un problema serio, my servidor de bases de datos se arruino y no saque copia de mi base de datos, he instalado otro servidor con las mismas caracteristicas pero como hago para recuperar toda la base de datos del anterior disco ---

[GENERAL] Recuperar Base de datos

Hola tengo un problema serio, my servidor de bases de datos se arruino y no saque copia de mi base de datos, he instalado otro servidor con las mismas caracteristicas pero como hago para recuperar toda la base de datos del anterior disco 1GB gratis, Antivirus y Antispam Correo Yahoo!, el mejor

Re: [GENERAL] to_char() Question

Bruno, Thanks for the response. The only problem is that FM removes all the leading spaces. I may have been unclear in stating my problem. I want the padding on the left; however, I don't want the extra space for the sign (+,-) that gets prepended to the string. This output shows what I mean:

Re: [GENERAL] to_char() Question

On Tue, Dec 13, 2005 at 11:30:36 -0500, Terry Lee Tucker <[EMAIL PROTECTED]> wrote: > > On Tuesday 13 December 2005 11:20 am, John Sidney-Woollett saith: > > Not sure if there is a numeric formatting option that allows what you want. > > > > But how about? > > > > substr(to_char(1029, '9,999'),2

Re: [GENERAL] Release 8.1.1 for Fedora X 64bits

[EMAIL PROTECTED] ("Alejandro D. Burne") writes: > Hi, I'll be watching on ftps without success. There is a release > date for 8.1.1? Version 8.1.1 looks pretty released to me... It's listed as the official "latest release" on -- output = reverse("gro.mca" "@" "enwor

Re: [GENERAL] outdated (bad) information in pg_stat_activity

On 12/14/05, Tom Lane <[EMAIL PROTECTED]> wrote: hubert depesz lubaczewski <[EMAIL PROTECTED]> writes:> my pg_stat_activity is raporting process working on a query for 12 hours> straight! (query_start).> 2 problems: > 1. this particular query runs typically between 80 and 200 miliseconds!> 2. procp

Re: [GENERAL] Release 8.1.1 for Fedora X 64bits

On 12/14/05, Leonel Nunez <[EMAIL PROTECTED]> wrote: > Jaime Casanova wrote: > > >On 12/14/05, Alejandro D. Burne <[EMAIL PROTECTED]> wrote: > > > > > >>Hi, I'll be watching on ftps without success. There is a release date for > >>8.1.1? > >> > >> > >> > > > >Yes... the announce was made yesterday.

Re: [GENERAL] Release 8.1.1 for Fedora X 64bits

Jaime Casanova wrote: On 12/14/05, Alejandro D. Burne <[EMAIL PROTECTED]> wrote: Hi, I'll be watching on ftps without success. There is a release date for 8.1.1? Yes... the announce was made yesterday... 8.1.1 is officially released... -- regards, Jaime Casanova (DBA: DataBase Aniq

Re: [GENERAL] Release 8.1.1 for Fedora X 64bits

Hi, On Wed, 2005-12-14 at 13:59 -0300, Alejandro D. Burne wrote: > Hi, I'll be watching on ftps without success. There is a release date > for 8.1.1? 8.1.1 RPMs for FC3-x86_64 and FC4-x86_64 have been uploaded 4 days before; however it seems that we have a problem with syncing. We are fixing it;

Re: [GENERAL] Release 8.1.1 for Fedora X 64bits

On 12/14/05, Alejandro D. Burne <[EMAIL PROTECTED]> wrote: > Hi, I'll be watching on ftps without success. There is a release date for > 8.1.1? > Yes... the announce was made yesterday... 8.1.1 is officially released... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) --

[GENERAL] Release 8.1.1 for Fedora X 64bits

Hi, I'll be watching on ftps without success. There is a release date for 8.1.1?

Re: [GENERAL] Improving Availability

Hi Scott, hi Richard, On 14.12.2005, at 17:30 Uhr, Scott Marlowe wrote: This setup I'm talking about would have pgpool on each db server. If you meant pgpool running on both application servers, that would work fine with slony in the background and pgpool in load balancing mode, or with p

Re: [GENERAL] Improving Availability

On Wed, 2005-12-14 at 10:29, Scott Marlowe wrote: > On Wed, 2005-12-14 at 10:19, Guido Neitzer wrote: > > On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote: > > > > > I'd be tempted to look at pgpool sitting between your application > > > and the database, and then replication from the one machi

Re: [GENERAL] Improving Availability

On Wed, 2005-12-14 at 10:19, Guido Neitzer wrote: > On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote: > > > I'd be tempted to look at pgpool sitting between your application > > and the database, and then replication from the one machine to the > > other. > > Right, I thought the same, BUT:

Re: [GENERAL] Improving Availability

Guido Neitzer wrote: On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote: I'd be tempted to look at pgpool sitting between your application and the database, and then replication from the one machine to the other. Right, I thought the same, BUT: I have two application servers (one on each mach

Re: [GENERAL] Improving Availability

On 14.12.2005, at 16:46 Uhr, Richard Huxton wrote: I'd be tempted to look at pgpool sitting between your application and the database, and then replication from the one machine to the other. Right, I thought the same, BUT: I have two application servers (one on each machine) connecting to

Re: [GENERAL] ANN: PgBrowse 1.4

Jerry LeVan wrote: PgBrowse ver 1.4 is a generic Postgresql database browser that works on Windows, Macintosh and Linux platforms that is written in Tcl/Tk. A Starpack is available for Linux/x86 and an application bundle is available for MacOSX. Sounds interesting. In the future please send an

Re: [GENERAL] Improving Availability

Guido Neitzer wrote: Hi. I have two server boxes (Apple Xserve G5). WebServers and applications are installed on both machines, the load is distributed by a loadbalancer to both machines. How can I make a setup in a way that the database is also tolerant against failure? What I actually nee

Re: [GENERAL] Improving Availability

Guido Neitzer wrote: Hi. I have two server boxes (Apple Xserve G5). WebServers and applications are installed on both machines, the load is distributed by a loadbalancer to both machines. How can I make a setup in a way that the database is also tolerant against failure? What I actually

Re: [GENERAL] outdated (bad) information in pg_stat_activity

hubert depesz lubaczewski <[EMAIL PROTECTED]> writes: > my pg_stat_activity is raporting process working on a query for 12 hours > straight! (query_start). > 2 problems: > 1. this particular query runs typically between 80 and 200 miliseconds! > 2. procpid of this backend does not exists anymore in

[GENERAL] Improving Availability

Hi. I have two server boxes (Apple Xserve G5). WebServers and applications are installed on both machines, the load is distributed by a loadbalancer to both machines. How can I make a setup in a way that the database is also tolerant against failure? What I actually need is a mechanism th

Re: [GENERAL] valgrind output

Martijn van Oosterhout writes: > On Wed, Dec 14, 2005 at 02:43:16PM +0530, surabhi.ahuja wrote: >> i have a test runner and i am using valgrind to analyse memory leak: > Well, given that that all appears to be C++ code and psql doesn't > include any C++ code, it would appear to be Terra's problem

Re: [GENERAL] "incomplete startup packet" on SGI

Tom Lane wrote: David Rysdam <[EMAIL PROTECTED]> writes: Just finished building and installing on *Sun* (also "--without-readline", not that I think that could be the issue): Works fine. So it's something to do with the SGI build in particular. More likely it's something to do with

[GENERAL] outdated (bad) information in pg_stat_activity

hi my pg_stat_activity is raporting process working on a query for 12 hours straight! (query_start). 2 problems: 1. this particular query runs typically between 80 and 200 miliseconds! 2. procpid of this backend does not exists anymore in system i found this: http://www.issociate.de/board/post/264

[GENERAL] ANN: PgBrowse 1.4

PgBrowse ver 1.4 is a generic Postgresql database browser that works on Windows, Macintosh and Linux platforms that is written in Tcl/Tk. A Starpack is available for Linux/x86 and an application bundle is available for MacOSX. What is new in 1.4? o Fixed a bug where fields greater than 200 chara

Re: [GENERAL] Memory Leakage Problem

Martijn Thanks for the tip. Since the connections on this server are from slon, I'm hoping that they hand around for a *long* time, and long enough to take a look to see what is going on. John Martijn van Oosterhout wrote: On Tue, Dec 13, 2005 at 04:37:42PM -, John Sidney-Woollett wrot

Re: [GENERAL] valgrind output

On Wed, Dec 14, 2005 at 02:43:16PM +0530, surabhi.ahuja wrote: > Hi > i have a test runner and i am using valgrind to analyse memory leak: > i use is as follows: > > valgrind --tool=memcheck --leak-check=yes --log-file=op ./dbExpressInstall > -r "dbexpress" -s "/gsp-dist/blr/developer/surabi/i

Re: [GENERAL] timestamp <-> ctime conversion question...

Martijn van Oosterhout wrote: On Tue, Dec 13, 2005 at 08:21:20PM +0100, Karsten Hilbert wrote: Presumably this would allow timestamps to be displayed with a timezone other than the current setting. *Display* of timestamptz values at arbitrary time zones is already possible using the "at time zo

Re: [GENERAL] timestamp <-> ctime conversion question...

On Tue, Dec 13, 2005 at 08:21:20PM +0100, Karsten Hilbert wrote: > > Presumably this would allow timestamps to be displayed with a > > timezone other than the current setting. > *Display* of timestamptz values at arbitrary time zones is > already possible using the "at time zone" syntax. Retrieving

Re: [GENERAL] Memory Leakage Problem

On Tue, Dec 13, 2005 at 04:37:42PM -, John Sidney-Woollett wrote: > I'll run this over the next few days and especially as the server starts > bogging down to see if it identifies the culprit. > > Is it possible to grab memory outsize of a processes space? Or would a > leak always show up by a

[GENERAL] valgrind output

Hi i have a test runner and i am using valgrind to analyse memory leak: i use is as follows:    valgrind --tool=memcheck --leak-check=yes --log-file=op ./dbExpressInstall -r "dbexpress" -s "/gsp-dist/blr/developer/surabi/images/mr/im152" 1 1 1   here is the output:    ==6214== ERROR SUMMARY:

Re: [GENERAL] Installing the latest 8.1.1 rpms question.

Jerry LeVan wrote: Hi, I just downloaded the 8.1.1 rpms for FC4 from postgresql.org. It appears that removing the existing rpms will require also removing a number of dependencies. (That what Synaptics asserts...) Is it possible to use a "rpm -Uvh *" to overwrite the existing 8.1.0 rpms from p

Re: [GENERAL] php + postgresql pg_connect problem

John Taber wrote: You are using "ident" authentication in your pg_hba.conf file. You probably don't want this. Start with trust if you are connecting locally, then turn passwords on once you are happy you can connect. Thks for directing me to the pg_hda file - I have made the changes - But I