Release Notes
Announcements
abstime, reltime, and tinterval, the verification task reports an error.abstime, reltime, and tinterval are older time and date types that have been deprecated in the new PostgreSQL versions. It is recommended to use the following types as replacements:abstime: You can use timestamp or timestamp with time zone as replacements. These types provide a broader range of date and time representation capabilities.reltime: You can use the interval type as a replacement. The interval type is used to represent time intervals, which can include units such as years, months, days, hours, minutes, and seconds.tinterval: You can use tsrange or tstzrange as replacements. These types are used to represent time ranges, which can include the origin and end times.abstime, reltime, and tinterval are similar. First, create a column, convert the old data format to the new one, and store it in the new one. After the new column's data is verified that it is correct, delete the old column. Finally, if necessary, rename the new column to the name of the old column.abstime to timestamp as an example.ALTER TABLE your_table ADD COLUMN new_column TIMESTAMP;
UPDATE your_table SET new_column = your_abstime_column::TIMESTAMP;
SELECT * FROM your_table;
ALTER TABLE your_table DROP COLUMN your_abstime_column;
ALTER TABLE your_table RENAME COLUMN new_column TO your_abstime_column;
Esta página foi útil?
Você também pode entrar em contato com a Equipe de vendas ou Enviar um tíquete em caso de ajuda.
comentários