[ADMIN] postgres Rules

2003-12-15 Thread Arun Gananathan
Could any one let me know is there a way to findout the rules previously created in the database . thanks ganesh  

Re: [ADMIN] popstgresql query

2004-01-26 Thread Arun Gananathan
Hi, Could anyone please let me know how to perform the following in postgresql I have two tables called P , Q  with the same attributes and data tpyes. I want to insert a record ( for example called A) into table P, when deleting the same record( for example  called A which is already in the

[ADMIN] Using PL/pgSQL

2004-01-26 Thread Arun Gananathan
Hi, I want to try some functions using pl/pgsql in the unix. i have tried the following 'createlang plpgsql yourdb' function and that is giving the following error message, which is ERROR:  Only users with Postgres superuser privilege are permitted to create a function in the 'C' language.