[ADMIN] webclient for postgresql

2012-07-03 Thread Madhu.Lanka
Hi Friends Can u please suggest me any web client tool for administrating postgres database.(like OEM for oracle) Thanks in Advance. Regards Madhu.Lanka

[ADMIN] need help to write a function in postgresql

2012-07-19 Thread Madhu.Lanka
er_roles u,.principals p,roles r where p.PRINCIPAL_ID = u.USER_ID and r.role_id = u.role_id and p.name=? and p.password=?" Thanks in Advance. Regards Madhu.Lanka

[ADMIN] ERROR: there is no parameter $1

2012-07-19 Thread Madhu.Lanka
wstest2" line 8 at FOR over EXECUTE statement ** Error ** ERROR: there is no parameter $1 SQL state: 42P02 Context: PL/pgSQL function "getrowstest2" line 8 at FOR over EXECUTE statement Can anyone please help me to resolve the issue. Thanks in Advance Regards Madhu.Lanka