MIME-Version: 1.0
In-Reply-To: 
 <CAMdfv4XEHpa8XSYf1C5EG5CE_VbcpptxiijUNOzj3HEvwLOaxQ@mail.gmail.com>
References: 
 <CAMdfv4XEHpa8XSYf1C5EG5CE_VbcpptxiijUNOzj3HEvwLOaxQ@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 3 Sep 2025 09:09:07 -0700
Message-ID: 
 <CAKFQuwYQBr7Fw4S9y_nWNS7A6WnyDXf5HZ+Zq85_3nW4kUxKLg@mail.gmail.com>
Subject: Re: Adding timestamp column
To: Mauricio Fernandez <mmauricio.fernandez@gmail.com>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000001f9e59063de7d38b"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwYQBr7Fw4S9y_nWNS7A6WnyDXf5HZ%2BZq85_3nW4kUxKLg%40mail.gmail.com>
Precedence: bulk

--0000000000001f9e59063de7d38b
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, September 3, 2025, Mauricio Fernandez <
mmauricio.fernandez@gmail.com> wrote:
>
>
> But, when I want to alter the table I get  a syntax error
>
> alter table MDL_LOGSTORE_STANDARD_LOG
>   add column datecreated timestamp
>   generated always as ( timezone ('America/Santiago'::text,
> to_timestamp(timecreated::double precision)));
>
> SQL Error [42601]: ERROR: syntax error at end of input
>   Position: 185
>
>
Unless you are experimenting with v18 the docs clearly indicate the keyword
=E2=80=9Cstored=E2=80=9D is mandatory (since the implemented in 18 virtual =
is the default).

David J.

--0000000000001f9e59063de7d38b
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Wednesday, September 3, 2025, Mauricio Fernandez &lt;<a href=3D"mailto:m=
mauricio.fernandez@gmail.com">mmauricio.fernandez@gmail.com</a>&gt; wrote:<=
blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex"><div dir=3D"ltr"><div><br></div><div>But, whe=
n I want to alter the table I get=C2=A0 a syntax=C2=A0error</div><div><br><=
/div><div>alter table MDL_LOGSTORE_STANDARD_LOG <br>=C2=A0 add column datec=
reated timestamp <br>=C2=A0 generated always as ( timezone (&#39;America/Sa=
ntiago&#39;::text, to_timestamp(timecreated::<wbr>double precision)));<br><=
/div><div><br></div><div>SQL Error [42601]: ERROR: syntax error at end of i=
nput<br>=C2=A0 Position: 185</div><div><br></div></div></blockquote><div><b=
r></div><div>Unless you are experimenting with v18 the docs clearly indicat=
e the keyword =E2=80=9Cstored=E2=80=9D is mandatory (since the implemented =
in 18 virtual is the default).</div><div><br></div><div>David J.</div><div>=
=C2=A0</div>

--0000000000001f9e59063de7d38b--