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

Jason Gabriele jasongabriele at yahoo.com
Sun Aug 22 09:40:08 EDT 2004


>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.

postgres supports a serial type which is just an autoincremented int4.
not sure if thats what you are looking for. 

"CREATE TABLE test (
   id serial UNIQUE PRIMARY KEY
);"

it also uses sequences where you increment it by calling nextval

http://www.postgresql.org/docs/7.4/interactive/datatype.html#DATATYPE-SERIAL


		
_______________________________
Do you Yahoo!?
Express yourself with Y! Messenger! Free. Download now. 
http://messenger.yahoo.com


More information about the mythtv-users mailing list