| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Kouber Saparev <postgresql(at)saparev(dot)com>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #1883: Renaming a schema leaves inconsistent sequence |
| Date: | 2005-09-23 04:12:23 |
| Message-ID: | 29560.1127448743@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> writes:
> On Thu, Sep 22, 2005 at 10:29:21PM -0400, Tom Lane wrote:
>> (wanders off, wondering if a "regclass" literal value would help ...)
> Wouldn't it be easy to create a nextval(oid) function, and have SERIAL
> emit that instead?
Well, for one thing, "nextval(583726163)" isn't likely to dump and
restore nicely. Making the literal be type regclass rather than bare
OID will probably help that, but I'm not sure it's a 100% solution.
If I recall the previous discussions correctly there were still some
gotchas :-(
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-09-23 04:35:02 | Re: BUG #1883: Renaming a schema leaves inconsistent sequence |
| Previous Message | Alvaro Herrera | 2005-09-23 03:12:28 | Re: BUG #1883: Renaming a schema leaves inconsistent sequence |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-09-23 04:35:02 | Re: BUG #1883: Renaming a schema leaves inconsistent sequence |
| Previous Message | Bruce Momjian | 2005-09-23 03:42:30 | Re: SQL/XML public functions documentation for PostgreSQL |