[ADMIN] Connection handling

2003-10-21 Thread shyamperi
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

[ADMIN] Connection handling

2003-10-21 Thread shyamperi
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

[ADMIN] unsubscribe

2003-10-20 Thread shyamperi
- 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

[ADMIN] Serious Problem with the windows and postgres configuration

2003-10-09 Thread shyamperi
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

[ADMIN] Problem with the pq_recvbuf

2003-10-08 Thread shyamperi
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:

Re: [ADMIN] error with functions

2003-09-22 Thread shyamperi
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

[ADMIN] error with functions

2003-09-21 Thread shyamperi
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

Re: [ADMIN] error with functions

2003-09-21 Thread shyamperi
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,

[ADMIN] Error with functions

2003-09-20 Thread shyamperi
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

Re: [ADMIN] Error with functions

2003-09-20 Thread shyamperi
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

[ADMIN] PK and FK relation ship

2003-09-11 Thread shyamperi
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