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

--047d7b3a946ad4e63004f09363de
Content-Type: text/plain; charset=ISO-8859-1

No....

But I recovered data from another table....thanks for helping..
On Jan 22, 2014 11:30 PM, "Raymond O'Donnell" <[email protected]> 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
> [email protected]
>

--047d7b3a946ad4e63004f09363de
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<p>No....</p>
<p>But I recovered data from another table....thanks for helping..</p>
<div class=3D"gmail_quote">On Jan 22, 2014 11:30 PM, &quot;Raymond O&#39;Do=
nnell&quot; &lt;<a href=3D"mailto:[email protected]">[email protected]</a>&gt; wrote:<br =
type=3D"attribution"><blockquote class=3D"gmail_quote" style=3D"margin:0 0 =
0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On 22/01/2014 13:02, Archana K N wrote:<br>
&gt; Hi,<br>
&gt;<br>
&gt; I am working on Debian OS. Using Python for scripting and Psycopg2 as<=
br>
&gt; interface for postgres.<br>
<br>
Hi Archana,<br>
<br>
Please keep your replies on-list. Also, you&#39;d probably be better off to=
<br>
post to pgsql-general; this list is for PHP.<br>
<br>
&gt;<br>
&gt; For adding columns:-<br>
&gt; ALTER TABLE name ADD COLUMN;<br>
&gt;<br>
&gt; For Updation:-<br>
&gt;<br>
&gt; =A0UPDATE tbl_name SET col=3Dvalue FROM(SELECT col FROM tabl2) AS somn=
am<br>
&gt; WHERE condition;<br>
&gt;<br>
&gt; For Insertion:-<br>
&gt;<br>
&gt; =A0INSERT INTO table_name VALUES();<br>
&gt;<br>
&gt;<br>
&gt; I tried to update another column , when I retrieved that specific one =
,<br>
&gt; say updated col-1 and retrieved it, then all the retrieved value was<b=
r>
&gt;<br>
&gt; blank. =A0Tried thru script then the updated columns where &#39;None&#=
39;.<br>
&gt;<br>
&gt; In .conf files I just made the &#39;LISTEN ADDRESS to * and added a ne=
w line<br>
&gt; in hba.conf say &#39;host all all ip/mask md5. thats all.<br>
<br>
I don&#39;t see anything there that would cause data to disappear.<br>
<br>
I&#39;m not familiar with either Python or Psycopg2, but could something be=
<br>
rolling back the transaction after the UPDATE?<br>
<br>
The other thought I had was that you were inadvertently connecting to a<br>
different database - probably a silly question, but could that be possible?=
<br>
<br>
Ray.<br>
<br>
<br>
--<br>
Raymond O&#39;Donnell :: Galway :: Ireland<br>
<a href=3D"mailto:[email protected]">[email protected]</a><br>
</blockquote></div>

--047d7b3a946ad4e63004f09363de--