Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

interval type fields not supported #51

Open
johanek opened this issue Aug 30, 2023 · 0 comments
Open

interval type fields not supported #51

johanek opened this issue Aug 30, 2023 · 0 comments

Comments

@johanek
Copy link
Contributor

johanek commented Aug 30, 2023

I'm not sure what these should be converted to, but internal isn't a valid type in mysql

$ cat test.pgsql
CREATE TABLE public.dcim_device (
    id uuid NOT NULL,
    created date,
    diff_time interval,
);

$ perl pg2mysql.pl < test.pgsql
--
-- Generated by pg2mysql
--
set foreign_key_checks = off;
--
DROP DATABASE IF EXISTS public;
CREATE DATABASE public;
CREATE TABLE public.dcim_device (
    `id` varchar(36) NOT NULL,
    `created` date,
    `diff_time` interval,
);
QuentiumYT added a commit to Quentium-Forks/pg2mysql that referenced this issue Oct 6, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant