Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 264432E010F for ; Sun, 2 Mar 2008 20:26:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 11757-10 for ; Sun, 2 Mar 2008 20:26:36 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from fg-out-1718.google.com (fg-out-1718.google.com [72.14.220.154]) by postgresql.org (Postfix) with ESMTP id C94762E0106 for ; Sun, 2 Mar 2008 20:26:42 -0400 (AST) Received: by fg-out-1718.google.com with SMTP id 22so4069180fge.23 for ; Sun, 02 Mar 2008 16:26:41 -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:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=q6SHZKy9vEwaLyD24utkYa1RgbkfHpWdERphn0E/Wzo=; b=xTGfeiLU2oY27rQLeZZUTZ6S6y5ffCv/18XPpxF2TzePMq8Sy88dXHLLCp/0mG7T4gDrARGs4wiHciCEocwxMYqA2JusK2UP5tElKGCk6flzUHe/dpLmlHNOsaGRB1hIUCeJAM2BMvhQmCzbrElYtXGuLCkdHnzSgkRLTp/eqiI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=CVXuSqv7tm9VMK9bitSGVBhA7Gy+g7w63CCY+7Wh4yCByR4/eb1lf+Za6goaHH+o7jyAdyJel0jcG5CrSfO0Ts7yYKZAG+yrJ4/ItULna1SiM3aYfoAnAw50tweG8cn+Bg5yiBHhZL9uJCDZvkCHAnFuotATzhxL5lRu0xVOlh4= Received: by 10.82.150.20 with SMTP id x20mr20167273bud.4.1204504001139; Sun, 02 Mar 2008 16:26:41 -0800 (PST) Received: by 10.86.27.10 with HTTP; Sun, 2 Mar 2008 16:26:41 -0800 (PST) Message-ID: <2b5e566d0803021626t60e8fce2mbb7cd313347813ad@mail.gmail.com> Date: Sun, 2 Mar 2008 16:26:41 -0800 From: "Selena Deckelmann" To: "Terminal Station" Subject: Re: Migration issue Cc: pgsql-www@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/21 X-Sequence-Number: 14140 On Sun, Mar 2, 2008 at 3:18 PM, Terminal Station wrote: > Url : http://pugs.postgresql.org/directory > * 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. [trimmed] This is not a casting problem. The problem is the LEFT() function call. This is a mysql-specific function that returns the left-most characters. I fixed it by creating a function that just uses SUBSTR() instead. But there's another bug :( And, I fixed it. There was a missing column in a GROUP BY. -selena -- Selena Deckelmann PDXPUG - Portland PostgreSQL Users Group http://pugs.postgresql.org/pdx http://www.chesnok.com/daily