Re: [GENERAL] [ADMIN] [HACKERS] retrieve statement from catalogs

Hi everybody, can anyone tell me if there's a way to retrieve the select instruction executed from the catalogs, or maybe via some structure in a trigger? The reason is that i have some selects constructed on-the-fly (just part of it) and i want to save that in a table in order to know what

[GENERAL][ADMIN][HACKERS]data fragmentation

is the solution you recommend? also i was thought that even when DBMS support dbspaces DELETEing records may cause data fragmentation anyway. so, can i think of DELETE statement as a double-edged sword? it is indifferent in pgsql - it doesn't support dbspaces anyway? thanks in advance, Jaime

[ADMIN] Raw devices vs. Filesystems

Can you tell me (or at least guide me to a palce where i can find the answer) what are the benefits of filesystems over raw devices? And what filesystem is the best for postgresql performance? _ The new MSN 8: advanced junk mail

Re: [ADMIN] Raw vs Filesystem

ok. if i don't misunderstand you (english is not my mother tongue, so i can be wrong). your point is that speed is not necesarily performance, that's right. so, the real question is what is the best filesystem for optimal speed in postgresql?

[ODBC] [ADMIN] psqlodbc problem?

and it give me the results. maybe aproblem of the odbc, if yes what solution can be. thanx in advance, Jaime Casanova _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail

[ADMIN] [admin] index in pk

hi all, there is a way to use my own index with pk constraint instead of the implicitly created one? why? just because i don't like the name, maybe can i change the generated name? thanx in advance, Jaime Casanova _ Help STOP SPAM

[ADMIN] binary fields

hi all, again. i can't find how can i store bynary fields (images, ¿¿pdfs?? is it possible?) in postgres. i'm using vb as frontend. any help?? thanx in advance, Jaime Casanova _ Tired of spam? Get advanced junk mail protection

Re: [ADMIN] [admin] index in pk

sorry if my questions are so primitive or show all my poor knowledge but ask is the way to find the right path. the dumber the question the smarter i will become. _ Add photos to your e-mail with MSN 8. Get 2 months FREE*.

Re: [ADMIN] E-R Tool

Hello, Db-designer is a nice tool, can work with importing Oracle databases, and use it with PG and MySQL. Hope this helps BR, Miguel Can someone suggest an E-R tool that will read a _PG_ database and create an E-R diagram - crows feet and all? Are there any that are available for free?

[ADMIN] unique constraints on foreign keys

on a referenced table? (I mean, a way that not involves the use of a set instruction because the odbc not allow such instructions) Thanx in advance, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo

Re: [ADMIN] unique constraints on foreign keys

--- Stephan Szabo [EMAIL PROTECTED] escribió: On Mon, 20 Sep 2004, Jaime Casanova wrote: There is a way to not enforce the creation of a primary or unique index on a referenced table? Not really. It's not the index that's important per-se, it's the uniqueness that is implied. OK

Re: [ADMIN] caching complete table for optimizing search ?

the PERFORMANCE list is more adecuate. Thx berger you welcome. regards, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com

Re: [ADMIN] postgres gets slower after some while

. Here is an explanation why VACUUM is necessary: http://www.postgresql.org/docs/7.4/interactive/maintenance.html Here you can find some other performance-tips: http://www.postgresql.org/docs/7.4/interactive/performance-tips.html regards, Jaime Casanova

Re: [ADMIN] Consult is very slow

