Hi, There is already an up to date laconica_pg.sql, but it is not in the main Laconica source repository yet. However, in addition to updating the creation script, there are a number of changes to queries in the Laconica code itself that are required to make all the new features work properly.
If you urgently need your installation up and running, I can supply these, but otherwise it is probably best to wait until they have been pulled into the main Laconica repository. Thanks, Ciaran Abigail Edwards wrote: > Greetings! I just installed laconica on a new server with a postgresql > backend and spent some time converting the mysql schema to a functional > postgresql schema. Maybe someone else has already done this; I saw > there was a laconica_pg.sql file under the db/ subdirectory of the > distribution, but this didn't work out of the box for me. > > I've attached my work, which is basically a combination of running the > mysql schema file through a converter, converting specific data types by > hand, adjusting the constraints and the indices to fall more in line > with the conventions used by whoever supplied the laconica_pg.sql file, > copying over the textsearch pieces, and granting appropriate permissions > to the database user. > > The script assumes you're connecting with an account privileged enough > to create tables and grant permissions on tables and sequences; it also > assumes a role named 'laconica' exists already. Anyway, it served my > purpose... I wanted to give it back to the group so that if anyone else > could use it they have it. Hopefully it helps. > > There's a patch attached, as well as the new file... though the patch is > actually larger than the new file, so maybe that's not very useful. > > Thanks, > > Abby > > > ------------------------------------------------------------------------ > > _______________________________________________ > Laconica-dev mailing list > [email protected] > http://mail.laconi.ca/mailman/listinfo/laconica-dev _______________________________________________ Laconica-dev mailing list [email protected] http://mail.laconi.ca/mailman/listinfo/laconica-dev
