X-Original-To: pgsql-sql-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 1EE999FB24C for ; Wed, 2 Aug 2006 10:02:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 43049-07 for ; Wed, 2 Aug 2006 10:01:59 -0300 (ADT) X-Greylist: delayed 00:08:03.584268 by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.188]) by postgresql.org (Postfix) with ESMTP id 4487C9FB225 for ; Wed, 2 Aug 2006 10:01:58 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id p77so660744nfc for ; Wed, 02 Aug 2006 06:01:57 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=googlemail.com; h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition; b=V0+Oc3Bp44ibyyiWRyqGVEc8JyfXFS1ZDk/sxFfa5w76cuVbyXKXpIOHAxPptmHc9+bduZqFsZpJJhEQd8fJOHFFuCJZPlY8VTqIIFFNk9IBU02aUTAh5n697uIMSnC6cLVu7CFkFyd+F7oLPQRNjG1o9XqlqPmV5I2prmgkw58= Received: by 10.78.170.17 with SMTP id s17mr162178hue; Wed, 02 Aug 2006 05:46:36 -0700 (PDT) Received: by 10.78.134.10 with HTTP; Wed, 2 Aug 2006 05:46:36 -0700 (PDT) Message-ID: <684362e10608020546t16e6d3e8nf6756abd15a21a68@mail.gmail.com> Date: Wed, 2 Aug 2006 19:46:36 +0700 From: "Markus Bertheau" To: pgsql-sql@postgresql.org Subject: alter column type from boolean to char with default doesn't work MIME-Version: 1.0 Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: base64 Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.223 tagged_above=0 required=5 tests=MIME_BASE64_NO_NAME, SPF_PASS X-Spam-Level: X-Archive-Number: 200608/12 X-Sequence-Number: 25970 SGksCgpJIGJhc2ljYWxseSB3YW50IHRvIGNoYW5nZSBhIGJvb2xlYW4gY29sdW1uIHRvIGNoYXIu IFRoZSBib29sZWFuCmNvbHVtbiBoYXMgYSBkZWZhdWx0IG9mIHRydWUuIFRoZSBjaGFyIGNvbHVt biBzaG91bGQgaGF2ZSAnZicgZm9yCmZhbHNlIGFuZCAndCcgZm9yIHRydWUuIEkgdGhpbmsgdGhh dCBhbiBTUUwgc3RhdGVtZW50IGxpa2UgdGhlCmZvbGxvd2luZyBzaG91bGQgd29yaywgYnV0IGl0 IGRvZXNuJ3Q6CgpibG9nPT4gc2VsZWN0IHZlcnNpb24oKTsKICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICB2ZXJzaW9uCi0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQogUG9zdGdyZVNRTCA4LjAuNyBvbiBpNDg2 LXBjLWxpbnV4LWdudSwgY29tcGlsZWQgYnkgR0NDCmdjYy00LjAuZ2NjLW9wdCAoR0NDKSA0LjAu MyAoVWJ1bnR1IDQuMC4zLTF1YnVudHUxKQooMSDawdDJ09gpCgpibG9nPT4gXGQgcG9zdHMKICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgIPTBwszJw8EgInB1YmxpYy5wb3N0cyIK IOvPzM/Oy8EgIHwgICAgICAgICAgICAg9MnQICAgICAgICAgICAgIHwgICAgICAgICAgICAgICAg ICAgICDtz8TJxsnLwdTP0tkKLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LSstLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t CiBpZCAgICAgICB8IGludGVnZXIgICAgICAgICAgICAgICAgICAgICB8IG5vdCBudWxsIGRlZmF1 bHQKbmV4dHZhbCgncHVibGljLnBvc3RzX2lkX3NlcSc6OnRleHQpCiB0aXRsZSAgICB8IHRleHQg ICAgICAgICAgICAgICAgICAgICAgICB8CiBib2R5ICAgICB8IHRleHQgICAgICAgICAgICAgICAg ICAgICAgICB8CiBjcmVhdGVkICB8IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZSB8CiBtb2Rp ZmllZCB8IHRpbWVzdGFtcCB3aXRob3V0IHRpbWUgem9uZSB8CiBkZWxldGVkICB8IGJvb2xlYW4g ICAgICAgICAgICAgICAgICAgICB8IGRlZmF1bHQgZmFsc2UK6c7ExcvT2ToKICAgICJwb3N0c19w a2V5IiBQUklNQVJZIEtFWSwgYnRyZWUgKGlkKQoKYmxvZz0+IGFsdGVyIHRhYmxlIHBvc3RzIGFs dGVyIGNvbHVtbiBkZWxldGVkIHR5cGUgY2hhcigxKSB1c2luZyAoY2FzZQp3aGVuIGRlbGV0ZWQg dGhlbiAndCcgZWxzZSAnZicgZW5kKSwgYWx0ZXIgY29sdW1uIGRlbGV0ZWQgc2V0IGRlZmF1bHQK J2YnOwpFUlJPUjogIGRlZmF1bHQgZm9yIGNvbHVtbiAiZGVsZXRlZCIgY2Fubm90IGJlIGNhc3Qg dG8gdHlwZSAicGdfY2F0YWxvZy5icGNoYXIiCmJsb2c9PiBhbHRlciB0YWJsZSBwb3N0cyBhbHRl ciBjb2x1bW4gZGVsZXRlZCBzZXQgZGVmYXVsdCAnZicsIGFsdGVyCmNvbHVtbiBkZWxldGVkIHR5 cGUgY2hhcigxKSB1c2luZyAoY2FzZSB3aGVuIGRlbGV0ZWQgdGhlbiAndCcgZWxzZSAnZicKZW5k KTsKRVJST1I6ICBkZWZhdWx0IGZvciBjb2x1bW4gImRlbGV0ZWQiIGNhbm5vdCBiZSBjYXN0IHRv IHR5cGUgInBnX2NhdGFsb2cuYnBjaGFyIgoKSG93IGlzIHRoaXMgc3VwcG9zZWQgdG8gd29yaz8g Tm90ZSB0aGF0IEkgZG9uJ3QgbmVlZCBhIHNvbHV0aW9uIGZvcgp0aGlzIHNwZWNpYWwgY2FzZSwg YnV0IHJhdGhlciB3YW50IHRvIGtub3csIGhvdyBpdCBpcyBzdXBwb3NlZCB0byB3b3JrCi0gYW0g SSBkb2luZyBpdCB3cm9uZyBvciBpcyBpdCBub3QgcG9zc2libGUgdG8gZG8gaXQgbGlrZSB0aGF0 IChhbmQgaXMKdGhhdCBiZWNhdXNlIHRoZSBTUUwgc3RhbmRhcmQgb3IgYmVjYXVzZSBvZiBob3cg cG9zdGdyZXNxbCBpbXBsZW1lbnRzCml0PykKClRoYW5rcwoKTWFya3VzIEJlcnRoZWF1Cg==