thanks
2009/12/22 Filip Rembiałkowski
>
>
> 2009/12/22 Pau Marc Munoz Torres
>
> Hi every body
>>
>
>
>>
>> there is some way to delete or rename an index only if this index exists?
>>
>> something like
>>
>> "alter index ind
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 Auto
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 shoul
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 '\ '; DROP...
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
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
c
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
c
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
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
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 databas
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 datab
Ok
it's works !!
thanks
2008/3/10, Craig Ringer <[EMAIL PROTECTED]>:
>
> Pau Marc Munoz Torres wrote:
>
> > Thanks Craig
> >
> > just one more question, most of the variables at
> > /home/postgresql/data/postgresql.conf file are commented (the di
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 dir
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 dir
ot; character?
Thanks
Pau
2008/2/4, 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 inf
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
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 int
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 Bellaterr
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 C
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
')>2;
or
select * from local where ce='ACIAD';
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:
>
t if i can't
use idr as an index it eill be to slow
pau
2007/11/29, 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,
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 thos
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;
Tab
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 (idr(p1,p4,p6,p7,p9,
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;
Tab
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 Computacio
Thanks every body, today i've created my first table with postgresql, what a
mass with \d 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 1
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 Computacional
29 matches
Mail list logo
