| From: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Michael Fuhr <mike(at)fuhr(dot)org>, Gary Doades <gpd(at)gpdnet(dot)co(dot)uk>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: Permissions problem with sequences |
| Date: | 2004-09-09 04:36:29 |
| Message-ID: | 413FDDCD.8030809@familyhealth.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
>>What if they change the owner of the serial sequence independently
>>anyway?
>
> I suppose a complete solution would involve forbidding that. We don't
> allow you to alter the owner of an index independently of its parent
> table ...
Problem is existing dump files. Oh, hang on - this is new for 8.0.
Hmmm...so what do we do then? I have been seriously pressed for time
the last few weeks, so I don't have time to make alter table alter all
the serial seqeunces on a table as well :(
I've got a mostly working fix for the bug that involves alter owner on
the sequence, but let me know if you want me to finish it.
Chris
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-09-09 04:39:07 | Re: Permissions problem with sequences |
| Previous Message | Tom Lane | 2004-09-09 04:14:50 | Re: Permissions problem with sequences |