Recent content by ceco

http://bg2.php.net/manual/en/ref.pgsql.php http://bg2.php.net/manual/en/ref.pdo.php http://bg2.php.net/manual/en/ref.pdo-pgsql.php (I do not know ASP to be usable under linux, but I am not quite aware of the mono project)

you can restor postgres DB two ways dump / restore (as already pointed out) and if you have the data files, then you need the same major postgres version (for the same computer arcitecture) the way you describe, the files you have, do not look any like postgres files at all

you can comment objects http://www.postgresql.org/docs/8.2/interactive/sql-comment.html but not with the create statement CREATE TABLE "test" ( "test" CHAR(36) NOT NULL, PRIMARY KEY ("test") ); COMMENT ON TABLE "test" IS 'this is realy test table'; COMMENT ON COLUMN "test"."test" IS 'this...

maybe safe points can do the thing

it is pretty large query, I don't have time to dive in to it, but at first glance, you can try to use UNION ALL instead of just UNION (if you are sure that there are no duplicates)

if you are using recent version of postgresql and using plain SQL, just enclose it with savepoint test@ws-dev:5432 test=> ALTER TABLE tbl DROP field; ALTER TABLE test@ws-dev:5432 test=*> SAVEPOINT test_1; SAVEPOINT test@ws-dev:5432 test=*> ALTER TABLE tbl DROP field; ERROR: column "field" of...

if only one of the parameters is null then the whole concatenation will return null by the way why do you construct this like this, and not just execute it, at first glance I don't see a reason

then what is this returing select count(*) from ( select distinct clientid from tbvisits where date > '2004-05-29' and date <= '2005-05-29' EXCEPT select distinct clientid from tbvisits where date > '2005-05-29' and date <= '2005-06-29' ) AS tmp;

in which schema is this table, and what is your search_path (the later I suppose is public)

this file exists when the standard version the one that comes with ubuntu is started, are you sure you see it in the process list actually, on ubuntu the start script is /etc/init.d/postgresql-8.2

as most of the services in ubuntu you start it with /etc/init.d/postgres start

if you are talking about plpgsql functions use raise notice http://www.postgresql.org/docs/8.2/interactive/plpgsql-errors-and-messages.html

http://www.postgresql.org/docs/8.2/interactive/runtime-config-logging.html see here it is for a newer version you can find it for your version too

I would suggest creating index on snp_allel_chr_20_kora_pt6(snd_ip) WHERE NOT a.allele_1='-' and then ordering BY a.snd._ip not like you do now with b.snd_ip

sory this is not the problem, you probaly have turned this syntax on from postgresql.conf