[GENERAL] performance problem with loading data

incorrect? Thanks in advance Sergey Karin === code=== === create table ( GID SERIAL not null, GEOM_ORDER INT4n

[GENERAL] pg_catalog.pg_get_serial_sequence() returns NULL

ename*_*colname*_seq; CREATE TABLE *tablename* ( *colname* integer DEFAULT nextval('*tablename*_*colname*_seq') NOT NULL ); Thanks in advance Sergey Karin

[GENERAL] Question about Large Objects

Hi, all   As I understood PostgreSQL allows to store large objects 2GB size maximum. Are there any plans to increase or removing that limitation?   If no, are there any abilities to store 10-20GB raster data (aero foto image) in postgreSQL?   Thanks   Sergey Karin

[GENERAL] problem with bit(n) type

ig problem for me... Is there a way to cast bit(n) to text or varchar? thanks in advance. Sergey Karin PS. I have found that there are some functions: varbit_in() and varbit_out(). But they works with internal type cstring. And I cannot cast cstring to varchar or text.

[GENERAL] [8.1] "drop table" in plpgsql function

n_query varchar; begin select f_is_table_exist(table_name) into tcount; if(tcount > 0) then dyn_query := 'drop table ' || table_name; execute dyn_query; return true; end if; return false; end 'language 'plpgsql'; == pano

[GENERAL] [8.1] "drop table" in plpgsql function

-- Forwarded message -- From: Sergey Karin <[EMAIL PROTECTED]> Date: 11.11.2005 13:59 Subject: [8.1] "drop table" in plpgsql function To: pgsql-general@postgresql.org hi all! I have found a strange error. panorama2=# select version();

[GENERAL] FOREIGN KEY CONSTRAINT AND INHERITANCE

oreign key constraint not only in master table, but also in all tables that inherited the master? Thanks in advance. Sergey Karin

[GENERAL] Please, help! About database cluster and adding to it additional disk space

created cluster additional disk space in new other disk? Similar ability exist in Informix... Thanks in advance for any answers! Sergey Karin

[GENERAL] question about large databases

organisation plans to use GIS based on PostGIS/Postgres. As we think, size of our database can be 50, 100 and more Gb. Thanks in advance! Sergey Karin

[GENERAL] triggers, rules and alter table

vents in 8.1.x version? Sergey Karin

[GENERAL] triggers and SELECT

Hi, List! Are there any plans to realize triggers on SELECT in new versions of PG? Sergey Karin

[GENERAL] NULL values and string

value = NULL\'; else    string_value := \'input_value = \' || num_value; end if; But it is not laconic... Sergey Karin

[GENERAL] change current user in pl/pgsql function

execotion change user to superuser. Sergey Karin

[GENERAL] alter superuser...

Hi, List!I alter user postgres, that was a superuser in my db cluster.  And now it is not a superuser. There are no superusers in my cluster. Yes, I am stupid :)But are there any abilities to restore superuser excluding initdb? Sergey Karin

[GENERAL] PG and Tivoli Data Protection

Hi All!Does anybody use Postgres with storage managers like Tivoli Data Protection? Are there aby abilities for that in PG (I use 8.1)?Sergey Karin.

[GENERAL] How to detect primary key of a table

Hi, List!I use PG8.1Are there any abilities to detect primary key of a table?Sergey Karin

Re: [GENERAL] How to detect primary key of a table

___From: [EMAIL PROTECTED][mailto:[EMAIL PROTECTED]] On Behalf Of Sergey KarinSent: Thursday, March 30, 2006 1:13 PMTo: pgsql-general@postgresql.orgSubject: [GENERAL] How to detect primary key of a tableHi, List!I use PG8.1Are there any abilities to detect primary key of a table?Sergey Karin