When I do a ps -ef, in the command column, I see:
postgres: postgres dbname 10.170.1.60(57413) idle
I get all of this, except the "57413". What does this mean, and more
importantly, how can I tie that number back to a connection that I've
acquired via JDBC?
In my case, I've got a connection tha
Yeah, kinda guessed that.
So there's no way (that you know of) to, say, cast my JDBC connection object
to something Postgresql'y and peer into its internals?
Thanks,
Dave
On Fri, Feb 22, 2008 at 11:28 AM, Douglas McNaught <[EMAIL PROTECTED]>
wrote:
> On 2/22/08, David Jaqua
(one of many) on the
client.
Thanks just the same, tho,
Dave
On Fri, Feb 22, 2008 at 11:55 AM, Erik Jones <[EMAIL PROTECTED]> wrote:
>
> On Feb 22, 2008, at 10:28 AM, Douglas McNaught wrote:
>
> > On 2/22/08, David Jaquay <[EMAIL PROTECTED]> wrote:
> &
I'm seeing a problem with a LEFT JOIN in 8.3.3, running on what I
believe to be an Ubuntu Heron server. The sql below demonstrates the
issue.
What I expect to see is no rows in the output, i.e. the LEFT JOIN
should pair the two rows together, and the WHERE clause should decide
that the joined row
Just got an email saying that this has been fixed in 8.3.4, so I
suppose I'll watch and wait for that. Thanks for looking, Alan (and
anyone else who was watching this...)
Dave
On Tue, Sep 9, 2008 at 4:57 PM, Alan Hodgson <[EMAIL PROTECTED]> wrote:
> On Tuesday 09 September 2008,
A really long time ago, on 2/27/07, Tom Lane <[EMAIL PROTECTED]> wrote:
Usually what you want to think about for something
like this is plan optimization, ie, what order are the tables joined in
and with what join methods.
How exactly can you control the join order? I have cases where the
expl
