Re: [GENERAL] Drop/ Alter index if exist

thanks 2009/12/22 Filip Rembiałkowski plk.zu...@gmail.com 2009/12/22 Pau Marc Munoz Torres paum...@gmail.com Hi every body there is some way to delete or rename an index only if this index exists? something like alter index index rename to pepe if exists for drop - yes: DROP

[GENERAL] Drop/ Alter index if exist

Hi every body there is some way to delete or rename an index only if this index exists? something like alter index index rename to pepe if exists thanks -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat

Re: [GENERAL] drop index

what can I do? 2008/9/16 Richard Huxton [EMAIL PROTECTED] Pau Marc Munoz Torres wrote: Hi everybody I have a problem with index, i droped a table before drop their indexs, so, now i can't remove the index That shouldn't be possible. What version of PostgreSQL

[GENERAL] too many warnings

Hi everybody i get a lot of warnings when i try to execute a postgresql from a script the warrning is HINT: Use the escape string syntax for escapes, e.g., E'\r\n'. WARNING: nonstandard use of escape in a string literal LINE 1: ...9.table.viewentry_general_old.txt' WITH DELIMITER '\ ';

Re: [GENERAL] Problems with memory

Hi maybe i should give you some more explanations of my problem. The reason for which i think that postgresql run out of memory is that: I have a relation with 6 fields, 29 indexes and 32000 registers, the registers where made up using a pgsql language to save disk space, and they work (see the

[GENERAL] Problems with memory

Hi I'm setting up a big database , and when i say big, i mean BIG, the problem with this is that some times, when a do a query the database run out of memory, so I really need to increase the amount of memory reserved to postgress almost 10x, could anyone tell me how can i do that? i mean, what

[GENERAL] Problems with memory

Hi I'm setting up a big database , and when i say big, i mean BIG, the problem with this is that some times, when a do a query the database run out of memory, so I really need to increase the amount of memory reserved to postgress almost 10x, could anyone tell me how can i do that? i mean, what

Re: [GENERAL] select from an index

Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb')); , where idr is a function that returns a real number,as a result i got the following table mhc2db= \d precalc; Table

[GENERAL] complex query using postgresql

Hi everybody I have de following table where i can perform two different queries: select * from precalc where idr(p1, p4, p6, p7, p9, 'HLA-DR7')2; where idr is a function used to create indicies and select * from precalc where p1='S'; Now i would like to perform a query as : select * from

[GENERAL] help with plpgsql

Hi everybody I trying to upload some plpsql functions to postgresql database using a perl script and i get the following error psql:/usr/local/Make2D-DB_II/pgsql/make2db_functions.pgsql:85: ERROR: language plpgsql does not exist HINT: Use CREATE LANGUAGE to load the language into the

Re: [GENERAL] help with plpgsql

Hi everybody I trying to upload some plpsql functions to postgresql database using a perl script and i get the following error psql:/usr/local/Make2D-DB_II /pgsql/make2db_functions.pgsql:85: ERROR: language plpgsql does not exist HINT: Use CREATE LANGUAGE to load the language into the

[GENERAL] Fwd: pgsql configuration

Hi today I had a problem with postgresql.conf file, i remove it from my local home, any of you know if there is some security copy of it somewhere or if there is some how to recover it? the guy who did the configuration is not working at my office any more and i don't know is he changed some

[GENERAL] pgsql configuration

Hi today I had a problem with postgresql.conf file, i remove it from my local home, any of you know if there is some security copy of it somewhere or if there is some how to recover it? the guy who did the configuration is not working at my office any more and i don't know is he changed some

[GENERAL] loading files into tables

Hi I'm an ex-mysql user, i know there was a sentence in mysql that was load data local infile somefile.txt into table sometable; I'm trying to do something similar in postgresql, can someone help me? Thanks Pau -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut

Re: [GENERAL] loading files into tables

, Dimitri Fontaine [EMAIL PROTECTED]: Hi, Le lundi 04 février 2008, Pau Marc Munoz Torres a écrit : I'm an ex-mysql user, i know there was a sentence in mysql that was load data local infile somefile.txt into table sometable; I'm trying to do something similar in postgresql, can

[GENERAL] if exists...does it exists for insert statments?

could i use a sentence similar to the mysql sentence insert if not exist into SP values ('cesp','sp'); in postgresql? pau -- Pau Marc Muñoz Torres Laboratori de Biologia Computacional Institut de Biotecnologia i Biomedicina Vicent Villar Universitat Autonoma de Barcelona E-08193

Re: [GENERAL] if exists...does it exists for insert statments?

Thanks, i'll test it tomorrow pau 2007/12/11, Richard Broersma Jr [EMAIL PROTECTED]: --- On Tue, 12/11/07, Pau Marc Munoz Torres [EMAIL PROTECTED] wrote: could i use a sentence similar to the mysql sentence insert if not exist into SP values ('cesp','sp'); in postgresql? Using

[GENERAL] Can i Force to postgrsql to use a certain index?

Hi every body it is possible to force to postgresql to use a certain index? I know that in mysql exits Force index (index_name) option for select queries SELECT * FROM precalc FORCE INDEX (hladrb50101) ; any of you have used this? thanks pau -- Pau Marc Muñoz Torres Laboratori de Biologia

[GENERAL] Can i Force to postgrsql to use a certain index?

Hi every body it is possible to force to postgresql to use a certain index? I know that in mysql exits Force index (index_name) option for select queries SELECT * FROM precalc FORCE INDEX (hladrb50101) ; any of you have used this? thanks pau -- Pau Marc Muñoz Torres Laboratori de Biologia

[GENERAL] Making a query from 2 tables at same time

Hi everybody I'm doing a two table query as follow mhc2db= select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local as t1, precalc as t2 where t1.ce='ACIAD' and t2.idr(p1, p4, p6, p7, p9, 'HLA-DRB5*0101')2; and i get the following error ERROR: schema t2 does not exist but those

Re: [GENERAL] Making a query from 2 tables at same time

, Richard Huxton [EMAIL PROTECTED]: Pau Marc Munoz Torres wrote: Hi everybody I'm doing a two table query as follow mhc2db= select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7, t2.p9 from local as t1, precalc as t2 where t1.ce='ACIAD' and t2.idr(p1, p4, p6, p7, p9, 'HLA-DRB5*0101')2

Re: [GENERAL] Making a query from 2 tables at same time

'; works perfectely is it clear enough? i don't now if i make myself understand, any way, if it not, please, ask me!! thanks pau 2007/11/29, Richard Huxton [EMAIL PROTECTED]: Pau Marc Munoz Torres wrote: i test it and now the error is mhc2db= select t1.sp, t1.pos,t2.p1, t2.p4, t2.p6, t2.p7

[GENERAL] select using an index

Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));, where idr is a function that returns a real number, as a result i got the following table mhc2db= \d precalc;

