Postgresql sequence creation

Please report bugs here!

Moderator: Thorsten

Post Reply
Rudism
Posts: 4
Joined: Tue Jul 19, 2005 8:23 pm

Postgresql sequence creation

Post by Rudism »

I tried installing 1.5 RC5 on my system:
-FreeBSD 5.4-stable
-PHP 5.0.4
-Postgresql 8.0.1

The install script completed without errors, but I was getting tons of errors when viewing the faq or trying to make any database related changes (adding categories, etc) in the admin tools...

I tracked it down to the fact that the database initialization script at install/pgsql.sql.php was not creating the _id_seq sequences in the database for the tables it was creating. I changed all of the sql statements to declare the primary columns of each table as a 'serial' type instead of INT4 NOT NULL and did a fresh install using that instead, and things seem to be working great now.
Thorsten
Posts: 15724
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Post by Thorsten »

Hi,

this is already fixed in CVS since last week. Thanks for your detailed bugreport. Just test the new daily snapshot.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist
Post Reply