Re: creating table w/ php help

Поиск
Список
Период
Сортировка
От webmaster
Тема Re: creating table w/ php help
Дата
Msg-id 3CC03679.E909AC00@harbornet.com
обсуждение исходный текст
Ответ на Re: creating table w/ php help  (David A Dickson <davidd@saraswati.wcg.mcgill.ca>)
Список pgsql-general
thanks, that did it.

Cornelia Boenigk wrote:

> > $query = "CREATE table $tablename (id INT UNSIGNED NOT NULL
> > AUTO_INCREMENT PRIMARY KEY, ip TEXT, customer TEXT, dslphone TEXT,
> date
> > TEXT, vpivci TEXT)";
>
> AUTO_INCREMENT is used in MySQL. With PostgreSQL you should use the
> keyword SERIAL. Also UNSIGNED is not used.
>
> > Here is the second problem. By looking at the php manual for the
> pg-exec
> > function (changed to pg-query in php 4)
> It *will* change from PHP 4.2.0 on. pg_exec() is still valid for all
> releases < 4.2.0.
>
> Regards
> Conni
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster


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

Предыдущее
От: Alex Krohn
Дата:
Сообщение: Re: unable to repair table: missing chunk number
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: INSERT & UPDATE