[BUGS] tsearch prefix searching doesn't work when last char of prefix is accent char

2011-11-04 Thread Pavel Stehule
Hello I found a following bug create table n(a varchar); postgres=# insert into n values('Stěhule'),('Chromečka'); postgres=# select * from n; a ─── Stěhule Chromečka (2 rows) -- work postgres=# select * from n where to_tsvector('cs', a) @@ to_tsquery('cs','St:*') ; a ──

[BUGS] Re: tsearch prefix searching doesn't work when last char of prefix is accent char

2011-11-04 Thread Pavel Stehule
Hello sorry, this is not bug, it is based on ispell dictionary behave Regards Regards Pavel Stehule -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Jim Jackson (817) 233-2385
So do you have an answer to this issue??? I have not heard from anyone. Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -Original Message- From: Jim Jackson (817) 233-2385 [mailto:jimjac

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Robert Haas
On Fri, Nov 4, 2011 at 11:30 AM, Jim Jackson (817) 233-2385 wrote: > So do you have an answer to this issue??? I have not heard from anyone. Your email with the attachments doesn't seem to have gotten through to the list. If you could perhaps answer the question in a text-format email, it would

Re: [BUGS] BUG #6286: Table Partitioning - SQL/MED - interaction broken

2011-11-04 Thread Robert Haas
On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane wrote: > "Greg Fausak" writes: >> Here is the bug when trying to use the two together with a rule to bind >> them: > >> create rule "_RETURN" as on select to X do instead select * from Y; > > Creating rules on inheritance children isn't supported, and you

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Kevin Grittner
"Jim Jackson (817) 233-2385" wrote: > So do you have an answer to this issue??? I have not heard from > anyone. Your reply to Craig did not show up on the list. Did you "reply all" when you sent it? If you did, the screen shots you mentioned might perhaps have caused the post to be filtered

Re: [BUGS] BUG #6286: Table Partitioning - SQL/MED - interaction broken

2011-11-04 Thread Greg Fausak
Right. Thanks for all the feedback guys. I was just trying to figure out how to do sql/med with partitioned tables. Can't go there, got it. -g On Fri, Nov 4, 2011 at 11:14 AM, Robert Haas wrote: > On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane wrote: > > "Greg Fausak" writes: > >> Here is the bug

Re: [BUGS] BUG #6286: Table Partitioning - SQL/MED - interaction broken

2011-11-04 Thread Tom Lane
Robert Haas writes: > On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane wrote: >> We probably ought to have something in there to throw an error ... > Probably not for rules in general, but we shouldn't let people turn > tables into views if they are involved in table inheritance, as either > a parent or

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Jim Jackson (817) 233-2385
Thank you for the response. I hope this is useful. I downloaded it as part of a poker tracking software. I do not remember what one when this started causing issues I removed that. PostgreSQL 8.4.1 Two example file pathes; C:\users\Jim\Local Settings C:\users\postgres Example of message "C

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Robert Haas
On Fri, Nov 4, 2011 at 12:39 PM, Jim Jackson (817) 233-2385 wrote: > Thank you for the response. I hope this is useful. > > I downloaded it as part of a poker tracking software. I do not remember what > one when this started causing issues I removed that. Probably Holdem Manager. We get regular

Re: [BUGS] BUG #6286: Table Partitioning - SQL/MED - interaction broken

2011-11-04 Thread Robert Haas
On Fri, Nov 4, 2011 at 1:21 PM, Tom Lane wrote: > Robert Haas writes: >> On Thu, Nov 3, 2011 at 5:07 PM, Tom Lane wrote: >>> We probably ought to have something in there to throw an error ... > >> Probably not for rules in general, but we shouldn't let people turn >> tables into views if they ar

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Kevin Grittner
"Jim Jackson (817) 233-2385" wrote: > The postgreSQL was a separate installation step that had to be > done separately from the poker software load to support the poker > software. The question is, where did you get the installation software for that step? If you got it from the poker softwar

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Kevin Grittner
"Jim Jackson (817) 233-2385" wrote: > Does any of that help determine how to get rid of it? It appears that they copied some documentation to your hard drive. I imagine those pages look something like these: http://www.postgresql.org/docs/8.4/static/release.html http://www.postgresql.org/

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Jim Jackson (817) 233-2385
The postgreSQL was a separate installation step that had to be done separately from the poker software load to support the poker software. After it was loaded it would not respond to the passwords that were provided so neither functioned. I did not bother with it for a while then realized I no long

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Jim Jackson (817) 233-2385
Can you tell anything from these documents? postgreSQL release notes.url PostgreSQL documentation.url Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -Original Message- From: Kevin Grit

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Jim Jackson (817) 233-2385
If I were to reload postgreSQL would it over ride the current software on my PC and allow proper access to the files inside the postgre directory? Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Jim Jackson (817) 233-2385
Can you tell anything from these documents? postgreSQL release notes.url PostgreSQL documentation.url Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -Original Message- From: Kevin Grit

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Jim Jackson (817) 233-2385
PostgreSQL 8.4.1 Documentation Prev Fast Backward Fast Forward Next Appendix D. SQL Conformance Table of ContentsD.1. Supported FeaturesD.2. Unsupported Features This section attempts to outline to wha

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Jim Jackson (817) 233-2385
Does any of that help determine how to get rid of it? Thanks Jim Jackson Realtor Regional Sales Manager Century 21 Judge Fite Company Arlington Regional Office (817) 804-3282 Office (817) 233-2385 Cell -Original Message- From: Kevin Grittner [mailto:kevin.gritt...@wicourts.gov] Sent:

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread Jim Jackson (817) 233-2385
PostgreSQL 8.4.1 Documentation The PostgreSQL Global Development Group Copyright C 1996-2009 The PostgreSQL Global Development Group Table of ContentsPrefaceWhat is PostgreSQL?A Brief History of PostgreSQLConven

[BUGS] BUG #6287: Unexpected protocol character during authentication

2011-11-04 Thread Ram
The following bug has been logged online: Bug reference: 6287 Logged by: Ram Email address: ramamohan.raj...@gmail.com PostgreSQL version: don't know Operating system: Linux Description:Unexpected protocol character during authentication Details: My odbc.ini is like

Re: [BUGS] BUG #6281: need to remove

2011-11-04 Thread John R Pierce
On 11/04/11 1:07 PM, Jim Jackson (817) 233-2385 wrote: The postgreSQL was a separate installation step that had to be done separately from the poker software load to support the poker software. After it was loaded it would not respond to the passwords that were provided so neither functioned. I d

Re: [BUGS] BUG #6287: Unexpected protocol character during authentication

2011-11-04 Thread Tom Lane
"Ram" writes: > My odbc.ini is like below: > --- > [FH1SQL1] > Description = PostgreSQL connection to 'dbProjNum' database > Driver = /usr/lib64/libodbcpsql.so.2.0.0 > Setup = /usr/lib64/libodbcpsqlS.so.1.0.0 You're apparently using the very obsolete and buggy Postgres ODB