I've just added some code to explain.c to change the label of join nodes
when they are using special join rules (for outer joins or IN joins).
This wasn't all that interesting up through 7.3, because knowing the
query you could be quite sure which join rule was in effect at each
step. But now
The recent addition of drop column makes possible to change column type.
E. g. : I have written a small utility reading Medline queries results and
dumping them in a Postgres database for further analysis.
[ Two remarks before starting ; 1) I *know* that I'm reinventing the wheel
and that you
Peter Eisentraut wrote:
alex avriette writes:
Is it worth warning the user that you cannot use gcc as ld on Irix?
You cannot use gcc as ld on any system.
Erm, perhaps not, but you can use it as the link step (both to
generate executables and to generate shared objects) on many systems.
Hi guys,
Looking at the log_duration postgresql.conf option. How about adding an
option log_duration_min which is a value in milliseconds that is the minimum
time a query must run for before being logged. Basically, what I'd be
interested in is please log the SQL query and duration of all
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
So you put the MD5 sum into the release announcement email. That is
downloaded by many people and also archived in many distributed places
that we don't control, so it would be very hard to tamper with.
ISTM that this gives you the same
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Looking at the log_duration postgresql.conf option. How about adding an
option log_duration_min which is a value in milliseconds that is the minimum
time a query must run for before being logged.
Fine with me --- but you'll need to add more
Hi,
In the merge join as well as in the nested loop join,
we do ExecProject() after we have found tuples from
the relations involved in the join.
For a join query involving just two relations and
merge join being used, the outer plan will be
NodeSort. Now, NodeSort will create Temp files and
Anagh Lal [EMAIL PROTECTED] writes:
Why do we not just store the attributes required in
the join (i.e. those in the join qual conditions and
the ones in the select list) and then perform sorting
and retrieval on these tuples rather than on the
possibly larger tuples with more attributes
Tom Lane writes:
code is concerned: the regex library actually offers three regex
flavors, advanced, extended, and basic, where extended matches
what we had before (extended and basic correspond to different
levels of the POSIX 1003.2 standard). We just need a way to expose
that knob to the
Tom Lane writes:
Is there a reason why lc_messages is PGC_SUSET, and not PGC_USERSET?
I can't see any security rationale for restricting it.
The language on the frontend is the same as the one used for the server
log, so a user could effectively encrypt his part of the server log for
the
Tom Lane writes:
REVOKE ALL ON SCHEMA public FROM PUBLIC;
which fails with
ERROR: dependent privileges exist (use CASCADE to revoke them too)
Not here.
This message seems incorrect --- what is a dependent privilege, and
why would PUBLIC have any?
The term dependent privilege is
Curt Sampson writes:
MD5, or any other unsigned check, makes sense from a security point of
view only if it is stored independently from the thing you are checking.
So you put the MD5 sum into the release announcement email. That is
downloaded by many people and also archived in many
Christopher Kings-Lynne writes:
I found an example of a casting problem in our source code now that we're
running 7.3:
SELECT CURRENT_DATE - EXTRACT(DOW FROM CURRENT_DATE);
A mathematically sound way to write this would be:
select current_date - extract(dow from current_data) * interval '1
alex avriette writes:
Is it worth warning the user that you cannot use gcc as ld on Irix?
You cannot use gcc as ld on any system.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our list archives?
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane writes:
code is concerned: the regex library actually offers three regex
flavors, advanced, extended, and basic, where extended matches
what we had before (extended and basic correspond to different
levels of the POSIX 1003.2 standard). We
Peter Eisentraut [EMAIL PROTECTED] writes:
Tom Lane writes:
REVOKE ALL ON SCHEMA public FROM PUBLIC;
which fails with
ERROR: dependent privileges exist (use CASCADE to revoke them too)
Not here.
[ scratches head ] Not here either; but it was definitely failing when
I wrote that
16 matches
Mail list logo