results
> like the compound query I quoted in my original post.
>
> On Thu, Dec 18, 2014 at 1:31 PM, Patrick Krecker
> wrote:
>>
>> On Thu, Dec 18, 2014 at 12:10 PM, Robert DiFalco
>> wrote:
>> > I have a table called friends with a user_id and a friend_id
On Thu, Dec 18, 2014 at 12:10 PM, Robert DiFalco
wrote:
> I have a table called friends with a user_id and a friend_id (both of these
> relate to an id in a users table).
>
> For each friend relationship there are two rows. There are currently ONLY
> reciprocal relationships. So if user ids 1 and
On Wed, Dec 17, 2014 at 3:11 PM, David G Johnston <
david.g.johns...@gmail.com> wrote:
>
> Patrick Krecker wrote
> > I encountered this today and it was quite surprising:
> >
> > select version();
> >
Sorry, I changed the email as I was writing it but I forgot to change the
subject line. An appropriate subject would be 'Strange behavior when
referencing non-existent column foo."count".'
On Wed, Dec 17, 2014 at 2:50 PM, Patrick Krecker
wrote:
>
> I encountered t
I encountered this today and it was quite surprising:
select version();
version
--
PostgreSQL 9.3.5 on x86_64-unknown-linux-gnu, compiled by gcc (Ubu
On Mon, Dec 15, 2014 at 10:29 AM, Joseph Kregloh
wrote:
>
>
> On Mon, Dec 15, 2014 at 12:59 PM, Patrick Krecker
> wrote:
>>
>> On Mon, Dec 15, 2014 at 9:12 AM, Joseph Kregloh
>> wrote:
>> > Hello,
>> >
>> > I have a master multi s
On Mon, Dec 15, 2014 at 9:12 AM, Joseph Kregloh wrote:
> Hello,
>
> I have a master multi slave streaming replication setup. One master and two
> slaves. I need to do some maintenance on one of the slaves as one of the
> drives died however there is some other weird things going on in that array
>
On Tue, Nov 25, 2014 at 6:37 PM, Sameer Kumar wrote:
>
> On Fri, Oct 24, 2014 at 8:01 PM, Michael Paquier
> wrote:
>>
>> On Fri, Oct 24, 2014 at 12:30 AM, John Smith
>> wrote:
>> >
>> > i want to setup a warm standby that listens 24/7 but only syncs when
>> > told to (ie only when i am ok with t
x27;IDENTIFY_SYSTEM;'
>
> (5432 is the stuck replica and 5445 is the pipe to the working replica)
>
> systemid | timeline | xlogpos
> -+--+--
> 5964163898407843711 | 1 | 174/B76D16A8
>
>
> On Fri, Aug 29, 2
On Fri, Aug 29, 2014 at 3:46 PM, Andres Freund
wrote:
> [FWIW: proper quoting makes answering easier and thus more likely]
>
> On 2014-08-29 15:37:51 -0700, Patrick Krecker wrote:
> > I ran the following on the local endpoint of spiped:
> >
> > while [ true ]; d
On Fri, Aug 29, 2014 at 2:11 PM, Andres Freund
wrote:
> On 2014-08-29 13:04:43 -0700, Patrick Krecker wrote:
> > Hi Craig -- Sorry for the late response, I've been tied up with some
> other
> > things for the last day. Just to give some context, this is a machine
> t
:30 PM, Craig Ringer
wrote:
> On 08/28/2014 09:39 AM, Patrick Krecker wrote:
> > We have a periodic network connectivity issue (unrelated to Postgres)
> > that is causing the replication to fail.
> >
> > We are running Postgres 9.3 using streaming replication. We also have
We have a periodic network connectivity issue (unrelated to Postgres) that
is causing the replication to fail.
We are running Postgres 9.3 using streaming replication. We also have WAL
archives available to be replayed with restore_command. Typically when I
bring up a slave it copies over WAL arch
On Tue, Jun 24, 2014 at 4:25 PM, Tom Lane wrote:
> Patrick Krecker writes:
> > Hello everyone -- We received a strange error today on our production
> write
> > master. During a routine maintenance script, we got the following error:
>
> > "ERROR: cache loo
Hello everyone -- We received a strange error today on our production write
master. During a routine maintenance script, we got the following error:
"ERROR: cache lookup failed for aggregate 5953992"
I think I found the culprit. We have a cron script that (among other
things) recreates the aggre
I have to say, this seems straightforward to me. An array with N elements
gets N rows in the result set. I'm curious what other behavior would be
more reasonable.
On Thu, Jan 3, 2013 at 11:22 AM, Jeff Trout wrote:
> I just ran into an interesting thing with unnest and empty arrays.
>
> create
16 matches
Mail list logo
