Op 7-2-2013 13:54, Andrew Colin Kissa schreef:
On 07 Feb 2013, at 2:38 PM, Johan Hendriks wrote:
psql:/usr/home/baruwa/px/lib/python2.7/site-packages/baruwa/config/sql/integration.sql:100:
ERROR: syntax error at or near "ruleset"
LINE 5: WHEN spam_actions=3 THEN 'delete' END], ' ') ruleset fr...
U do not have PLPGSQL enabled in the DB
su - psql -c "psql baruwa -c \"CREATE LANGUAGE plpgsql;\""
su - psql -c "psql baruwa -c \"CREATE LANGUAGE plpythonu;\""
--
www.baruwa.org
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
Sorry , but the commands give me the following
[beheer@baruwa2 ~]$ su -
Password:
[root@baruwa2 ~]# su - pgsql -c "psql baruwa -c \"CREATE LANGUAGE
plpgsql;\""
ERROR: language "plpgsql" already exists
[root@baruwa2 ~]# su - pgsql -c "psql baruwa -c \"CREATE LANGUAGE
plpythonu;\""
ERROR: language "plpythonu" already exists
[root@baruwa2 ~]#
Can i drop the database and create the database once again using command
line options?
And which command do i need for that.
Sorry to bother you with this.
regards
johan
_______________________________________________
Keep Baruwa FREE - http://pledgie.com/campaigns/12056
