"offset" reserved in PostgreSQL [#225824]

I receive the following error when I try to save a panels view. I am using Drupal 5.5 with PostgreSQL.

    * warning: pg_query() [function.pg-query]: Query failed: ERROR: syntax error at or near "offset" LINE 1: ..., view_type, use_pager, pager_id, nodes_per_page, offset, li... ^ in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 125.
    * user warning: query: INSERT INTO panels_views (pvid, view, name, description, title, category, category_weight, view_type, use_pager, pager_id, nodes_per_page, offset, link_to_view, more_link, feed_icons, url_override, url, url_from_panel, contexts, allow_type, allow_nodes_per_page, allow_offset, allow_use_pager, allow_link_to_view, allow_more_link, allow_feed_icons, allow_url_override, allow_url_from_panel) VALUES (1, 'circle_events', 'circle_events', 'Events for Circle of Interest', '', 'Views', -1, 'page', 0, 0, 10, 0, 0, 0, 0, 0, '', 0, 'a:4:{i:0;a:5:{s:4:"type";s:7:"context";s:7:"context";s:3:"any";s:5:"panel";s:1:"0";s:5:"fixed";s:0:"";s:5:"label";s:16:"OG: Group nid(s)";}i:1;a:5:{s:4:"type";s:7:"context";s:7:"context";s:3:"any";s:5:"panel";s:1:"0";s:5:"fixed";s:0:"";s:5:"label";s:14:"Calendar: Year";}i:2;a:5:{s:4:"type";s:7:"context";s:7:"context";s:3:"any";s:5:"panel";s:1:"0";s:5:"fixed";s:0:"";s:5:"label";s:15:"Calendar: Month";}i:3;a:5:{s:4:"type";s:7:"context";s:7:"context";s:3:"any";s:5:"panel";s:1:"0";s:5:"fixed";s:0:"";s:5:"label";s:13:"Calendar: Day";}}', 0, 0, 0, 0, 0, 0, 0, 0, 0) in /usr/local/apache2/htdocs/drupal/includes/database.pgsql.inc on line 144.

Comment	File	Size	Author
#7	panels-DRUPAL-5--2.pgsql-offset.patch	905 bytes	sun

Comments

Comment #1

eleybourn commented 27 February 2008 at 13:14

offset is a reserved word. You can get around this by quoting the word in double quotes.
ie
pager_id, nodes_per_page, "offset", link_to_view

Comment #2

sime

any/any

Melbourne

commented 27 February 2008 at 23:39

Title:

Syntax Errors Creating Panels View

» "offset" reserved in PostgreSQL

Comment #3

jruberto commented 22 April 2008 at 22:02

Yep, add these few lines to panels_views.install and it will work in PostgreSQL. I don't know enough about PostgreSQL to say so with any authority, but it might be better to just put all the field names in quotes?

  $fields = panels_views_pane_fields();
  $sql = "";
  foreach ($fields as $field => $data) {
    if ($sql) {
      $sql .= ', ';
    }
    /*  start postgres fix  */
    if ($field == "offset") {
        $field = '"offset"';        // offset is a reserved word in postgres, needs to be quoted
    }
    /*  end postgres fix  */
    $sql .= $field . ' ' . $data['definition'];
  }
  db_query("CREATE TABLE {panels_views} ($sql) /*!40100 DEFAULT CHARACTER SET utf8 */");