> On 24 Dec 2017, at 18:52, Michelle Konzack
> wrote:
> CREATE TABLE sqmf_stat (
> stat_loginvarchar(70) NOT NULL,
> stat_post integer default '1',
> stat_thread integer default '1',
> PRIMARY KEY (stat_login),
> UNIQUE KE
Michelle,
On 12/24/2017 1:20 PM, Michelle Konzack wrote:
Hello Igal
Am 2017-12-24 hackte Igal @ Lucee.org in die Tasten:
I am doing a similar thing migrating from SQL Server, and I am
considering to publish an open source Migrator.
Can you tell me about some of the data types that you had to
Hello Igal
Am 2017-12-24 hackte Igal @ Lucee.org in die Tasten:
> I agree with Andreas. First create the tables, then create the
> indexes. If you can copy the data before creating the indexes then
> you
> will probably save some time on all of the INSERTs.
>
> I am doing a similar thing migra
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 DATABA
On 12/24/2017 10:18 AM, Andreas Kretschmer wrote:
On 24 December 2017 18:52:39 CET, Michelle Konzack
wrote:
I try to convert a Database scheme from mySQL to pgSQL and have
problems with the line:
KEY post_date (post_date)
and later probably with the lines
UNIQUE KEY user
On Sun, Dec 24, 2017 at 1:04 PM, James Keener wrote:
> What are the errors you're getting?
>
> I don't think unique key is the correct syntax.
> https://www.postgresql.org/docs/current/static/indexes-unique.html
>
> I also don't think the key can be named the same as the field.
>
> Jim
>
> On Dec
On 24 December 2017 18:52:39 CET, Michelle Konzack
wrote:
>Hello *
>
>I try to convert a Database scheme from mySQL to pgSQL and have
>problems with the line:
>
> KEY post_date (post_date)
>
>and later probably with the lines
>
> UNIQUE KEY user (stat_login)
>and
> KEY forum
What are the errors you're getting?
I don't think unique key is the correct syntax.
https://www.postgresql.org/docs/current/static/indexes-unique.html
I also don't think the key can be named the same as the field.
Jim
On December 24, 2017 12:52:39 PM EST, Michelle Konzack
wrote:
>Hello *
>
>
Hello *
I try to convert a Database scheme from mySQL to pgSQL and have
problems with the line:
KEY post_date (post_date)
and later probably with the lines
UNIQUE KEY user (stat_login)
and
KEY forum_id (forum_id)
too. How to solv this prolem?
Thanks
Michelle
--
