Re: Scheme conversion MySQL to PGSQL - Mailing list pgsql-general

From Michelle Konzack
Subject Re: Scheme conversion MySQL to PGSQL
Date
Msg-id cd2051d53a1b8c233005bf969631cad2.squirrel@webmail.tamay-dogan.net
Whole thread Raw
In response to Re: Scheme conversion MySQL to PGSQL  (James Keener <jim@jimkeener.com>)
List pgsql-general
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



pgsql-general by date:

Previous
From: "Igal @ Lucee.org"
Date:
Subject: Re: Scheme conversion MySQL to PGSQL
Next
From: "Michelle Konzack"
Date:
Subject: Re: Scheme conversion MySQL to PGSQL