| From: | "Rod Taylor" <rod(dot)taylor(at)inquent(dot)com> |
|---|---|
| To: | "Hackers List" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Permissions on SERIAL |
| Date: | 2001-02-23 04:48:15 |
| Message-ID: | 026b01c09da6$11858970$2205010a@jester |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Appears that permissions applied to a table using the SERIAL element
aren't carried over to the sequence itself.
Create table with SERIAL, set-up permissions so table is accessible,
attempt to use inserts. No permission to sequence :(
Guess I won't be using this shortcut, between this and them being left
behind it makes SERIAL a pain in the ass. Atleast names for the
sequence are usually predictable.
--
Rod Taylor
There are always four sides to every story: your side, their side, the
truth, and what really happened.
| Attachment | Content-Type | Size |
|---|---|---|
| Taylor, Rod B.vcf | text/x-vcard | 451 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-02-23 06:38:39 | Lock structures |
| Previous Message | Bruce Momjian | 2001-02-23 04:04:23 | Re: [HACKERS] Re: [INTERFACES] Re: Chinese patch for Pgaccess |