have proved it). regards, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ---(end of broadcast

Re: [ADMIN] joins INNER, OUTER, LEFT, RIGHT, FULL, ...

*? regards, Jaime Casanova _ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com ---(end of broadcast)--- TIP 4: Don't

Re: [ADMIN] Running sql files

trying to populate a table with values ( There are more than 5000 tuples to be inserted). When I run this command, it displays the results on to the screen which I don't want to do. Could anyone help me in this. $psql dbname sqlfile /dev/null regards, Jaime Casanova

[ADMIN] From latin9 to sql_ascii??

Hi, someone show me that if had accents in a word i can suppress it with the to_ascii function. = select to_ascii('Jiménez'); will retrieve 'Jimenez' at least it works on Latin1 encoding. Why it not work on Latin9, there's another way of doing such a thing? regards, Jaime Casanova

Re: [ADMIN] From latin9 to sql_ascii??

--- Tom Lane [EMAIL PROTECTED] escribió: Jaime Casanova [EMAIL PROTECTED] writes: = select to_ascii('Jiménez'); will retrieve 'Jimenez' at least it works on Latin1 encoding. Why it not work on Latin9, Probably because it hasn't got a table for Latin9. Feel free to contribute

Re: [ADMIN] max_fsm_relations

count(*) from pg_class where relname like 'some-prefix-youuse%'; but you need to do this per-database. besides your tables must have a prefix to identify them if they have not maybe the owner if it is postgres, wll i don't know. regards, Jaime Casanova

Re: [ADMIN] Admin Tool to Send Me Email

operator intervention, class 58 system error, and a few others. I don't know if it can be useful for you but there is a project called pgMail. You need he pl/tclu to run it. hope it can help you. regards, Jaime Casanova ---(end of broadcast)--- TIP

Re: [ADMIN] [pgsql-es-ayuda] bien, esta es mi duda sobre almacenamiento de datos grandes en una columna

eso, al menos en las listas en ingles. PD: Podrias mandar a la lista en español, la definicion de tu tabla? Hicistes la prueba que te sugirio Alvaro de ingresar via script para confirmar si el problema es el pgAdmin y no el postgres? -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator

Re: [ADMIN] Alter Table vs. Rename/Create/Drop table with plpgsql functions.

Secondly does anyone know a way to insert a column instead of appending a column to a table. That way I could just avoid the entire mess. http://archives.postgresql.org/pgsql-hackers/2004-09/msg00102.php -- Regards, Jaime Casanova (DBA: DataBase Aniquilator

Re: [ADMIN] autovacuum on updated rows

: volumes_i1 unique, btree (label) volumes_i2 btree (environment_name) -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [ADMIN] Postgres Database slow

that slow or just queries? (maybe it is a problem of lack of resources) -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] Postgres Database slow

, explain analyze (from 7.3.8 if possible, and from 7.4.2)... Regards Nirmal --- Jaime Casanova [EMAIL PROTECTED] wrote: On 11/21/05, Nirmal Kumar [EMAIL PROTECTED] wrote: Hi We are facing a slowness problem in posgres Database. Whenver we query a data it is very very

Re: [ADMIN] single click, double query

because they come throught firewall. Thanks, Szabek -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [ADMIN] cache lookup failed for type

ERROR: cache lookup failed for type 12345 I thing that maybe there is(are) parameter(s) that need to be configure to give more cache to prevent this error can you help me ? this is not about memory... it's a bug... can you provide info about the version that you have? -- regards, Jaime

Re: [ADMIN] sending mail from Postgres

an index scan if your joining column's datatypes do not match -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index

Re: [ADMIN] NHibernate

you are giving us... -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your

Re: [ADMIN] NHibernate

at the postgresql logs... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do

Re: [ADMIN] Vacuum is needed or not?

transactions... execute it in a script periodically... if you are in doubt if you need VACUUM then you need it urgently, execute it right now!!! -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 2: Don't 'kill -9

Re: [ADMIN] Vacuum is needed or not?

, but actually i think it's need again, but just for feel i couldn't stop the server. I need evidence. (oldspice rulez ;)) Szabek a plain VACUUM (without full) is enough in most cases... and you don't need to stop the server for a plain VACUUM... -- regards, Jaime Casanova (DBA: DataBase Aniquilator

[ADMIN] [DOCS] technical papers

HI, is there a site where we can see all technical papers that postgresql is based on? i mean algorithm and other stuff related... if not is worth the effort to maintain such a site? some of us live in countries where this kind of info is very difficult to get... -- regards, Jaime Casanova

