Skip site navigation (1) Skip section navigation (2)

Re: column does not exist Error

From: Ramy Abdel-Azim <ramy(dot)abdel-azim(at)startdatelabs(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: column does not exist Error
Date: 2011-11-09 21:28:14
Message-ID: CAHjAGiNyh0dWK79M2BCxHHmrg=DN-a+n1zzV2JY-GCZnZNbXPw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
well...
probably this is the problem/solution:

http://www.fettesps.com/postgres-column-name-does-not-exist/

i'll give it a shot now. if you don't hear from me, this worked ;-)

On Wed, Nov 9, 2011 at 4:10 PM, Ramy Abdel-Azim <
ramy(dot)abdel-azim(at)startdatelabs(dot)com> wrote:

> it may be worth noting that i'm not naming all of the columns in the DB
> table explicitly in the list of columns. I've omitted the second column
> name as well as having omitted a value for the second column. I've tried
> however to put the second column name into the column list and a value for
> the second column. I still get the same error, though.
>
>
> On Wed, Nov 9, 2011 at 4:06 PM, Ramy Abdel-Azim <
> ramy(dot)abdel-azim(at)startdatelabs(dot)com> wrote:
>
>> Hello,
>>
>> I'm getting a confusing error message. I'm trying to insert a row into a
>> database table called "users". I'm trying to insert using the form:
>>
>> insert into table (column, column1, column2)
>> values (value, value1, value2)
>>
>> however, i'm getting an error message that, relative to the query i
>> provide above, would say this:
>>
>> ERROR:  column value1 does not exist
>>
>> LINE 5:   "value1","value2"
>>
>>                ^
>>
>> ....I didn't specify value1 AS a column. Why is it telling me the value
>> i'm trying to insert is not a column. It shouldn't be a column. Why does it
>> think it IS a column?
>>
>>
>> Thanks,
>>
>> _Ramy
>>
>
>

In response to

Responses

pgsql-novice by date

Next:From: Craig BarnesDate: 2011-11-09 21:37:37
Subject: Re: column does not exist Error
Previous:From: Ramy Abdel-AzimDate: 2011-11-09 21:10:04
Subject: Re: column does not exist Error

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group