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

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


Yes, i'm working with VS 2008 with QT framework working on a
application with i don't know couple hundred thousand lines of code.

Been using VS sense 1997  how about you???

One of your big problems is your using the Automatic Class builder. 
Its sucks and is what is causing your problem as it creates code that
don't work.

Case in point the SQL code is wrong. 

In this case the Select statement being created is trying to join two
tables together that have the same column name

Select * from mytable, othertable where ctid = ctid
this command will create the error you have

now to avoid the error it should look like this
Select * from mytable, othertable where mytable.ctid = othertable.ctid

Now Postgresql knows what you want it to do.  Before the Postgresql has
two columns with the same name and does not understand how to join the
two tables

Find the the code where the Select statement is change the Joining
argument


salman Sheikh wrote:


Hi Justin
  thanks for helping me,
  But can i ask u ,have u ever worked with Visual C++ 2005.It does
every thing automatically,u just click on the button it will generats
all classes, for example View class, document class Set class and so
on,Set class is actually connection class,which connect application
with database, and shows all columns of the table which we added in
this application,thatwhy i dont need to write any sql code for adding
all table,how long i know,if i am wrong pls correct me.
  thanks once more Jusitn
  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 02:02:21
        An: pgsql-general@postgresql.org
        Betreff: Re: [GENERAL] Error in Adding All Tables

        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
thedatabase. 
The select insert update commands.   If i could see what you are doingi
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++ itgenerates all classes automatically,if i add table one by one,it
showsno problem.i can comunicate with my database.But if i add 2 or
moretables 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" <a moz-do-not-send="true"
 class="moz-txt-link-rfc2396E" href="mailto:justin@emproshunts.com"><justi
n@emproshunts.com>
                Gesendet: 02.11.08 01:48:04
                An: <a moz-do-not-send="true"
 class="moz-txt-link-abbreviated"
 href="mailto:pgsql-general-owner@postgresql.org">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 theSQLcommands 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><
/A>
                        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 iwant toa dd themall togather.
                                 After Adding all tables, it shows
me alwaysthiserrors bydebugging.

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

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

                                thanks
She ikh


                                <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
neuenWEB.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
hardtoknowwhat the problem is

but ambiguous column means the Postgresql can't figure o ut
whatyouwantto 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; font-family: verdana;">n5Schritten 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" alt=""
 src="https://img.web.de/p.gif" border="0" height="1" width="1">


                er
WEB.DESmartSurfer 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  















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


        <td
 style="font-family: verdana; font-size: 12px; line-height: 17px;">n 5
Schritten 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