Is it at all possible to use vim to interact with psql to provide
input? That would be cool!
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
me
> Tom Lane writes:
>
> > Well, we need to talk about that. I like your idea of making ident auth
> > "just work" on local connections better than Oliver's approach of
> > inventing a separate auth-type keyword.
>
> This is exactly what I would not like to see. "ident" defines a specific
> prot
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> test=# create index myindex on accounts(aid) where bid <> 0;
> test=# explain select * from accounts where aid < 10 and bid <> 0;
> and I got a log message:
> DEBUG: clause_pred_clause_test: unknown pred_op
> Is this normal?
Yes. We might want to s
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Wait, why isn't that the solution in the first place. Let's build the
> index with an opclass that uses plain strcmp comparison.
By George, I think you've got it! All we need is comparison ops and
an opclass that use strcmp, even when USE_LOCALE is
I know. I forgot to put the -request in the e-mail address.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Tom Lane writes:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > I have had an idea how the LIKE optimization problem could be solved.
>
> Hmm ... so in a non-ASCII locale, we'd have to look for an index on
> strxfrm(A) rather than directly on A. And the index would need to
> use a nonstandar
I have created a test data using pgbench, played with the partial
index.
test=# create index myindex on accounts(aid) where bid <> 0;
CREATE
test=# explain select * from accounts where aid < 10 and bid <> 0;
and I got a log message:
DEBUG: clause_pred_clause_test: unknown pred_op
Is this norm
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > >> The complaints about WAL size amount to "we don't have the disk space
> > >> to keep track of this, for long-running transactions". If it doesn't
> > >> fit on disk, how likely is it that it will fit in memory?
> >
> > > Sure, we can put on th
* Peter Eisentraut <[EMAIL PROTECTED]> [010805 14:51]:
> Tom Lane writes:
>
> > Just moments after writing that, I was startled to read on another
> > mailing list that the long-mythical Autoconf 2.50 is released!
>
> Last I checked 2.51 was also released. AC 2.50 had some quality issues in
> m
John Gray writes:
> Is it OK just to link the .so of my backend function against the expat
> library? i.e. to do
>
> gcc -shared -lexpat -o pgxml.so pgxml.o
>
> as the link stage (it seems to work fine) -or is there a portability
> problem with this?
On some platforms the dynamic loader will hav
mlw wrote:
>
> Hiroshi Inoue wrote:
> >
> > The analog of ROWID in PostgreSQL is TID rather than OID
> > because TID is a physical address of a tuple within a table.
> > However there's a significant difference. Unfortunately TID
> > is transient. It is changed by UPDATE and VACUUM.
> > Though TI
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> I have had an idea how the LIKE optimization problem could be solved.
Hmm ... so in a non-ASCII locale, we'd have to look for an index on
strxfrm(A) rather than directly on A. And the index would need to
use a nonstandard operator set --- ie, *non*
I have had an idea how the LIKE optimization problem could be solved.
The problem was that given the expression
A LIKE (P || '%')
where A is a column reference and P is a constant not containing
wildcards, we wanted to find X and Y such that
X <= A and A <= Y
where X and Y are calculat
Tom Lane wrote:
>
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Just out of curiosity - does CLUSTER currently "practically rebuild
> > a tables representation" ?
>
> CLUSTER currently *loses* most of a table's representation :-(.
> It needs work.
The easiest implememntaion of CLUSTER seems t
Tom Lane wrote:
>
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > Just out of curiosity - does CLUSTER currently "practically rebuild
> > a tables representation" ?
>
> CLUSTER currently *loses* most of a table's representation :-(.
> It needs work.
at least \h CLUSTER in psql seems to imply th
Tom Lane wrote:
>
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> The complaints about WAL size amount to "we don't have the disk space
> >> to keep track of this, for long-running transactions". If it doesn't
> >> fit on disk, how likely is it that it will fit in memory?
>
> > Sure, we can pu
Peter Eisentraut <[EMAIL PROTECTED]> writes:
>> Well, we need to talk about that. I like your idea of making ident auth
>> "just work" on local connections better than Oliver's approach of
>> inventing a separate auth-type keyword.
> This is exactly what I would not like to see. "ident" defines
Tom Lane writes:
> Yes. Peter noticed and fixed that typo in the fe-connect.c original a
> few weeks ago --- but it looks like he forgot to update de.po to match.
> I've committed the change to CVS. Thanks!
Please, do not feel obligated to propogate every message fix to every po
file immediate
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Last I checked 2.51 was also released. AC 2.50 had some quality issues in
> my mind which were probably fixed by now. If we see a need we can update;
> I suppose it depends on the release schedule. (Note that some non-trivial
> patches will be need
> Some of you got bounces over the last two weeks. I did't get any email.
> Is there a way to have the messages of mailing list L between dates X and
> Y have sent to me with a majordomo command?
echo "help" | mail [EMAIL PROTECTED]
--
Sean Chittenden
PGP signature
Some of you got bounces over the last two weeks. I did't get any email.
Is there a way to have the messages of mailing list L between dates X and
Y have sent to me with a majordomo command?
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---
Tom Lane writes:
> Well, we need to talk about that. I like your idea of making ident auth
> "just work" on local connections better than Oliver's approach of
> inventing a separate auth-type keyword.
This is exactly what I would not like to see. "ident" defines a specific
protocol, with an id
Tom Lane writes:
> Just moments after writing that, I was startled to read on another
> mailing list that the long-mythical Autoconf 2.50 is released!
Last I checked 2.51 was also released. AC 2.50 had some quality issues in
my mind which were probably fixed by now. If we see a need we can upd
Larry Rosenman writes:
> I believe Caldera has submitted changes to the autoconf people to
> update config/config.guess to support OpenUNIX 8.
For one thing, the autoconf people don't maintain config.{guess,sub}.
(They don't much care for this confusion either.) Updates should be
obtained from
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> The complaints about WAL size amount to "we don't have the disk space
> >> to keep track of this, for long-running transactions". If it doesn't
> >> fit on disk, how likely is it that it will fit in memory?
>
> > Sure, we can put on the disk if th
BigWhat.com writes:
> ld: 0711-317 ERROR: Undefined symbol: .log
> ld: 0711-317 ERROR: Undefined symbol: .ceil
> ld: 0711-317 ERROR: Undefined symbol: .sqrt
[...]
Looks like configure failed to notice your math library (-lm). Please
check the config.log file to see why.
> ld: 0711-345 Use the
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> The complaints about WAL size amount to "we don't have the disk space
>> to keep track of this, for long-running transactions". If it doesn't
>> fit on disk, how likely is it that it will fit in memory?
> Sure, we can put on the disk if that is better
Hannu Krosing <[EMAIL PROTECTED]> writes:
> Just out of curiosity - does CLUSTER currently "practically rebuild
> a tables representation" ?
CLUSTER currently *loses* most of a table's representation :-(.
It needs work.
But since the whole point of CLUSTER is to physically rearrange the
tuples o
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > My idea is that we not put UNDO information into WAL but keep a List of
> > rel ids / tuple ids in the memory of each backend and do the undo inside
> > the backend.
>
> The complaints about WAL size amount to "we don't have the disk space
> to keep
Tom Lane wrote:
>
> mlw <[EMAIL PROTECTED]> writes:
> > ... people looked at me like I had two heads when I told them about
> > "vacuum." It wasn't obvious to them what it did.
>
> I won't dispute that, but changing a command name that's been around for
> ten or fifteen years strikes me as a rec
Bruce Momjian wrote:
>
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > >> Not necessarily. Concurrent VACUUM does truncate the relation if it can
> > >> do so conveniently --- for example, it will successfully reclaim space
> > >> if you do "DELETE FROM foo; VACUUM foo;". It just doesn't try
Hiroshi Inoue wrote:
>
> The analog of ROWID in PostgreSQL is TID rather than OID
> because TID is a physical address of a tuple within a table.
> However there's a significant difference. Unfortunately TID
> is transient. It is changed by UPDATE and VACUUM.
> Though TIDs are unavailable for cri
Bruce Momjian <[EMAIL PROTECTED]> writes:
> My idea is that we not put UNDO information into WAL but keep a List of
> rel ids / tuple ids in the memory of each backend and do the undo inside
> the backend.
The complaints about WAL size amount to "we don't have the disk space
to keep track of this
The analog of ROWID in PostgreSQL is TID rather than OID
because TID is a physical address of a tuple within a table.
However there's a significant difference. Unfortunately TID
is transient. It is changed by UPDATE and VACUUM.
Though TIDs are unavailable for critical use, OIDs could
compensate t
Tom Lane wrote:
>
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > I keep bugging Jan about it, since pre-7.1 and no one has come up with
> > an idea.
>
> Well, if you want an idea:
>
> BEGIN;
>
> SELECT open_toast_object(toastable_column) FROM tab WHERE ...;
>
> -- app
Bruce Momjian wrote:
>
> > Bruce Momjian <[EMAIL PROTECTED]> writes:
> > > I agree we should have it, but I thought the problem was that we
> > > couldn't come up with an API that worked.
> >
> > AFAIR, no one's really tried yet. I do not recall any proposals
> > getting shot down ...
>
> I kee
36 matches
Mail list logo
