I wrote:
> I noticed this problem in 8.2 and 8.3:
>
> pei=# select mod( trunc( 1 ), 2 );
> ERROR: 42883: function mod(double precision, integer) does not exist
> LINE 1: select mod( trunc( 1 ), 2 );
>^
I suppose there will be little interest in including the obvious solution,
nam
Jeff Davis wrote:
On Mon, 2007-11-05 at 22:45 +, Heikki Linnakangas wrote:
1) Do as you say above. What are some of the cost trade-offs here? It
seems that frequent VACUUM FREEZE runs would keep the visibility map
mostly full, but will also cause more writing. I suppose the worst case
is tha
Peter Eisentraut wrote:
I wrote:
I noticed this problem in 8.2 and 8.3:
pei=# select mod( trunc( 1 ), 2 );
ERROR: 42883: function mod(double precision, integer) does not exist
LINE 1: select mod( trunc( 1 ), 2 );
^
I suppose there will be little interest in including the obvio
Josh,
did you try to set XML2_CONFIG prior to ./configure?
I _am_ on Mac OS X 10.4.10, and using (in my particular case)
$ export XML2_CONFIG=/usr/local/bin/xml2-config
as well as
--with-libraries=/usr/lib/:/usr/local/lib/
--with-includes=/usr/include/:/usr/local/include/
seems to wor
Peter Eisentraut wrote:
> Am Mittwoch, 7. November 2007 schrieb Heikki Linnakangas:
> > Peter Eisentraut wrote:
> > > I wrote:
> > >> I noticed this problem in 8.2 and 8.3:
> > >>
> > >> pei=# select mod( trunc( 1 ), 2 );
> > >> ERROR: 42883: function mod(double precision, integer) does not exist
Gregory Stark wrote:
>
> "Brendan Jurd" <[EMAIL PROTECTED]> writes:
>
> > They are clear, useful and easy to understand.
> >
> > [1] http://www.python.org/dev/peps/pep-0007/
> > [2] http://www.python.org/dev/peps/pep-0008/
>
> I didn't look at the second but the first at least is a good example
>>> On Tue, Nov 6, 2007 at 8:18 AM, in message <[EMAIL PROTECTED]>,
Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
> The indexam API needs to be modified as well, because there's currently
> no API to return index tuples from an index.
I know this is tangential, but expanding the types of sel
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> Am Mittwoch, 7. November 2007 schrieb Heikki Linnakangas:
>> Why would you run a query like that in the first place? It seems like a
>> useless query as it is. Is there a bigger story behind it?
> The "1" is substituted from somewhere else.
Seems lik
On 11/8/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> The problem is that a full list would be harder to understand than just
> looking at the existing code and following it, or taking suggestions
> from us as we review the patch.
>
What makes you say it would be necessarily harder to understand?
On Wed, 7 Nov 2007, Hannu Krosing wrote:
To be really useful, we should always run general system monitoring
alongside DB test runs, so we can see, and also later look up, where the
bottleneck are.
The way the DBT-2 tests run involves spawning off the relevant monitoring
tools (iostat, vmstat
Brendan Jurd wrote:
> On 11/6/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> >
> > I understand your suggestions but it seems there would be too many
> > individual items to be readable. Can you suggest a full list so we can
> > get an idea of how long it would be?
>
> If the body of material on
Marko Kreen wrote:
> On 11/6/07, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> > Alvaro Herrera wrote:
> > > > > Tom, how about putting a note about that into next 8.2 minor
> > > > > release notes? (8.3 too?) Something like "You need to refresh
> > > > > pgcrypto functions, because since rel 8.2 th
Maybe except
--with-tcl
--with-tclconfig=DIRECTORY
although that's not exactly what you were referring to, of course.
Anyway, I think the OS X case could be worth to keep the design question in
mind. Speaking as a not very experienced user of 'make' and friends, I'm
appreciating --with-feat
There are interval * double precision operators (both ways) but none for
interval * numeric. Adding this would make sense since interval is now
optionally stored as fixed-point internally. Any objections to adding this
in 8.4?
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---
"Brendan Jurd" <[EMAIL PROTECTED]> writes:
> They are clear, useful and easy to understand.
>
> [1] http://www.python.org/dev/peps/pep-0007/
> [2] http://www.python.org/dev/peps/pep-0008/
I didn't look at the second but the first at least is a good example of a
style guide which is *not* useful.
Am Mittwoch, 7. November 2007 schrieb Heikki Linnakangas:
> Peter Eisentraut wrote:
> > I wrote:
> >> I noticed this problem in 8.2 and 8.3:
> >>
> >> pei=# select mod( trunc( 1 ), 2 );
> >> ERROR: 42883: function mod(double precision, integer) does not exist
> >> LINE 1: select mod( trunc( 1 ), 2
Stefan Kaltenbrunner wrote:
Hi all!
There will be planned downtime on tribble.postgresql.org Nov 7(tomorrow)
from 11:30-12:00 GMT(estimated) affecting the following services:
cvs.postgresql.org
wwwmaster.postgresql.org
www.pgadmin.org
doxygen.postgresql.org
Downtime is necessary to implement s
Ühel kenal päeval, P, 2007-11-04 kell 13:02, kirjutas Greg Smith:
> On Sat, 3 Nov 2007, Stefan Kaltenbrunner wrote:
>
> > there is the various dbt workloads,sysbench, jans tpc-w implementation,
> > hell even pgbench
>
> The DBT workloads are good for simulating disk-bound operations, but I
> d
Am Dienstag, 25. September 2007 schrieb Simon Riggs:
> > Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > > First log file ID for new XLOG:
> > > First log file segment for new XLOG:
> Perhaps "after reset" would be better than "for new XLOG".
I like this better. I have made the change.
Hi,
It is well known that in some instances the Postgresql will make
estimates of the number of distinct values in a table that can be
quite far off reality. This then has a tendency to make the planner
lean towards unsavory plans (read: seqscans) because it estimates the
number of lines retu
>>> On Wed, Nov 7, 2007 at 3:13 PM, in message
<[EMAIL PROTECTED]>, Heikki Linnakangas
<[EMAIL PROTECTED]> wrote:
> Kevin Grittner wrote:
> On Tue, Nov 6, 2007 at 8:18 AM, in message <[EMAIL PROTECTED]>,
>> Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
>>
>>> The indexam API needs to be m
Hi,
ftp://elsie.nci.nih.gov/pub/tzdata2007i.tar.gz
Per announcement:
"...is now available; this reflects changes for Cuba and Syria
circulated earlier this week on the time zone mailing list.
There are no code changes, so there's no tzcode2007i; tzcood2007h
remains current."
Regards,
--
Devri
Kevin Grittner wrote:
On Tue, Nov 6, 2007 at 8:18 AM, in message <[EMAIL PROTECTED]>,
Heikki Linnakangas <[EMAIL PROTECTED]> wrote:
The indexam API needs to be modified as well, because there's currently
no API to return index tuples from an index.
I know this is tangential, but expanding
Hi,
Regarding the function parameter ref TODO:
I am trying to catch and copy an error to be re-thrown later.
I have the following questions:
1. Is the catch part in the following safe?
2. How do I re-throw the copied error when I am not in ErrorContext anymore?
I cannot use ReThrowError becau
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
> I am writing tsearch2 wrapper and I testing functionality. I found
> some little bit strange on default parser. It can't parse tags with
> numbers:
Well, the state machine definitely thinks that tag names should contain
only ASCII letters (with possibl
Whilst reading http://www.postgresql.org/docs/8.2/interactive/sql-comment.html
I came across this user comment:
Ricardo Bánffy 04 Sep 2007 18:15:44
It is a pretty obvious suggestion I bet was made many, many times
before, but it would be very useful if you
"Gevik Babakhani" <[EMAIL PROTECTED]> writes:
> I am trying to catch and copy an error to be re-thrown later.
This is certainly not the right way to go about solving your problem.
If you need to refactor some of the column lookup routines to make
this patch work, then do so, but don't try to make
CaT <[EMAIL PROTECTED]> writes:
> It is a pretty obvious suggestion I bet was made many, many times
> before, but it would be very useful if you could create comments while
> creating the objects themselves, like
> CREATE TABLE FOO (
>ID INTEGER NOT NULL PRIMARY KEY COMMENT 'The ID',
>VALU
Tom Lane wrote:
"Pavel Stehule" <[EMAIL PROTECTED]> writes:
I am writing tsearch2 wrapper and I testing functionality. I found
some little bit strange on default parser. It can't parse tags with
numbers:
Well, the state machine definitely thinks that tag names should contain
only ASC
On Wed, Nov 07, 2007 at 06:32:53PM -0500, Tom Lane wrote:
> CaT <[EMAIL PROTECTED]> writes:
> > It is a pretty obvious suggestion I bet was made many, many times
> > before, but it would be very useful if you could create comments while
> > creating the objects themselves, like
>
> > CREATE TABLE
Thank you Tom.
I have considered a noError boolean too.
but please considered the following:
step 1: call qualifiedNameToVar(noError = true), which generates an error
but gets suppressed by noError parameter.
step 2: process function parameter name for
funct1.param1, check "funct1" == ,
which
Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Well, the state machine definitely thinks that tag names should contain
only ASCII letters (with possibly a leading or trailing '/'). Given the
HTML examples I suppose we should allow non-first digits too. Is
On Wed, 7 Nov 2007, Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
Well, the state machine definitely thinks that tag names should contain
only ASCII letters (with possibly a leading or trailing '/'). Given the
HTML examples I suppose we should allow non-first digi
Jörg Beyer wrote:
Josh,
did you try to set XML2_CONFIG prior to ./configure?
I _am_ on Mac OS X 10.4.10, and using (in my particular case)
$ export XML2_CONFIG=/usr/local/bin/xml2-config
as well as
--with-libraries=/usr/lib/:/usr/local/lib/
--with-includes=/usr/include/:/usr/local/i
Tom Lane <[EMAIL PROTECTED]> [07-11-2007 05:24]:
> Jeff Davis <[EMAIL PROTECTED]> writes:
>> I agree that a dump/restore from 8.2 with tsearch2 to 8.3 with built-in
>> tsearch should not SIGSEGV.
> That's not what he did, though. Force-feeding contrib/tsearch2 into 8.3
> will not work.
That is wh
CaT wrote:
On Wed, Nov 07, 2007 at 06:32:53PM -0500, Tom Lane wrote:
CaT <[EMAIL PROTECTED]> writes:
It is a pretty obvious suggestion I bet was made many, many times
before, but it would be very useful if you could create comments while
creating the objects themselves, like
CR
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> Well, the state machine definitely thinks that tag names should contain
>> only ASCII letters (with possibly a leading or trailing '/'). Given the
>> HTML examples I suppose we should allow non-first digits too. Is there
>> anything
"Gevik Babakhani" <[EMAIL PROTECTED]> writes:
> I have considered a noError boolean too.
> but please considered the following:
> step 1: call qualifiedNameToVar(noError = true), which generates an error
> but gets suppressed by noError parameter.
> step 2: process function parameter name for
38 matches
Mail list logo
