Re: Default Value Retention After Dropping Default

2025-02-24 Thread David G. Johnston
On Mon, Feb 24, 2025 at 9:37 AM Adrian Klaver wrote: > On 2/24/25 03:50, Laurenz Albe wrote: > > On Mon, 2025-02-24 at 20:56 +1300, Marcelo Fernandes wrote: > >> I am experiencing an interesting behavior in PostgreSQL and would like > to seek > >> some clarification. > > > >> > >> Can anyone expl

Re: Default Value Retention After Dropping Default

2025-02-24 Thread Adrian Klaver
On 2/24/25 03:50, Laurenz Albe wrote: On Mon, 2025-02-24 at 20:56 +1300, Marcelo Fernandes wrote: I am experiencing an interesting behavior in PostgreSQL and would like to seek some clarification. Can anyone explain how PostgreSQL "knows about" the default value that has just been dropped a

Re: Default Value Retention After Dropping Default

2025-02-24 Thread Adrian Klaver
On 2/23/25 23:56, Marcelo Fernandes wrote: Hi folks, I am experiencing an interesting behavior in PostgreSQL and would like to seek some clarification. In the following snippet, I first add a column with a default value, then drop that default. However, when I query the table, the column still

Re: Default Value Retention After Dropping Default

2025-02-24 Thread Laurenz Albe
On Mon, 2025-02-24 at 20:56 +1300, Marcelo Fernandes wrote: > I am experiencing an interesting behavior in PostgreSQL and would like to seek > some clarification. > > In the following snippet, I first add a column with a default value, then drop > that default. However, when I query the table, the

Default Value Retention After Dropping Default

2025-02-23 Thread Marcelo Fernandes
Hi folks, I am experiencing an interesting behavior in PostgreSQL and would like to seek some clarification. In the following snippet, I first add a column with a default value, then drop that default. However, when I query the table, the column still retains the dropped default for existing rows