Hi,
I'm not very familiar with PostgreSQL, so I'm not sure if this is a bug or
not. I'm trying to copy an SQLite database to PostgreSQL, but I'm getting
an error:
Error: Sequel::DatabaseError: PG::DuplicateColumn: ERROR: column "0.0"
specified more than once
Looking at the SQL, it appears there are some unnamed numeric columns being
added before any Decimal/Numeric columns:
CREATE TABLE "items" ("id" integer GENERATED BY DEFAULT AS IDENTITY PRIMARY
KEY, "product_id" integer, "part_number" varchar(34) NOT NULL, "note" text,
"option1" varchar(255), "option2" varchar(255), "option3" varchar(255),
"0.0" numeric, "price1" numeric DEFAULT NULL NOT NULL, "0.0" numeric,
"price2" numeric DEFAULT NULL NOT NULL ...<snip>
Changing the column type to Float appears to get rid of these "0.0" numeric
column definitions.
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
