| 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: | Whole Thread | Raw Message | 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) |