Hi,
First, I like the way you got back to the needs before trying to
organize an approach to find a solution. Having said it allows me to cut
a lot of your text, it's the one I agree with :)
Robert Haas robertmh...@gmail.com writes:
Given a type T, I think we'd like to be able to define a type
On Thu, Apr 8, 2010 at 11:00 PM, Robert Haas robertmh...@gmail.com wrote:
I think you could shut it down at the first point at which it is
holding no locks, rather than letting it continue recovering and
potentially retake some new locks. That would be more consistent with
the general idea of
Hi all
I've asked related question on General list, but got no answer,
although I have been able to work around that issue a little bit.
There is one snag I encountered and I have no idea on how to work it
out.
I need to modify TSQuery object (add another operator and do some
stuff with it) -
Hello
Please find my project proposal at the following link:
https://docs.google.com/fileview?id=0B4sVSOdX9RZKNjI1MDZlNDgtZGU0MS00NDE4LThiZDItMjZhMGZkYjUzMWExhl=en
I would be glad to have your review/feedback on the same.
--
Regards
Dhiraj Lohiya
On Wed, Apr 7, 2010 at 00:48, Tom Lane t...@sss.pgh.pa.us wrote:
Magnus Hagander mag...@hagander.net writes:
On Wed, Apr 7, 2010 at 00:02, Tom Lane t...@sss.pgh.pa.us wrote:
Oh, another thought here: what is the effect of the combination of this
with your other proposal to add more timezones
Robert Haas wrote:
Under the first type [4pm,5pm) =
[4pm,4:59:59pm], while under the second [4pm,5pm) = [4pm,4:59pm].
Thoughts?
The examples with units look a lot like the IVLPQ datatype from HL7,
see
http://www.hl7.org/v3ballot/html/infrastructure/datatypes_r2/datatypes_r2.htm
About a
On Wed, Apr 7, 2010 at 21:06, Tom Lane t...@sss.pgh.pa.us wrote:
I wrote:
ereport(LOG,
(errmsg(could not determine system time zone, defaulting to
\%s\, GMT),
BTW, does anyone remember the reason for making GMT nonlocalizable
in these messages? It seems more
On Wed, Apr 7, 2010 at 21:01, Tom Lane t...@sss.pgh.pa.us wrote:
Stefan Kaltenbrunner ste...@kaltenbrunner.cc writes:
Even if if keep the current fallback behaviour we should at least fix
the windows codepath to do the same as the unix codepath does - as in
actually logging that the fallback
Hi all,
I am new at open source project however in a user point of view I must
confess that usability is a really though issue ,even if the performance of
a database is crucial.
As to my idea for improve postgresql is ;
http://www.postgresql.org/docs/current/interactive/ddl-partitioning.html in
Here's a thread that incorrectly started on the security list, but really is
more about functionality. Looking for comments:
The function is_absolute_path() is incorrect on Windows. As it's implemented,
it considers the following to be an absolute path:
* Anything that starts with /
* Anything
Magnus Hagander mag...@hagander.net wrote:
it considers the following to be an absolute path:
* Anything that starts with /
* Anything that starst with \
These aren't truly absolute, because the directory you find will be
based on your current work directory's drive letter; however, if the
On Fri, Apr 9, 2010 at 9:10 AM, Necati Batur necatiba...@gmail.com wrote:
I am new at open source project however in a user point of view I must
confess that usability is a really though issue ,even if the performance of
a database is crucial.
Sure. Nobody is saying otherwise.
As to my idea
On Fri, Apr 9, 2010 at 7:55 AM, Yeb Havinga yebhavi...@gmail.com wrote:
Robert Haas wrote:
Under the first type [4pm,5pm) =
[4pm,4:59:59pm], while under the second [4pm,5pm) = [4pm,4:59pm].
Thoughts?
The examples with units look a lot like the IVLPQ datatype from HL7, see
On Fri, Apr 9, 2010 at 10:33 AM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Apr 9, 2010 at 7:55 AM, Yeb Havinga yebhavi...@gmail.com wrote:
Robert Haas wrote:
Under the first type [4pm,5pm) =
[4pm,4:59:59pm], while under the second [4pm,5pm) = [4pm,4:59pm].
Thoughts?
The examples
On Fri, Apr 9, 2010 at 16:02, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
Magnus Hagander mag...@hagander.net wrote:
it considers the following to be an absolute path:
* Anything that starts with /
* Anything that starst with \
These aren't truly absolute, because the directory you
On Fri, Apr 9, 2010 at 4:10 AM, Dimitri Fontaine dfonta...@hi-media.com wrote:
Do we want to enable support for string based ranges, as in the
contributed prefix_range type?
Yes, probably, but that doesn't require as much knowledge of the
underlying data type, so I didn't feel it needed to be
Hi,
All I want to contribute to the project a liitle. I do not claim that I can
actually solve all the issues about partitioning.
Of course there are lots of ideas ,some looks pretty easy however, the
distribution issue seems too attractive to me that I am dying to work on.
I have checked the
Robert Haas wrote:
On Fri, Apr 9, 2010 at 10:33 AM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Apr 9, 2010 at 7:55 AM, Yeb Havinga yebhavi...@gmail.com wrote:
Robert Haas wrote:
Under the first type [4pm,5pm) =
[4pm,4:59:59pm], while under the second [4pm,5pm) =
From the implementers perspective, IMHO an extra catalog entry in
pg_type is not bad on its own, you would have one anyway if the range
type was explicitly programmed. About different kinds of range types -
I would not know how to 'promote' integer into anything else but just
one kind of
Necati Batur escribió:
Hi,
All I want to contribute to the project a liitle. I do not claim that I can
actually solve all the issues about partitioning.
Of course there are lots of ideas ,some looks pretty easy however, the
distribution issue seems too attractive to me that I am dying to work
On Fri, Apr 9, 2010 at 11:07 AM, Yeb Havinga yebhavi...@gmail.com wrote:
From the implementers perspective, IMHO an extra catalog entry in pg_type
is not bad on its own, you would have one anyway if the range type was
explicitly programmed. About different kinds of range types - I would not
*IDEA:XMLQuery*
* *
*Abstract*
SQL/XML makes it possible to store your XML documents in your SQL database,
to query those documents using XPath and XQuery, and to publish your
existing SQL data in the form of XML documents.
*Benefits of Project*
SQL/XML is an ANSI and ISO standard that
On 04/09/2010 07:33 AM, Robert Haas wrote:
On Fri, Apr 9, 2010 at 7:55 AM, Yeb Havinga yebhavi...@gmail.com wrote:
'tagging' a datatype as a lineair order, it could automatically have a range
type defined on it, like done for the array types currently.
The way we've handled array types is,
Robert Haas robertmh...@gmail.com wrote:
Given a type T, I think we'd like to be able to define a type U as
the natural type to be added to or subtracted from T. As Jeff
pointed out to me, this is not necessarily the same as the
underlying type. For example, if T is a timestamp, U is an
On Fri, Apr 9, 2010 at 1:13 PM, Kevin Grittner
kevin.gritt...@wicourts.gov wrote:
As it is de rigueur for someone to escalate the proposed complexity
of an idea by at least one order of magnitude, and everyone else has
fallen down on this one: ;-)
Gee, thanks for filling in?
I've often
Magnus Hagander mag...@hagander.net wrote:
On Fri, Apr 9, 2010 at 16:02, Kevin Grittner
I assume we reject anything where what precedes the colon doesn't
match the current drive's designation?
Define reject?
I guess I made that comment thinking about the example of usage
farther down.
Oleg Bartunov suggested that I should explicitly use
set search_path=public,pg_catalog;
That's a good tip, as I missed the info in the manual, but it solved
only one instance of my problem, namely
SELECT to_tsquery('cat dog mouse'); --this now works as it should
But the other instances still
Robert Haas robertmh...@gmail.com wrote:
I dowanna rework the type system. I'm not even 100% sure I want
to implement what I actually proposed. I do want to find out if
people think the framework makes sense and whether it's the right
way forward for those projects that need these
Robert Haas wrote:
On Fri, Apr 9, 2010 at 11:07 AM, Yeb Havinga yebhavi...@gmail.com wrote:
.. I now see the example of different ranges in your original mail with
different unit increments. Making that more general so there could be
continuous and discrete ranges and for the latter, what
Alvaro Herrera alvhe...@commandprompt.com writes:
Necati Batur escribió:
Hi,
All I want to contribute to the project a liitle. I do not claim that I can
actually solve all the issues about partitioning.
Of course there are lots of ideas ,some looks pretty easy however, the
distribution issue
On Fri, Apr 9, 2010 at 4:01 PM, Yeb Havinga yebhavi...@gmail.com wrote:
Robert Haas wrote:
On Fri, Apr 9, 2010 at 11:07 AM, Yeb Havinga yebhavi...@gmail.com wrote:
.. I now see the example of different ranges in your original mail with
different unit increments. Making that more general so
Necati Batur wrote:
*IDEA:XMLQuery*
* *
*Abstract*
SQL/XML makes it possible to store your XML documents in your SQL
database, to query those documents using XPath and XQuery, and to
publish your existing SQL data in the form of XML documents.
*Benefits of Project*
SQL/XML is an ANSI
Hello,
I am sending my proposal on GSoC. Details are listed below. Please, if
you have ideas, tips, or if you only want to say you opinion about my
project, go ahead.
thanks,
Pavel Baros
Abstract:
It is effort to implement snapshot materialized view (are only updated
when refreshed) in
Hi,
i'm startint to try Hot Standby Streaming Replication, so i started
a replication:
1) Install master server with regression database
2) Start WAL archive (archive_mode=on, archive_command='cp %p
/usr/local/pgsql/wal_archive/%f')
3) select pg_start_backup('standby test');
4) cp -R
pavelbaros baro...@seznam.cz wrote:
I am also waiting for approval for my repository named
materialized_view on git.postgresql.org
They seem to prefer that you get a repository under your name and
use materialized_view as a branch name. See my account on
git.postgresql.org and its
On Fri, Apr 9, 2010 at 4:37 PM, Andrew Dunstan and...@dunslane.net wrote:
(Personally I wish some SOC student would do LATERAL. It would be useful and
is a feature of about the right size, I think).
Actually, I think that requires two rounds of significant executor
refactoring. This is round
Necati Batur escribió:
*Delivarables on Timeline*
The implementation of XQuery support can ce achieved by;
*Understanding the basics of the SQL/XML (1 week)
*A research of on other kinds of XQuery supported DBMSs scuh as; Oracle and
SQLServer(1-2 week)
*The design for the core
Well, If the project criterias and other neccessary information were
collected under a single link that would be great for not only gsoc students
but also for other enthusiastic students :).By provided info we would spend
less time to understand the project phases and requirements and more time on
2010/4/9 chaoyong wang catcher_w...@hotmail.com:
Hi,
I'm using VC2005 to create PG C-language Fun in my contrib xml_index,
which import other library, and I have add the include and lib directory by
changing Mkvcbuild.pm and config.pl.
But after I executed the following commands:
On Fri, 2010-04-09 at 12:50 -0500, Kevin Grittner wrote:
I just thought that if you were adding more type information,
oriented aournd the types themselves rather than index AMs, some form
of inheritence might fit in gracefully.
There are already some specific proposals for inheritance in
On Fri, Apr 9, 2010 at 5:02 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Necati Batur escribió:
*Delivarables on Timeline*
The implementation of XQuery support can ce achieved by;
*Understanding the basics of the SQL/XML (1 week)
*A research of on other kinds of XQuery supported
On Fri, 2010-04-09 at 11:14 -0400, Robert Haas wrote:
range of integers with increment y, if xy? Maybe the increment step and
continuous/discrete could be typmods.
Nope, not enough bits available there.
I think the problem is deeper than that. Typmods aren't carried along as
part of the
On Thu, 2010-04-08 at 22:29 -0400, Robert Haas wrote:
1. knngist wants to use index scans to speed up queries of the form
SELECT ... ORDER BY column op constant (as opposed to the
existing machinery which only knows how to use an index for SELECT ...
ORDER BY column).
2. Window functions want
On Fri, Apr 9, 2010 at 5:49 PM, Jeff Davis pg...@j-davis.com wrote:
It may or may not be worth building the concept of a unit
increment into the type interface machinery, though: one could imagine
two different range types built over the same base type with different
unit increments - e.g. one
2010/4/9 pavelbaros baro...@seznam.cz:
Implementation: could be divided to few steps:
1) create materialized view
- modify grammar (parser): CREATE MATERIALIZED VIEW mv_name AS SELECT ...
- change executor, so that it will create physical table defined by select
statement
This basically
The advantage of specifying a + and a - in the type interface is that
the unit definition can then be specified as part of the type
declaration itself. So you can do:
CREATE TYPE ts_sec AS RANGE OVER timestamp (UNIT = '1s');
CREATE TYPE ts_min AS RANGE OVER timestamp (UNIT = '1m');
All of
Using 9.0devel cvs HEAD, 2010.04.08.
I am trying to understand the performance difference
between primary and standby under a standard pgbench
read-only test.
server has 32 GB, 2 quadcores.
primary:
tps = 34606.747930 (including connections establishing)
tps = 34527.078068 (including
On Fri, Apr 9, 2010 at 7:18 PM, Nathan Boley npbo...@gmail.com wrote:
The advantage of specifying a + and a - in the type interface is that
the unit definition can then be specified as part of the type
declaration itself. So you can do:
CREATE TYPE ts_sec AS RANGE OVER timestamp (UNIT =
On Fri, Apr 9, 2010 at 7:53 PM, Robert Haas robertmh...@gmail.com wrote:
On Fri, Apr 9, 2010 at 7:18 PM, Nathan Boley npbo...@gmail.com wrote:
The advantage of specifying a + and a - in the type interface is that
the unit definition can then be specified as part of the type
declaration itself.
On Fri, Apr 9, 2010 at 5:02 PM, Alvaro Herrera
alvhe...@commandprompt.com wrote:
Necati Batur escribió:
*Delivarables on Timeline*
...
*Implementation of a GUI for XQuery for the PostgreSql users (2 week)
What, you will *also* implement a GUI? Gimme a break. There's no way
you can achieve
On Fri, Apr 9, 2010 at 4:08 PM, Dimitri Fontaine dfonta...@hi-media.com wrote:
I guess a GSoC of reasonable size would be to define a spec for how to
implement partitioning in PostgreSQL with a sound and accepted proposal
on independent steps to contribute separately, in order to reach the
pavelbaros wrote:
I am also waiting for approval for my repository named
materialized_view on git.postgresql.org, so I could publish
completed parts.
Presuming that you're going to wander there and get assigned what looks
like an official repo name for this project is a bit...optimistic. I
2010/4/9 Greg Smith g...@2ndquadrant.com:
The main hidden complexity in this particular project relates to handling
view refreshes. The non-obvious problem is that when the view updates, you
need something like a SQL MERGE to really handle that in a robust way that
doesn't conflict with
On Fri, Apr 9, 2010 at 3:39 PM, Jaime Casanova
jcasa...@systemguards.com.ec wrote:
Hi,
i'm startint to try Hot Standby Streaming Replication, so i started
a replication:
i think make standbycheck needs a little more work, why it isn't
accesible from top of source dir?
For now, to excercise
54 matches
Mail list logo
