Re: [HACKERS] [PATCH] pgcrypto: pgp_encrypt v3

On Tue, Jul 05, 2005 at 10:20:17AM +1000, Neil Conway wrote:
> Bruce Momjian wrote:
> >Your patch has been added to the PostgreSQL unapplied patches list
>
> That is not the latest version of Marko's patch.

Bruce got v3, thats indeed the latest.

Also, http://momjian.postgresql.org/cgi-bin/pgpatches shows v3.


> But in any case, the
> patch is not yet ready for application:
>
> http://archives.postgresql.org/pgsql-patches/2005-07/msg00077.php

Now I did fresh rebuild of CVS and played with it.  Result
is that it is only partly my error.  It just happens that I did
initdb with option '-E unicode'.  Now, can anybody explain the
following difference:

========================================
$ psql -c '\l' template1; psql -c "select 'a\nxxxxxx'::text as
x;" template1
           List of databases
        Name        | Owner | Encoding
--------------------+-------+-----------
 contrib_regression | marko | SQL_ASCII
 postgres           | marko | SQL_ASCII
 template0          | marko | SQL_ASCII
 template1          | marko | SQL_ASCII
(4 rows)

    x
----------
 a
xxxxxx
(1 row)
========================================
$ psql -c '\l' template1; psql -c "select 'a\nxxxxxx'::text as
x;" template1
           List of databases
        Name        | Owner | Encoding
--------------------+-------+----------
 contrib_regression | marko | UTF8
 postgres           | marko | UTF8
 template0          | marko | UTF8
 template1          | marko | UTF8
(4 rows)

 x
---
 a
xxxxxx
(1 row)

=========================================

I can send new regression test for SQL_ASCII, but it still
would not work for all users.

--
marko