Pointers to what this is? Do we have it documented anywhere? Search
engine, of course, is done, so can't search there ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{fr
> > It was discussed several times for btree - add heap tid to
> > index key and you'll scan index for particulare tuple much faster.
>
> good idea :) Why don't just to use tid ALWAYS as last part of key ?
> When btree code sees equal keys then it will compare tids ?
> Would not be better to use
> > Why not implement *true* CLUSTER?
> > With cluster, all heap tuples will be in cluster index.
>
> It would be nice. It's pity that pg AMs are not general.
> There is no simple way to use btree instead of heap. But
> it would help.
> But using values from index is good idea too because you
> c
> Following up to myself, I finally understood my problem: I
> was trying to
> re-use SPI_tuptable->vals[i] after calling SPI_exec() on another,
> unrelated query. So the backend crash makes perfect sense now.
>
> What is the best strategy:
> - store the result of a SELECT returning multiple tu
Well all, I just spent a bit of time trying to figure out how to recover a
database where the tables appear to be intact with postgres in 'single
user mode', and came up with a quick and dirty that might not be totally
complete, but might help someone else in a similar situation ...
On Wed, Sep 27, 2000 at 10:53:43AM -0400, Tom Lane wrote:
> I think it would be a real bad idea to put the postmaster and postgres
> executables right in /usr/local/bin. Perhaps it is time to think about
> a separate 'sbin' directory for programs that aren't supposed to be
> invoked by normal use
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> It would be desirable for several reasons that PostgreSQL can be installed
> safely with --prefix=/usr/local, or some other such shared location.
> ...
> My proposal is to set includedir=${prefix}/include/postgresql (instead of
> ${prefix}/include)
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Tom Lane writes:
>> What I'm thinking about doing is eliminating the "skipAcl" RTE field
>> and instead adding an Oid field named something like "checkAclAs".
>> The semantics of this field would be "if zero, check access permissions
>> for this table
> I want to make a client application that performs a query to show the
> results, but the client application stays open and the database gets
> updated.
>
> I want that the updates of the database reflects on the open client
> application, I think this can be done with triggers but I'm not sur
Hannu Krosing writes:
> I think I'm using the default locale (this is just straight install on
> Linux from RPM-s)
>
> Is there any way to find out the locale used from within the running
> system ?
The locale the postmaster uses is whatever was set in its environment,
i.e., LC_ALL, etc.
--
I've brought this up before, but maybe if I sell it as a bug someone will
agree. :-)
It would be desirable for several reasons that PostgreSQL can be installed
safely with --prefix=/usr/local, or some other such shared location.
(One reason: no PATH, MANPATH, LD_LIBRARY_PATH to set up.)
The m
Philip Warner writes:
> Didn't Peter & Jan have a rewrite of the permissions system in the pipeline
> - or has that disappeared? What Jan was proposing was rather more
> substantial than just the setuid stuff, I *think*.
If I had known that we wouldn't beta until October I probably would have
st
Tom Lane writes:
> What I'm thinking about doing is eliminating the "skipAcl" RTE field
> and instead adding an Oid field named something like "checkAclAs".
> The semantics of this field would be "if zero, check access permissions
> for this table using the current effective userID; but if not ze
If you've had the feeling lately that you are getting a little less email
from me than expected in the process of due information to the other
developers, let me assure you that I've had the feeling lately that I'm
getting a little less than hoped for answers to my countless posts.
The reason, ho
Based on the lack of reaction on GENERAL and SQL, I am inclined to go ahead
with the
changes below at least as far as returning NULL instead of 'Not a View' or
'unknown (UID=)' (as per Tom's request), if noone objects...
At 13:15 24/09/00 +1000, Philip Warner wrote:
>
>Two routines do eccentri
> What is *true* CLUSTER ?
>
> 'grep CLUSTER' over the latest SQL standards gives back nothing.
storing data in b-tree instead of heap for example.
> > And update *entire* heap after addition new index?!
>
> I guess that this should be done even for limited number of
> indices' TIDs in a heap
> Why not implement *true* CLUSTER?
> With cluster, all heap tuples will be in cluster index.
It would be nice. It's pity that pg AMs are not general.
There is no simple way to use btree instead of heap. But
it would help.
But using values from index is good idea too because you
can have table wi
On Wed, Sep 27, 2000 at 08:53:58AM +0200, Louis-David Mitterrand wrote:
> Hello,
>
> I am writing a SPI function to run maintenance tasks on my auction
> system but it keeps crashing the backend after running only one loop.
> Now, I am not a C programmer, nor do I have any formal training in CS.
"Mikheev, Vadim" wrote:
>
> Why not implement *true* CLUSTER?
> With cluster, all heap tuples will be in cluster index.
>
What is *true* CLUSTER ?
'grep CLUSTER' over the latest SQL standards gives back nothing.
> > > The last step could be done in two ways. First by limiting
> > > number of
Tom Lane wrote:
>
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Can anyone explain why I must make / a character class
> > in case-insensitive query in order to match / ?
>
> What LOCALE are you using? There was a thread about strange ordering
> rules confusing the LIKE/regexp optimizer recen
> Hello again.
>
> I'm in the process of making a COM wrapper (enabling VB to connect to
> PostGres) for the libpq library using Visual Studio 6.0 Pro, but have
> a few problems. I can make use of the libpq.dll library from the COM
> wrapper, but I thought that it might be a bit better if the act
Finn Kettner wrote:
> Hello again.
>
> I'm in the process of making a COM wrapper (enabling VB to connect to
> PostGres) for the libpq library using Visual Studio 6.0 Pro, but have
> a few problems. I can make use of the libpq.dll library from the COM
> wrapper, but I thought that it might be a
22 matches
Mail list logo
