table schema causes crash - Mailing list pgsql-general

7.2.3

CREATE TABLE imap_passwd (
        username              varchar(128) NOT NULL PRIMARY KEY,
        pw_crypt              varchar(128) DEFAULT '' NOT NULL,
        pw_cr                 varchar(128) DEFAULT '' NOT NULL,
        name                  varchar(128) DEFAULT '' NOT NULL,
        user_id               int DEFAULT 65534 NOT NULL,
        group_id              int DEFAULT 65534 NOT NULL,
        home                  varchar(255) DEFAULT '' NOT NULL,
        maildir               varchar(255) DEFAULT '' NOT NULL,
        quota                 varchar(255) DEFAULT '' NOT NULL
);

then at the psql prompt:

\d imap_passwd

will core dump.

---
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
'imap_passwd_pkey' for table
 'imap_passwd'
CREATE
authtest=# \d imap_passwd
Segmentation fault
---