>> ALTER SEQUENCE ... OWNER TO ...;
>> GRANT ... ON SEQUENCE ... TO ...;
>> ...
>>
>
>I don't quite understand why it should be your way and not the other. Care
>to
>explain?
>
>Regards.
>
>
>--
>Guillaume.
Oops, sorry, there is no syntax ALTER SEQUENCE ... OWNER TO ...;
But since release 8.2,
Le vendredi 9 octobre 2009 à 09:50:22, Dmitry Samokhin a écrit :
> For sequences, the DDL script generated looks like:
>
> CREATE SEQUENCE ...;
> ALTER TABLE ... OWNER TO ...;
> GRANT ... ON TABLE ... TO ...;
> ...
>
> ... but should be:
>
> ...
> ALTER SEQUENCE ... OWNER TO ...;
> GRANT ... ON
For sequences, the DDL script generated looks like:
CREATE SEQUENCE ...;
ALTER TABLE ... OWNER TO ...;
GRANT ... ON TABLE ... TO ...;
...
... but should be:
...
ALTER SEQUENCE ... OWNER TO ...;
GRANT ... ON SEQUENCE ... TO ...;
...
Regards,
Dmitry.
--
Sent via pgadmin-support mailing list
