[GENERAL] embedded

How is the support for embedded database applications? has it been used in embedded environment? dbadmin point of view? What is the largest installation of postgresql? Sandeep

Re: [GENERAL] copy table from...

Thanks. I think you are right. After thinking a bit I guessed the problem. Sandeep > > I am trying to copy data from an ascii file into the table; > > I get following error. can anybody explain why? solution if possible; > > copy: line 1, pg_atoi: error in "tom": can't parse "tom " > > > > Are

[GENERAL] pg_class : reltuples

What does "reltuples" from pg_class represent? any comments Here is something that raised this question: --- testdb=# select count(*) from zuser3; count - 100 (1 row) testdb=# select count(*) from zuser2; count 10 (1 row) testdb

Re: [GENERAL] pg_class : reltuples

I had to run "vacuum" to get corect no.s. Why is that? I thought "pg_class" will be upto date. This makes me nervous. Sandeep > What does "reltuples" from pg_class represent? > any comments > Here is something that raised this question: > > --- > testdb=# s

[GENERAL] XA support / Dist. tran. support

Hi, Does PostgreSql support XA and/or distributed transactions? (TWO-PHASE commit) Whatever I found so far says PG doesn't support 2-P. Sandeep

[GENERAL] indices

Hi, I had learned in theory that Hash indices are used for "=" and B-tree for "<" ,">". explain command doesn't tell us which index it is using. Hash or Btree? Also, should a following query "id < 1243" invoke a index ? (assuming there is an index on id). I have seen Postgres

[GENERAL] PostgreSql and XA

Hi, Do you know if XA can be used as a resource manager? Is there any code available? OR How do I do a transaction which spans two databases automatically in Postgres? Thanks in advance, Sandeep

Re: [GENERAL] Unanswered questions about Postgre

what is the tentative date for 7.1 release? what is the release date for replication? sandeep

[GENERAL] create trigger

I am trying to use "triggers". I get an error after "create trigger". Does anybody know why? create function insert_into_db2 RETURNS int AS '/work/posgresql/lib/libpq.so' language 'C'; create trigger trial before insert or update on db1user for each row execute procedure insert_into_db2();

Re: [GENERAL] create trigger

ers20290.htm > > Sorry I can't help more as I've never actually used C triggers, just PL/pgSQL > ones. > > On Thursday 14 December 2000 18:04, Sandeep Joshi wrote: > > I am trying to use "triggers". I get an error after "create trigger". > > Does anyb

Re: [GENERAL] create trigger (can't compile example, problem with include files)

al/pgsql/include > -I/usr/src/postgresql-7.0.3/src/include ttest.c -o ttest.o > ttest.c: In function `trigf': > ttest.c:17: `WARN' undeclared (first use in this function) > ttest.c:17: (Each undeclared identifier is reported only once > ttest.c:17: for each function it appears in

[GENERAL] question

I need to update a second database through a trigger function written 'C'. Is that possible ? how? Do I need to go to commercial product for this? - Sandeep

Re: [GENERAL] question

> Hi, I reduced my trigger to do following : (Trigger gets invoked for Table1 in Db1) 1. conn=PQconnectdb ( db2 ) 2. PQexec(conn,"begin") <--- FAILS 3. PQfinish(conn) I get failure in step (2) with following message in 'postmaster.log' ERROR: begin pq_recvbuf: une

[GENERAL] no. of functions

ns can be loaded? do they need to be in separate file? Thanks, Sandeep Joshi

[GENERAL] postmasteralive()

In my application I need to know whether the postmaster is alive or not and also whether a particular database is accessible or not. I need api's to do this. Are there any? thanks, Sandeep

Re: [GENERAL] replication followup

How do we get it? I want to test the product. Sandeep > On Fri, 5 Jan 2001, Justin Banks wrote: > > > Hello - > > As a followup to my mail about replication yesterday, I've > > realized that I can make replication bi-directional, with each > > (non-replicant master initiated) connection to

[GENERAL] delete trigger function in 'C'

How do I get the values of parameters in the query? e.g. where x = 'op'; i.e. How do I get ? field: x value : op any example, pointers will help. thanks, Sandeep Joshi