Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W626A-0000hT-0p for pgsql-php@arkaria.postgresql.org; Wed, 22 Jan 2014 18:00:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1W6269-0006CR-Dr for pgsql-php@arkaria.postgresql.org; Wed, 22 Jan 2014 18:00:21 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W6268-0006CE-Ku for pgsql-php@postgresql.org; Wed, 22 Jan 2014 18:00:20 +0000 Received: from teladesign.vm.bytemark.co.uk ([89.16.172.204]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1W6261-0004wy-7a for pgsql-php@postgresql.org; Wed, 22 Jan 2014 18:00:19 +0000 Received: from [109.78.168.76] (helo=[127.0.0.1]) by teladesign.vm.bytemark.co.uk with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.72) (envelope-from ) id 1W625y-0003z2-Te; Wed, 22 Jan 2014 18:00:11 +0000 Message-ID: <52E00723.4010408@iol.ie> Date: Wed, 22 Jan 2014 18:00:03 +0000 From: Raymond O'Donnell Reply-To: rod@iol.ie User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 MIME-Version: 1.0 To: Archana K N , PostgreSQLPHP Subject: Re: Data missing from table........ References: <52DFB99E.1050901@iol.ie> <52DFBAF3.3060300@iol.ie> In-Reply-To: X-Enigmail-Version: 1.6 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 140121-1, 21/01/2014), Outbound message X-Antivirus-Status: Clean X-Pg-Spam-Score: -0.5 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-php Precedence: bulk Sender: pgsql-php-owner@postgresql.org On 22/01/2014 13:02, Archana K N wrote: > Hi, > > I am working on Debian OS. Using Python for scripting and Psycopg2 as > interface for postgres. Hi Archana, Please keep your replies on-list. Also, you'd probably be better off to post to pgsql-general; this list is for PHP. > > For adding columns:- > ALTER TABLE name ADD COLUMN; > > For Updation:- > > UPDATE tbl_name SET col=value FROM(SELECT col FROM tabl2) AS somnam > WHERE condition; > > For Insertion:- > > INSERT INTO table_name VALUES(); > > > I tried to update another column , when I retrieved that specific one , > say updated col-1 and retrieved it, then all the retrieved value was > > blank. Tried thru script then the updated columns where 'None'. > > In .conf files I just made the 'LISTEN ADDRESS to * and added a new line > in hba.conf say 'host all all ip/mask md5. thats all. I don't see anything there that would cause data to disappear. I'm not familiar with either Python or Psycopg2, but could something be rolling back the transaction after the UPDATE? The other thought I had was that you were inadvertently connecting to a different database - probably a silly question, but could that be possible? Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie -- Sent via pgsql-php mailing list (pgsql-php@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-php