Re: [ADMIN] What happens to transactions durring a pg_dump?

On 1/9/06, Chris Hoover [EMAIL PROTECTED] wrote: I'm trying to understand better what happens to a transaction that is commited in the middle of a pg_dump. Is the transaction included in the database dump, or is it excluded. AFAIK, it's excluded... -- regards, Jaime Casanova (DBA: DataBase

Re: [ADMIN] What happens to transactions durring a pg_dump?

will only see transactions that were commited before the isolation level was set Is this correct? Any transactions that are commited while the backup is running are not seen by pg_dump. Correct? Thanks, Chris correct -- regards, Jaime Casanova (DBA: DataBase Aniquilator

Re: [ADMIN] pg_autovacuum

of that line -- Atentamente, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [ADMIN] Transferring DATA directory

in machine B -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [ADMIN] pg_dump - txt sql vs binary

for me because i don't use most of these things, and for plpgsql i create it by hand in linux before run the script generated by pg_dump -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;) ---(end of broadcast)--- TIP 2: Don't 'kill -9

Re: [ADMIN] install postgre on windows XP, service failed to start.

(postgres) any hits are appreciated Regards Jeff the installation completes? if so, try to start the service by hand and show the error (eventlog should have a description) -- Atentamente, Jaime Casanova Programming today is a race between software engineers striving to build bigger

Re: [ADMIN] PLPGSQL/EXCEPTION HANDLING

. that's because that construction was added in 8.0, you have to upgrade to use it -- regards, Jaime Casanova Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far

Re: [ADMIN] PLPGSQL/EXCEPTION HANDLING

On 6/13/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Jaime Casanova wrote: On 6/12/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: In a function implemented in 7.4.8 I had the following error when I call the function: ERROR: syntax error at or near EXCEPTION Offending line

Re: [ADMIN] Move indexes

/interactive/sql-alterindex.html ALTER INDEX name SET TABLESPACE tablespace_name Haven't tried this for my own, so take care (and test). i think we should add: in = 8.1 -- regards, Jaime Casanova Programming today is a race between software engineers striving to build bigger and better idiot-proof

Re: [ADMIN] Moving a table to another directory

... -- regards, Jaime Casanova Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning. Richard Cook

Re: [ADMIN] Moving a table to another directory

in upgrading... ;) -- regards, Jaime Casanova Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning. Richard

Re: [ADMIN] Moving a table to another directory

On 2/7/07, Ezequiel Luis Pellettieri [EMAIL PROTECTED] wrote: thanks guys, is it possible to go with it, without stopping the postmaster? maybe just rejecting conns to the DB... this is cos I had another DB's running... thanks again. AFAIR, no -- regards, Jaime Casanova Programming today

Re: [ADMIN] tabla pg_user Ayuda......

vacuum full regularmente? -- Atentamente, Jaime Casanova Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe is winning

Re: [ADMIN] tabla pg_user Ayuda......

problema es el que mencione arriba, no se me ocurre que mas pudo ser... -- Atentamente, Jaime Casanova Programming today is a race between software engineers striving to build bigger and better idiot-proof programs and the universe trying to produce bigger and better idiots. So far, the universe

Re: [ADMIN] [Admin]To estimate the size of db

-DBSIZE else there is a contrib/dbsize end if -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 087171157 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [ADMIN] postgres 'forgets' table definitions

, Jaime Casanova Soporte y capacitación de PostgreSQL Guayaquil - Ecuador Cel. (593) 87171157 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Urgente error in restore prod

this error can you show what were you doing? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http

Re: [ADMIN] postgres 8.2.9 transaction id wraparound failure

running? if so, you only have to vacuum the one that is giving you troubles... vacuum; you execute this inside psql... rigth? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-admin

Re: [ADMIN] WAL file compatibility

On Tue, Oct 20, 2009 at 9:25 AM, Tom Lane t...@sss.pgh.pa.us wrote: OS per se shouldn't matter unless you try to do it between windows and some flavor of linux -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel

Re: [ADMIN] WAL file compatibility

On Tue, Oct 20, 2009 at 10:56 AM, Tom Lane t...@sss.pgh.pa.us wrote: Jaime Casanova jcasa...@systemguards.com.ec writes: On Tue, Oct 20, 2009 at 9:25 AM, Tom Lane t...@sss.pgh.pa.us wrote: OS per se shouldn't matter unless you try to do it between windows and some flavor of linux hmmm

Re: [ADMIN] WAL file compatibility

could be a problem too... -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [ADMIN] Altering a column (increasing size) in Postgres takes long time

)   Is there a more practical and safe method  to alter a huge table with reasonable amount of time? use text fields instead of varchar(n) -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql

