Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B63932E00B3 for ; Sun, 2 Mar 2008 19:18:41 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 28138-02 for ; Sun, 2 Mar 2008 19:18:39 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from wf-out-1314.google.com (wf-out-1314.google.com [209.85.200.173]) by postgresql.org (Postfix) with ESMTP id A3FB02E0075 for ; Sun, 2 Mar 2008 19:18:38 -0400 (AST) Received: by wf-out-1314.google.com with SMTP id 28so5397312wff.28 for ; Sun, 02 Mar 2008 15:18:37 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; bh=TNMoGmkFUSP9D3+h6i/0Ajbkb64fRwTdNLZ47hNfwpM=; b=w9R4OCED9KQN1BoIfGtEpO09AKzKxrhNGJfZXb6Uj6GL/jvRVhc/PSuXx9NPnT9qZqWD0Lxt3iI1XjIe7FN26UtuCt4WP+WqIZVeo+6teA5y6/6nOqm+F2qYGIhtabdItH9lB9YA+hWBdsByc61PjcfglUIJqLkgjAFhcASYpCk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=I94VCYgWIZ0BqT5RHy2hnyjLwkT5JYQqNzfDOm5OL01MpN/Cqw9MMUcQ3qvk3VsvuifDfPbK26+pZOWYybOuu6pfuKsVsSnCVxGMyCpfIFEf7Z/Y9FEsiPrp51J7EYNtE9rjHv9RjpzJRTlRoAx0QoGQMHg4ytdErPqHwoJ7shU= Received: by 10.142.128.6 with SMTP id a6mr8609497wfd.135.1204499917598; Sun, 02 Mar 2008 15:18:37 -0800 (PST) Received: by 10.142.148.10 with HTTP; Sun, 2 Mar 2008 15:18:37 -0800 (PST) Message-ID: Date: Sun, 2 Mar 2008 23:18:37 +0000 From: "Terminal Station" To: pgsql-www@postgresql.org Subject: Migration issue MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200803/17 X-Sequence-Number: 14136 Url : http://pugs.postgresql.org/directory Error Msg: " * warning: pg_query() [function.pg-query]: Query failed: ERROR: function left(character varying, integer) does not exist LINE 1: SELECT count(DISTINCT(LEFT(term_data.name, 1))) FROM node no... ^ HINT: No function matches the given name and argument types. You may need to add explicit type casts. in /usr/local/www/drupal5/includes/database.pgsql.inc on line 125. * user warning: query: SELECT count(DISTINCT(LEFT(term_data.name, 1))) FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid WHERE (node.status = '1') AND (term_data.name IS NOT NULL) in /usr/local/www/drupal5/includes/database.pgsql.inc on line 144. * warning: pg_query() [function.pg-query]: Query failed: ERROR: function left(character varying, integer) does not exist LINE 1: SELECT term_data.tid, LEFT(term_data.name, 1) AS letter, cou... ^ HINT: No function matches the given name and argument types. You may need to add explicit type casts. in /usr/local/www/drupal5/includes/database.pgsql.inc on line 125. * user warning: query: SELECT term_data.tid, LEFT(term_data.name, 1) AS letter, count(node.nid) AS num_nodes, term_data.weight AS term_data_weight, term_data.name AS term_data_name, node.sticky AS node_sticky, node.created AS node_created_created FROM node node LEFT JOIN term_node term_node ON node.nid = term_node.nid LEFT JOIN term_data term_data ON term_node.tid = term_data.tid WHERE (node.status = '1') AND (term_data.name IS NOT NULL) GROUP BY LEFT(term_data.name, 1), term_data_weight, term_data_name, node_sticky, node_created_created ORDER BY term_data_weight ASC, term_data_name ASC, node_sticky DESC, node_created_created DESC LIMIT 50 OFFSET 0 in /usr/local/www/drupal5/includes/database.pgsql.inc on line 144. " Cause: Automatic casting not supported!