Re: Error in Adding All Tables - Mailing list pgsql-general

<meta content="text/html;charset=ISO-8859-15"
 http-equiv="Content-Type">


you mean you are trying some kind of table joining correct???

example

Select * from mytable, othertable where ctid = ctid ???

Please post the SQL statement you are using to communicate with the
database. 
The select insert update commands.   If i could see what you are doing
i would have solved your problem 3 emails ago.

just post the C++ code that has the problem




salman Sheikh wrote:


 Hi
  i just want to add table through MFC application,in Visual C++ it
generates all classes automatically,if i add table one by one,it shows
no problem.i can comunicate with my database.But if i add 2 or more
tables togather,then it shows this error, i dont know why?
  sheikh

  <table id="alt"
 style="border-left: 2px solid blue; padding-left: 10px; font-size: 9pt; margin-left: 20px; font-family: Verdana;">



        Von: "justin" <justin@emproshunts.com>
        Gesendet: 02.11.08 01:48:04
        An: pgsql-general-owner@postgresql.org
        Betreff: Re: [GENERAL] Error in Adding All Tables

        I have no idea what you are trying to do??   please send the
SQLcommands you are using. 

For me to help you
Need to know what you are trying to accomplish and need to see the code!


salman Sheikh wrote:


 hi
          Do u ha ve any suggestion regarding this problem?
          can u add all tables once in postgresql?
          In MS access i can add table once without any problem.
          sheikh

          <table id="alt"
 style="border-left: 2px solid blue; padding-left: 10px; font-size: 9pt; margin-left: 20px; font-family: Verdana;">



                Von: "justin" <a moz-do-not-send="true"
 class="moz-txt-link-rfc2396E" href="mailto:justin@emproshunts.com"><justin@emproshunts.com>
                Gesendet: 02.11.08 01:23:15
                An: salman Sheikh
                CC: <a moz-do-not-send="true"
 class="moz-txt-link-abbreviated"
 href="mailto:pgsql-general@postgresql.org">pgsql-general@postgresql.org,<a
 moz-do-not-send="true" class="moz-txt-link-abbreviated"
 href="mailto:pgsql-odbc@postgresql.org">pgsql-odbc@postgresql.org
                Betreff: Re: [GENERAL] Error in Adding All Tables

                @WEB.DE>
                salman Sheikh wrote:


                  <table id="alt"
 style="border-left: 2px solid blue; padding-left: 10px; font-size: 9pt; margin-left: 20px;">



                        Hi freinds,
i wanted to add my all tables once in MFC application,
                        i have a databank,which has 11 tables and i
want toa dd themall togather.
                         After Adding all tables, it shows me always
thiserrors bydebugging.

ERROR: column reference "ctid" is ambiguous;
Error while executing the query

                        i need help from u ppl. I am using Visual
C++ 2005andpostgresql 8.3.

                        thanks
Sheikh


                        <table border="0" cellpadding="0"
 cellspacing="0">


                              <img
 moz-do-not-send="true" alt="" src="https://img.web.de/p.gif" border="0"
 height="1" width="1">


                              <td
 style="font-size: 12px; font-family: verdana;">Psssst!Schonvom neuen
WEB.DE MultiMessenger geh&oum l;rt?    
Der kann`s mit allen: <a moz-do-not-send="true"
 href="http://www.produkte.web.de/messenger/?did=3123">http://www.produkte.web.de/messenger/?did=3123  










Without looking at the sql statement you are using its kinda hardtoknow
what the problem is

but ambiguous column means the Postgresql can't figure o ut whatyouwant
to do as the column shows up twice in a command.












                <img moz-do-not-send="true" alt=""
 src="https://img.web.de/p.gif" border="0" height="1" width="1">


                <td
 style="font-size: 12px; line-height: 17px; font-family: verdana;">n
5Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten!    
Nur 3,99 EUR/Monat! <a moz-do-not-send="true"
 href="http://www.maildomain.web.de/?mc=021114">http://www.maildomain.web.de/?mc=021114  















        <img moz-do-not-send="true"
 src="https://img.web.de/p.gif" alt="" border="0" height="1" width="1">


        er WEB.DE
SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!   
        <a moz-do-not-send="true"

href="http://smartsurfer.web.de/?mc=100071&distributionid=000000000066">http://smartsurfer.web.de/?mc=100071&distributionid=000000000066