[EMAIL PROTECTED] wrote:
The subquery will always return a row from LogEvent, but that row's itemID
will be null if the itemID doesn't match a row from Item.
That's why the subquery has the "and i.ItemID is null".
You lost me.
[EMAIL PROTECTED] \d foo
Table "public.foo"
Column | Type
The subquery will always return a row from LogEvent, but that row's itemID
will be null if theitemID doesn't match a row from Item. That's why the subquery has
the
"and i.ItemID is null".
> Stephan Szabo wrote:
>
>> On Thu, 26 Feb 2004 [EMAIL PROTECTED] wrote:
>>
>>
>>>I'm using postgresl 7.3.2
Mike Mascari wrote:
Stephan Szabo wrote:
On Thu, 26 Feb 2004 [EMAIL PROTECTED] wrote:
I'm using postgresl 7.3.2 and have a query that executes very slowly.
There are 2 tables: Item and LogEvent. ItemID (an int4) is the
primary key
of Item, and is also a field in LogEvent. Some ItemIDs in Log
How would i go about changing a databases encoding? Is this at all
possible?
There does not seem to be much i can with ALTER DATABASE except change
its name!
--
Alexander Cohen
http://www.toomuchspace.com
(819) 348-9237
(819) 432-3443
---(end of broadcast)---
On Thu, Feb 26, 2004 at 03:22:02PM -0600, Keith Bottner wrote:
> I am very interested in a similar solution and believe that I could get some
> resources from my company for implementing such a system. Are you interested
> in helping to develop the functionality for Postgres?
>
> Is anybody else i
Hi,
I'm running snort, ulogd and samhain on my system, all using persistent db
connections. Thereby I'm using sqlrelay for my websites (which maintains a
connection pool: default 3 persistent connections, maximal 15).
Although I'm now the only one using the webserver (for testing purposes only),
On Thu, 26 Feb 2004 16:47:10 -0500, Alexander Cohen <[EMAIL PROTECTED]> wrote:
> Im trying to get a list of all groups that a certain user is a member
> of. Can anyone help me with the sql to get that?
select groname
>from pg_group
where (select usesyside from pg_shadow where usename = 'postgres'
"Jeffrey W. Baker" <[EMAIL PROTECTED]> writes:
> We've also seen XFS panic because of inconsistent in-memory
> metadata.
>From this fact alone we may deduce with absolute confidence that
either your hardware or your filesystem implementation are faulty.
There is no combination of operations which
Dear list,
We are using PostgreSQL with the database and xlogs on (separate) XFS
volumes under Linux 2.4.25. We are simply curious to hear your
experiences with this combination, if you are using it. In only two
days of heavy activity, we've already been able to corrupt one
database. We've also
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Date: 26.02.2004 22:22:02
Subject: Re: [GENERAL] Postgres clustering?
> There currently is no solution as I have asked this question quite a few
> times in the past.
[...]
Forgive me if you already get this:
I think Li
Jeffrey W. Baker wrote:
On Thu, 2004-02-26 at 11:46, Holger Marzen wrote:
On Thu, 26 Feb 2004, Jeffrey W. Baker wrote:
We are using PostgreSQL with the database and xlogs on (separate) XFS
volumes under Linux 2.4.25. We are simply curious to hear your
experiences with this combination, if you ar
Hello,
I have a rather simple function I’ve been using in
7.3.4
version
-
PostgreSQL 7.3.4
on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (
>Is there a shorthand notation when performing a multi-table join and one
>column is to be equaled in all tables?
Is this you are looking for?
SELECT t1.c7,t2.c6
FROM t1,t2
USING (c1,c2,c3)
WHERE t1.c4='2004-2-28' AND t2.c5='xyz'
performs the same as
SELECT t1.c7,t2.c6
FROM t1,t2
WHERE t1.c1=t
Karam Chand wrote:
Hello
I have read the docs.you need to install PostgrSQL
using cygwin etc. I am not in a position right now to
do that :)
Are no standard libpq.lib for Windows available?
In MySQL you get a precompiled library for C API and
that is very helpful.
Can some body mail me a com
Karam Chand wrote:
Hello
Thanks for all the reponses yesterday for my queries
regarding moving from MySQL to PgSQL.
As I see there is no native port of POstgresql for
Windows. My applications is being developed in Windows
primarily due to better editors. We are using
wxWindows cross platform tool
Tom Lane wrote:
StopService()
{
ConsoleMessage "Stopping PostgreSQL database services"
/usr/local/pgsql/bin/pg_ctl stop -D /usr/local/pgsql/data
x=`/bin/ps axc | /usr/bin/grep postgres`
if /bin/test "$x"
then
set $x
kill -9 $x
Thanks.
Well this decision is taken by manager not me :)
Anyway, our product is cross platform version so I
have to compile it in Window...I need the Windows
library..
Karam
--- Shridhar Daithankar <[EMAIL PROTECTED]>
wrote:
> Karam Chand wrote:
>
> > Hello
> >
> > Thanks for all the reponses
Hello
Thanks for all the reponses yesterday for my queries
regarding moving from MySQL to PgSQL.
As I see there is no native port of POstgresql for
Windows. My applications is being developed in Windows
primarily due to better editors. We are using
wxWindows cross platform toolkit to develop the
18 matches
Mail list logo
