PostgreSQL Updates

I've successfully created and upgraded (well, sort of) my
version 2 Blog
into Blojsom 3.0. Just in case anyone is interested in some
of the ins
and outs of the Postgresql version, I'm posting what I found
necessary
to change to make it work.

blojsom.xml:
I changed the bean dbloader property detectBlojsomSQL from
<value>list
tables;</value>to
<value>select relname from
pg_stat_user_tables;</value>

blojsom-postgresql.sql:
I changed the Properties table creation from property_value
longtext
property_value text

I hope this helps someone. Hmmmm... it seemed like it was
harder than
these two simple things!

Dan

---
Dan McGinn-Combs
danmcginn-combs.org
Peachtree City, GA USA
+1 770 487 6321



------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief surveys
-- and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

I'll be posting the PostgreSQL items today on the wiki.


On 10/8/06 8:47 PM, "danmcginn-combs.org"
<danmcginn-combs.org> wrote:

> I've successfully created and upgraded (well, sort of)
my version 2 Blog
> into Blojsom 3.0. Just in case anyone is interested in
some of the ins
> and outs of the Postgresql version, I'm posting what I
found necessary
> to change to make it work.
> 
> blojsom.xml:
> I changed the bean dbloader property detectBlojsomSQL
from <value>list
> tables;</value>to
> <value>select relname from
pg_stat_user_tables;</value>
> 
> blojsom-postgresql.sql:
> I changed the Properties table creation from
property_value longtext
> property_value text
> 
> I hope this helps someone. Hmmmm... it seemed like it
was harder than
> these two simple things!
> 
> Dan
> 
> ---
> Dan McGinn-Combs
> danmcginn-combs.org
> Peachtree City, GA USA
> +1 770 487 6321
> 
> 
> 
>
------------------------------------------------------------
-------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the
chance to share your
> opinions on IT & business topics through brief
surveys -- and earn cash
> http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Blojsom-users mailing list
> Blojsom-userslists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers

-- 
David Czarnecki

http://www.blojsom.com/b
log/ | http://blojsom.sf.net



------------------------------------------------------------
-------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the
chance to share your
opinions on IT & business topics through brief surveys
-- and earn cash
http://www.techsay.com/default.
php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Blojsom-users mailing list
Blojsom-userslists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/blojsom-u
sers