Re: [ADMIN] pg_dump and restore

2013-01-09 Thread Arun Padule
mple, there might be many other functions that might not be used or compatible with the higher version of postgres. In this case you need to explicit on the changes in the proc or function. Like as below. where '5'::integer = 5; Thanks, Arun On Wed, Jan 9, 2013 at 5:18 PM, suhas.basavar

[ADMIN] How to find dependent procdures on a table in postgresql

2012-10-12 Thread Arun Padule
How to find dependent procdures on a table in postgresql. The postgresql version I am using is 8.1. Regards, Arun Padule

[ADMIN] Taking backup of login roles in postgresql 8.2

2007-10-24 Thread arun
Hi all, I'm new to this forum. Can any one tell me how to take backup of login roles in postgresql. I know how to take database backup. It is giving me all the schemas in the selected database, but not creating the login roles required when restoring the database Thank you

[ADMIN] Using PL/pgSQL

2004-01-26 Thread Arun Gananathan
27;C' language.    Others may use the 'sql' language or the created procedural languages.createlang: language installation failed  Could any one help me to sort out thsi problem. many thanks and regards from arun  

Re: [ADMIN] popstgresql query

2004-01-26 Thread Arun Gananathan
the other table)  from the other table Q. Thank you   arun

[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