Is it possible (postgresql/mysql)

Поиск
Список
Период
Сортировка
От louis gonzales
Тема Is it possible (postgresql/mysql)
Дата
Msg-id 44E31655.5040600@linuxlouis.net
обсуждение исходный текст
Ответы Re: Is it possible (postgresql/mysql)  ("Harald Armin Massa" <haraldarminmassa@gmail.com>)
Список pgsql-general
Hello List,
PostgreSQL 8.0.1 (on Solaris 9)
There is a PERL program that a friend purchased which is used to create
tables on a MySQL database, and of course ;) I want to run this on a
PostgreSQL database server instead.  The below is the code:
 $sth=runSQL("CREATE TABLE someTable (
                    date_create bigint NOT NULL,
                    date_end bigint NOT NULL,
                    username VARCHAR(20) NOT NULL,
                    $cat_definition
                    id serial PRIMARY KEY,
                    status VARCHAR(20) NOT NULL,
                    $adfields
                   visibility TEXT NOT NULL,
                   priority TEXT NOT NULL,
                   template TEXT NOT NULL,
                   view bigint DEFAULT 0 NOT NULL,
                   reply bigint DEFAULT 0 NOT NULL,
                   save bigint DEFAULT 0 NOT NULL,
                   updated bigint,
                   photo VARCHAR(1) NOT NULL DEFAULT '0',
                   INDEX(username),
                   $cat_index
                   INDEX(date_create) );");

What my question is, the "INDEX(...)" function calls, which work this
way on MySQL, don't work in PostgreSQL.  Does anybody know what a
synonymous way to modify the above code, for compatibility with PostgreSQL?

FYI:    yourVariable  INT UNSIGNED AUTO_INCREMENT(MySQL)
            can be replaced by
           yourVariable serial

Thanks group!

--
Email:    louis.gonzales@linuxlouis.net
WebSite:  http://www.linuxlouis.net
"Open the pod bay doors HAL!" -2001: A Space Odyssey
"Good morning starshine, the Earth says hello." -Willy Wonka


В списке pgsql-general по дате отправления:

Предыдущее
От: Chris Mair
Дата:
Сообщение: Re: Segmentation Fault
Следующее
От: "Harald Armin Massa"
Дата:
Сообщение: Re: Is it possible (postgresql/mysql)