mwhitneysdsu
commented
8 years ago 1045 includes a great deal of discussion regarding the problems with trying to get everything working under PostgreSQL. You may be able to find the solutions to many issues there, but I don't know if we'll ever get to a point at which the system would be truly database-agnostic.
However, we would certainly love to incorporate anything which would help in doing so. If we can get even 2 or 3 database platforms working, it becomes much easier to get additional platforms working.
I followed steps to install bonfire, but get following during installation:
ERROR: type "datetime" does not exist LINE 10: "date_published" DATETIME NULL, ^
CREATE TABLE "bf_email_queue" ( "id" SERIAL NOT NULL, "to_email" VARCHAR(128) NOT NULL, "subject" VARCHAR(255) NOT NULL, "message" TEXT NOT NULL, "alt_message" TEXT NULL, "max_attempts" INT DEFAULT 3 NOT NULL, "attempts" INT DEFAULT 0 NOT NULL, "success" SMALLINT DEFAULT 0 NOT NULL, "date_published" DATETIME NULL, "last_attempt" DATETIME NULL, "date_sent" DATETIME NULL, CONSTRAINT "pk_bf_email_queue" PRIMARY KEY("id") )
In file: bonfire/migrations/001_Install_initial_tables.php
I don't think Postgresql have a DATETIME field type, maybe:
"timestamp with time zone" or "timestamp without time zone"