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
-----------------------------------------------------------------
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." |
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) |