What is the translation stats on
http://webmail.postgresql.org/~petere/nls.php
based on? I've not updated my translation in a long time (since 7.3.0)
and it's still at 100% (except the big file that wasn't 100% before).
Seems strange that there havn't been any new or changed strings since
t
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
>>> Is there a way to make our way around the pages ?
>>
>> If the header is corrupt, I don't think so.
> What I asked is how to read all other sane pages.
Oh, I see. You can do "SELECT ...
Tom Lane wrote:
(B>
(B> Hiroshi Inoue <[EMAIL PROTECTED]> writes:
(B> > Tom Lane wrote:
(B> >> I'm thinking of modifying ReadBuffer() so that it errors out if the
(B>
(B> > What does the *error out* mean ?
(B>
(B> Mark the buffer as having an I/O error and then elog(ERROR).
(B>
(B> >
> > > > So if you do this, do you still need to store that information in
> > > > pg_control at all?
> >
> > Yes: to "speeds up the recovery process".
>
> If it's going to slow down the performance of my database when not doing
> recovery (because I have to write two files for every transaction,
>
I am leaving in 36 hours for another trip, this time to China and Japan.
I will have connectivity in both countries, but I am not sure how much
free time I will have.
I have no public speaking events on this trip, just meetings with
companies using PostgreSQL in Asia. I will return March 4.
I sh
Patch applied. Thanks.
---
Teodor Sigaev wrote:
> Please apply patches for contrib/ltree.
>
> ltree_73.patch.gz - for 7.3 :
> Fix ~ operation bug: eg '1.1.1' ~ '*.1'
>
> ltree_74.patch.gz - for current CVS
> Fi
Patch applied. Thanks.
---
Oleg Bartunov wrote:
> Bruce,
>
> we just released new version of contrib/btree_gist
> (7.3 and current CVS) with support of int8, float4, float8
> in addition to int4. Thanks Janko Richter for
Christopher Kings-Lynne wrote:
>
>*sigh* It's just like a standard to come up with a totally new syntax for a
>feature that no-one has except MySQL who use a different syntax :)
You sure? :)
http://otn.oracle.com/products/oracle9i/daily/Aug24.html
MERGE INTO SALES_FACT D
USING SALES_JUL
On Tue, 2003-02-18 at 21:43, mlw wrote:
> This patch enables PostgreSQL to be far more flexible in
> its configuration methodology.
Without weighing in on the configuration debate, one thing this patch
definitely needs to do is update the documentation.
Cheers,
Neil
--
Neil Conway <[EMAIL PROTE
I have a new idea. You know how we have search_path where you can
specify multiple schema names. What if we allow the config_dirs/-C to
specify multiple directories to search for config files. That way, we
can use only one variable, and we can allow people to place different
config files in dif
On Tue, 18 Feb 2003, Mikheev, Vadim wrote:
> > > So if you do this, do you still need to store that information in
> > > pg_control at all?
>
> Yes: to "speeds up the recovery process".
If it's going to slow down the performance of my database when not doing
recovery (because I have to write two
PostgreSQL Extended Configuration Patch
Mohawk Software, 2003
This patch enables PostgreSQL to be far more flexible in
its configuration methodology.
Specifically, It adds two more command line parameters, "-C"
which specifies either the location of the postgres
configuration file or a directory co
Bruce Badger wrote:
There have been a number of people comment on how PostgreSQL performs as
a StORE repository - some good comments, some not so good. Either way,
given the varied use of StORE, the feedback may yield valuable
information.
The place to look for feedback from StORE users is the
URL added to develepers FAQ.
---
Peter Eisentraut wrote:
> Hannu Krosing writes:
>
> > Where is this upcoming standard available on net ?
>
> Near ftp://sqlstandards.org/SC32/WG3/Progression_Documents/FCD
>
> --
> Peter
> > REPLACE INTO anyone? ;)
>
> The upcoming SQL 200x standard includes a MERGE command that appears to
> fulfill that purpose.
Is there somewhere that I can read that spec?
Or can you just post the MERGE syntax for us?
*sigh* It's just like a standard to come up with a totally new syntax for a
I use a version control system called StORE which uses a relational
database as it's back end. I use StORE with PostgreSQL, others use it
with DB2, Oracle, etc
I mention StORE here because it struck me that it may be a useful source
of real-world information about how PostgreSQL performs rel
Ross J. Reedstrom wrote:
> On Wed, Feb 19, 2003 at 12:03:44AM +0100, Peter Eisentraut wrote:
> > Ross J. Reedstrom writes:
> >
> > > Yes, BSD systems that install libedit directly in /usr/include (or into
> > > readline), like Patrick's, don't need it, but mine do. Is there some
> > > reason we _
Andrew Sullivan <[EMAIL PROTECTED]> writes:
> On Mon, Feb 17, 2003 at 05:42:21PM -0500, Tom Lane wrote:
>> The mechanism I described in the above-referenced message only occurs
>> for nailed-in-cache system tables. Given Daniels' report (and one or
> And for ones that have been truncated? I foun
Hiroshi Inoue <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> I'm thinking of modifying ReadBuffer() so that it errors out if the
> What does the *error out* mean ?
Mark the buffer as having an I/O error and then elog(ERROR).
> Is there a way to make our way around the pages ?
If the header is
Tom Lane wrote:
(B>
(B> Postgres has a bad habit of becoming very confused if the page header of
(B> a page on disk has become corrupted. In particular, bogus values in the
(B> pd_lower field tend to make it look like there are many more tuples than
(B> there really are, and of course these
Hannu Krosing writes:
> Where is this upcoming standard available on net ?
Near ftp://sqlstandards.org/SC32/WG3/Progression_Documents/FCD
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands
Ross J. Reedstrom writes:
> Yes, BSD systems that install libedit directly in /usr/include (or into
> readline), like Patrick's, don't need it, but mine do. Is there some
> reason we _shouldn't_ support this configuration?
I don't like adding code to support every configuration that someone
drea
On Mon, Feb 17, 2003 at 05:42:21PM -0500, Tom Lane wrote:
> Andrew Sullivan <[EMAIL PROTECTED]> writes:
> > On Thu, Feb 13, 2003 at 03:27:01PM +1000, Paul L Daniels wrote:
>
> > http://archives.postgresql.org/pgsql-hackers/2002-11/msg00486.php
>
> The mechanism I described in the above-referenced
Peter Eisentraut kirjutas T, 18.02.2003 kell 21:02:
> Christopher Kings-Lynne writes:
>
> > REPLACE INTO anyone? ;)
>
> The upcoming SQL 200x standard includes a MERGE command that appears to
> fulfill that purpose.
Where is this upcoming standard available on net ?
Hannu
---
The proclock is structure links locks and procs, either for locks held,
or procs waiting for locks.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can b
I received this in my inbox, can anyone comment on it
-Forwarded Message-
From: Felipe Schnack <[EMAIL PROTECTED]>
Subject: [JDBC] 7.3.2 psql error!
Date: 18 Feb 2003 15:54:29 -0300
I just compiled psql version 7.3.2 in a redhat 7.3 box and I get this
error:
psql: /lib/i686/libc.so.
if pgproc is used to represent a process and proclock represents a process and its locks of interest, then why does pgproc contain the following information about locks?
/*
* XLOG location of first XLOG record written by this backend's
* current transaction. If backend is not in a transaction or h
On Mon, 2003-02-17 at 22:04, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > On Mon, 17 Feb 2003, Tom Lane wrote:
> >> Postgres has a bad habit of becoming very confused if the page header of
> >> a page on disk has become corrupted.
>
> > What typically causes this corruption?
>
>
> > > Added to TODO:
> > >
> > > * Allow WAL information to recover corrupted pg_controldata
> > >...
> > > > Using pg_control to get the checkpoint position
> speeds up the
> > > > recovery process, but to handle possible
> corruption of pg_control,
> > > > we should actually im
Uh, not sure. Does it guard against corrupt WAL records?
---
Curt Sampson wrote:
> On Tue, 18 Feb 2003, Bruce Momjian wrote:
>
> >
> > Added to TODO:
> >
> > * Allow WAL information to recover corrupted pg_controldata
FWIW, that's the approach O*'s taking.
http://otn.oracle.com/products/oracle9i/daily/Aug24.html
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Peter Eisentraut
Sent: Tuesday, February 18, 2003 11:02 AM
To: Christopher Kings-Lynne
Cc: Tom Lane; Hackers
Su
Martin Matusiak writes:
> I am doing a project for college developing a java system utilizing a
> RDBMS. The choice is between PostgreSQL and Oracle and I'm wondering
> exactly how impossible would it be to make it compatible with both.
I tried to do something like that recently and the way Oracl
Christopher Kings-Lynne writes:
> REPLACE INTO anyone? ;)
The upcoming SQL 200x standard includes a MERGE command that appears to
fulfill that purpose.
--
Peter Eisentraut [EMAIL PROTECTED]
---(end of broadcast)---
TIP 6: Have you searched our
Consider the following query on a large table with lots of different
`id's:
SELECT id FROM my_table GROUP BY id ORDER BY count(id) LIMIT 10;
It has an (usually unique) index on id. Obviously, the index helps to
evaluate count(id) for a given value of id, but count()s for all the
`id's shoul
Hi all,
Also need add function, returned GetSessionUserId() too.
On 7 Feb 2003, Dr. Ernst Molitor wrote:
DEM>record offers saving a few bytes per record, so I wrote a _very small_
DEM>add-on to directly access the usesysid information, using the function
DEM>GetUserId().
--
Olleg Samoylov
--
On Mon, Feb 17, 2003 at 12:05:20AM +0100, Peter Eisentraut wrote:
> Ross J. Reedstrom writes:
>
> I don't think this is what we were out for. We've certainly been running
> with libedit for a long time without anyone ever mentioning
> /usr/include/editline. I suggest this part is taken out.
Wel
On Sat, Feb 15, 2003 at 03:10:19PM -0600, Ross J. Reedstrom wrote:
> On Fri, Feb 14, 2003 at 11:32:02AM -0500, Tom Lane wrote:
> > Patrick Welche <[EMAIL PROTECTED]> writes:
> > > On Thu, Feb 13, 2003 at 10:25:52AM -0500, Tom Lane wrote:
> > >> Well, is that a bug in your wrapper? Or must we add a
On Tue, 18 Feb 2003, Gavin Sherry wrote:
GS>Perhaps the change that needs to be made is:
GS>
GS>if(IsUnderPostmaster)
GS> elog(ERROR,"You cannot run REINDEX INDEX in multi-user mode");
GS>
GS>to ReindexIndex() or some other appropriate place (with a better error
GS>message).
GS>
GS>Gavin
It i
Hello.
I am a student of Tuiuti University and I want to develop a
project with PostgreSQL.
My idea is to create clients for PostgreSQL that receive
messages from the "server"(PostgreSQL) according to events
occured into the database.
At this point I just tought that these events could be like
tri
Ryan,
I am crossing this discussion to the PGSQL-PERFORMANCE list, which is the
proper place for it. Anyone interested, please follow us there!
>>>Ryan Bradetich said:
> the table would look like:
> 1 | Mon Feb 17 00:34:24 MST 2003 | p101 | user x has an invalid shell.
> 1 | Mon Feb 17 00:3
On Sat, 15 Feb 2003, Curt Sampson wrote:
> On Fri, 14 Feb 2003, scott.marlowe wrote:
>
> > Asking for everything in a directory with the name local in it to be
> > shared is kind of counter intuitive to me.
>
> Not really. If you install a particular program that doesn't come with
> the OS on on
Tom Lane kirjutas T, 18.02.2003 kell 17:21:
> Kevin Brown <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> The cases I've been able to study look like the header and a lot of the
> >> following page data have been overwritten with garbage --- when it made
> >> any sense at all, it looked like t
Hi guys,
There seems to be quite a laundry list of things which have to be
patched or otherwise massaged in order to get a cygwin build. Did these
get fixed before 7.3.2 rolled out the door?
Paul
Original Message
Subject: [postgis-users] Postgis-0.7.4 + PSQL-7.3.1- installati
Hi everyone,
Just looked on the IBM website for info relating to shared memory and
IPC limits in AIX, and found a few useful-looking documents:
The Interprocess Communication (IPC) Overview
http://www-1.ibm.com/support/docview.wss?rs=0&context=SWG10&q=shmget&uid=aix15f11dd1d98f3551f85256816006a0
Kevin Brown <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> The cases I've been able to study look like the header and a lot of the
>> following page data have been overwritten with garbage --- when it made
>> any sense at all, it looked like the contents of non-Postgres files (eg,
>> plain text),
> On Tue, Feb 18, 2003 at 13:13:30 +0100,
> Christoph Haller <[EMAIL PROTECTED]> wrote:
> > > >
> > > > Moreover, are there any ANSI standards for this kind of thing? Or
> > each one
> > > > to his own?
>
> Based on discussions in the past that I have loosely followed, I believe
> there is some k
> tom lane wrote:
> > Hm. A single lock that must be grabbed for operations anywhere in
> > the index is a concurrency bottleneck.
I replied a bit later:
> I don't think it would be that bad. It's not a lock but a
> mutex that would only be held for relatively brief duration.
> It looks like
On Tue, Feb 18, 2003 at 13:13:30 +0100,
Christoph Haller <[EMAIL PROTECTED]> wrote:
> > >
> > > Moreover, are there any ANSI standards for this kind of thing? Or
> each one
> > > to his own?
Based on discussions in the past that I have loosely followed, I believe
there is some kind of standard a
On Tue, Feb 18, 2003 at 10:26:46 +0600,
Anuradha Ratnaweera <[EMAIL PROTECTED]> wrote:
>
> My 3rd attempt to post ...
>
> Consider this query on a large table with lots of different IDs:
>
> SELECT id FROM my_table GROUP BY id ORDER BY count(id) LIMIT 10;
>
> It has an index on id. Obvio
> >
> > I was wondering what kind of functions/constants exist in Postgre to
dig
> up
> > metadata. I barely scratched the surface of Oracle but I know you
find
> > things like user_tables there that can be used to extract info about
your
> > tables. What I'm looking for is some kind of functions t
>
> Consider this query on a large table with lots of different IDs:
>
> SELECT id FROM my_table GROUP BY id ORDER BY count(id) LIMIT 10;
>
> It has an index on id. Obviously, the index helps to evaluate
count(id)
> for a given value of id, but count()s for all the `id's should be
> evaluated,
Tom Lane wrote:
> The cases I've been able to study look like the header and a lot of the
> following page data have been overwritten with garbage --- when it made
> any sense at all, it looked like the contents of non-Postgres files (eg,
> plain text), which is why I mentioned the possibility of d
52 matches
Mail list logo
