Respected sir/madam,
Please can you send me link of windows postgres sql download page.
thanks
senthil
---(end of broadcast)---
TIP 6: explain analyze is your friend
Dear friends,I am having an lengthy SQL, which will be called every
conditions of if...else statement. I tried with passing that via a string and
execute it.But I got error.
v_sql := 'INSERT INTO activities(
activity_id, parent_activity_id,
activity_type_id, subject,
descrip
following statement
UPDATE pg_proc SET proowner = 1 where proname = 'plpgsql_call_handler';
I am asking this because to ensure not any wrong impact gets into the live
database. Pls advise.
Regards
Kumar
- Original Message -
From: "Peter Eisentraut" <[EMAIL PROTECT
Dear Friends,
While doing compressed backup for one of the database running
at Postgres Server 7.3.4 on RH Linux 7.2, I got the following error., but it
backup other items
--Command to backup
$ $ pg_dump -h 192.xxx.x.xxx -p 5432 -v testdb -f
/home/db_repository/testdb20031023.sql.tar.gz -
Hi,
I have 2 versions of Postgres server 7.2 & 7.3.4 installed
on Linux server 7.3. I have not started the Postgres Server 7.2 which is located
at /var/library/pgsql.
I am running and using only 7.3.4 located at
/usr/local/pgsql.
After I login, I come to the /usr/local/pgsql/bin and the
Dear Friends,
Using Postgres 7.3.4 over the linux server 7.3.
Is it possible to alter/change the data type of a existing
table's column, with out dropping and recreating a column of same
name.
Thanks for ur knowledge sharing.
Regards
Kumar
itable examples with plpgsql code
and also the Calling Java code.
3) Can default values
be assigned to postgresql function parameters? If yes, how?
Thanks in advance.
Senthil.
