Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.databases.postgresql > #586

Re: Issue where postgres randomly gets into state where it returns hstore as string

Path csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!news.netfront.net!gonzo.reversiblemaps.ath.cx!not-for-mail
From Jasen Betts <jasen@xnet.co.nz>
Newsgroups comp.databases.postgresql
Subject Re: Issue where postgres randomly gets into state where it returns hstore as string
Date 26 Aug 2014 06:55:21 GMT
Organization JJ's own news server
Lines 13
Message-ID <lthb0p$di2$1@gonzo.reversiblemaps.ath.cx> (permalink)
References <db3c89b3-0965-4922-943d-0ee5a9b35ee6@googlegroups.com>
NNTP-Posting-Host 118.90.59.246
X-Trace adenine.netfront.net 1409036435 13291 118.90.59.246 (26 Aug 2014 07:00:35 GMT)
X-Complaints-To news@netfront.net
NNTP-Posting-Date Tue, 26 Aug 2014 07:00:35 +0000 (UTC)
X-Face ?)Aw4rXwN5u0~$nqKj`xPz>xHCwgi^q+^?Ri*+R(&uv2=E1Q0Zk(>h!~o2ID@6{uf8s;a +M[5[U[QT7xFN%^gR"=tuJw%TXXR'Fp~W;(T"1(739R%m0Yyyv*gkGoPA.$b,D.w:z+<'"=-lVT?6 {T?=R^:W5g|E2#EhjKCa+nt":4b}dU7GYB*HBxn&Td$@f%.kl^:7X8rQWd[NTc"P"u6nkisze/Q;8 "9Z{peQF,w)7UjV$c|RO/mQW/NMgWfr5*$-Z%u46"/00mx-,\R'fLPe.)^
User-Agent slrn/pre1.0.0-18 (Linux)
Xref csiph.com comp.databases.postgresql:586

Show key headers only | View raw


On 2014-08-25, zebharadon@gmail.com <zebharadon@gmail.com> wrote:
>
> The problem is that it is returning an hstore array as a string.
> From a non-working instance, here is some text from an irb session:

can the brokenness be dumped by pg_dumpall and restored and produce a
broken restore. or is this feature something that pg_dump can't access.

-- 
umop apisdn


--- news://freenews.netfront.net/ - complaints: news@netfront.net ---

Back to comp.databases.postgresql | Previous | NextPrevious in thread | Next in thread | Find similar


Thread

Issue where postgres randomly gets into state where it returns hstore as string zebharadon@gmail.com - 2014-08-25 11:39 -0700
  Re: Issue where postgres randomly gets into state where it returns hstore as string Jasen Betts <jasen@xnet.co.nz> - 2014-08-26 06:55 +0000
    Re: Issue where postgres randomly gets into state where it returns hstore as string zebharadon@gmail.com - 2014-08-27 14:51 -0700
      Re: Issue where postgres randomly gets into state where it returns hstore as string Jasen Betts <jasen@xnet.co.nz> - 2014-08-28 12:47 +0000
  Re: Issue where postgres randomly gets into state where it returns hstore as string mattheww@chiark.greenend.org.uk (Matthew Woodcraft) - 2014-08-28 23:05 +0100
    Re: Issue where postgres randomly gets into state where it returns hstore as string mattheww@chiark.greenend.org.uk (Matthew Woodcraft) - 2014-08-28 23:15 +0100

csiph-web