Skip site navigation (1) Skip section navigation (2)

Re: 'now' doesnt seem to work in stored procedure

From: "Henshall, Stuart - Design & Print" <SHenshall(at)westcountry-design-print(dot)co(dot)uk>
To: 'HK' <harikrishnan(at)midascomm(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: 'now' doesnt seem to work in stored procedure
Date: 2002-11-28 11:42:34
Message-ID: E382B5D8EDE1D6118DBE0008C759BCD6116AF4@WCPEXCHANGE (view raw or flat)
Thread:
Lists: pgsql-novice
HK wrote:
> hi all,
> i am using postgreSQL 7.1.3 and i am new to postgres.
> 
> i have 2 queries
> 
> Query 1:
> =========
> I used the following commands to add pl/pgsql language to the
> database. 
> 
> 1) create function plpgsql_call_handler() returns opaque as
>    '/usr/lib/pgsql/plpgsql.so' language 'c';
> 
> 2) create language 'plpgsql' handler plpgsql_call_handler lancompiler
>    'pl/pgsql';
> 
> I am able to execute stored procedures. But sometimes i get this
> message. 
> 
> ERROR:  fmgr_info: cache lookup for language 1952725 failed
> 
> After which i have to drop the database and create again.
> 
> Can anybody tell me why this happens and the remedy.
> 
> Query 2:
> ========
> Inside a stored procedure i am using 'now' for a datetime value.
> Wat happens is when the stored procedure is loaded, the 'now' is
> initialised and afterwards whenever i use this procedure, the same
> value is being inserted.
> Is my understanding correct and am i going wrong somewhere.
> 
> the procedure i am using is
> 
> create function login (int2) returns int2 as '
> DECLARE
> arguserid   alias for $1;
> 
> begin
>         insert into useraccounting (userid, logintime) values        
> (arguserid, 'now'); 
> 
> return 0;
> end;
> ' language 'plpgsql';
> 
> Help me.
> 
> --
> regards,
> hari
> 

Not mush idea of Query 1 (I always use the createlang script and haven't had
a problem)
Query 2:
use now() or CURRENT_TIMESTAMP
Or, to get different times within a transaction: timeofday()
hth,
- Stuart

pgsql-novice by date

Next:From: Tom LaneDate: 2002-11-28 15:08:19
Subject: Re: 'now' doesnt seem to work in stored procedure
Previous:From: HKDate: 2002-11-28 11:36:43
Subject: 'now' doesnt seem to work in stored procedure

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group