From: | webmaster <webmaster(at)harbornet(dot)com> |
---|---|
To: | Cornelia Boenigk <poppcorn(at)cornelia-boenigk(dot)de> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: creating table w/ php help |
Date: | 2002-04-19 15:23:37 |
Message-ID: | 3CC03679.E909AC00@harbornet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Francisco Reyes | 2002-04-19 15:47:48 | Re: Backup very large databases |
Previous Message | Darren Ferguson | 2002-04-19 15:16:35 | Re: pltcl bug in 7.2? |