Re: creating table w/ php help - Mailing list pgsql-general

From webmaster
Subject Re: creating table w/ php help
Date
Msg-id 3CC03679.E909AC00@harbornet.com
Whole thread Raw
In response to Re: creating table w/ php help  (David A Dickson <davidd@saraswati.wcg.mcgill.ca>)
List 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 by date:

Previous
From: Alex Krohn
Date:
Subject: Re: unable to repair table: missing chunk number
Next
From: Martijn van Oosterhout
Date:
Subject: Re: INSERT & UPDATE