problems with query

From: "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: problems with query
Date: 2000-12-20 20:23:20
Message-ID: 00122017232101.11600@math.unl.edu.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi, I have this table on postgres-7.0.3

CREATE TABLE ciudad (
id_ciudad SERIAL,
ciudad VARCHAR(60)
);

GRANT ALL ON ciudad TO martin;

CREATE INDEX ciudad_idx ON ciudad (ciudad);

And I try to insert a value using this query:

INSERT INTO ciudad (ciudad) VALUES ("Villa Guillermina")

getting as responce the message:

ERROR: Attribute 'Villa Guillermina' not found.

The field ciudad is of type varchar(60), so I don't get why it gives me this
message.

Any ideas?

--
System Administration: It's a dirty job,
but someone told I had to do it.
-----------------------------------------------------------------
Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Swan 2000-12-20 20:26:16 Re: problems with query
Previous Message Marc SCHAEFER 2000-12-20 19:04:50 Re: Re: [ADMIN] Help me for "DBI->connect failed: Sorry, too many clients already."

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Swan 2000-12-20 20:26:16 Re: problems with query
Previous Message Tom Lane 2000-12-20 20:12:14 Re: Re: Table name scope (was Re: [BUGS] Outer joins aren't working with views)