Hi,
I build PG on VS2005, which files should I change to use a external lib in
my own contrib, for example, Berkeley DB 4.8.26?
Until now, I have tried the following 2 ways, but both failed.
1. Add the target include and lib
1). src/tools/msvc/config.pl
Robert Haas wrote:
This seems pretty reasonable to me, especially considering that JDBC
is apparently already doing it. I suppose there will always be
projects that want to reimplement the backend protocol so that they
can be pure some-language, but chipping away at the list of other
reasons
Joseph Adams wrote:
Hello, I'm Joey Adams, and I'm interested in applying for Google
Summer of Code to work on PostgreSQL. I'm a former GSoC student (I
worked on CCAN last year), and a strong C programmer, though I am
still new to working with large, established communities. I apologize
if
2010/3/22 chaoyong wang catcher_w...@hotmail.com
Hi,
I build PG on VS2005, which files should I change to use a external lib
in my own contrib, for example, Berkeley DB 4.8.26?
Until now, I have tried the following 2 ways, but both failed.
1. Add the target include and lib
Hi,
Attached is updated Turkish stopword list for Tsearch2, against 8.4 and
HEAD.
Please apply.
Regards,
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository: http://yum.pgrpms.org
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
Dimitri Fontaine dfonta...@hi-media.com writes:
Sure, I should go and write a complete pgsql emacs mode
with a linum-mode like feature counting lines the way PG does it, …
Ok maybe just using the current SQL mode and linum mode is enough if we
teach this latter one to count PostgreSQL function
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= dev...@gunduz.org writes:
Attached is updated Turkish stopword list for Tsearch2, against 8.4 and
HEAD.
It would be a good idea to submit this upstream at the snowball project,
else it might get lost in future updates.
regards, tom
On Mon, 2010-03-22 at 08:55 -0400, Tom Lane wrote:
It would be a good idea to submit this upstream at the snowball
project, else it might get lost in future updates.
Ok, will do.
--
Devrim GÜNDÜZ
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
PostgreSQL RPM Repository:
* Joseph Adams (joeyadams3.14...@gmail.com) wrote:
I propose adding application-level access control to PostgreSQL via a
jails concept. In a nutshell, a jail is created as part of the
database definition (typically exposing a free variable for the
current user). When a jail is activated for
Exclusion constraints are good. There's a few annoyances around them,
that are minor but feel should be addressed for 9.0.
* Exclusion indexes are created with the suffix _exclusion. That's a
very long suffix and will overflow most defined reports/screens. It
would be much better to use just
Deferrable unique constraints seem an interesting feature, though I have
either some questions or some issues, not sure which.
I don't seem to be able to find any way to do an ALTER TABLE that adds
this new capability to an existing table.
There is no way to add a constraint via a CREATE TABLE
On Mon, Mar 22, 2010 at 9:39 AM, Stephen Frost sfr...@snowman.net wrote:
* Joseph Adams (joeyadams3.14...@gmail.com) wrote:
I propose adding application-level access control to PostgreSQL via a
jails concept. In a nutshell, a jail is created as part of the
database definition (typically
On Mon, Mar 22, 2010 at 9:15 AM, Simon Riggs si...@2ndquadrant.com wrote:
Exclusion constraints are good. There's a few annoyances around them,
that are minor but feel should be addressed for 9.0.
* Exclusion indexes are created with the suffix _exclusion. That's a
very long suffix and will
* Robert Haas (robertmh...@gmail.com) wrote:
Sometimes it would be nice to conditionalize queries on a value other
than the authenticated role. I really wish we had some kind of SQL
variable support. Talking out of my rear end:
I certainly agree- having variable support in the backend would
Simon Riggs si...@2ndquadrant.com writes:
* Exclusion indexes are created with the suffix _exclusion. That's a
very long suffix and will overflow most defined reports/screens. It
would be much better to use just _excl,
No particular objection here.
* Circles, Boxes and other geometric
Simon Riggs si...@2ndquadrant.com writes:
Am I missing something?
That we're long past feature freeze? Some of these might be reasonable
TODO items. None of them are happening for 9.0.
regards, tom lane
--
Sent via pgsql-hackers mailing list
On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
* Exclusion indexes are created with the suffix _exclusion. That's a
very long suffix and will overflow most defined reports/screens. It
would be much better to use just _excl,
No particular
2010/3/22 Dimitri Fontaine dfonta...@hi-media.com:
Dimitri Fontaine dfonta...@hi-media.com writes:
Sure, I should go and write a complete pgsql emacs mode
with a linum-mode like feature counting lines the way PG does it, …
Ok maybe just using the current SQL mode and linum mode is enough if
Simon Riggs si...@2ndquadrant.com writes:
On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote:
Also, if the only common sense usage of exclusion constraints is GIST,
why does the syntax default to btree?
Since your if isn't a correct statement, the complaint doesn't follow.
Docs say
The
On mån, 2010-03-22 at 13:15 +, Simon Riggs wrote:
* inet datatypes don't have a commutative operator on which a unique
index can be built. There is no overlaps equivalent, which again is a
shame because that stops them being used with the new feature.
http://pgfoundry.org/projects/ip4r/
Josh Berkus wrote:
In hindsight I could have loaded the ASCII release notes into a wiki and
people could have modified, them, and later I could have converted them
to SGML,
That was, in fact, *exactly* what you said you'd do 3 months ago when we
discussed this.
I now remember
On Mon, Mar 22, 2010 at 10:03 AM, Stephen Frost sfr...@snowman.net wrote:
* Robert Haas (robertmh...@gmail.com) wrote:
Sometimes it would be nice to conditionalize queries on a value other
than the authenticated role. I really wish we had some kind of SQL
variable support. Talking out of my
On Mon, 2010-03-22 at 16:40 +0200, Peter Eisentraut wrote:
On mån, 2010-03-22 at 13:15 +, Simon Riggs wrote:
* inet datatypes don't have a commutative operator on which a unique
index can be built. There is no overlaps equivalent, which again is a
shame because that stops them being
Simon Riggs si...@2ndquadrant.com wrote:
On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
* Circles, Boxes and other geometric datatypes defined
overlaps to include touching shapes. So
SELECT circle '((0,0), 1)' circle '((2,0),1)';
is true,
2010/3/22 Robert Haas robertmh...@gmail.com:
On Mon, Mar 22, 2010 at 9:39 AM, Stephen Frost sfr...@snowman.net wrote:
* Joseph Adams (joeyadams3.14...@gmail.com) wrote:
I propose adding application-level access control to PostgreSQL via a
jails concept. In a nutshell, a jail is created as
On Mon, 2010-03-22 at 10:32 -0500, Kevin Grittner wrote:
Simon Riggs si...@2ndquadrant.com wrote:
On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
* Circles, Boxes and other geometric datatypes defined
overlaps to include touching shapes.
Robert Haas robertmh...@gmail.com wrote:
Does the SQL standard specify anything in this area?
The only thing that comes to mind for me is the SQL/PSM
SQL variable declaration.
-Kevin
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your
On Thu, Mar 18, 2010 at 9:43 AM, Simon Riggs si...@2ndquadrant.com wrote:
On Wed, 2010-03-17 at 11:37 +0200, Heikki Linnakangas wrote:
One awkward omission in the new built-in standby mode, mainly used for
streaming replication, is that there is no easy way to delete old
archived files like
On Mon, Mar 22, 2010 at 03:42:39PM +, Simon Riggs wrote:
On Mon, 2010-03-22 at 10:32 -0500, Kevin Grittner wrote:
Simon Riggs si...@2ndquadrant.com wrote:
On Mon, 2010-03-22 at 10:13 -0400, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
* Circles, Boxes and other
Simon Riggs si...@2ndquadrant.com wrote:
Yes, for most people touching != overlap. So it just looks like a
bug.
A quick search of the web turned up a definition of overlap in
geometry as meaning that two polygons share at least one *internal*
point, which would be consistent with your
Simon Riggs wrote:
Basically, what you feel is missing is documentation that if two
shapes share one or more points they are considered to overlap;
there is no requirement that they share an area?
Yes, for most people touching != overlap. So it just looks like a bug.
I guess I
On Mon, 2010-03-22 at 09:00 -0700, David Fetter wrote:
Yes, for most people touching != overlap. So it just looks like a
bug.
I don't know which people you've surveyed, but at least in my math
classes, one point in common was sufficient for an overlap. I'd be
happy to write up something
On Mon, Mar 22, 2010 at 04:47:37PM +, Simon Riggs wrote:
On Mon, 2010-03-22 at 09:00 -0700, David Fetter wrote:
Yes, for most people touching != overlap. So it just looks like a
bug.
I don't know which people you've surveyed, but at least in my math
classes, one point in common
David Fetter da...@fetter.org writes:
I'm seeing a lot of places where this might be documented. Any ideas
as to which ones are appropriate?
I would think Geometric Functions and Operators would be the most
appropriate spot ...
regards, tom lane
--
Sent via
On Mon, Mar 22, 2010 at 01:46:51PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
I'm seeing a lot of places where this might be documented. Any ideas
as to which ones are appropriate?
I would think Geometric Functions and Operators would be the most
appropriate spot ...
David Fetter wrote:
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 9881ff4..9313112 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -7134,7 +7134,7 @@ CREATE TYPE rainbow AS ENUM ('red', 'orange', 'yellow',
'green', 'blue', 'purple
/row
On Mon, Mar 22, 2010 at 04:04:16PM -0300, Alvaro Herrera wrote:
David Fetter wrote:
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml
index 9881ff4..9313112 100644
--- a/doc/src/sgml/func.sgml
+++ b/doc/src/sgml/func.sgml
@@ -7134,7 +7134,7 @@ CREATE TYPE rainbow AS ENUM
On Mon, Mar 22, 2010 at 1:15 PM, Simon Riggs si...@2ndquadrant.com wrote:
* Circles, Boxes and other geometric datatypes defined overlaps to
include touching shapes. So
* inet datatypes don't have a commutative operator on which a unique
index can be built. There is no overlaps equivalent,
On Mon, 2010-03-22 at 10:55 -0700, David Fetter wrote:
On Mon, Mar 22, 2010 at 01:46:51PM -0400, Tom Lane wrote:
David Fetter da...@fetter.org writes:
I'm seeing a lot of places where this might be documented. Any ideas
as to which ones are appropriate?
I would think Geometric
Simon Riggs si...@2ndquadrant.com wrote:
I think you've missed my point.
What I was talking about was that box '((0,0),(1,1))' box
'((1,1),(2,2))' returns true, even though they touch at only a
single point, and share zero area.
FWIW, that's what I would take away from one point in
Takahiro Itagaki wrote:
Bruce Momjian br...@momjian.us wrote:
Takahiro Itagaki wrote:
Since 9.0 has GetPlatformEncoding() for the purpose, we could simplify
db_encoding_strdup() with the function. Like this:
OK, I don't have any Win32 people testing this patch so if we want this
On Mon, Mar 22, 2010 at 4:45 PM, Paul Ramsey pram...@cleverelephant.ca wrote:
Did you already try replacing your postgis functions with array_agg
calls to see if we can push the problem back over the fence to pgsql
land?
On Sat, Mar 20, 2010 at 9:17 AM, Mike Leahy mgle...@alumni.uwaterloo.ca
Jeff Davis wrote:
On Tue, 2010-03-16 at 15:29 +, Greg Stark wrote:
I'm picturing storing a bit in the visibility map indicating that *no*
records are visible in a given page.
I've been thinking for a while that we could store the visibility
information in a structure separate from the
On 3/22/10 7:46 AM, Bruce Momjian wrote:
I do not require them to submit SGML; just some format where I can
identify the lines that changed. I can do the same for the release
notes. I have to check the diffs anyway so manually merging in the
changes isn't a problem.
So there are 2 large
On sön, 2010-03-21 at 20:40 -0400, Robert Haas wrote:
\ef function-name line-number
with suitable magic to get the editor to place the cursor at that line.
I suspect this wouldn't be too hard to do with emacs --- what do you
think about vi?
Well, in vi you can just do vi +linenum
On sön, 2010-03-21 at 13:07 -0400, Andrew Dunstan wrote:
Yeah, maybe. According to
http://www.w3.org/TR/REC-DOM-Level-1/level-one-core.html the only
legal child of an XML Document node that is not also a legal child of a
DocumentFragment node is a DocumentType node. So we could probably
On mån, 2010-03-22 at 14:18 -0700, Josh Berkus wrote:
So there are 2 large problems I have with the SGML version, let's see if
we can deal with them separately:
(1) re-arranging and regrouping the items: the stuff in the release
notes should end up in 7-8 clear categories, with items
On Mon, Mar 22, 2010 at 02:18:04PM -0700, Josh Berkus wrote:
On 3/22/10 7:46 AM, Bruce Momjian wrote:
I do not require them to submit SGML; just some format where I
can identify the lines that changed. I can do the same for the
release notes. I have to check the diffs anyway so manually
On Mar 22, 2010, at 2:23 PM, Peter Eisentraut wrote:
On sön, 2010-03-21 at 20:40 -0400, Robert Haas wrote:
\ef function-name line-number
with suitable magic to get the editor to place the cursor at that line.
I suspect this wouldn't be too hard to do with emacs --- what do you
think
On Mon, 2010-03-22 at 16:48 -0400, Bruce Momjian wrote:
I don't think we want to move to 64-bit xids becasue we would still need
to do vacuum freeze to trim the clog. In fact we do vacuum freeze much
more frequently than required for 32-bit xids for this very reason.
Good point. I think there
Uh why? Open the file with a text editor, cut and paste the lines
elsewhere.
... because even one edit by anyone else is a merge conflict. And CVS
isn't too good with merge conflicts. Also few of the people whom I'd
want to ask for help are committers -- the release notes are as much
about
On Mon, Mar 22, 2010 at 23:18, Josh Berkus j...@agliodbs.com wrote:
Uh why? Open the file with a text editor, cut and paste the lines
elsewhere.
... because even one edit by anyone else is a merge conflict. And CVS
isn't too good with merge conflicts. Also few of the people whom I'd
want
On Sat, Mar 20, 2010 at 5:02 AM, Bruce Momjian br...@momjian.us wrote:
Interestingly the 9.0 release notes contain 201 items, while the 8.4
release notes contained 314 items.
Is the following pg_dump change covered by the release notes? I
couldn't find it. It was the last committed patch from
On mån, 2010-03-22 at 09:54 -0400, Robert Haas wrote:
We have had one previous request for the ability to limit the list of
queries that the user can issue to a fixed set, but it's not clear to
me that that's really all that useful.
Well, sudo is pretty useful, and this would be quite similar.
Simon Riggs wrote:
On Thu, 2010-01-14 at 17:33 +0900, Fujii Masao wrote:
I added two new functions;
(1) pg_last_xlog_receive_location() reports the last WAL location received
and synced by walreceiver. If streaming replication is still in progress
this will increase
Joachim Wieland wrote:
On Sat, Mar 20, 2010 at 5:02 AM, Bruce Momjian br...@momjian.us wrote:
Interestingly the 9.0 release notes contain 201 items, while the 8.4
release notes contained 314 items.
Is the following pg_dump change covered by the release notes? I
couldn't find it. It was
Josh Berkus wrote:
On 3/22/10 7:46 AM, Bruce Momjian wrote:
I do not require them to submit SGML; just some format where I can
identify the lines that changed. I can do the same for the release
notes. I have to check the diffs anyway so manually merging in the
changes isn't a problem.
Uh, are you saying you want to remove the exiting release note
subcategories and put everything into 7-8 long lists? That hardly seems
like an improvement, or are you talking about make a user-focused list
that is shorter with 7-8 categories?
I'm talking about adjusting which subcategories
Bruce,
BTW, I didn't say it before, but thanks for getting this draft out
*now*. It's a lot more time than we've had in the past.
--
-- Josh Berkus
PostgreSQL Experts Inc.
Josh Berkus wrote:
Uh, are you saying you want to remove the exiting release note
subcategories and put everything into 7-8 long lists? That hardly seems
like an improvement, or are you talking about make a user-focused list
that is shorter with 7-8 categories?
I'm talking about
On fre, 2010-03-19 at 11:50 -0400, Andrew Dunstan wrote:
Peter Eisentraut wrote:
Log Message:
---
Prevent the injection of invalidly encoded strings by PL/Python into
PostgreSQL
with a few strategically placed pg_verifymbstr calls.
Awesome. Do we need to fix pltcl too?
Short
Josh Berkus wrote:
Bruce,
BTW, I didn't say it before, but thanks for getting this draft out
*now*. It's a lot more time than we've had in the past.
Sure. For some reason it was easier/faster this time; possible causes:
o I am getting better because I have done it before
Peter Eisentraut pete...@gmx.net writes:
I have never used Tcl before just now, and the documentation is sketchy,
but it looks like the behavior of Tcl is kind of mixed in this area.
Escapes such as \xd0 are apparently converted to Unicode code points
rather than bytes when the appropriate OS
Peter Eisentraut wrote:
On sön, 2010-03-21 at 13:07 -0400, Andrew Dunstan wrote:
Yeah, maybe. According to
http://www.w3.org/TR/REC-DOM-Level-1/level-one-core.html the only
legal child of an XML Document node that is not also a legal child of a
DocumentFragment node is a DocumentType
Uh, I did adjust the subcategories based on what we completed for 9.0.
You will find many added/removed ones compared to 8.4
warranted. Also, within each subcategory, items should be arranged in
descending order according to how much impact we expect them to have on
users.
I think I
On mån, 2010-03-22 at 19:29 -0400, Tom Lane wrote:
Peter Eisentraut pete...@gmx.net writes:
I have never used Tcl before just now, and the documentation is sketchy,
but it looks like the behavior of Tcl is kind of mixed in this area.
Escapes such as \xd0 are apparently converted to
Pavel Stehule pavel.steh...@gmail.com wrote:
I wrote some small patch, that allow preloading of selected ispell
dictionary. It solve the problem with slow tsearch initialisation with
some language configuration.
I afraid so this module doesn't help on MS Windows.
I think it should work
Simon Riggs wrote:
On Sat, 2009-09-19 at 13:21 -0400, Tom Lane wrote:
I realized the truth of $SUBJECT while reading this report:
http://archives.postgresql.org/pgsql-general/2009-09/msg00712.php
...
Also, does this have any impact on the Hot Standby stuff?
It could potentially, but
Bruce Momjian br...@momjian.us writes:
[This is an open item for 9.0, hence the response to an apparently old
hackers thread]
Thanks for the reply; 9.0 open item removed.
I think you misread his reply. Please put that back.
regards, tom lane
--
Sent via
Tom Lane wrote:
Bruce Momjian br...@momjian.us writes:
[This is an open item for 9.0, hence the response to an apparently old
hackers thread]
Thanks for the reply; 9.0 open item removed.
I think you misread his reply. Please put that back.
OK, I re-read it and still don't
On Tue, Mar 23, 2010 at 7:56 AM, Bruce Momjian br...@momjian.us wrote:
Sorry, release notes updated:
Add link
linkend=functions-recovery-info-tablefunctionpg_last_xlog_receive_location()//link
and functionpg_last_xlog_replay_location()/, which
Greg Smith g...@2ndquadrant.com wrote:
Attached is an updated version that I think is ready to commit. Only
changes are docs--I rewrote those to improve the wording some.
Thanks for the correction. Applied.
Regards,
---
Takahiro Itagaki
NTT Open Source Software Center
--
Sent via
(2010/03/20 13:37), Tom Lane wrote:
KaiGai Koheikai...@kaigai.gr.jp writes:
Is it an expected behavior that PostgreSQL tries to execute foo() with
privileges of the owner of language call handler because of its security
definer property? This server crash is just a result.
A language call
Fujii Masao wrote:
On Tue, Mar 23, 2010 at 7:56 AM, Bruce Momjian br...@momjian.us wrote:
Sorry, release notes updated:
? ? ? ? ? ? ?Add link
? ? ? ? ? ?
?linkend=functions-recovery-info-tablefunctionpg_last_xlog_receive_location()//link
? ? ? ? ? ? ?and
Bruce Momjian br...@momjian.us wrote:
I have completed the 9.0 release notes:
http://developer.postgresql.org/pgdocs/postgres/release-9-0.html
There is an additional incompatibilitiy in pg_largeobject catalog.
We need to rewrite queries to test existences of large objests
from SELECT
Takahiro Itagaki wrote:
Greg Smith g...@2ndquadrant.com wrote:
Attached is an updated version that I think is ready to commit. Only
changes are docs--I rewrote those to improve the wording some.
Thanks for the correction. Applied.
By the way: the pgbench.sgml that you committed
Greg Smith g...@2ndquadrant.com wrote:
By the way: the pgbench.sgml that you committed looks like it passed
through a system that added a CR to every line in it. Probably not the
way you intended to commit that.
Oops, fixed. Thanks.
Regards,
---
Takahiro Itagaki
NTT Open Source Software
77 matches
Mail list logo