On Tuesday, July 24, 2018 at 2:36:29 PM UTC-7, James wrote:
>
> 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.
>
Weird, it looks like the column names are being cast to float and then to
string. I haven't seen that before and nobody else has reported it. Any
chance you could put together a minimal self-contained reproducible example
that I can test?
Thanks,
Jeremy
--
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.
