Dear all,
How are the connection requestion handled in postgres. Is it different with different
operating systems. And how can I know the number of open connections in windows.
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Dear all,
How are the connection requestion handled in postgres. Is it different with different
operating systems. And how can I know the number of open connections in windows.
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Fax : 91-824-2451050
DISCLAIMER: This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
DISCLAIMER: This message contains privileged and confidential information and is
intended only for the individual named.If you are not the intended
recipient you should not disseminate,distribute,store,print, copy or
deliver this message.Please notify the sender immediately by e-mail if
you
4:12p
Dear all,
I am facing problems with the postgres(7.3.1) on windows machine(98). The problem is
with pg_recvbuf. And here are the logs..
Can any one teach me more on this
LOG: pq_recvbuf: unexpected EOF on client connection
LOG: pq_recvbuf: unexpected EOF on client connection
LOG:
You do realize that the shell is going to interpret that string in
double quotes right?
I guess so, for the very same I have tried with
Command: psql test -c CREATE FUNCTION add_one (integer) RETURNS
INTEGER AS ' BEGIN RETURN ''$1'' + 1; END; ' LANGUAGE
'plpgsql';
But still it
10:12a
Dear all,
This is about the same problem which I have been facing for the past one week and
which I am unable to solve.
I have create a function which return +1 of the argument passed.
Function Definition:
CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
BEGIN
RETURN $1
Command: psql test -c CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
BEGIN REURN $1 + 1; END; ' LANGUAGE 'plpgsql';
Result: CREATE FUNCTION
And the function executed perfectly fine.
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Hey,
create or replace function sample(varchar,int) returns varchar as'
declare
data alias for $1;
size alias for $2;
begin
return substr(data,(length(data)-size)+1,length(data));
end;
' language 'plpgsql';
WARNING: plpgsql: ERROR during
5:08p
Dear All,
When I am executing any function with parameter.. I am unable to access them. So, I
would be thankful if, anyone can help me in teaching this aspect.
CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
BEGIN
RETURN $1 + 1;
END;
' LANGUAGE 'plpgsql';
The
Can any one tell me when would a primary key be refered to as foreign key in
its own table.
-
Warm Regards
Shÿam Peri
II Floor, Punja Building,
M.G.Road,
Ballalbagh,
Mangalore-575003
Ph : 91-824-2451001/5
Fax : 91-824-2451050
DISCLAIMER: This message contains privileged and confidential
11 matches
Mail list logo