I use a window client to conncet to a postgreSQL server with windows ODBC.
It seems if I haven't done anything on the connection for hours, the
connection will be dropped. Is that possible to set the time limit of a
connection? Thank you in advance!
Jack
---(end of broadc
Wei,
> Do you have any idea of what the software is called? I could only find
> the redhat database ISO for download.
Announced on PGSQL-ANNOUNCE a couple of weeks ago:
(if you're not subscribed to PGSQL-ANNOUNCE, you should be)
===
The Red Hat
Josh:
Do you have any idea of what the software is called? I could only find
the redhat database ISO for download.
Thanks
On Wed, 2002-10-30 at 18:43, Josh Berkus wrote:
> Wei,
>
> > My colleague installed a redhat database 2(which is based on postgresql)
> > onto his redhat 7.3 machine and it
Wei,
> My colleague installed a redhat database 2(which is based on postgresql)
> onto his redhat 7.3 machine and it came with a very nice java query
> analyzer tool. It is sort of like the query analyzer in MS SQL Server
> with the graphical output of the execution plan, quite intuitive.
>
> I w
My colleague installed a redhat database 2(which is based on postgresql)
onto his redhat 7.3 machine and it came with a very nice java query
analyzer tool. It is sort of like the query analyzer in MS SQL Server
with the graphical output of the execution plan, quite intuitive.
I wonder if I can fin
Dan,
I use Xpga Java Postgresql client and it is awesome.
It's at http://www.kazak.ws/xpg/
Kevin
On Wed, 2002-10-30 at 10:30, Dan Hrabarchuk wrote:
> gASQL is a gnome-db client that looks like it has a lot of promise. The
> only problem is I've never been able to get the application to run
How do I get rid of the messages like "NOTICE: CREATE TABLE / PRIMARY
KEY will create implicit index 'test_pkey' for table 'test'" coming out
from stderr when I run psql with my create table script?
(I don't want to direct them to /dev/null, since I still want to be able
to see the *real* sql err
One strategy is to use some sort of middleware that takes care of this. On
a project I did a few years ago, I used a perl module that read the record
from Postgres and made it into a perl object. The object contained a
variable, "changed", that reflected whether anything had actually changed
in the
When doing database work over the web, especially when many records are
on one page, *many* updates get posted to pg that do not change the
record. Eg, the page may contain 50 records, the user changes 1, and
submits.
I assume that a no-change update takes the same resources as a "real"
update, i
Of course, I meant
SELECT COALESCE( (SELECT true FROM ... WHERE ... AND boolcol LIMIT 1),
FALSE);
Jean-Luc Lachance wrote:
>
> Why not simply:
>
> SELECT COALESCE( (SELECT true FROM ... WHERE boolcol LIMIT 1), FALSE);
>
> JLL
>
> Josh Berkus wrote:
> >
> > Tom,
> >
> > > Perhaps
> > >
Why not simply:
SELECT COALESCE( (SELECT true FROM ... WHERE boolcol LIMIT 1), FALSE);
JLL
Josh Berkus wrote:
>
> Tom,
>
> > Perhaps
> > SELECT true = ANY (SELECT boolcol FROM ...);
> > or
> > SELECT true IN (SELECT boolcol FROM ...);
> >
> > Which is not to say that MAX(bool) migh
gASQL is a gnome-db client that looks like it has a lot of promise. The
only problem is I've never been able to get the application to run
properly. I'm using RedHat 8.0 on my desktop. The last official version
does not install properly. If I grab a CVS copy, I go through dependency
hell. Has anyon
On Wed, 2002-10-30 at 07:45, Viacheslav N Tararin wrote:
Hi,
(which list should this go to? I guess it is OT on both...)
> Can anybody take me reference on Database design tool with PostgreSQL
> support.
Dia and dia2sql (or something similar...) Google knows more :-)
HTH
Johannes Lochmann
> I installed 7.3beta3 but how do I do it now?
> How do I make a function that returns a dataset
>
> Greets
> Zertox
He is an email I received from Joe Conway on the subject a month or so ago
> Adam Witney wrote:
>> There have been a few emails recently concerning using functions. However I
>>
Uz.ytkownik Viacheslav N Tararin napisa?:
Hi.
Can anybody take me reference on Database design tool with PostgreSQL
support.
pgadmin.postgresql.org
Tomasz Myrta
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Yea it would be easier to have everything in one table filling unused with
nulls, but I was trying to avoid that because of the wasted space.
But I think I'll do it that way after all :~]
Thanks for your help
- Original Message -
From: "Tomasz Myrta" <[EMAIL PROTECTED]>
To: "James Adam
> From: Stephan Szabo <[EMAIL PROTECTED]>
> To: Philip Van Hoof <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
> Subject: Re: [SQL] Creating Stored Procedures
> Date: 29 Oct 2002 10:36:17 -0800
>
>
> On 29 Oct 2002, Philip Van Hoof wrote:
>
> > Note that I have searched A LOT on
> Can anybody take me reference on Database design tool with PostgreSQL
> support.
>
visit, http://sourceforge.net/projects/phppgadmin/
regards,
bhuvaneswaran
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives
As far as I know functions can not return recordsets. Try functions returning cursors
(then FETCH ALL IN..), or temporary tables.
regards Joseph
- Original Message -
From: "Philip Van Hoof" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, October 29, 200
Uz.ytkownik James Adams napisa?:
Hello,
I have a "baseTable". I have a number of decendantTables that INHERIT
from the base table.
I want to do somthing like
=>select * from baseTable;
But I want it to return the data in the all the descendant tables along
with the extra column that th
20 matches
Mail list logo
