Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id A4E74650078 for ; Wed, 27 Aug 2008 20:52:05 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 77273-06 for ; Wed, 27 Aug 2008 20:51:56 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from qb-out-0506.google.com (qb-out-0506.google.com [72.14.204.234]) by postgresql.org (Postfix) with ESMTP id 4728F64FF8E for ; Wed, 27 Aug 2008 20:52:00 -0300 (ADT) Received: by qb-out-0506.google.com with SMTP id d8so181473qbc.23 for ; Wed, 27 Aug 2008 16:51:58 -0700 (PDT) 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=wSaLc8BviQ14qT7HLkbh+PVhYKL78ePz7U3KKawz6Z0=; b=QvV+NznnkJZvdTwPgJ9odIKSULdV9jKVerIztcvISR3GavSia7o6gngVmKGfncWwWh 5DY4xA+5Zu3nEQu6pKMpM81sLsjM5Gg9ayJR8AbhKzluu6NLQJ8QrHmO2Ksi7Cx5//ok nRbWZXsVEYxhpXFGni/dPmC7PjhvI76DjzzkI= 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=eRT8BHk/WhecYTiB684Fr7mwiDFc4bc3vPaC1IOmmnmCVZ1EimIQCpEuWqI7LzlvQF 2utD72n7BpxjKKTtikMEECxdQr/YgggSKtlkPODu3QJlxIiT2CpHuv7CdDMVS/xZxgpT r0L/BXBoORdFgpB9V69TQueCi7VVdyCJBUw38= Received: by 10.114.166.1 with SMTP id o1mr730226wae.119.1219881117146; Wed, 27 Aug 2008 16:51:57 -0700 (PDT) Received: by 10.114.184.10 with HTTP; Wed, 27 Aug 2008 16:51:57 -0700 (PDT) Message-ID: Date: Thu, 28 Aug 2008 07:51:57 +0800 From: "Phoenix Kiula" To: "Tino Wildenhain" Subject: Re: Dumping/Restoring with constraints? Cc: "PG-General Mailing List" In-Reply-To: <48B5BC2A.5070104@wildenhain.de> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <48B5BC2A.5070104@wildenhain.de> 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: 200808/978 X-Sequence-Number: 136808 Is there a mechanism to check exactly which row may have characters that are not UTF8? I am trying with this kind of a command: select id from employee where modify_date between '2008-03-01' and '2008-07-01' and joint_field_of_name_etc <> convert(joint_field_of_name_etc, 'UTF8') This is of course not the best way of doing so. Is there a better system-provided way of checking for rows that may not be UTF8? Or to even have a constraint to this effect, to disallow any non-UTF8 data from getting in there? Thanks