pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Manfred Koizar <mkoi-pg@aon.at>
To: vernonw@gatewaytech.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Please help me out on this insert error
Date: Fri, 14 Jun 2002 00:26:29 +0200
Message-ID: <3s6igukoh2bmechd9fnhj05os7mnup2q94@4ax.com> (raw)
In-Reply-To: <TQWRKJIWV95LKS653WWR835NKIB0.3d082aad@kimiko>
References: <TQWRKJIWV95LKS653WWR835NKIB0.3d082aad@kimiko>

On Thu, 13 Jun 2002 13:16:29 +0800, Vernon Wu
<vernonw@gatewaytech.com> wrote:
>
>Command:
>
>Insert into profile (userid, haveChildren)values('id98', 'No');
>
>Error:
>
>ERROR:  Relation 'profile' does not have attribute 'havaChildren'
                                                        ^
                                 cut'n'paste error here ?

>Table:
>                 Table "profile"
>    Column    |         Type          | Modifiers
>--------------+-----------------------+----------
> userid       | character varying(25) | not null
> [...]
> haveChildren | character varying(20) | not null

Anyway, try
Insert into profile (userid, "haveChildren") values('id98', 'No');

Servus
 Manfred



view thread (7+ messages)  latest in thread

Message-ID: <3s6igukoh2bmechd9fnhj05os7mnup2q94@4ax.com>
Permalink:  ../3s6igukoh2bmechd9fnhj05os7mnup2q94@4ax.com/
Also on:    postgresql.org/message-id/3s6igukoh2bmechd9fnhj05os7mnup2q94@4ax.com

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: mkoi-pg@aon.at, vernonw@gatewaytech.com
  Subject: Re: Please help me out on this insert error
  In-Reply-To: <3s6igukoh2bmechd9fnhj05os7mnup2q94@4ax.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox