>>> Pavel Stehule 9/7/2009 3:47 PM >>>
Hello
2009/9/7 Tomasz Karlik :
>
>
Alvaro Herrera 9/4/2009 7:23 PM >>>
> tkar...@ultimo.pl wrote:
>
>> Without casting function executes much slower:
>>
>> CREATE OR REPLACE FUNCTION table_exists(tblname text) RETURNS boolean AS '
>> DECLARE
>> exis
The following bug has been logged online:
Bug reference: 5043
Logged by: Martin Edlman
Email address: edl...@fortech.cz
PostgreSQL version: 8.2.0
Operating system: Linux (RHEL 4.4)
Description:Stored procedure returning different results for same
arguments
Details:
"Martin Edlman" writes:
> When I call "select get_schemebind_date(1004,'2009-09-01')" from psql I get
> correct result, which is 2009-09-01.
> But when I call it from within another sp (let's call it xfunc(int, date,
> varchar), I get wrong result 2008-11-01.
The only thought that comes to mind i
Hello
please send function xfunc. Your code looks well.
please try sql function
CREATE OR REPLACE FUNCTION get_schemebind_date(integer, date)
RETURNS date AS $$
SELECT max(valid_from)
FROM schemebind
WHERE valid_from <= $2 AND contractid = $1;
$$ LANGUAGE sql;
has it same behave like plpgsql
Tom,
I ran the test scenario again and it appears that you are right. The
first test most likely was executed with the command
"pg_try_advisory_lock(12345)" instead of
"pg_try_advisory_lock_shared(12345)" as you stated. When I ran the
scenario again using "pg_try_advisory_lock_shared(12345)", th
hi all:
i use Python and PyGreSQL to link PostgreSQL
but the Python give me the error
the error here :
...
95
93
95
97
94
96
94
message type 0x43 arrived from server while idle
message type 0x5a arrived from server while idle
INSERT INTO code (stock_
The following bug has been logged online:
Bug reference: 5044
Logged by: vyouzhi
Email address: vyou...@gmail.com
PostgreSQL version: 8.4.0
Operating system: linux 2.6.25
Description:error: message type 0x5a arrived from server while idle
Details:
hi all:
i use Pyt
Hi.
dblink generates orphaned connections when we failed on performing dblink()
function.
# But it occurs only when dblink('conn_str', 'sql', true). See following
examples.
==
$ pslq local
local=# SELECT datname, procp
