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
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
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 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
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 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: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
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 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
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
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
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
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
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 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
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 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
=?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 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
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:"
=?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: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
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
=?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
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
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
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
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.
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
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
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 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 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 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 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
35 matches
Mail list logo
