This is a discussion on Surprising syntax error within the Pgsql General forums, part of the PostgreSQL category; --> The statement: revoke all on view internal.all_objects from public; yields a syntax error. The docs show that the word ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| The statement: revoke all on view internal.all_objects from public; yields a syntax error. The docs show that the word "view" is not acceptable in this statement which is fine but the surprising thing is that: revoke all on table internal.all_objects from public; works fine even though all_objects is a view and not a table. Now that I know about it, this doesn't bother me but it was a surprise and I wonder whether the the parser/planner/whatever should be a bit smarter about allowing the word table to apply to non-tables, and whether the word view ought to be allowed. __ Marc -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQBIKzhYUBr6u+c2wkERAkq4AJ0YChEZagyPx6PvbR9eIS rFLhEjJwCfbg3Q dIVJ0fGr7uK2tU76lX6sr9A= =/grW -----END PGP SIGNATURE----- |