[GENERAL] indexing tables using my owns functions

Hi every body Recently i wrote my own function into postgesql... and it works perfecly!!, now i would like use it to index a table like this guy do at the link ( http://www.faqs.org/docs/ppbook/r24254.htm) but i get the following error mhc2db= create index h2iab on precalc

[GENERAL] select from an index

Hi Recently i created an index in a table using a function (not a column) as following create index H2IAb on precalc (idr(p1,p4,p6,p7,p9,'H-2*IAb'));, where idr is a function that returns a real number, as a result i got the following table mhc2db= \d precalc;

[GENERAL] loading a funtion script from a file

Hi I've written a sql function in a text file, and now, i would like to upload into postgresql an execute, is there any command to do it? as far as I know in mysql exist source command, is there something similar in postgresql? Thanks -- Pau Marc Muñoz Torres Laboratori de Biologia

Re: [GENERAL] moving from mysql to postgree

Thanks every body, today i've created my first table with postgresql, what a mass with \d table and sequancial vs auto_increment data type in create... anyway, i will become an expert soon ;-) thanks again pau 2007/11/16, Merlin Moncure [EMAIL PROTECTED]: On Nov 15, 2007 10:44 AM, Pau Marc

[GENERAL] moving from mysql to postgree

Hi I'm moving from mysql to postgresql just now i I'm a bit lost, could anyone tell me some place with a comparative between postdresql and mysql commands, i think than mostly is the same think but, any way, do anything change ? pau -- Pau Marc Muñoz Torres Laboratori de Biologia