PostgreSQL

Doesn't look like that's the problem. I moved my table over to another Linux box running PG 8.3 and update performance was pretty ba...

On Tue, Sep 30, 2008 at 1:21 PM, Rui Maximo < rmaximo@greenplum.com > wrote: > As we get closer to that date, could you share logi...

Alvaro Herrera wrote: > A customer of ours has been having trouble with corrupted data for some > time. Of course, we've almost a...

Chander Ganesan wrote: > Magnus Hagander wrote: > > > > We don't have a bug tracker, thus there is nothing to gather stat...

Bueno gente he encontrado un código hecho en Oracle y lo adapte a plpsql Les dejo el codigo de ejemplo: ------------------------------------...

2008/9/30 Daniel Ferrer < daniel.ferrer@ctd.com.ar >: > Buenas Tardes a todos: > Alguien tiene armada alg...

Podrias pegar la salida del error o el log? Fijate el enconding de la base también, en especial si compilaste el codigo. El día 30 de septie...

hola a todos   en DEBIAN estoy haciendo un programa en c++ con wxwidgets y con librerias  de C para conectarse a postgres (libpq )   e...

Claro como el agua! Gracias Alvaro! El día 30 de septiembre de 2008 17:03, Alvaro Herrera < alvherre@alvh.no-ip.org > escribió: > p...

postgres Emanuel CALVO FRANCO escribió: > entonces ... cual seria la funcion que inserta la imagen directamente > en la tabla? > o ...

copio a la lista porque le erré a la direccion.... entonces ... cual seria la funcion que inserta la imagen directamente en la tabla? o mejo...

On Tue, Sep 30, 2008 at 1:00 PM, Bill Thoen < bthoen@gisnet.com > wrote: > Working with PG 8.1 I'm trying to update a char(4) c...

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, Le 30 sept. 08 à 20:03, Tom Lane a écrit : > set_read_position(tupstore, &local_re...

Thanks to Scott and Taras for pointing me to the crosstab functions. I only had a quick look but they seem very helpful! Kind regards, Felix...

On Tue, 2008-09-30 at 13:00 -0600, Bill Thoen wrote: > Working with PG 8.1 I'm trying to update a char(4) column, and it's > t...

postgres Emanuel CALVO FRANCO escribió: > Entonces le quedaria usar > lo_read(PGconn *conn, int fd, char *buf, size_t len); > y lo_...

Entonces le quedaria usar lo_read(PGconn *conn, int fd, char *buf, size_t len); y lo_open ? por lo que si bien import lo que hace es devolve...

Carol Walter wrote: > Greetings, > > As you may be aware, we experienced a problem last week with pg_clogs > that had been delet...

On Tue, 30 Sep 2008, Heikki Linnakangas wrote: > Doesn't some filesystems include a per-block CRC, which would achieve the > same ...

Bill Thoen < bthoen@gisnet.com > schrieb: > Working with PG 8.1 I'm trying to update a char(4) column, and it's > takin...

> A customer of ours has been having trouble with corrupted data for some > time. Of course, we've almost always blamed hardware ...

On Tuesday 30 September 2008, Bill Thoen < bthoen@gisnet.com > wrote: > Working with PG 8.1 I'm trying to update a char(4) colu...

Alvaro Herrera wrote: > Initially I'm aiming at a CRC32 sum > for each block. FlushBuffer would calculate the checksum and store ...

Working with PG 8.1 I'm trying to update a char(4) column, and it's taking a very long time; 15 minutes so far and no end in sight. ...

Hello Alvaro, some random thoughts while reading your proposal follow... Alvaro Herrera wrote: > So we've been tasked with adding CRC...

Tom Lane wrote: > Chander Ganesan < chander@otg-nc.com > writes: > >> You should also understand that if you set checkpo...

On Tue, Sep 30, 2008 at 2:49 PM, Joshua Drake < jd@commandprompt.com > wrote: > On Tue, 30 Sep 2008 14:33:04 -0400 > "Jonah...

I might have to disagree here. I personally experienced a scenario where I had 500 MB of file space defined for my WAL log files and then a...

On Tue, 30 Sep 2008 14:33:04 -0400 "Jonah H. Harris" < jonah.harris@gmail.com > wrote: > > I'd like to submit this...

Alvaro Herrera wrote: > A customer of ours has been having trouble with corrupted data for some > time. Of course, we've almost a...

Chander Ganesan < chander@otg-nc.com > writes: > You should also understand that if you set checkpoint_segments to a > small num...

Alvaro Herrera < alvherre@commandprompt.com > writes: > The implementation I'm envisioning requires the use of a new relation ...

Buenas Tardes a todos: Alguien tiene armada alguna función para validar el CUIT (Clave Única de Identificación Tributaria) de Argentina. ...

*** a/src/backend/libpq/auth.c --- b/src/backend/libpq/auth.c *************** *** 126,134 **** char *pg_krb_realm = NULL; * MIT Kerber...

On Tue, Sep 30, 2008 at 2:02 PM, Alvaro Herrera < alvherre@commandprompt.com > wrote: > A customer of ours has been having trouble ...

----- Original Message ----- From: "Jaime Casanova" < jcasanov@systemguards.com.ec > To: "Edwin Quijada" < list...

I think you should look at crosstab contrib module. Regards, Taras Kopets On 9/30/08, Felix Homann < fexpop@onlinehome.de > wrote: ...

Finalmente he conseguido solucionarlo con una funcion. Gracias a todos los que me contestaron. -- ***************************************** ...

Jonny wrote: > Hi, > > I have installes Postgres 8.0.15 on a embedded Linux and have only 130 > MB for Postgres. > Is it poss...

Greg Stark < greg.stark@enterprisedb.com > writes: > On 24 Sep 2008, at 02:45, Tom Lane < tgl@sss.pgh.pa.us > wrote: >>...

A customer of ours has been having trouble with corrupted data for some time. Of course, we've almost always blamed hardware (and we...