ackups.
By my reading, GNU tar handles larger files and no-one else (not even a
POSIX standard tar) can...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you
will try again.
I wonder if you've fixed it but looking at the source it references an
external JS file at http://js-kit.com/comments.js, maybe some security
thing? It appears to work by fetch automatically generated JS files
from the server to execute.
Have a nice day,
--
Martijn van
s but in the end we decided
it was more important to have the display not messed up than displaying
tabs as is.
The other alternative is to convert tabs to spaces on output. Can't
remember why we didn't do that.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]&
this ALTER command will effectively
> rewrite the whole table (to add new not null column).
ISTM a while back someone adding a patch that made the above almost
instantaneous. Probably remembering wrong though.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kle
n seconds to calculate the plans
using it? I think Tom pointed there are a few places that are O(n^2)
the number entries...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> bo
xpect anything from the server
during transmission.
That's why I was wondering about the rows per packet. Sending bigger
packets reduces overall overhead.
(The malloc/free per row doesn't seem too efficient.)
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]>
a single text object with the two leading characters
signifying something?
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
all the ECPG
errors so the developers could fix them. Looking at the latest results
it has a lot of warnings about dead-code in libstemmer, which is not
entirely surprising given that it's generated code.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svan
> underlying buffering between the protocol (which always sends one
> message per row) and libpq (which is one call per row)? It seems
> possible for us to request a number of rows from the server up to a
> preferred total transfer size.
AIUI the server merely streams the rows to
here are systems that have broken 64-integer
support. Or at least, that's the theory. There was a question recently
to check if there really are such systems still running...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who
here...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
---(end of broadcast)---
TIP
ice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
her languages can do
it is because they are typed at run-time, not compile time.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
omments, and has stable URLs for every email message? Is there
> software I can install on my server to do this?
debbugs? *duck*
Personally I like trac for its simplicity. You can add comments and
post patches and track status. Which seems more than enough for what we
do.
Have a nice day,
akes effect?
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
nning database.
> I think DBA would need to set maximum shared buffers size
> along the normal setting.
Shared memory segments can't be resized... There's not even a kernel
API to do it.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/k
27;t think it would meet the standard definition then. The statement
shouldn't be able to to see the effects of itself...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent
t was
designed for: banking on the fact that 99% of the time, that space
isn't written to. Overcommit is precisely what makes forking as cheap
as threads.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolu
s actually taking
the time.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
.
It would mostly be a win for comparing strings since you then don't
need to lookup the collation tables as often.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revol
nother context it's common to suffix it with a _P
(the P stands for something but I forget what. Predicate?). That way
you don't run into unexpected surprises when it compiles with other
headers...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org
s that
got affected, presumably by NEW representing a tuplestore. How that
would work for BEFORE STATEMENT triggers I don't know.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will mak
can get the timings without this
> overhead?
\timing iirc.
Inside psql, check the help.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
&g
oes seem a bit
wierd to support one but not the other. It's also interesting to note
that the implementation in the backed is commented with:
> I do not expect this file to be used for general purpose MD5'ing of
> large amounts of data, only for generating hashed passwords fro
tead of a socket is OK, sockets
are connected to, not opened. Trying to open it normally produces the
error: No such device or address.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make vi
ing materialised
views on postgres already. It is however a completely orthoginal
problem. Someone needs to write the code to maintain such a view before
you can even think about working on the planner.
However, step 1 would be to get them onto the TODO list.
Have a nice day,
--
Martijn van Ooste
esome idea.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
works by using
strace to check the data it's sending.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
ny reason seems
wrong.
- Temporarily disabling triggers/indexes/constraints, if the system
aborts/crashes, the triggers are reinstated automatically.
- Just general niceity of being able to test schema changes without
immediatly changing the system.
There are many more...
Have a nice day,
--
Martijn van
ottom up (the split
and insert is a single operation), so I don't think you can actually
combine the current split algorithm with the logging operation I
suggest above.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make p
ain shouldn't we say b-tree with user-defined op-classes as gist-btree? If
> not what is the difference between both?
gist-btree is a nice example but IIRC it takes more diskspace and can't
handle uniqueness.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]&g
On Wed, Jan 02, 2008 at 04:04:48PM +0530, Gokulakannan Somasundaram wrote:
> On Jan 2, 2008 3:35 PM, Martijn van Oosterhout <[EMAIL PROTECTED]> wrote:
> > If the goal is to only store the insert, then we need to determine
> > during recovery which page the record needs to be
y which page the record needs to be added to. To do this
you need to go through the index, which can only be done by calling
user-defined functions.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossi
l the data.
The only thing I'm not sure about is whether it's easy to get the
relevent inforation to make this efficient.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violen
ls. Very low cost, quick setup
solution.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
sabled
Set automatic startup behaviour in start.conf (default: 'auto')
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
y that software distribution time is not the place
> for such restrictions.
Nothing is being prevented here. Things are being made possible that
are otherwise difficult.
Have a niec day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peace
, since only postmasters owned by "postgres" can create a
socket in that directory, any client attempting to connect to a server
using that directory knows it's connecting to a server owned by
'postgres'.
I can't think of any non-libpq clients which support Unix domain
and table format as input and creates an ascii dump
> (similar to pgdump).
Yes, I wrote a program called pgfsck years ago which did this. Not for
all data types, but most of the common ones. I'm in the process up
upgrading it work with the latest versions.
Have a nice day,
--
Martijn van Oo
s about how to work out
optimal thread/memory/datasize ratios.
The way around this is a NUMA architecture, but that's a whole
other ball of wax.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible
) the proper way to get a translatable string in like that, or is
> there a better way?
Hmm, from a translation point of view wouldn't it be better to have the
word "violation" inside each of the _(), since not all languages might
allow such substitions (gender problems).
Have a ni
uot; it. You don't have to
use the ecxt_* fields at all, for example, the ExecAppend node. It's
just convenient to reuse fields that are used for a common purpose.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful
On Tue, Dec 18, 2007 at 09:32:51AM -0300, Alvaro Herrera wrote:
> Martijn van Oosterhout wrote:
> > On Mon, Dec 17, 2007 at 01:48:31PM +, Alvaro Herrera wrote:
> > > Log Message:
> > > ---
> > > Improve wording.
>
> I agree that the paren
ence
between 256MB and 1G shared memory, I'd say you're better off using the
smaller amount so you can have higher maintainence work mem.
VACUUM doesn't benefit much from lots of shared buffers, but it does
benefit from maint workmem.
Have a nice day,
--
Martijn van Oosterhout
antly lower (24 MB, I believe). I'll try with 128 MB
> before I leave in the evening, though (assuming the other tests I'm
> running complete by then).
What you want is a reasonable shared mem, maybe 0.5GB and a smaller
maintainence workmem since the letter is probably what's
arn't portable. Just guessing...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
do the conversion straight away,
but at least you don't need to guess the type anymore.
Hope this helps,
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
o select the collation on a per
database/table/column level (SQL complaince requires this).
This has nothing to do with C by the way. C has many features that
allow you to work with different encodings. It just doesn't force you
to use any particular one.
Have a nice day,
--
Martijn van O
doing it this way. Users need
to type the password in the same encoding it was added. It not usually
a big deal because people set their own passwords...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impo
It seems it would be more user-friendly if the message
was displayed (just as for unix) rather than the code.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> i
ord. The
correctly entered password in the wrong encoding is also wrong, because
the matching is done at the byte level.
So I suppose the answer is: whatever encoding you would like it to
be/what the DB admin uses.
This is all AIUI,
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTE
at least there it's
not true.
http://gcc.gnu.org/ml/gcc-patches/2005-12/msg01518.html
Hope this helps,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
>
On Wed, Nov 14, 2007 at 10:25:23PM +0100, Peter Eisentraut wrote:
> Martijn van Oosterhout wrote:
> > To be honest I think that psql shouldn't be ignoring the
> > EISDIR error the kernel is returning.
>
> We use fopen(), which doesn't appear to pass that on.
It
#x27;t ignore other
errors, like EIO or EPIPE,
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
f a_pipe?)
Sure, why not. To be honest I think that psql shouldn't be ignoring the
EISDIR error the kernel is returning.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent
unction
> is executed.
What kind of problems? The encoding is done by psql, just before
display. They're not stored like that in the DB. Can you be more
specific as to the problems?
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those
gt; again...
AIUI LIKE is mashed into an operator at parse time, so yes, if you
create the operator with the right name it will just work.
Or not (I havn't tested it).
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make pea
like this?
>
> SELECT * FROM text_table
> WHERE text_search('haystack needle haystack', 'needle');
Can't you do this with an SQL function that gets expanded inline?
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/klep
es, if
you have a recent enough version, or do you mean something else?
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
ot sure you're saving anything here. Or am I
missing something?
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution
> inevitable.
> -- John F Kennedy
signature.asc
Description: Digital signature
also be cleaned, you have to lock all the pages to make sure the change
is atomic...
As soon as you have to lock more than one page, deadlocks become a
problem.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution
down 100 pages? Because then it gets very
expensive. Not to mention the locking considerations. Better keep it
simple.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolu
d adds one more feature under the umbrella of postgres.
I'm still confused. Why on earth would you want to run a query against
an old snapshot? If you want a stable view, I'd think of opening a
cursor or using a temporary table. And where does serializable come
into this?
Have a
ssed to this
> function from the parser/gram.c?
AIUI, if there are RULEs on a table, you can get multiple queries as
the result of a single request.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each acc
e most useful feature IMHO would be if the installed modules could be
recognised as a block (using pg_depends) so that:
1. pg_dump can see them and emit only INSTALL
2. Uninstall removes everything that was installed
This only covers installtion though, not building or compiling.
Have a nice day,
n other CPUs.
I think relibility becomes the real issue though, you can always
produce the wrong answer instantly, the trick is to get the right
one...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To e
On Thu, Oct 25, 2007 at 01:49:57PM +0200, Hubert FONGARNAND wrote:
> Another question : does this TOAST code works for all type of data, like
> TEXT (in our case)
Yes.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each a
back (>1 year) can I use this to manage the bitrot? Just doing a CVS
update will probably just mark everything conflicted, so I'm wondering
is GIT can do it better.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to
back to improve it. If we can fix the disparity I think
most of the problems will go away...
Ofcourse, posting just prior FF doesn't help, but I think that's a
chicken/egg problem. People do what works.
Have a ncie day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana
x27;re actually interested in.
Have a ncie day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
of an index
> to file index.c for example?
> Thank,
Are you correctly attaching the debugger to the child (and not just the
postmaster).
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each
ecall it was *really* slow, not just a little
bit.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
ly available.
Perhaps we should fix that problem, rather than making more
workarounds.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
indexes etc...
The standard does have stuff relating to extracting samples from
tables, but they're not implemented.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his abili
unpunctual for their appointments.
For both money and timestamps the taggedtypes module provides exactly
what you want. It stores the timezone/currency as entered and displays
that when output. Sometimes that's what you want, sometimes it's not.
Have a nice day,
--
Martijn van Oosterho
On Thu, Sep 27, 2007 at 01:07:33PM -0400, Tom Lane wrote:
> Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> > The original patch for controlling the export list on Linux included
> > support for symbol versioning. Eventually a version of the export.list
> > control
r
some reason, don't remember why).
In any case, to add it now for linux would be a one-line change.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
milar workaround for postgres too, but it's a hack, it
won't work in the general case.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
his problem don't come up too
often.
It's been on the TODO list for at least 5 years...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
text string.
Languages like perl distinguish between "encode" which is text->bytea
and "decode" which is bytea->text. We've got "convert" for oth and that
causes problems.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svan
oes
show there are other ways to deal with this.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
pposed).
Oh, the last discussion on this didn't answer this question. Is there a
standard somewhere that maps integers to characters in EUC-JP. If so,
how can I find out what character 512 is?
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
&g
way of dealing with that. It's
not just going to happen a lot, it is going to be common, even for
unique indexes.
Presumably HOT will help with this, but that relies on all index columns
not to change.
The major benenfits will mostly come from not storing the key at all. I
think.
Ha
a cache would make any useful difference.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
what you are protecting against, then you can get some more
useful answers.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
almost unlimited key size yet flexible
matching... (combined with other index, or even just the same index).
Neat.
Have a nice day,
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> liti
On Fri, Aug 17, 2007 at 10:42:09AM -0400, Tom Lane wrote:
> Martijn van Oosterhout <[EMAIL PROTECTED]> writes:
> > I'm unsure how it works now, but it seems reasonable that when a
> > regclass/regtype/regetc is passed to a trigger, pass it in OID form.
>
>
cking dependancies.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
cient than the current method is another question
entirely.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
h. An fsync will
make the OS write everything ASAP.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
t for the case of changes in built-in
> types.
Well, it seems to me 99% of cases can be handled easily, we just might
have to have a backup method for the cases where the simple cases
doesn't work...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org
e will even work with the new version. Seems like
too much work considering REINDEX will simply fix the problem outright.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
ly if the index is on a datatype
that has changed format... I suppose those indexes will just have to be
rebuilt (a REINDEX will upgrade every page in the table anyway...). I
think it'd still be cheaper than dump/restore.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]>
n the page telling you if it's
upgraded or not?
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
64-bit architecture. However,
variable-length values are always byref.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
ing the number of bytes, or negative for variable length.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
resolution, and it allows to
continue a sleep that has been interrupted by a signal more
easily.
But I don't know if that would help on your HPUX box though...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each accordi
easier is to write a stored proc that you use like so:
SELECT promote_supplier( article, supplier );
No trigger necessary...
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
index on the result of combining the points. It does
mean you need to use the same syntax when doing the queries, but it
works with modifying any internal code at all...
Given you can use rowtypes more easily these days, it's quite possible
you use build an operator class on a row type...
er defined typmod" and I don't beleive any
released version has it, but it will be in the next release.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to
> litigate.
signature.asc
Description: Digital signature
401 - 500 of 1587 matches
Mail list logo