Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Longer term, a robust mechanism for DB level locks would probably be
> preferable, I guess, so I'm not sure if my idea is worth doing in the
> mean time. Presumably it hasn't caused much of a problem up to now,
> since most people are not likely to mo
Tom Lane wrote:
A final point is that implementing CREATE DATABASE via "cp -r" is and
always has been fundamentally broken anyway, because of the lack of
interlocking against other backends changing the source database.
We have a very half-baked defense against that (erroring out if anyone
else
how to do select from same table to get only unique values from same
column(s) ?
SELECT DISTINCT a, b FROM tab;
or even:
SELECT DISTINCT ON (a) a, b FROM tab;
Chris
---(end of broadcast)---
TIP 8: explain analyze is your friend
hi
how to do select from same table to get only unique values from same
column(s) ?
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
Joe Conway <[EMAIL PROTECTED]> writes:
> The patch at the root of this discussion eliminates both issues, but
> leaves us with no check at all in the INSTEAD case. Is there any way to
> do the permission checks on the original query in the INSTEAD case, even
> though the query itself will never
Tom Lane wrote:
No; it's possible for the amalgamated query to include references to
tables that are referenced only in the original query and nowhere in the
text of the rule. (This is obviously possible right now, since we just
take the union of the two rtables and don't make any effort to discar
Hello ,
I was trying to write a patch code in converting the querytree being
generated after the pg_analyze_and_rewrite().
For that I want to know the operator name ( like =, < , <> etc ) .. but the
Oper node stores the "opno "
How to get the operator from the opno ???
Thanks for the Help in a
Joe Conway <[EMAIL PROTECTED]> writes:
> Why wouldn't we force checkAsUser to the rule owner in the copied RTEs,
> similar to the rest of the rule query?
Because it would be the wrong check. We need to check that the rule
caller has permissions on the view for whatever he originally tried
to do
Sander Steffann wrote:
Hi,
Inside the RH9.0 coesist the 7.4.0-0.3 and 7.4.0-0.5 versions
looking on other RH directory version I found that actually
7.4.0-0.2
7.4.0-0.3
7.4.0-0.4
7.4.0-0.5
are existing.
Inside the SRPMS directory is present only the 7.4.0-0.2
version!
This is because when I bu
In postgresql.conf the first entry should be something like 'tcpip'.
Set it to 'true'. That's the equivalent of the postmaster -D.
HTH,
-Tony
[EMAIL PROTECTED] (Nailah Ogeer) wrote in message news:<[EMAIL PROTECTED]>...
> How do you connect to postgres if it is running on a different machine. I
AFAICS the server doesn't know (and in my opinion shouldn't care) what
platform a non-local client is running on. This appears to be purely a
client-side issue. Furthermore, on Windows, if you are writing the data
you get from Postgres to a file which you opened in non-binary mode,
Windows will do
Hi,
> Inside the RH9.0 coesist the 7.4.0-0.3 and 7.4.0-0.5 versions
> looking on other RH directory version I found that actually
>
> 7.4.0-0.2
> 7.4.0-0.3
> 7.4.0-0.4
> 7.4.0-0.5
>
> are existing.
> Inside the SRPMS directory is present only the 7.4.0-0.2
> version!
This is because when I built
12 matches
Mail list logo
