Possible error in psql or Postgres?
От | Dusan Misic |
---|---|
Тема | Possible error in psql or Postgres? |
Дата | |
Msg-id | CAGdZ+ND2bN6KO4cPJRHSPVtC2vun5s+uoAUYKPXYvB2h2fgXvQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Possible error in psql or Postgres?
Re: Possible error in psql or Postgres? |
Список | pgsql-hackers |
<small><font>Is this normal Postgres / psql behavior?<br /><br /> griffindb=# \d system.user;<br /> Table "system.user"<br /> Column | Type | Modifiers<br/><br /> -----------+-----------------------+--------------------------------------------<br /> --------<br /> username | character varying(20) | not null<br /> password | character varying(32) | not null<br /> firstname | charactervarying(40) | not null default 'nema ime'::character vary<br /> ing<br /> lastname | character varying(40) | notnull default 'nema prezime'::character<br /> varying<br /> Indexes:<br /> "SystemUser_PK" PRIMARY KEY, btree (username)CLUSTER<br /><br /> normal query: <br /><br /> griffindb=# select * from system.user where username = 'root';<br/> username | password | firstname | lastname<br /> ----------+----------------------------------+-----------+---------------<br/> root | 1e7db545fccbf4e03abc6b71d329ab4f| Super | administrator<br /> (1 row)<br /><br /> error query:<br /><br /> griffindb=#select * from system.user where user = 'root';<br /> username | password | firstname | lastname<br /> ----------+----------+-----------+----------<br/> (0 rows)<br /><br /> column user does not exist should throw an error!<br/><br /> PostgreSQL / psql version: 9.1.3 on Windows 7 64-bit<br /><br /> Should Postgres or psql report an errorbecause column used in WHERE clause does not exist? </font><br /></small>
В списке pgsql-hackers по дате отправления: