Re: DB table_seq
| From: | Jackson Miller | Date: | Fri, 13 Feb 2004 00:25:32 +0000 |
| Subject: | Re: DB table_seq | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-10670@lists.php.net to get a copy of this message | ||
On Thursday 12 February 2004 10:19 am, Daniel Kopp wrote:
> Dear Pears :-)!
>
> I don't know whether this has any connection with pear at all but sometimes
> in the last days I find a table that I did not create in my database. The
> name is like one of the tables I did create plus an ending "_seq". Does
> anybody have an idea where it might come from?
I am guessing you are using PEAR::DB and MySQL.
I _think_ if you used PEAR::DB to create the table, it would use the _seq
table as the sequence (or "autoincrement" field in MySQL).
Just a guess.
I guess this because of behaviour in PEAR::DB where your sequence name must
end in "_seq" when using PostgreSQL or it will not know how to access it.
-Jackson
>
> thanks for any ideas ...
> Daniel