[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