| From: | Markus Bengts <markus(at)click3(dot)jsp(dot)fi> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: chkpass |
| Date: | 2003-01-08 18:47:59 |
| Message-ID: | Pine.LNX.4.40.0301082034420.15634-100000@click3.jsp.fi |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sun, 5 Jan 2003, Markus wrote:
>
> Hello,
>
> I have just done an rpm-installation of postgresql-7.3.1-1PGDG and
> postgresql-contrib-7.3.1-1PGDG.
>
> The documentation says that chkpass is a password type for storing and
> comparing encrypted passwords. What should I do to be able to create a
> table with a field of type chkpass?
>
> create table passtable (username varchar(30), passwd chkpass);
>
> does not work.
>
Can someone help me use this data type? Is it already implemented, or is
there something else in the shared library file? I have tried
load '/usr/lib/pgsql/chkpass.so';
but the type is not available in the pg_type system catalog. Can I somehow
add it with create type?
> Markus
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zengfa Gao | 2003-01-08 19:03:37 | PgSQL 7.3: /opt/pgsql/bin/postgres: Execute permission denied. |
| Previous Message | Lamar Owen | 2003-01-08 17:54:10 | Re: [HACKERS] Have people taken a look at pgdiff yet? |