Index: openacs-4/packages/edit-this-page/www/etp-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-edit-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-edit-postgresql.xql	2 Nov 2001 01:51:24 -0000	1.1
@@ -0,0 +1,28 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="get_standard_attribute">
+<querytext>
+        select $attribute as value, r.title as page_title
+          from cr_revisions r, cr_items i
+         where i.parent_id = etp__get_folder_id(:package_id)
+           and i.name = :name
+           and i.item_id = r.item_id
+	   and r.revision_id = :revision_id
+</querytext>
+</fullquery>
+
+<fullquery name="get_extended_attribute">
+<querytext>
+	select etp_get_attribute_value(r.revision_id, :attribute_id) as value,
+	       r.title as page_title
+	  from cr_items i, cr_revisions r
+	 where i.parent_id = etp__get_folder_id(:package_id)
+	   and i.name = :name
+	   and i.item_id = r.item_id
+	   and r.revision_id = :revision_id
+</querytext>
+</fullquery>
+ 
+</queryset>
Index: openacs-4/packages/edit-this-page/www/etp-extlink-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-extlink-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-extlink-postgresql.xql	2 Nov 2001 01:52:37 -0000	1.1
@@ -0,0 +1,11 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="create_extlink">
+<querytext>
+    select etp__create_extlink(:package_id, :url, :label, :description);
+</querytext>
+</fullquery>
+ 
+</queryset>
Index: openacs-4/packages/edit-this-page/www/etp-publish-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-publish-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-publish-postgresql.xql	2 Nov 2001 01:53:33 -0000	1.1
@@ -0,0 +1,23 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="set_publish_date">
+<querytext>
+update cr_revisions
+set publish_date = now()
+where revision_id = :latest_revision_id
+</querytext>
+</fullquery>
+
+<fullquery name="set_audit_info">
+<querytext>
+update acs_objects
+set modifying_user = :user_id,
+    last_modified = now()
+where object_id = :latest_revision_id
+</querytext>
+</fullquery>
+
+
+</queryset>
Index: openacs-4/packages/edit-this-page/www/etp-symlink-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/edit-this-page/www/etp-symlink-postgresql.xql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/edit-this-page/www/etp-symlink-postgresql.xql	2 Nov 2001 01:55:12 -0000	1.1
@@ -0,0 +1,26 @@
+<?xml version="1.0"?>
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="create_symlink">
+<querytext>
+    select etp__create_symlink(:package_id, :target_id);
+</querytext>
+</fullquery>
+
+<fullquery name="all_pages">
+<querytext>
+	select i.item_id, i.name, etp__get_title(i.item_id, null) as title,
+               repeat('&nbsp;',(tree_level(i.tree_sortkey) - 1) * 4) as indent
+          from cr_items i, acs_objects o
+         where i.item_id = o.object_id
+           and o.object_type in ('content_item', 'content_folder')
+           and i.name != 'index'
+           and i.tree_sortkey not like (select tree_sortkey 
+                                          from cr_items
+                                         where item_id = -400) || '%'
+         order by i.tree_sortkey
+</querytext>
+</fullquery>
+ 
+</queryset>