[GENERAL] Information regarding currently locked tables

2006-10-18 Thread Nirmalya Lahiri
Hi all, I want a list of currently locked tables. How can I do that? I already found a list from pg_locks table. But how I know the name of the table against relation id of a relation? Nirmalya Lahiri(+91-94331-13536) Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small

Re: [GENERAL] Update from diferents conditions

2006-04-15 Thread Nirmalya Lahiri
I think it is not possible using a single SQL command. You have to issue separate SQL command for each row. --- Claudio Alejandro Ulloa Heinsohn [EMAIL PROTECTED] wrote: i want update differents rows of a table, but each row with a diferente condition, is possible make that update?

Re: [GENERAL] Comparing text field

2006-04-15 Thread Nirmalya Lahiri
You have made a wrong mistake in your SQL quary. Your quary should be look like this. SELECT id FROM table1 WHERE message like '%VAC153-683-685-131830- /O.NEW.KLWX.SV.W.0022.060413T1742Z-060413T1830Z/ BULLETIN - EAS ACTIVATION REQUESTED SEVERE THUNDERSTORM WARNING NATIONAL WEATHER SERVICE

Re: [GENERAL] encryption/decryption

2006-04-01 Thread Nirmalya Lahiri
Hi Akhilesh, Can you send the script please I want to see that. --Nirmalya --- AKHILESH GUPTA [EMAIL PROTECTED] wrote: hi all, just to ask u all one thing regarding encryption/decryption. i am migrating my database from mysql to pgSQL using a php script. in mysql there is a table

Re: [GENERAL] Broken pipe

2005-10-03 Thread Nirmalya Lahiri
..lets try the process written above. I am waiting for your reply. --Nirmalya --- Ben-Nes Yonatan [EMAIL PROTECTED] wrote: - Original Message - From: Nirmalya Lahiri [EMAIL PROTECTED] To: pgsql-general@postgresql.org Sent: Sunday, October 02, 2005 7:34 PM Subject: Re: [GENERAL

Re: [GENERAL] Broken pipe

2005-10-02 Thread Nirmalya Lahiri
Hi all, I am not expert in PHP, so my assumption may not correct Can we solve this problem by increasing the max_execution_time value at php.ini file? --Nirmalya --- Ben-Nes Yonatan [EMAIL PROTECTED] wrote: Hi all, I sent the following email to the php mailing list also but maybe

[GENERAL] Private or publice function

2005-01-11 Thread Nirmalya Lahiri
Hi, How can I create a publice or private function? Nirmalya Lahiri __ Do you Yahoo!? Yahoo! Mail - 250MB free storage. Do more. Manage less. http://info.mail.yahoo.com/mail_250 ---(end of broadcast

Re: [GENERAL] Private or publice function

2005-01-11 Thread Nirmalya Lahiri
function_4(), only from withen the function_1() I can call function_2() and function_3(). Is it possible in PostgreSQL? Nirmalya Lahiri --- Richard Huxton dev@archonet.com wrote: Nirmalya Lahiri wrote: Hi, How can I create a publice or private function? I'm not sure the concept makes sense