Re: Error in Adding All Tables - Mailing list pgsql-general
From | justin |
---|---|
Subject | Re: Error in Adding All Tables |
Date | |
Msg-id | 490D0A05.3030502@emproshunts.com Whole thread Raw |
In response to | Error in Adding All Tables (salman Sheikh <salman_sheikh@web.de>) |
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
pgsql-general by date: