On Sun, Dec 26, 2010 at 01:10, Andrew Dunstan wrote:
>
>
> On 12/20/2010 01:25 PM, Magnus Hagander wrote:
>>
>> On Mon, Dec 20, 2010 at 19:24, Tom Lane wrote:
>>>
>>> Andrew Dunstan writes:
Maybe. I have no idea where narwhal got its version of dbghelp.h. I
copied the file from th
On Thu, Dec 23, 2010 at 10:26 AM, Tom Lane wrote:
> Kenneth Marshall writes:
> > On Thu, Dec 23, 2010 at 10:42:26PM +0800, Li Jie wrote:
> >> But in the last query that sorts on "id", since the query selects all
> the columns for output, the actual sorted size is the same, and the only
> differ
On 26/12/10 05:55, Robert Haas wrote:
> On Sat, Dec 25, 2010 at 3:39 PM, Tom Lane wrote:
>> Robert Haas writes:
>>> Add foreign data wrapper error code values for SQL/MED.
>>> Extracted from a much larger patch by Shigeru Hanada.
>>
>> This patch is quite incomplete. Any patch that adds to errco
On Sun, Dec 26, 2010 at 8:03 AM, Jan Urbański wrote:
> See
> https://github.com/wulczer/postgres/commit/44fc42b7708f23483156e4e0e1e321e68b2a7e2d#diff-0
> for something that maybe could be used as a basis to autogenerate
> errcodes.sgml and plerrcodes.h.
Interesting. It looks like this might be e
On 12/26/2010 04:35 AM, Magnus Hagander wrote:
On Sun, Dec 26, 2010 at 01:10, Andrew Dunstan wrote:
On 12/20/2010 01:25 PM, Magnus Hagander wrote:
On Mon, Dec 20, 2010 at 19:24, Tom Lanewrote:
Andrew Dunstanwrites:
Maybe. I have no idea where narwhal got its version of dbghelp.h.
On Dec 25, 2010, at 12:55 PM, Николай Ижиков wrote:
> I got error
>
> "could not load libraty /usr/lib/postgresql/uuid-ossp.so":
> /usr/lib/postgresql/uuid-ossp.so: undefined symbol: uuid_error"
>
> How I can fix it?
cd contrib/uuid-ossp
make install
...Robert
Hello,
I have a free time and I can do a review of your patch. Please, can
send a last version and can send a links on documentation that you
used?
Regards
Pavel Stehule
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postg
Robert Haas writes:
> On Sun, Dec 26, 2010 at 8:03 AM, Jan UrbaÅski wrote:
>> See
>> https://github.com/wulczer/postgres/commit/44fc42b7708f23483156e4e0e1e321e68b2a7e2d#diff-0
>> for something that maybe could be used as a basis to autogenerate
>> errcodes.sgml and plerrcodes.h.
> Interesting.
Craig Ringer writes:
> On 12/26/2010 02:14 PM, Elliot Chance wrote:
>> /usr/include/pgsql/server/nodes/primnodes.h:1155: error: expected
>> unqualified-id before using
> You've neglected to mention which version of Pg you're compiling
> against, so that line number means nothing. What's the o
2010/12/4 Tom Lane :
> What we have at this point (pending contrib/btree_gist fixes) is
> nearest-neighbor searching capability for point columns. And
> trigram-based nearest-neighbor for text strings, if you install
> contrib/pg_trgm. That doesn't seem like a lot of return for the
> amount of wo
On 26/12/10 18:17, Tom Lane wrote:
> Robert Haas writes:
>> On Sun, Dec 26, 2010 at 8:03 AM, Jan Urbański wrote:
>>> See
>>> https://github.com/wulczer/postgres/commit/44fc42b7708f23483156e4e0e1e321e68b2a7e2d#diff-0
>>> for something that maybe could be used as a basis to autogenerate
>>> errcode
=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= writes:
> I then tried to do the same for plerrcodes.h, but found discrepancies.
You shouldn't assume that errcodes.h necessarily includes all the info
needed to create the other two files.
The way I'd envision this working is that we have a master file
containin
Hitoshi Harada writes:
> Catching up tonight, I wonder I could propose to add ordering
> operators in btree, not in gist, for basic types.
I thought about that for a bit while working on the knngist patch, but
couldn't really see any useful application. In particular, I don't see
a way to shoeho
On 26/12/10 20:33, Tom Lane wrote:
> =?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= writes:
>> I then tried to do the same for plerrcodes.h, but found discrepancies.
>
> You shouldn't assume that errcodes.h necessarily includes all the info
> needed to create the other two files.
>
> The way I'd envision this
=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= writes:
> How about a format like this then:
> # Comment
> Section: Class 2F - SQL Routine Exception
> macro_name sqlstate plpgsqlname is_error
> That is: # and blank lines are comments, lines starting with "Section:"
> are section names (needed for SGML output),
On 26/12/10 20:57, Tom Lane wrote:
> =?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= writes:
>> How about a format like this then:
>
>> # Comment
>> Section: Class 2F - SQL Routine Exception
>> macro_name sqlstate plpgsqlname is_error
>
>> That is: # and blank lines are comments, lines starting with "Section:"
On Dec 26, 2010, at 3:09 PM, Jan Urbański wrote:
>> Things might line up nicer if the sqlstate is the first column.
>
> I was thinking of separating the values with tabs anyway, but I'm fine
> with putting sqlstate first.
+1 for putting SQLSTATE first.
...Robert
--
Sent via pgsql-hackers mail
=?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= writes:
> Makes sense. Wait, no, errcodes.sgml includes the entries for success
> and warnings, but the plpgsql conditions list does not. So we need a
> separate column to differentiate.
OK. But not 0/1 please. Maybe 'E', 'W', or 'S' ? And again, fixed
width co
On Sun, Dec 26, 2010 at 12:17 PM, Tom Lane wrote:
>> Proposed patch attached. This adds what I believe to be the correct
>> incantations to errcodes.sgml and plerrcodes.h, and also corrects a
>> typographical error in yesterday's commit which I failed to notice
>> while reviewing.
>
> Hmm. Even
On 26/12/10 21:17, Tom Lane wrote:
> =?UTF-8?B?SmFuIFVyYmHFhHNraQ==?= writes:
>> Makes sense. Wait, no, errcodes.sgml includes the entries for success
>> and warnings, but the plpgsql conditions list does not. So we need a
>> separate column to differentiate.
>
> OK. But not 0/1 please. Maybe '
On Sun, Dec 26, 2010 at 2:41 PM, Tom Lane wrote:
> Hitoshi Harada writes:
>> Catching up tonight, I wonder I could propose to add ordering
>> operators in btree, not in gist, for basic types.
>
> I thought about that for a bit while working on the knngist patch, but
> couldn't really see any usef
Robert Haas writes:
> On Sun, Dec 26, 2010 at 12:17 PM, Tom Lane wrote:
>> Hmm. Even with the typo fixed, ERRCODE_FDW_UNABLE_TO_CREATE_EXECUTION
>> seems pretty darn opaque. Is it missing a word? Can we rephrase it so
>> people will have some idea what it means?
> Appears to be straight out o
On 12/26/2010 12:31 PM, Tom Lane wrote:
In any case, I think it's very likely the issue is a C/C++
incompatibility in the Pg headers. It fails for me in a different place
using Pg 9.1git and g++ 4.5, complaining about the use of "private" as
an identifier in fmgr.h, because it's a keyword in
2010/12/27 Robert Haas :
> On Sun, Dec 26, 2010 at 2:41 PM, Tom Lane wrote:
>> Hitoshi Harada writes:
>>> Catching up tonight, I wonder I could propose to add ordering
>>> operators in btree, not in gist, for basic types.
>>
>> I thought about that for a bit while working on the knngist patch, bu
Hitoshi Harada writes:
> 2010/12/27 Robert Haas :
>> As far as window functions go, we clearly need some kind of type
>> interface feature, but I am unclear whether we should sandwhich it
>> into the btree opclass machinery or whether it might be better to
>> create a whole separate concept just f
On Sun, Dec 26, 2010 at 4:18 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Sun, Dec 26, 2010 at 12:17 PM, Tom Lane wrote:
>>> Hmm. Even with the typo fixed, ERRCODE_FDW_UNABLE_TO_CREATE_EXECUTION
>>> seems pretty darn opaque. Is it missing a word? Can we rephrase it so
>>> people will have
On Fri, Dec 24, 2010 at 11:47 PM, Bruce Momjian wrote:
> Applied.
storage.sgml seems to need to be updated.
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes
In reviewing the work Shigeru Hanada has done on SQL/MED, it's come to
my attention that we have a lot of error messages that use the error
code ERRCODE_WRONG_OBJECT_TYPE and have text like this:
"%s" is not a table
"%s" is not an index
or even better:
"%s" is not a table, view, composite type,
On Sun, Dec 26, 2010 at 10:13:35PM -0500, Robert Haas wrote:
> In reviewing the work Shigeru Hanada has done on SQL/MED, it's come to
> my attention that we have a lot of error messages that use the error
> code ERRCODE_WRONG_OBJECT_TYPE and have text like this:
>
> "%s" is not a table
> "%s" is
On Mon, Dec 27, 2010 at 12:13, Robert Haas wrote:
> Could we get away with something as simple as "requested operation is
> not supported for "?
+1. If so, will we have a function to get object names something like
GetPluralFormOfObjectType(Relation rel or char relkind) => char * ?
> But that b
On Sun, Dec 26, 2010 at 10:44 PM, Itagaki Takahiro
wrote:
> On Mon, Dec 27, 2010 at 12:13, Robert Haas wrote:
>> Could we get away with something as simple as "requested operation is
>> not supported for "?
>
> +1. If so, will we have a function to get object names something like
> GetPluralFormO
On Dec 26, 2010, at 7:55 PM, Robert Haas wrote:
> "tables do not support %s"
> "views do not support %s"
> "indexes do not support %s"
The more detail we can give, the better, of course. Nothing's more frustrating
than having a command with an error like, "Object does not support requested
op
Hi,
While inspecting a report from pgpool-II user, I found an interesting
behavior change in 8.2 series.
When connecting to 8.2.13 using 9.0's psql, I got following error
message:
11034 2010-12-27 14:50:57 JST FATAL: unrecognized configuration parameter
"application_name"
However if I connect
On Mon, Dec 27, 2010 at 3:06 PM, Tatsuo Ishii wrote:
> It seems somewhere between 8.2.13 and 8.2.18, an behavior change was
> made. According to a someone who were inspecting this, the change was
> precisely made between 8.2.14 and 8.2.15. I couldn't find related
> item in HISTORY of 8.2.15.
htt
On Mon, Dec 27, 2010 at 6:06 AM, Tatsuo Ishii wrote:
> Hi,
>
> While inspecting a report from pgpool-II user, I found an interesting
> behavior change in 8.2 series.
>
> When connecting to 8.2.13 using 9.0's psql, I got following error
> message:
>
> 11034 2010-12-27 14:50:57 JST FATAL: unrecogni
35 matches
Mail list logo
