[GENERAL] Hints for postgresql package recompilation (FIXED)

FIXED!! compilation needs a non root user (initdb complains about root during tests )... regards, Angel # Hi, We are trying to deploy an OpenBravo installation on OpenSuSE 11.2 X64 and are using Postgresql 8.4.2-1.1.1 as the data backend, but

Re: [GENERAL] tup_returned/ tup_fetched

> -- > > Gregory Stark > > EnterpriseDB http://www.enterprisedb.com > > Get trained by Bruce Momjian - ask me about EnterpriseDB's > > PostgreSQL training! > > > > -- No imprima este correo si no es necesario. El medio ambiente está en nuestras manos. ___

[GENERAL] ProblemWithCharsOSX

Hi there, This is my first post in the list. I'm a PostgreSQL user in the linux world but at the office there is a Mac computer and I have a problem with postgres in it. The problem is when I use characters with tildes in spanish like in the follow word "países". The next is ilustrates my problem

Re: [GENERAL] Annoying Reply-To

, as not all of the previous 4 options works as expected. For me this makes postgres lists the most complete about the RFC. So is about, thunderbird to move forward one step, not to cripple standars back. In fact this remembers me the M$ way o

Re: [GENERAL] Annoying Reply-To

. Regards, Angel El Jueves 23 Octubre 2008 Collin Kidder escribió: > Angel Alvarez wrote: > > What's such most advanced mail reader?? > > > > No one, ive seen, seems to be perfect nor thunderbird. > > By the way kmail has 4 options (reply, reply to all, reply to autho

Re: [GENERAL] nearest neighbor search from xyz coordinates