Re: [ADMIN] message during PostgreSQL 8.4.3 installation

permissions -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil - Ecuador Cel. +59387171157 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] initdb failure

any solution so far. The data directory does have inheritable permissions for user postgres to read, write, modify etc. are you executing the installer with a privileged user? -- Atentamente, Jaime Casanova Soporte y capacitación de PostgreSQL Asesoría y desarrollo de sistemas Guayaquil

Re: [ADMIN] [GENERAL] Copying data files to new hardware?

to reindex) -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación de PostgreSQL -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Determining the WAL file needed by a standby

? that info is on the standby, you need to execute pg_controldata on the standby and read the Latest checkpoint location, IIRC... then, from that you can now what the segment you need is, but you have to look for it on the master -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte

Re: [ADMIN] Oracle Label Security/ Row Level Security on Postgresql

(not yet released) as a contrib module -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación de PostgreSQL -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin

Re: [ADMIN] Hot-standby/Reporting database.

the contrib module dblink for this: http://www.postgresql.org/docs/9.0/static/dblink.html -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación de PostgreSQL -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription

Re: [ADMIN] Hot-standby/Reporting database.

On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova ja...@2ndquadrant.com wrote: On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman jweatherma...@alumni.wfu.edu wrote: Has anyone run into this already and have an idea for a work around?  I am primarily an Oracle guy and in that environment I

Re: [ADMIN] Hot-standby/Reporting database.

On Sun, Mar 20, 2011 at 10:38 PM, jonathan ferguson j...@hoozinga.com wrote: hi. On Mar 20, 2011, at 9:05 PM, Jaime Casanova wrote: On Sun, Mar 20, 2011 at 8:04 PM, Jaime Casanova ja...@2ndquadrant.com wrote: On Fri, Mar 18, 2011 at 4:25 PM, John P Weatherman jweatherma...@alumni.wfu.edu

Re: [ADMIN] synchronous_commit and wal_writer_delay

shouldn't be setting synchronous_commit on postgresql.conf normally but from the application -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http

Re: [ADMIN] Tentative release date for 9.1 and 9.2

On Wed, Aug 10, 2011 at 9:51 AM, A J s5...@yahoo.com wrote: What are the tentative release dates of 9.1 and 9.2 versions ? about 9.1: http://archives.postgresql.org/message-id/19869.1312298...@sss.pgh.pa.us 9.2 is just starting its dev cicle, it will be released next year -- Jaime Casanova

Re: [ADMIN] [SQL] parsing audit table

functions on it (http://www.postgresql.org/docs/9.0/static/hstore.html) The other one uses arrays to store column names, old values, new values, still more parseable -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación -- Sent via pgsql-admin

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

) can be run on master -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http

Re: [ADMIN] Database size stays constant but disk space keeps shrinking -- postgres 9.1

the next postgresql minor version to be released -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell: +593 987171157 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription

Re: [ADMIN] Postgres en Cluster

Enterprise 11, and postgres database is at version 9.0.4. you really need to upgrade to 9.0.12, you can upgrade very easily when the first 2 numbers (9.0) are the same -- Jaime Casanova www.2ndQuadrant.com Professional PostgreSQL: Soporte 24x7 y capacitación Phone: +593 4 5107566 Cell