[mythtv-users] Can postgresql be used with mythtv?

[Matt White]

Jay R. Ashworth wrote:
> On Sun, Aug 22, 2004 at 01:01:51AM -0400, Isaac Richards wrote:
>>The largest thing that makes myth 'tightly coupled' to mysql is it
>>tells Qt to load the mysql driver. Other than that, I'm not aware of
>>anything that would prevent the useage of postgres. There may be a few
>>queries that need modified, but I doubt it would take much effort.
>>
>>I have no interest in spending my time making myth work with other DB
>>backends - apparently no one else who professes an interest in running
>>other DBs cares all that much, either. I've not seen a single person
>>even look into it, aside from the occasional question on the lists.
> 
> 
> Since I'm having 145 error problems, and not getting any replies at all
> to my queries on it, I might be Mr PostGreSQL guy.
> 
> Specifically: do you do any inserts that default numeric columns?  By
> which I mean inserting a NULL (or an empty string, which casts the same
> way), into an INTEGER column?  Cause that's the major thing that cranks
> newer versions of PG off.  If not, it probably won't be too hard a
> port.

I've started it a couple of times and stopped to work on other things.
It's still something I'd like to see (I run PostgreSQL for quite a few
other things and like it better).  If I recall correctly, the major
issue the last time I looked was the autoincrement stuff.  The code
inserted a stub record, got the autoincrement number back, and then went
on to modify the record as needed.  PostgreSQL (out of the box) doesn't
support that directly.  Should be possible to do it with a function, but
that means that it'll require different SQL than there is now.  Other
than that, it should be possible.  It's possible that the SQL code has
changed somewhat as well - I haven't really looked at it much since
before 0.14.

If you do start working on it, let me know - I'd still like to see psql
as an option, and I'll work with you on it.

-- 
Matt White                          whitem at arts.usask.ca
Arts and Science Computer Labs      University of Saskatchewan