On Sat, Dec 23, 2017 at 11:11 PM, Daevor The Devoted
wrote:
>
> This is an interesting feature you are talking about. However, I'm not
> sure I properly understand the use-case(s). Could you perhaps please give
> some examples to help me understand? (I don't just mean some SQL code, I
> mean an e
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
--
On 2017-12-23 14:40:13 -0500, Melvin Davidson wrote:
> On Sat, Dec 23, 2017 at 2:27 PM, Peter J. Holzer wrote:
> >If you do not understand something, please ask.
>
> Your response is inappropriate and offensive.
I apologize for my tone. I should have calmed down before replying.
I do not apolog
On Sun, Dec 24, 2017 at 1:11 AM, Daevor The Devoted
wrote:
>
> Le 23 déc. 2017 20:25, "Peter J. Holzer" a écrit :
>
> I think the OP wants something like this:
>
> create table features (
> id serial primary key,
> name varchar not null
> );
>
> create table products (
> id serial pr
11 matches
Mail list logo
