Re: Scheme conversion MySQL to PGSQL

Hello James,

Am "=!/-!"-"$ hackte James Keener in die Tasten:
> What are the errors you're getting?

psql (9.1.24lts2)
Type "help" for help.

postgres=# DROP DATABASE sqmail_forum_tdnet;
DROP DATABASE
postgres=# \i
/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql
CREATE DATABASE
ALTER DATABASE
GRANT
You are now connected to database "sqmail_forum_tdnet" as user
"postgres".
psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:14:
NOTICE: CREATE TABLE will create implicit sequence
"sqmf_forum_forum_id_seq" for serial column "sqmf_forum.forum_id"
psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:14:
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
"sqmf_forum_pkey" for table "sqmf_forum"
CREATE TABLE
psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:24:
NOTICE: CREATE TABLE will create implicit sequence
"sqmf_post_post_id_seq" for serial column "sqmf_post.post_id"
psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:24:
ERROR: type "post_date" does not exist
LINE 8: KEY post_date (post_date)
^
psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:32:
ERROR: syntax error at or near "user"
LINE 6: UNIQUE user (stat_login)
^
psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:47:
NOTICE: CREATE TABLE will create implicit sequence
"sqmf_thread_thread_id_seq" for serial column "sqmf_thread.thread_id"
psql:/srv/CONFIG_webmail.tamay-dogan.net/htdocs/plugins/forum/database.sql:47:
ERROR: type "forum_id" does not exist
LINE 13: KEY forum_id (forum_id)
^

> I don't think unique key is the correct syntax.
> https://www.postgresql.org/docs/current/static/indexes-unique.html

I found it already. it is only "UNIQUE"

> I also don't think the key can be named the same as the field.

This is, what I have to figure out.

> Jim

--
Michelle Konzack
00372-54541400