Russell Smith wrote:
On Wed, 6 Apr 2005 08:18 am, Andreas Pflug wrote:
Joshua D. Drake wrote:
The question is coming from the TODO:
Allow REINDEX to rebuild all database indexes, remove
contrib/reindexdb
We can do whatever the community wants :) Just tell us what it is.
Does this pos
On Wed, 6 Apr 2005 08:18 am, Andreas Pflug wrote:
> Joshua D. Drake wrote:
> > The question is coming from the TODO:
> >
> > Allow REINDEX to rebuild all database indexes, remove
> > contrib/reindexdb
> >
> > We can do whatever the community wants :) Just tell us what it is.
>
Does this pose a p
Joshua D. Drake wrote:
The question is coming from the TODO:
Allow REINDEX to rebuild all database indexes, remove
contrib/reindexdb
We can do whatever the community wants :) Just tell us what it is.
RECREATE option that performs like DROP/CREATE INDEX (best without
changing the indexes OID)
Reg
The question is coming from the TODO:
Allow REINDEX to rebuild all database indexes, remove
contrib/reindexdb
We can do whatever the community wants :) Just tell us what it is.
Sincerely,
Joshua D. Drake
IIRC, "REINDEX DATABASE" only reindexes the system catalogs. I suppose
Joshua is thinking of
On Tue, Apr 05, 2005 at 04:19:54PM -0400, Tom Lane wrote:
> I've gotten a bee in my bonnet again about Resdom being wasteful.
> There is no case where Resdom appears without TargetEntry, nor vice
> versa, so we ought to fold them into a single node type.
Gee, I was looking at that code and nearby
I've gotten a bee in my bonnet again about Resdom being wasteful.
There is no case where Resdom appears without TargetEntry, nor vice
versa, so we ought to fold them into a single node type. Is anyone
out there working on a patch that would be seriously affected by
such a change? If so speak up -
=?ISO-8859-1?Q?Hans-J=FCrgen_Sch=F6nig?= <[EMAIL PROTECTED]> writes:
> What is this patch supposed to do?
> As far as I can see, there is already a reindex command ...
> test=# \h reindex
> Command: REINDEX
> Description: rebuild indexes
> Syntax:
> REINDEX { DATABASE | TABLE | INDEX } name [
Joshua D. Drake wrote:
Hello,
We are considering submitting a patch for REINDEX ALL. What syntax would
we like?
REINDEX ALL?
REINDEX DATABASE ALL?
Sincerely,
Joshua D. Drake
-- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services,
Hello,
We are considering submitting a patch for REINDEX ALL. What syntax would
we like?
REINDEX ALL?
REINDEX DATABASE ALL?
Sincerely,
Joshua D. Drake
-- Command Prompt, Inc., Your PostgreSQL solutions company. 503-667-4564
Custom programming, 24x7 support, managed services, and hosting
Open Source
Wes <[EMAIL PROTECTED]> writes:
> Ok, now I follow. Taking the biggest indexes:
> The weekend before:
> INFO: index "message_recipients_i_recip_date" now contains 393961361 row
> versions in 2435100 pages
> INFO: index "message_recipients_i_message" now contains 393934394 row
> versions in 1499
Oleg Bartunov writes:
> what if not require RETURN iff OUT parameter is defined ?
That's what I'm suggesting ;-)
regards, tom lane
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan
On Tue, 5 Apr 2005, Tom Lane wrote:
Robert Treat <[EMAIL PROTECTED]> writes:
While it is useless in this example, istm it only makes things more
confusing to require return in some cases but not in others. Is there
some technical advantage to dropping it?
It's about the same either way as far as t
On Tue, 5 Apr 2005, Russell Smith wrote:
I may be a bad man for suggesting it... But is it possible to ship
libpq as a seperate tarball that you can compile without postgresql
server?
Actually, its something that I'm going to sit down and work on ... not
pulling libpq out of core, but creating
Robert Treat <[EMAIL PROTECTED]> writes:
> While it is useless in this example, istm it only makes things more
> confusing to require return in some cases but not in others. Is there
> some technical advantage to dropping it?
It's about the same either way as far as the code is concerned. But
I'
=?iso-8859-1?q?Mart=EDn_Marqu=E9s?= writes:
> El Lun 04 Abr 2005 17:36, Tom Lane escribió:
>> Perl and Python don't have "BuildPrereq: postgresql-devel" in their rpmspecs.
>> PHP does.
> The header files would not be a problem. The real problem is that you also
> need to have postgresql-libs. :-
On Tue, 2005-04-05 at 03:43, Tom Lane wrote:
> Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> > On Tue, 5 Apr 2005, Tom Lane wrote:
> >> CREATE FUNCTION sum_n_product(x int, y int, OUT sum int, OUT prod int) AS
> >> $$
> >> BEGIN
> >> sum := x + y;
> >> prod := x * y;
> >> RETURN;
> >> END;
> >> $
El Lun 04 Abr 2005 18:00, Doug McNaught escribió:
> Robert Treat <[EMAIL PROTECTED]> writes:
>
> > If by "stripped down" you mean without postgresql database support then
> > I'll grant you that, but it is no different than other any other pl
> > whose parent language requires postgresql to be ins
El Lun 04 Abr 2005 17:36, Tom Lane escribió:
> "Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> > Maybe I am just dense, but the argument seems to be completely moot. PHP
> > is no different than Perl or Python in this case.
>
> Perl and Python don't have "BuildPrereq: postgresql-devel" in their
Greg Sabino Mullane said:
>
>> Other languages don't require PG to be installed in order to compile
>> them. For example, you can build Perl (with no Postgres on the
>> system), build Postgres and then build DBD::Pg as a completely
>> separate step.
>
> Just so we are all on the same sheet of
On Tue, Apr 05, 2005 at 06:06:09PM +1000, Russell Smith wrote:
> The issue also includes the fact that you can't install libpq without having
> postgresql
> installed. If you could do that, the circular dependency wouldn't exist.
>
> Some systems build postgresql into php, given that is the case
On Tue, 5 Apr 2005 06:01 am, Joshua D. Drake wrote:
> Tom Lane wrote:
>
> >Andrew Dunstan <[EMAIL PROTECTED]> writes:
> >
> >>... If there are no license or build issues I'm in favor.
> >>
> >
> >Peter has pointed out that the problem of circular dependencies is a
> >showstopper for integrating pl
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> On Tue, 5 Apr 2005, Tom Lane wrote:
>> CREATE FUNCTION sum_n_product(x int, y int, OUT sum int, OUT prod int) AS $$
>> BEGIN
>> sum := x + y;
>> prod := x * y;
>> RETURN;
>> END;
>> $$ LANGUAGE plpgsql;
> The above code example do not have any RETURNS
On Tue, 5 Apr 2005, Tom Lane wrote:
> CREATE FUNCTION sum_n_product(x int, y int, OUT sum int, OUT prod int) AS $$
> BEGIN
> sum := x + y;
> prod := x * y;
> RETURN;
> END;
> $$ LANGUAGE plpgsql;
>
> The RETURN statement is kinda useless in this example, but it is still
> required, be
23 matches
Mail list logo
