From: | mgbii bax <gezeala(at)gmail(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Pg Bugs <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #14862: create table with missing sequence bug |
Date: | 2017-10-19 18:33:38 |
Message-ID: | CAJKO3mVEqui6h46-Uike9jJu=VhG3QXP1n0UO0-znz6XDmoNdw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
On Thu, Oct 19, 2017 at 10:46 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> gezeala(at)gmail(dot)com writes:
>> --on a fresh db:
>> CREATE SCHEMA testschema;
>
>> --sequence is missing
>> --create table fails:
>> CREATE TABLE testschema.sometable1 (
>> col1 bigint DEFAULT
>> nextval('missingschema.missingsequence_id1'::regclass) NOT NULL,
>> col2 text
>> );
>
>> --sequence is missing
>> --create table works fine:
>> CREATE TABLE testschema.sometable2 (
>> col1 bigint DEFAULT
>> nextval(('missingschema.missingsequence_id2'::text)::regclass) NOT NULL,
>> col2 text
>> );
>
>> Only difference is sometable2 sequence definition has ::text::regclass.
>
> This looks like the expected and documented behavior to me. See the
> "Note" regarding early vs. late binding of sequence names at
>
> https://www.postgresql.org/docs/current/static/functions-sequence.html
>
> regards, tom lane
Thanks for looking into it.
--
regards
gezeala bacuño II
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2017-10-19 19:01:57 | Re: BUG #14861: Handle syntax_error |
Previous Message | Tom Lane | 2017-10-19 17:46:33 | Re: BUG #14862: create table with missing sequence bug |