On Fri, Mar 23, 2001 at 03:20:52AM +0100, Emiliano wrote:
> Adam Blomberg wrote:
> >
> > Hi,
> >
> > I've recently upgraded from 1.2.5 to 1.4, and it works great. Now, I would
> > like to use Midgard at another site, where we are currently using PostgreSQL
> > as our database backend. My question is simple, would it be feasible to
> > patch Midgard so that it uses PostgreSQL instead of MySQL? I realise that
> > any porting to PostgreSQL would include some hacking, but would it be
> > extensive? On a side note, I think I've read somewhere that 2.0 will include
> > a database abstraction layer, but unfortunately this particular project
> > can't wait for that release.
>
> I'm not too familiar with PostgreSQL. The main thing you'll need is
> auto-incrementing
> IDs. If it supports that, all changes should be to midgard-lib only. I
> think.
>
PostgreSQL has a datatype 'serial' which actually just is a shortcut to
creating a sequence. It has approximately the same functionality as
auto-incrementing in MySQL.
/erwin
--
Erwin Lansing -- www.droso.org
"Computers are useless. They only give you answers"
-- Pablo Picasso
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