of points seems to be faster than trying all points blindy (despite of being indexed). -- ->>--- Clist UAH a.k.a Angel -[www.uah.es]-<<-- "" -- Sent via pgsql-general mailing list (pgsql

[GENERAL] schema or catalog? what's the diference?

; for public schema REATE SCHEMA public AUTHORIZATION postgres; GRANT ALL ON SCHEMA public TO postgres; GRANT ALL ON SCHEMA public TO public; COMMENT ON SCHEMA public IS 'Standard public schema'; regards, Angel -- No imprima este correo si no es necesario, necesitará el dinero del

[GENERAL] Many temporal schemas appearred on my DB

oing DROPS by hand? Thanks, Angel -- No lea este correo si no es necesario. El buen ambiente está en nuestras manos. ->>--- Clist UAH a.k.a Angel -[www.uah.es]-<<-- Tú lo compras, yo lo copio. Todo lega

Re: [GENERAL] Many temporal schemas appearred on my DB

El Jueves, 25 de Diciembre de 2008 Martijn van Oosterhout escribió: > On Thu, Dec 25, 2008 at 04:57:10PM +0100, Angel Alvarez wrote: > > Hi > > > > up to 5 chemas... pg_temp_n for (n=1..5) appearred on my pg 8.3 DB. > > > > pgadmin3 refuses to drop them so i

[GENERAL] unsuscribe

unsuscribe __ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! ¡Abrí tu cuenta ya! - http://correo.yahoo.com.ar ---(end of broadcast)--- TIP 2: you can get off all lists at

[GENERAL] pg_hba.conf

nts of the pg_hba.conf file are   hostssl  dnet  att 172.16.13.40 255.255.255.255  trust   thanks     Angel T. Todorov PGP public key ID: 1024D/35454B4C  

[GENERAL] Greetings, Thinking about converting

Hi, I have a database with the 2 principal tables using 716,819 rows and 43,157,442 rows each one, related each one, I have some triggers and stored procedures and views having a frontend made in Visual Basic using ODBC and ADO to connect to the database, Im considering to move from Microsof

Re: [GENERAL] Greetings, Thinking about converting

share as I see.. but, OS and hardware appart, what about the MSSQL vs MySQL vs PostgreSQL discussion. what you think ? Speed is what I am lookin for - Original Message - From: "GH" <[EMAIL PROTECTED]> To: "Miguel Angel Heredia" <[EMAIL PROTECTED]> Cc: <[E

Re: [GENERAL] Re: Warning: database postgres must be vacuumed within 1000000 transactions

w.postgresql.org/mailpref/pgsql-general > -- ISC Miguel Angel Hernandez Moreno

[GENERAL] problems with pg_restore and java

.getRuntime().exec(comando,env);* <---Error in windows InputStream es = p.getErrorStream(); arch.muestraSalidaDeError(es); } catch (IOException ex) { Logger.getLogger(gPrincipal.class.getName()).log(Level.SEVERE, null, ex); } I use my env variable to enter the password of postgres -- ISC Miguel Angel Hernandez Moreno

Re: [GENERAL] problems with pg_restore and java

alue of my variables comando=: "C:\Program Files\pgAdmin III\1.12\pg_restore.exe" -h 192.170.1.89 -d postgres -U postgres -v -1 "C:\Users\Miguel\Documents\NetBeansProjects\ env[0]=PGPASSWORD=postgres 2011/9/8 Merlin Moncure > On Thu, Sep 8, 2011 at 10:45 AM, Miguel Angel Hernande

Re: [GENERAL] problems with pg_restore and java

sorry comando=: "C:\Program Files\pgAdmin III\1.12\pg_restore.exe" -h 192.170.1.89 -d postgres -U postgres -v -1 "C:\Users\Miguel\Documents\ NetBeansProjects\file.backup" 2011/9/8 Miguel Angel Hernandez Moreno > Sorry > > This is the error that sends me

Re: [GENERAL] problems with pg_restore and java

If I leave the trust authentication server, the program runs correctly. change is that the exec () does not add the env variable 2011/9/8 Miguel Angel Hernandez Moreno > sorry > > > comando=: "C:\Program Files\pgAdmin III\1.12\pg_restore.exe" -h > 192.170.1.89 -d postg

[GENERAL] tipo de dato

disculpen alguien tiene o sabe de algun documento que me pueda ayudar para defender la idea de que los tipos de datos si afectan en la velocidad de una consulta por ejemplo. tengo un tipo de dato timestamp y un numerico y lo que quiero dar a entender es que una consulta con un numerico con un ti

[GENERAL] recuperar nodo en estado 3

tengo un problema ya habia replicado los datos en las BD 2010-03-11 19:23:58 DEBUG: pid 8252: starting health checking 2010-03-11 19:23:58 DEBUG: pid 8252: health_check: 0 th DB node status: 1 2010-03-11 19:23:58 DEBUG: pid 8252: health_check: 1 th DB node status: 3 2010-03-11 19:24:28 DEBUG: pid

[GENERAL] exporting table for load into oracle

hi everybody first, it is not that i'm migrating from postgresql to oracle, it's just that we have a payroll system (we are a software development company) that currently runs on postgresql, but the goal is that it runs on other databases too (for our internal needs it runs on postgresql, and tw

[GENERAL] inherited type

Hi, I am working with inheritance in postgresql 7.4. If I create a table named A, and another named B that inherits from A, if I perform a query such a "SELECT * FROM A" (without ONLY clause), how can I get the type (identifier from pg_type) of the returned records?? Thanks in advance. -- --

[GENERAL] last tuple affected

Hi all! Two related questions about a problem i'm trying to solve: How can I know the last tuple affected by an insert/update operation per table?? Is there exists any function in Postgres for retrieving some hash value from a table?? Thanks in advance. -- Miguel Ángel Tribaldos -

Re: [GENERAL] last tuple affected

I only need to know if a table has changed since the last check (create, update...), but I want to avoid a trigger + artificial records table. Is this information recorded somewhere, in a system table perhaps? What about a hash value refered to any table? Thanks. >>Miguel Angel Tri

[GENERAL] Import SVG file

Hi, how can I import a SVG file to a row?? The main problem is that it has many postgres scape symbols. Can I utilize the 'text' type for that? Have I to do some byte-stuffing before the import? Thanks -- Miguel A. Tribaldos ---(end of broadcast)---

Re: [GENERAL] Import SVG file

I want to do the import from the psql client. ... Something like that: -- ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [GENERAL] Import SVG file

rectly escaped. Best regards. -- Miguel A. Tribaldos >Miguel Angel Tribaldos Hervas wrote: >> Hi, >> >> how can I import a SVG file to a row?? The main problem is that it has many >> postgres scape symbols. Can I utilize the >> 'text' type for that? >&g

[GENERAL] [OT] Problem starting pgsql on windows 2000 server

hi, maybe it's not the right place to ask this, but hope somebody can helpme. i've downloaded the "peer direct" pgsql version for windows, and i've installed it on windows 200 professional and server with no problems until now. yesterday we installed it on a customer's server with windows 2000

[GENERAL] jdbc driver with BigDecimal patch

hi, i'm having trouble with the BigDecimal bug in the jdbc driver using jbuilder 4 and wonder if some body has a compiled version of the jdbc with the patch applied and if i can download it thanks in advance and best regards. ---(end of broadcast)