large XML data type appears empty when doing a select

Поиск
Список
Период
Сортировка
От Paula Price
Тема large XML data type appears empty when doing a select
Дата
Msg-id 32E8EAEC23EF1947BEC2FA1E4BFBADCD1C214CE912@VA3DIAXVS901.RED001.local
обсуждение исходный текст
Ответы Re: large XML data type appears empty when doing a select  (René Romero Benavides <ichbinrene@gmail.com>)
Список pgsql-novice

Postgresql 9.0.5 on Red Hat/Linux

In the table described below, the report xml contains xml (DOCUMENT) that ranges in size from 31KB to 518KB.  When I do ‘select reportxml from somereportxml where reportkey = ‘silly’;’ the terminal screen appears blank with ‘more’ displayed on the bottom.  The data is in the database – verified using EMS SQL Studio for PostgreSQL – but does not show up using pgadmin3 or typing the Select statement from the terminal screen.  Any ideas?

CREATE TABLE somereportxml

(

  reportkey character varying(36) NOT NULL DEFAULT uuid_generate_v1(),

  objectname character varying(200) NOT NULL,

  reportxml xml NOT NULL,

  recordtimestamp timestamp(2) with time zone NOT NULL DEFAULT now(),

   CONSTRAINT pkey_somereportxml PRIMARY KEY (reportkey )

)

WITH (

  OIDS=FALSE

);

 

Paula Price

 

В списке pgsql-novice по дате отправления:

Предыдущее
От: "2M Data Systems"
Дата:
Сообщение: Compiling libpq with Borland bcc32
Следующее
От: Tom Browder
Дата:
Сообщение: Security Best Practices: Is This Reasonable?