[ADMIN] need help to write a function in postgresql

Hi Friends Can u please help to write a function for the following scenario? I have 3 table's user_roles, principals and roles. I have to write a function in postgresql which should excepts 2 parameters (name, password) With those 2 parameters the query should be executed and return the r

Re: [ADMIN] need help to write a function in postgresql

Madhu.Lanka, 19.07.2012 11:14: Hi Friends Can u please help to write a function for the following scenario? I have 3 table’s user_roles, principals and roles. I have to write a function in postgresql which should excepts 2 parameters (name, password) With those 2 parameters the query should

[ADMIN] SSL SYSCALL error: EOF detected

Hi all, i have a problem while trying to delete rows from a table: I received: SSL SYSCALL error: EOF detected How can i fix this problem? -Postgresql version 9.1 -O.S Ubuntu Server 11.04 Thanks Francesco -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to

Re: [ADMIN] need help to write a function in postgresql

Madhu.Lanka wrote: > Can u please help to write a function for the following scenario? > "select [...] from [...] where [...] and p.name=? and p.password=?" Don't use "?" for the parameters. Use "$1" for the first parameter and "$2" for the second. Yours, Laurenz Albe -- Sent via pgsql-admin m

Re: [ADMIN] SSL SYSCALL error: EOF detected

"francescobocca...@libero.it" writes: > Hi all, i have a problem while trying to delete rows from a table: > I received: > SSL SYSCALL error: EOF detected > How can i fix this problem? This looks like a connection failure (network problem), not anything particularly to do with Postgres at all.

[ADMIN] Measurin the lag between a master and a replica

Hi, I am using a master and a replica with PostgreSQL 9.1.3. I would like to measure the replication lag between my servers (in time units). On the replica I can use the function pg_last_xact_replay_timestamp(). But on the master I only can use pg_current_xlog_location() which does not return a ti

[ADMIN] autovacuum: found orphan temp

Hi all, in postgresql log file i found a lots of rows like: autovacuum: found orphan temp table "pg_temp_32"."test11" in database "Test" I tried to select this table: select * from "pg_temp_32"."test11" but i received the follow error: ERROR: could not open file "base/16385/t32_13288115": No

Re: [ADMIN] Measurin the lag between a master and a replica

On Thu, Jul 19, 2012 at 7:17 PM, Ali Pouya wrote: > On the replica I can use the function pg_last_xact_replay_timestamp(). > But on the master I only can use pg_current_xlog_location() which does not > return a timestamp. I do not know any function returning the timestamp. > > Is there any way to

[ADMIN] Postgres Database got down

Hi All, I am sure, this question must have been asked many times, I tried to search archives as well, but still unable to find solution. Below are logs. I am using Windows 2003 server 2 and using Postgres as a metadata database for my ODI. I got similar error last week as well. And today i

Re: [ADMIN] Measurin the lag between a master and a replica

On Jul 19, 2012, at 8:17 AM, Ali Pouya wrote: > Hi, > I am using a master and a replica with PostgreSQL 9.1.3. > I would like to measure the replication lag between my servers (in time > units). > > On the replica I can use the function pg_last_xact_replay_timestamp(). > But on the master I onl

[ADMIN] ERROR: there is no parameter $1

Hi Friends I am creating the function like CREATE OR REPLACE FUNCTION getrowstest3(pname character varying,ppassword character varying) RETURNS SETOF getrows AS $BODY$ declare r getrows; begin for r in EXECUTE 'select u.role_id,u.user_id,p.name,p.creation_date,p.telephone_number,

Re: [ADMIN] Measurin the lag between a master and a replica

On Fri, Jul 20, 2012 at 1:02 AM, David Kerr wrote: > I was looking into this last month and some nice folks on the list pointed me > to this formula > for calculating lag. (to be run on the slave) similar to what Sergey said. > > when pg_last_xlog_receive_location() = pg_last_xlog_replay_

Re: [ADMIN] Measurin the lag between a master and a replica

On Jul 19, 2012, at 9:03 PM, Sergey Konoplev wrote: > On Fri, Jul 20, 2012 at 1:02 AM, David Kerr wrote: >> I was looking into this last month and some nice folks on the list pointed >> me to this formula >> for calculating lag. (to be run on the slave) similar to what Sergey said. >> >>

Re: [ADMIN] ERROR: there is no parameter $1

On Fri, Jul 20, 2012 at 6:33 AM, Madhu.Lanka wrote: > I am getting the following error > > ERROR: there is no parameter $1 > LINE 5: r.role_id = u.role_id and p.name= $1 and p.password = $2 Because they are not expanding inside strings. Use EXECUTE ... USING ... EXECUTE '... and p.name =$1 and

Re: [ADMIN] Postgres Database got down

On 07/20/2012 12:19 AM, Umer Asghar wrote: After that I gave it a reboot to my machine, and its 3 hrs now and its running fine. but not sure why it got down and will it go down again soon. Can somebody advice what should I looked into? [snip] 2012-07-19 18:05:08 PKT LOG: server process (PI

Re: [ADMIN] Postgres Database got down

Thanks- the sysmtoms seems same on my machine here. i will take up this with my Operating system team. good news is that after yesterday's reboot, its around 20 hrs and still this problem has not appear again. On Fri, Jul 20, 2012 at 9:38 AM, Craig Ringer wrote: > On 07/20/2012 12:19 AM, Umer

Re: [ADMIN] ERROR: there is no parameter $1

Hi pgsql-admin-ow...@postgresql.org wrote on 20/07/2012 03:33:36:> From: "Madhu.Lanka" > To: , > Date: 20/07/2012 06:37> Subject: [ADMIN] ERROR:  there is no parameter $1> Sent by: pgsql-admin-ow...@postgresql.org> > Hi Friends>  > I am creating the function like >  > CREATE OR REPLACE FUNCTION get