[Pkg-postgresql-public] Bug#739393: postgresql-9.3: Documented type “json” does not exist

Ben Finney ben+debian at benfinney.id.au
Tue Feb 18 04:44:11 UTC 2014

Package: postgresql-9.3
Version: 9.3.2-1
Severity: normal

Dear Maintainer,

The documentation specifies that the “json” type is built in, see
‘/usr/share/doc/postgresql-doc-9.3/html/datatype-json.html’. However, when
I try to use this type, the server tells me it doesn't exist:

$ psql
bignose@[local] ~=> CREATE TABLE foo (
bignose@[local] ~(>     id integer NOT NULL,
bignose@[local] ~(>     spam json NOT NULL,
bignose@[local] ~(>     PRIMARY KEY (id)
bignose@[local] ~(> );
ERROR:  type "json" does not exist
LINE 3:     spam json NOT NULL,

Please enable the “json” type in the server as a built-in type, as documented.

-- System Information:
Debian Release: jessie/sid
  APT prefers testing
  APT policy: (500, 'testing'), (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386

Kernel: Linux 3.12-1-amd64 (SMP w/4 CPU cores)
Locale: LANG=en_AU.UTF-8, LC_CTYPE=en_AU.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_AU.UTF-8)
Shell: /bin/sh linked to /bin/dash

Versions of packages postgresql-9.3 depends on:
ii  libc6                  2.17-97
ii  libcomerr2             1.42.9-3
ii  libgssapi-krb5-2       1.12+dfsg-2
ii  libkrb5-3              1.12+dfsg-2
ii  libldap-2.4-2          2.4.31-1+nmu2+b1
ii  libpam0g               1.1.3-9
ii  libpq5                 9.3.2-1
ii  libssl1.0.0            1.0.1f-1
ii  libxml2                2.9.1+dfsg1-3
ii  locales                2.17-97
ii  postgresql-client-9.3  9.3.2-1
ii  postgresql-common      153
ii  ssl-cert               1.0.33
ii  tzdata                 2013i-1

postgresql-9.3 recommends no packages.

Versions of packages postgresql-9.3 suggests:
pn  locales-all             <none>
ii  pidentd [ident-server]  3.0.19.ds1-7

-- no debconf information

 \     “Guaranteed to work throughout its useful life.” —packaging for |
  `\                                          clockwork toy, Hong Kong |
_o__)                                                                  |
Ben Finney <ben at benfinney.id.au>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 819 bytes
Desc: Digital signature
URL: <http://lists.alioth.debian.org/pipermail/pkg-postgresql-public/attachments/20140218/f3485417/attachment.sig>

More information about the Pkg-postgresql-public mailing list