Bruno Wolff III <[EMAIL PROTECTED]> writes:
> This is different in that you are using - instead of >= . Date - Date
> will get picked because that is the only - operator with a left operand
> of type date.
Even if it weren't the only one, there is a preferential case involved:
given "known_type op
On Mon, Mar 29, 2004 at 15:28:59 -0600,
"Karl O. Pinc" <[EMAIL PROTECTED]> wrote:
>
> And this was my scratch psql test:
>
> => select CAST('1/1/2004' AS date) - '3 years';
> ERROR: Bad date external representation '3 years'
>
> I am using 7.3 so maybe this has been fixed. Or it's just the
>
On Mar 29, 2004, at 7:44 PM, Marc G. Fournier wrote:
On Mon, 29 Mar 2004, Mike Nolan wrote:
Now, that doesn't preclude clients from seeing the names of another
clients database using \l, but unless there is gross mis-management
of the
pg_hba.conf, seeing the names of other databases doesn't give
On Monday 29 March 2004 05:24 pm, Dann Corbit wrote:
> Of course I meant that is contained in "vacuumlo" --> stupid spell
I have never worked with large objects in postgresql and I have no idea what
is different with vacuumlo. Suggestions or thoughts anyone?
Matthew
---
On Mon, 29 Mar 2004, Mike Nolan wrote:
> > Now, that doesn't preclude clients from seeing the names of another
> > clients database using \l, but unless there is gross mis-management of the
> > pg_hba.conf, seeing the names of other databases doesn't give other
> > clients any benefits ...
>
> Tha
> Now, that doesn't preclude clients from seeing the names of another
> clients database using \l, but unless there is gross mis-management of the
> pg_hba.conf, seeing the names of other databases doesn't give other
> clients any benefits ...
That rather depends upon what those clients are doing,
Which HA abilities does PG lack?
CSN
I sincerely hope not. PostgreSQL is THE free database
that can reach the
production quality of the major databases (Oracle,
DB2). The only remaining
feature it lacks out of the box is replication and
some HA abilities the big
ones have. And f
On Mon, 29 Mar 2004, Mike Nolan wrote:
> I know of an ISP who has a large number of customers (in excess of 400)
> running similar small (probably under 100MB each) MySQL databases. Since
> I know each customer has access only to his own data, I assume it is
> implemented using a different databa
On Mon, 29 Mar 2004, Tom Lane wrote:
> It might be possible to do something with a flat file as an intermediary
> between the postmaster and the tables that are the master data. We
> already do this for pg_shadow passwords, and I've been thinking of
> proposing that we add a flat file for the dat
On Mon, 29 Mar 2004, Tom Lane wrote:
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
> > And while we're at it, maybe we should have a setting somewhere should
> > someone execute the famous "update pg_shadow set usesuper = false" that
> > someone did a while back to be able to force an account to
On Mon, 29 Mar 2004, Karl O. Pinc wrote:
>
> On 2004.03.29 14:44 Bruno Wolff III wrote:
> >
> > In postgres you shouldn't have to explicitly cast the constant to an
> > interval as long as there isn't one than one >= operator that could
> > be applied (depending on the eventaul type of the constan
Title: Message
Is there any
functionality contained in vacuum that is
not contained in pg_autovacuum?
Suggestion:
Modify the
base schema for tables and add a timestamp column for the last vacuum
operation, and a timestamp for the last vacuum analyze. Finally, a
timestamp for the last tim
Of course I meant that is contained in "vacuumlo" --> stupid spell
checker auto-corrected it.
-Original Message-
From: Dann Corbit
Sent: Monday, March 29, 2004 2:24 PM
To: [EMAIL PROTECTED]
Subject: Contrib question
Is there any functionality contained in vacuum that is not contained in
Alex wrote:
MySQL is still the default database offered by any web hosting company
and if Postgres wants to become the designated db engine for these
services or become the worlds no.1 open source db then i think lots of
things need to be done. Take for example the admin interface (MySQL
Admin
On Sun, 28 Mar 2004, Mike Nolan wrote:
> > > Perhaps, but it isn't obvious which directory has which database. I'm not
> > > not sure which system catalogs provide that information, something that
> > > wasn't obvious from the online docs, either.
> >
> > SELECT oid FROM pg_database WHERE datname
On Sun, 28 Mar 2004, Mike Nolan wrote:
> I'm not much of an expert in MySQL, but on my ISP 'show databases' only
> shows MY databases.
Right, show databases == \l, I believe ... but, how is security on the
table(s) that 'show databases' dealt with ... can you access those
directly, by passing the
Hi david and PGSQL lovers,
I think that PGSQL devellopers and users must not be upset
by all the ongoing comparisons between MySQL and PostgreSQL.
This is the direct illustration of the postgresql success,
it gives me the feelings that its like a shameful desire
of MySQL users to come to a more "p
17 matches
Mail list logo
