Index: openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-drop.sql,v diff -u -r1.2 -r1.2.2.1 --- openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-drop.sql 1 Jun 2004 10:59:18 -0000 1.2 +++ openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-packages-drop.sql 7 Jun 2006 15:07:03 -0000 1.2.2.1 @@ -7,7 +7,7 @@ drop function na_weblog__delete(integer); drop function na_weblog__name(integer); drop function na_weblog__new(integer, integer, varchar, varchar, varchar, integer, varchar); -seledct acs_object_type__drop_type('na_weblog', true); +select acs_object_type__drop_type('na_weblog', true); --drop na_subscription functions drop function na_subscription__new ( Index: openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql,v diff -u -r1.2.2.3 -r1.2.2.4 --- openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql 14 Jan 2006 23:27:59 -0000 1.2.2.3 +++ openacs-4/packages/news-aggregator/sql/postgresql/news-aggregator-tables-create.sql 7 Jun 2006 15:07:03 -0000 1.2.2.4 @@ -105,6 +105,7 @@ -- ---------------- +create sequence na_items_item_id_seq cache 1; create table na_items ( item_id integer default nextval('na_items_item_id_seq') @@ -130,7 +131,6 @@ pub_date timestamptz ); -create sequence na_items_item_id_seq cache 1; create index na_items_guid_idx on na_items(guid); create index na_items_source_id_idx on na_items(source_id);