On Wednesday, October 1, 2025, yanliang lei <[email protected]> wrote: > > dbversion180=# create table schema_1.test_tab_100(c1 int default > nextval('seq_xx_yy')); >
Since you didn’t schema qualify the sequence name every single time a default value is created the sequence will be looked up anew. The stored expression is not associated with any specific object. This is also why there is a separate step to mark a sequence as being owned by a table. That establishes a dependency that this textual form is unable to do. David J.
