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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
>>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Craig Barnes | 2011-11-09 21:37:37 | Re: column does not exist Error |
Previous Message | Ramy Abdel-Azim | 2011-11-09 21:10:04 | Re: column does not exist Error |