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:10:04 |
Message-ID: | CAHjAGiMDQywWFkbozYFzJ9+Bn3zOKMWVDRxB1iD_Cn+r-wPFMg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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 | Ramy Abdel-Azim | 2011-11-09 21:28:14 | Re: column does not exist Error |
Previous Message | piotr | 2011-11-09 21:08:58 | Linux Mint 10 (julia): starting Postrgesql 8.4 at booting up |