Re: Data missing from table........

No....

But I recovered data from another table....thanks for helping..
On Jan 22, 2014 11:30 PM, "Raymond O'Donnell" <rod(at)iol(dot)ie> wrote:

> 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(at)iol(dot)ie
>