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 <b...@benfinney.id.au>
signature.asc
Description: Digital signature
_______________________________________________ Pkg-postgresql-public mailing list Pkg-postgresql-public@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public