[SQL] Issue while using PostgreSql 8.4.

2010-12-23 Thread Atul Kumar
to delete that table . I am observing application is getting hang while executing statement.execute(). Please suggest me how to fix this issue. Thanks Atul Kumar DISCLAIMER == This e-mail may contain privileged and confidential information which is the property of Persistent Systems L

[SQL] UNSUBSCRIBE

2003-11-04 Thread Atul Pedgaonkar
UNSUBSCRIBE ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

[SQL] About Postgresql Service on SUN OS

2003-07-01 Thread Atul Pedgaonkar
Hello, Any one who knows, how to start the postgresql service on sun solaris server. Please help me in this regards. Thank you. Regards, Atul Pedgaonkar ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] How to increase Column width of table

2003-03-25 Thread Atul Pedgaonkar
Hello, Atul here, i have one table and i would like to increase the length of existing column and the sql statement is Exisiting Column is "vehicle_make" varchar(30) SQL: alter table commute_profile alter column "vehicle_make" varchar(100)

[SQL] Postgresql To Oracle9i

2003-02-05 Thread Atul Pedgaonkar
Hello, Atul here From india.Anyone who knows how to mirgrate the data from postgresql7.2 to Oracle9i.Please give the idea or methood to transfer the data. Thank you. Regards, Atul... ---(end of broadcast)--- TIP 5: Have you checked our

Re: [SQL] Stored Procedure Problem

2002-12-12 Thread Atul
eturn an_integer,an_name;  END;  '  LANGUAGE 'plpgsql';   But This Gives Error(For Multiple column , not for single column) Please Let me know.   Thanks   Atul…

[SQL] Stored Procedure Problem

2002-12-12 Thread Atul
Hello,       Atul Here, I have one problem while accessing Database Records Or Recordset from stored procedure. Procedure is like this,   CREATE FUNCTION b_function() RETURNS int4 AS ' DECLARE    an_integer int4; BEGIN    select emp_id from employee;    r

[SQL] Need Postgresql Help

2002-12-02 Thread Atul Pedgaonkar
Respected sir, Atul Pedgaonkar here from india. I am using postgresql7.2 as backend and for front-end ,perl5.6.1. I need some help regarding postgresql stored procedure. The problem is like this 1)How to create stored procedure in postgresql ? 2)How can i use it

[SQL] Need Postgresql Help

2002-12-02 Thread Atul
Respected sir, Atul Pedgaonkar here from India. I am using postgresql7.2 as backend and for front-end, perl5.6.1. I need some help regarding postgresql-stored procedure. The problem is like this     1)How to create stored procedure in postgresql?     2)How can i