Hi,
I found a strange behavior in PostgreSQL.
I created a table as user pippo then I created a view based upon this
tables,
latter someone drops user pippo and now when I do:
select from view PostgreSQL show me this:
pg_aclcheck: invalid user id #
I suppose it is because the user pippo the owner of this view, is any
more in the database
but if I do select from table it works fine.
Is this a bug?
Jose
[color=blue]
>
>
>[/color]
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)
I found a strange behavior in PostgreSQL.
I created a table as user pippo then I created a view based upon this
tables,
latter someone drops user pippo and now when I do:
select from view PostgreSQL show me this:
pg_aclcheck: invalid user id #
I suppose it is because the user pippo the owner of this view, is any
more in the database
but if I do select from table it works fine.
Is this a bug?
Jose
[color=blue]
>
>
>[/color]
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddres sHere" to majordomo@postg resql.org)