MIME-Version: 1.0
From: Mauricio Fernandez <mmauricio.fernandez@gmail.com>
Date: Wed, 3 Sep 2025 11:50:57 -0400
Message-ID: 
 <CAMdfv4XEHpa8XSYf1C5EG5CE_VbcpptxiijUNOzj3HEvwLOaxQ@mail.gmail.com>
Subject: Adding timestamp column
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="000000000000ac7e91063de7922c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAMdfv4XEHpa8XSYf1C5EG5CE_VbcpptxiijUNOzj3HEvwLOaxQ%40mail.gmail.com>
Precedence: bulk

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

Hi admins, greetings.

I'm trying to add a timestamp column in an existent table.

This query works fine:

select timecreated, timezone('America/Santiago'::text,
to_timestamp(timecreated::double precision)) datecreated
from MDL_LOGSTORE_STANDARD_LOG;

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

I would appreciate some tips

Thanks in advanced

kind regards

Mauricio Fern=C3=A1ndez

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

<div dir=3D"ltr">Hi admins, greetings.<div><br></div><div>I&#39;m trying to=
 add a timestamp column in an existent table.<br><br>This query works fine:=
<br><br>select timecreated, timezone(&#39;America/Santiago&#39;::text, to_t=
imestamp(timecreated::double precision)) datecreated =C2=A0<br>from MDL_LOG=
STORE_STANDARD_LOG;<br></div><div><br></div><div>But, when I want to alter =
the table I get=C2=A0 a syntax=C2=A0error</div><div><br></div><div>alter ta=
ble MDL_LOGSTORE_STANDARD_LOG <br>=C2=A0 add column datecreated timestamp <=
br>=C2=A0 generated always as ( timezone (&#39;America/Santiago&#39;::text,=
 to_timestamp(timecreated::double precision)));<br></div><div><br></div><di=
v>SQL Error [42601]: ERROR: syntax error at end of input<br>=C2=A0 Position=
: 185</div><div><br></div><div>I would appreciate some tips</div><div><br><=
/div><div>Thanks in advanced</div><div><br></div><div>kind regards</div><di=
v><br></div><div>Mauricio Fern=C3=A1ndez</div></div>

--000000000000ac7e91063de7922c--