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
