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
