Re: [HACKERS] [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY

2009-01-10 Thread Robert Haas
> 2009/1/10 Tom Lane : >> Bruce Momjian writes: >>> Uh, is this ready to be applied? >> >> I don't think any consensus has been reached on changing this behavior. > > I thing, so this is bug - RETURN QUERY has to supply FOR SELECT LOOP > RETURN NEXT pattern. > > My first patch expected so RETURN

Re: [HACKERS] [BUGS] BUG #4516: FOUND variable does not work after RETURN QUERY

2009-02-04 Thread Robert Haas
On Wed, Feb 4, 2009 at 1:32 PM, Bruce Momjian wrote: > Robert Haas wrote: >> > 2009/1/10 Tom Lane : >> >> Bruce Momjian writes: >> >>> Uh, is this ready to be applied? >> >> >> >> I don't think any consensus has been reached on

Re: [HACKERS] [BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7

2009-06-09 Thread Robert Haas
On Tue, Jun 9, 2009 at 12:07 PM, Tom Lane wrote: > The technically best solution is probably similar to what Materialize > nodes do, ie, read the query only once and be careful to stash rows > aside into a tuplestore as they are read.  This would fix both issues > with one patch.  The problem with

Re: [HACKERS] [BUGS] Cursor with hold emits the same row more than once across commits in 8.3.7

2009-06-09 Thread Robert Haas
On Tue, Jun 9, 2009 at 1:47 PM, Tom Lane wrote: > Robert Haas writes: >> This seems like the only option that will produce correct answers, so >> it gets my vote.  How much is the performance penalty for >> materializing the tuplestore?  I'm inclined to think that whatev

Re: [BUGS] Installation problems

2009-07-15 Thread Robert Haas
On Wed, Jul 15, 2009 at 7:18 PM, Don Fox wrote: > I am having  installation problems with postrgesql on my mac. I'v tried > MacPorts, your site and PostgreSQLforMac. I've tried 8.3.7 and the most > current version. After each install I'm unable to locate any actual access > to the DB. When installi

Re: [BUGS] fix: plpgsql: return query and dropped columns problem

2009-07-28 Thread Robert Haas
On Tue, Jul 21, 2009 at 2:13 AM, Pavel Stehule wrote: > 2009/7/21 Jaime Casanova : >> On Mon, Jul 20, 2009 at 11:34 AM, Jaime >> Casanova wrote: >>> On Mon, Jul 20, 2009 at 10:09 AM, Alvaro Getting rid of the check on natts was "ungood" ... it needs to compare the number of undropped

Re: [BUGS] fix: plpgsql: return query and dropped columns problem

2009-07-28 Thread Robert Haas
On Tue, Jul 28, 2009 at 1:19 PM, Jaime Casanova wrote: > On Tue, Jul 28, 2009 at 12:12 PM, Robert Haas wrote: >>>> >>>> patch attached >>>> >>> super, thanks >>> >>> Pavel >> >> So is this Ready for Committer? &g

Re: [BUGS] BUG #4945: Parallel update(s) gone wild

2009-07-28 Thread Robert Haas
On Jul 28, 2009, at 1:16 PM, "Dan Boeriu" wrote: I am doing a reply-all - hope that's fine. The pg_locks shows only locks held by that Postgresql process - I am the only one on the box. pg_stat_activity shows 2 things: 1) the update 2) vacuum on the updated table Now, I tried to isolate th

Re: [BUGS] BUG #4949: NOT IN is prohibitive slower than the rewrite for medium to large sets

2009-07-28 Thread Robert Haas
On Jul 28, 2009, at 9:47 AM, Tom Lane wrote: "Ole Tange" writes: (modulo NULLs which seem to always cause problems in NOT INs). Because it can be rewritten, NOT IN should never be much slower than the rewritten solution, as PostgreSQL should simply rewrite NOT IN to the above. Let's se

Re: [BUGS] BUG #4950: Problem in Job scheduling in Advanced postgre sql

2009-07-29 Thread Robert Haas
On Tue, Jul 28, 2009 at 9:26 AM, Ramakanth wrote: > > The following bug has been logged online: > > Bug reference:      4950 > Logged by:          Ramakanth > Email address:      ramaka...@iblesoft.com > PostgreSQL version: Advanced 8.3 R2 > Operating system:   Windows xp > Description:        Prob

Re: [BUGS] BUG #4925: "select ... for update" doesn't affect rows from sub-query

2009-07-29 Thread Robert Haas
On Thu, Jul 16, 2009 at 12:34 PM, Steve Caligo wrote: > > The following bug has been logged online: > > Bug reference:      4925 > Logged by:          Steve Caligo > Email address:      steve.cal...@ctie.etat.lu > PostgreSQL version: 8.3.7 and 8.4.0 > Operating system:   Archlinux and Gentoo 8.3.7,

Re: [BUGS] BUG #4925: "select ... for update" doesn't affect rows from sub-query

2009-07-30 Thread Robert Haas
On Thu, Jul 30, 2009 at 1:40 AM, Steve Caligo wrote: > Allowing FOR UPDATE in sub-queries has been rejected in this same thread, > you've also mentioned it your previous reply. > http://archives.postgresql.org/pgsql-bugs/2004-10/msg00150.php Um, I didn't write that email. That was Tom Lane. >> T

Re: [BUGS] BUG #4946: bug - libiconv-2.dll

2009-08-06 Thread Robert Haas
On Mon, Jul 27, 2009 at 8:06 PM, Fabiano wrote: > > The following bug has been logged online: > > Bug reference:      4946 > Logged by:          Fabiano > Email address:      fabiano.san...@onda.com.br > PostgreSQL version: 8.3 > Operating system:   windows > Description:        bug - libiconv-2.dl

Re: [BUGS] BUG #4965: missing tests in tools/fsync/test_fsync.c

2009-08-08 Thread Robert Haas
On Wed, Aug 5, 2009 at 10:46 AM, Jeff Janes wrote: > > The following bug has been logged online: > > Bug reference:      4965 > Logged by:          Jeff Janes > Email address:      jeff.ja...@gmail.com > PostgreSQL version: 8.4.0 > Operating system:   Linux > Description:        missing tests in to

Re: [BUGS] BUG #4959: unable to install/start service

2009-08-08 Thread Robert Haas
On Fri, Jul 31, 2009 at 11:00 AM, wrote: > > The following bug has been logged online: > > Bug reference:      4959 > Logged by: > Email address:      wad...@jcom.home.ne.jp > PostgreSQL version: 8.4.0 > Operating system:   Windows > Description:        unable to install/start service > Details: >

Re: [BUGS] BUG #4969: ajuda

2009-08-09 Thread Robert Haas
On Thu, Aug 6, 2009 at 3:09 PM, Dielton Paulo wrote: > > The following bug has been logged online: > > Bug reference:      4969 > Logged by:          Dielton Paulo > Email address:      dpa...@sefaz.ba.gov.br > PostgreSQL version: 8.4 > Operating system:   Windows XP > Description:        ajuda > D

Re: [BUGS] BUG #4970: Broken link in manual

2009-08-09 Thread Robert Haas
On Fri, Aug 7, 2009 at 12:31 AM, Rob Wultsh wrote: > > The following bug has been logged online: > > Bug reference:      4970 > Logged by:          Rob Wultsh > Email address:      wult...@gmail.com > PostgreSQL version: 8.4 > Operating system:   N/A > Description:        Broken link in manual > De

Re: [BUGS] Huge speed penalty using <>TRUE instead of =FALSE

2009-08-10 Thread Robert Haas
On Fri, Jul 17, 2009 at 10:21 AM, Tom Lane wrote: > Peter Eisentraut writes: >> ... But again, this is data type specific knowledge. > > Actually, now that I think about it, the planner already has > datatype-specific knowledge about boolean equality (see > simplify_boolean_equality).  It would ta

Re: [BUGS] BUG #4972: RFE: convert timestamps to fractional seconds

2009-08-10 Thread Robert Haas
On Mon, Aug 10, 2009 at 8:52 AM, Richard Neill wrote: > What I think I meant was dividing a differential timestamp by an interval. > In this case, both should be unambiguously expressed in seconds, and the > result will be dimensionless. And what will you get when you divide 1 month by 1 day? ...

Re: [BUGS] Huge speed penalty using <>TRUE instead of =FALSE

2009-08-10 Thread Robert Haas
On Mon, Aug 10, 2009 at 11:10 AM, Tom Lane wrote: > Robert Haas writes: >> On Fri, Jul 17, 2009 at 10:21 AM, Tom Lane wrote: >>> Actually, now that I think about it, the planner already has >>> datatype-specific knowledge about boolean equality (see >>> simpli

Re: [BUGS] Connections closed unexpectedly

2009-08-11 Thread Robert Haas
On Fri, Aug 7, 2009 at 7:50 AM, psqluser wrote: > I am getting the below error repeatedly in postgres 8.3 > > 2009-08-07 15:19:35.749 ISTLOG:  unexpected EOF on client connection > 2009-08-07 15:31:47.718 ISTWARNING:  worker took too long to start; > cancelled > 2009-08-07 15:32:22.825 ISTWARNING:

Re: [BUGS] BUG #4980: Dblink issue

2009-08-13 Thread Robert Haas
On Wed, Aug 12, 2009 at 8:00 AM, Gaurav K Srivastava wrote: > > The following bug has been logged online: > > Bug reference:      4980 > Logged by:          Gaurav K Srivastava > Email address:      gaurav...@gmail.com > PostgreSQL version: 8.3 > Operating system:   Windows xp > Description:      

Re: [BUGS] Malfunction in dropping database with pgAdmin

2009-08-13 Thread Robert Haas
On Tue, Aug 11, 2009 at 2:40 AM, Sergei Abramov wrote: > Platform: Windows XP, 5.1 (Build 2600).Language: Russain. > Distribution used: Binary. > pgAdmin version: 1.10.0. > PostgreSQL version: 8.4.0-1. > > Bug description: When I use pgAdmin's menu command 'Delete/drop' to drop > database, especial

Re: [BUGS] BUG #4976: pgadmin - reconnect to drop database

2009-08-13 Thread Robert Haas
On Wed, Aug 12, 2009 at 3:28 AM, Jim Michaels wrote: > > The following bug has been logged online: > > Bug reference:      4976 > Logged by:          Jim Michaels > Email address:      jmich...@yahoo.com > PostgreSQL version: 8.4.0 > Operating system:   Windows XP Pro SP3 > Description:        pgad

Re: [BUGS] Stalled post to pgsql-bugs

2009-08-14 Thread Robert Haas
On Fri, Aug 14, 2009 at 1:35 AM, Saneera Gunasekara wrote: > > Dear Sir > > I have got the following error message when connecting postgres from > postgres admin connecting form the localhost > (only special thing in machine configuration is attached the 2 network cards > to the installation machin

Re: [BUGS] BUG #4984: One click Installation error.

2009-08-17 Thread Robert Haas
On Thu, Aug 13, 2009 at 2:32 AM, Carlos B Netto wrote: > > The following bug has been logged online: > > Bug reference:      4984 > Logged by:          Carlos B Netto > Email address:      cobbne...@hotmail.com > PostgreSQL version: 8.4.0-1 > Operating system:   Windows Server 2003 > Description:  

Re: [BUGS] BUG #4975: Not properly installed during the installation comes out an alert

2009-08-17 Thread Robert Haas
On Wed, Aug 12, 2009 at 2:11 AM, Hans wrote: > > The following bug has been logged online: > > Bug reference:      4975 > Logged by:          Hans > Email address:      nanjangmu...@naver.com > PostgreSQL version: 8.4.0 > Operating system:   Windows Server 2003 Standard Edition KN Service Pack 2 >

Re: [BUGS] BUG #4971: Backend crash while doing nothing...

2009-08-17 Thread Robert Haas
On Sun, Aug 9, 2009 at 4:51 PM, Daniel Migowski wrote: > > The following bug has been logged online: > > Bug reference:      4971 > Logged by:          Daniel Migowski > Email address:      dmigow...@ikoffice.de > PostgreSQL version: 8.3.5 > Operating system:   Windows XP > Description:        Back

Re: [BUGS] Regarding permissions

2009-08-21 Thread Robert Haas
On Wed, Aug 19, 2009 at 5:45 AM, Gaurav K Srivastav wrote: > HI, > > I have a normal user  'abcd' and grant all previliges to this user on the > database 'pqr'. > now i am unable to use dblink(text,text). > while via super user 'postgre' which is the owner of database  'postgre'  I > am able to use

Re: [BUGS] When Drop Table or alter Table I need restart service Posgresql - 8.1 ?????

2009-08-21 Thread Robert Haas
On Fri, Aug 21, 2009 at 10:36 AM, fabiofurlan wrote: > > Hi. > > I do not any idea. > > When i drop table or alter table, i need restart service postgresql 8.1, > because is impossible new connect or > because the changes are not visible. > > Gnu Linux Debian 4.0 > PostgreSQL 8.1 > > > Thanks a lot

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Robert Haas
On Mon, Aug 24, 2009 at 8:24 AM, Brian Ceccarelli wrote: > Yes.   I understand.   It has all to do with Unicode collating sequence.  I > need to somehow remove this bug from the list, since it is not a bug. Heh. As far as I understand, there is no list... one thing that I have been worrying abou

Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false . . .

2009-08-24 Thread Robert Haas
On Mon, Aug 24, 2009 at 3:10 PM, Greg Stark wrote: > On Mon, Aug 24, 2009 at 8:03 PM, Alvaro > Herrera wrote: >> Personally I still think debbugs would suit us perfectly, but 1. I don't >> have time to handle it, 2. nobody else believes this, 3. the debbugs >> developers are not very interested in

Re: [BUGS] BUG #5019: Nao funciona

2009-08-27 Thread Robert Haas
On Thu, Aug 27, 2009 at 12:49 PM, Eduardo wrote: > > The following bug has been logged online: > > Bug reference:      5019 > Logged by:          Eduardo > Email address:      edua...@vip10.com.br > PostgreSQL version: 8.3 > Operating system:   Vista 64 bits > Description:        Nao funciona > Det

Re: [BUGS] BUG #5019: Nao funciona

2009-08-27 Thread Robert Haas
2009/8/27 Alvaro Herrera : > Robert Haas escribió: > >> Para obtener ayuda en espan~ol, tal vez puede Ud. tratar >> pgsql-es-ay...@postgresql.org.  Creo que no tenemos una list de correo >> en Portugue's. > > It lives in another list server: > https://li

Re: [BUGS] BUG #5013: Error in psqlodbc configuration

2009-08-28 Thread Robert Haas
On Wed, Aug 26, 2009 at 5:55 AM, Ishara wrote: > > The following bug has been logged online: > > Bug reference:      5013 > Logged by:          Ishara > Email address:      ishara...@gmail.com > PostgreSQL version: 8.4 > Operating system:   Solaris x86 > Description:        Error in psqlodbc config

Re: [BUGS] BUG #5003: setup error

2009-08-28 Thread Robert Haas
On Fri, Aug 21, 2009 at 9:35 AM, Pramod wrote: > > The following bug has been logged online: > > Bug reference:      5003 > Logged by:          Pramod > Email address:      pramodchoudhar...@yahoo.com > PostgreSQL version: 8.4.0-1 > Operating system:   Windows XP > Description:        setup error >

Re: [BUGS] BUG #5027: SQL query error?

2009-09-02 Thread Robert Haas
On Tue, Sep 1, 2009 at 9:51 AM, Dmitry wrote: > > The following bug has been logged online: > > Bug reference:      5027 > Logged by:          Dmitry > Email address:      mas...@hsdesign.ru > PostgreSQL version: 8.3.5 > Operating system:   ALT Linux > Description:        SQL query error? > Details

Re: [BUGS] BUG #5028: CASE returns ELSE value always when type is"char"

2009-09-02 Thread Robert Haas
On Wed, Sep 2, 2009 at 11:55 AM, Sam Mason wrote: > In fact it doesn't seem to want to play ball at all.  Even given the > apparently unambiguous: > >  SELECT 1+add(1,2); > or >  SELECT 'hi'||add(1,2); > > It doesn't get anywhere.  No need for "text 'hi'" in the second one > because || isn't define

Re: [BUGS] BUG #5028: CASE returns ELSE value always when type is"char"

2009-09-02 Thread Robert Haas
On Wed, Sep 2, 2009 at 3:34 PM, Sam Mason wrote: > On Wed, Sep 02, 2009 at 12:54:03PM -0500, Kevin Grittner wrote: >> Sam Mason wrote: >> > If we did follow Kevin's request directly, should we also be >> > specifying the type of NULL? >> >> I don't *think* the SQL standard requires that, and barri

Re: [BUGS] BUG #5032: unexpected syntax error for plpgsql function returns table

2009-09-03 Thread Robert Haas
On Sep 2, 2009, at 11:27 PM, Pavel Stehule wrote: Hello it's not bug - PostgreSQL doesn't support parameter placeholder on this position. Use dynamic query instead - plpgsql statement EXECUTE. It may not be a bug exactly, but it sure isn't a feature. ...Robert -- Sent via pgsql-bugs mail

Re: [BUGS] BUG #5028: CASE returns ELSE value always when type is "char"

2009-09-04 Thread Robert Haas
On Fri, Sep 4, 2009 at 11:15 AM, Tom Lane wrote: > I certainly don't want to have "char" emulate the misbegotten decision > to have explicit and implicit coercions behave differently.  So it > looks to me like the argument to make "char" work like char(1) doesn't > actually help us much to decide i

Re: [BUGS] BUG #5028: CASE returns ELSE value always when type is "char"

2009-09-04 Thread Robert Haas
On Fri, Sep 4, 2009 at 11:59 AM, Kevin Grittner wrote: > Tom Lane wrote: > >> I certainly don't want to have "char" emulate the misbegotten >> decision to have explicit and implicit coercions behave differently. >> So it looks to me like the argument to make "char" work like char(1) >> doesn't act

Re: [BUGS] BUG #5034: plperlu problem with gethostbyname

2009-09-04 Thread Robert Haas
On Thu, Sep 3, 2009 at 5:21 PM, Diego de Lima wrote: > > The following bug has been logged online: > > Bug reference:      5034 > Logged by:          Diego de Lima > Email address:      diego_de_l...@hotmail.com > PostgreSQL version: 8.3.7 > Operating system:   Linux Fedora 10 > Description:      

Re: [BUGS] BUG #5010: perl iconv function returns ? character

2009-09-04 Thread Robert Haas
On Tue, Aug 25, 2009 at 8:15 AM, Lampa wrote: > > The following bug has been logged online: > > Bug reference:      5010 > Logged by:          Lampa > Email address:      lamp...@gmail.com > PostgreSQL version: 8.4.0 > Operating system:   Debian testing/unstable > Description:        perl iconv fun

Re: [BUGS] BUG #5034: plperlu problem with gethostbyname

2009-09-06 Thread Robert Haas
On Sep 5, 2009, at 6:52 PM, Tom Lane wrote: Robert Haas writes: On Thu, Sep 3, 2009 at 5:21 PM, Diego de Lima> wrote: Using Fedora 10 default rpm packages, all updated last month via yum. I can't reproduce this on a clean build of 8.3.7 or on a clean build of CVS HEAD, both agai

Re: [BUGS] need higher extra_float_digits value (3)

2009-09-09 Thread Robert Haas
On Wed, Sep 9, 2009 at 6:04 PM, Tom Lane wrote: > Keh-Cheng Chu writes: >> While 17 decimal digits are sufficient to guarantee the >> complete recovery of all 64-bit double values, some 32-bit >> reals actually require NINE significant figures. > > Hm, annoying.  Seems like we could do one of two

Re: [BUGS] BUG #5053: domain constraints still leak

2009-09-14 Thread Robert Haas
On Sun, Sep 13, 2009 at 10:28 PM, Tom Lane wrote: > "Andrew Gierth" writes: >> Domain NOT NULL constraints (and probably other constraints too) aren't >> being enforced in some code paths. e.g. > > The example you give seems to tie really closely into the debate about > whether a composite null i

Re: [BUGS] BUG #5046: java developer

2009-09-14 Thread Robert Haas
On Wed, Sep 9, 2009 at 5:42 AM, mahmoud badr wrote: > > The following bug has been logged online: > > Bug reference:      5046 > Logged by:          mahmoud badr > Email address:      alien_...@yahoo.com > PostgreSQL version: 8.4 > Operating system:   windows > Description:        java developer >

Re: [BUGS] BUG #5053: domain constraints still leak

2009-09-14 Thread Robert Haas
On Mon, Sep 14, 2009 at 10:22 AM, Tom Lane wrote: > Robert Haas writes: >> It seems like regardless of this discussion you oughtn't to be able to >> store a NULL into that table column.  But maybe I'm just confused. > > The system is relying on the not-unr

Re: [BUGS] BUG #5047: Not able to connect from Informatica

2009-09-14 Thread Robert Haas
On Thu, Sep 10, 2009 at 7:17 AM, Rohan jamadagni wrote: > > The following bug has been logged online: > > Bug reference:      5047 > Logged by:          Rohan jamadagni > Email address:      rohan.jamada...@tcs.com > PostgreSQL version: 8.3.7 > Operating system:   Linux Rhel 5.0 > Description:    

Re: [BUGS] BUG #5037: jdbc bug \uffff

2009-09-14 Thread Robert Haas
On Fri, Sep 4, 2009 at 6:02 PM, Rob Resendez wrote: > The following bug has been logged online: > > Bug reference:      5037 > Logged by:          Rob Resendez > Email address:      rob.resen...@cpsinet.com > PostgreSQL version: 8.3.7 > Operating system:   Linux > Description:        jdbc bug \uff

Re: [BUGS] BUG #5056: SQLDescribeColW for function returning a result set incorrectly setting sql_nullable

2009-09-14 Thread Robert Haas
On Mon, Sep 14, 2009 at 10:40 PM, the6campbells wrote: > > The following bug has been logged online: > > Bug reference:      5056 > Logged by:          the6campbells > Email address:      the6campbe...@gmail.com > PostgreSQL version: 8.4.1 > Operating system:   windows > Description:        SQLDes

Re: [BUGS] error: message type 0x5a arrived from server while idle

2009-09-15 Thread Robert Haas
On Tue, Sep 8, 2009 at 11:38 PM, vyou zhi wrote: > hi all: > > i use Python and PyGreSQL to link  PostgreSQL > but the Python give me the error > > the error here : > > ... > 95 > 93 > 95 > 97 > 94 > 96 > 94 > message type 0x43 arrived from server while

Re: [BUGS] GIN needs tonic

2009-09-15 Thread Robert Haas
On Tue, Sep 15, 2009 at 4:41 PM, Simon Riggs wrote: > I guess if you or another committer spends some time writing a test > framework that is useful and that you can trust, I'm sure many people > will add to it. That'll be true for any of the major/complex areas not > covered by public test suites

Re: [BUGS] BUG #5058: [jdbc] Silent failure with executeUpdate()

2009-09-15 Thread Robert Haas
On Tue, Sep 15, 2009 at 3:26 PM, Joseph Shraibman wrote: > > The following bug has been logged online: > > Bug reference:      5058 > Logged by:          Joseph Shraibman > Email address:      ...@selectacast.net > PostgreSQL version: 8.2.14 > Operating system:   Linux > Description:        [jdbc]

Re: [BUGS] BUG #5042: Update numeric within a rule

2009-09-15 Thread Robert Haas
On Sun, Sep 6, 2009 at 4:48 PM, Ilian Georgiev wrote: > > The following bug has been logged online: > > Bug reference:      5042 > Logged by:          Ilian Georgiev > Email address:      georgiev.il...@gmail.com > PostgreSQL version: 8.1.10 > Operating system:   Windows XP > Description:        U

Re: [BUGS] BUG #5059: Planner ignores estimates when planning an IN () subquery

2009-09-16 Thread Robert Haas
On Tue, Sep 15, 2009 at 11:35 PM, Kenaniah Cerny wrote: > > The following bug has been logged online: > > Bug reference:      5059 > Logged by:          Kenaniah Cerny > Email address:      kenan...@gmail.com > PostgreSQL version: 8.4.1 > Operating system:   Centos5.2 > Description:        Planner

Re: [BUGS] BUG #5059: Planner ignores estimates when planning an IN () subquery

2009-09-16 Thread Robert Haas
On Wed, Sep 16, 2009 at 6:39 PM, Kenaniah Cerny wrote: > I can provide the output of statistics queries if you would like. Just let > me know which statistics you want and I'll pastebin them. > > As far as selectivity goes, the selectivity estimate for the > user_anime_log.user_account_id was defi

Re: [BUGS] Wrong default values of columns

2009-09-17 Thread Robert Haas
On Thu, Sep 17, 2009 at 8:15 AM, Andre Rothe wrote: > Hi, > > I have installed Postgres 8.3.8 on Fedora Linux. If I create a table, > the default values will be set by the database to > > NULL::timestamp without time zone > > for a timezone column and to > > NULL::character varying > > for a varch

Re: [BUGS] Wrong default values of columns

2009-09-17 Thread Robert Haas
On Thu, Sep 17, 2009 at 10:44 AM, Andre Rothe wrote: > The problem is, that I get the default values from a metadata query > with JDBC, > so I have to parse every return value for such an annotation before I > can > use them. That sounds annoying, but it's not a PostgreSQL bug. > So it seems tha

Re: [BUGS] BUG #5063: MS Access crashes by quiting after linking tables with PostgreSQL

2009-09-18 Thread Robert Haas
On Fri, Sep 18, 2009 at 5:45 AM, Annita wrote: > > The following bug has been logged online: > > Bug reference:      5063 > Logged by:          Annita > Email address:      annita.ven...@qs-unisolution.com > PostgreSQL version: 8 > Operating system:   Windows > Description:        MS Access  crash

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-19 Thread Robert Haas
On Sat, Sep 19, 2009 at 3:53 PM, Tom Lane wrote: > "Tim Bunce" writes: >> The plperl implementation doesn't call perl_destruct() during server >> shutdown. > > Who cares?  The process is going away anyway. END {} blocks can execute arbitrary code. Perl users will expect them to be executed. ..

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread Robert Haas
On Mon, Sep 21, 2009 at 12:06 PM, Alvaro Herrera wrote: > David Fetter escribió: > >> Taken literally, that would mean, "the last action before the backend >> exits," but at least to me, that sounds troubling for the same reasons >> that "end of transaction" triggers do.  What happens when there a

Re: [BUGS] BUG #5053: domain constraints still leak

2009-09-21 Thread Robert Haas
On Mon, Sep 21, 2009 at 12:31 PM, Bruce Momjian wrote: > Sam Mason wrote: >> On Mon, Sep 14, 2009 at 10:54:07AM -0500, Kevin Grittner wrote: >> > Sam Mason wrote: >> > > the deeper problem seems to be that the table was created as: >> > > >> > >   create table test (a tstdom); >> > > >> > > and n

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread Robert Haas
On Mon, Sep 21, 2009 at 2:17 PM, David Fetter wrote: > On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote: >> David Fetter escribió: >> > On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote: >> > > David Fetter escribió: >> > > >> > > > Taken literally, that would mean, "the

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-21 Thread Robert Haas
On Mon, Sep 21, 2009 at 3:08 PM, Alvaro Herrera wrote: > David Fetter escribió: >> On Mon, Sep 21, 2009 at 01:06:17PM -0400, Alvaro Herrera wrote: > >> > The fine manual saith >> > >> >     You may have multiple "END" blocks within a file--they will >> >     execute in reverse order of definition;

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-22 Thread Robert Haas
On Mon, Sep 21, 2009 at 7:30 PM, Tom Lane wrote: > David Fetter writes: >> On Mon, Sep 21, 2009 at 12:06:30PM -0400, Alvaro Herrera wrote: With connection poolers, backends can last quite awhile.  Is it OK for the END block to run hours after the rest of the code? >>> >>> This is an int

Re: [BUGS] BUG #5066: plperl issues with perl_destruct() and END blocks

2009-09-22 Thread Robert Haas
On Tue, Sep 22, 2009 at 10:13 AM, Tom Lane wrote: > Robert Haas writes: >> If the changes are simple, as Tim seems to believe, exactly what do we >> lose by doing this? > > It's not simple.  There are any number of issues that Tim has not > addressed.  The most obvi

Re: [BUGS] Problem installing Postgres 8.4.1

2009-09-22 Thread Robert Haas
On Mon, Sep 21, 2009 at 3:23 PM, Christine Penner wrote: > At 11:57 AM 21/09/2009, you wrote: >> >> What error you get when you run initdb?? (Also what exact command you >> run?) > > The first time I just double clicked on the file initdb.exe. Just now I > tried to run it through the command promp

Re: [BUGS] Encounter shared memory error when running createlang command!

2009-09-23 Thread Robert Haas
2009/9/23 Yaming Gu > > > Hi, List > > Because I need to use pl/perl language, then I decided to run “createlang” > to create PL/Perl language. I have checked all dependencies and all is ok. > > Next I run: D:\Program Files\Postgresql\bin>createlang �CU postgres plperl > example (example is my

Re: [BUGS] BUG #5081: ON INSERT rule does not work correctly

2009-09-27 Thread Robert Haas
On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane wrote: > "Stefan" writes: >> The problem is that if it is no record in the table, it seems that first the >> INSERT command is issued and after that the UPDATE command is issued, too. > > Well, yeah.  That's exactly how it's documented to work: an ON INS

Re: [BUGS] BUG #5081: ON INSERT rule does not work correctly

2009-09-27 Thread Robert Haas
On Sun, Sep 27, 2009 at 11:36 AM, Tom Lane wrote: > Robert Haas writes: >> On Sat, Sep 26, 2009 at 12:35 PM, Tom Lane wrote: >>> Well, yeah.  That's exactly how it's documented to work: an ON INSERT >>> rule is executed after the INSERT proper. > >

Re: [BUGS] BUG #5082: I can't get logfile( achive )

2009-09-27 Thread Robert Haas
On Fri, Sep 25, 2009 at 11:50 AM, smuffy wrote: > > The following bug has been logged online: > > Bug reference:      5082 > Logged by:          smuffy > Email address:      vday1...@gmail.com > PostgreSQL version: 8.4.0 > Operating system:   opensuse 10.2 > Description:        I can't get logfile

Re: [BUGS] Encounter shared memory error when running createlang command!

2009-09-27 Thread Robert Haas
On Wed, Sep 23, 2009 at 11:44 PM, Yaming Gu wrote: > 2009-09-24 10:50:55 HKT LOG:  loaded library > "$libdir/plugins/plugin_debugger.dll" > > 2009-09-24 10:50:59 HKT LOG:  loaded library > "$libdir/plugins/plugin_debugger.dll" > > Substitution pattern not terminated at line 1. I'm very suspicious

Re: [BUGS] BUG #5071: abbrev() bug with IPv6

2009-09-27 Thread Robert Haas
On Tue, Sep 22, 2009 at 12:54 AM, wrote: > > The following bug has been logged online: > > Bug reference:      5071 > Logged by: > Email address:      alexander.o...@koeln.de > PostgreSQL version: 8.3.7 > Operating system:   Debian Lenny 64Bit > Description:        abbrev() bug with IPv6 > Detail

Re: [BUGS] Databse installation problem

2009-09-27 Thread Robert Haas
On Mon, Sep 21, 2009 at 1:53 AM, Bhushan Verma wrote: > > I have tried to install postgres version 8.3.7 as follows > > rm -rf /var/lib/pgsql > mkdir /var/lib/pgsql > ./configure --prefix /var/lib/pgsql > gmake > su > gmake install > adduser postgres > mkdir /var/lib/pgsql/data > chown postgres /v

Re: [BUGS] PROBLEMA AL INSTALAR POSTSGRESQL

2009-09-27 Thread Robert Haas
2009/9/17 Paola R. > > > buenas tardes >  estoy tratando de instalar postgresql 8.2 pero en la parte "initialise > databasecluster" cuando ingreso un el password al dar next>>  me sale el > siguiente mensaje: > > the "secondary logon" service is not running. this service is required for > the i

Re: [BUGS] BUG #5075: Text Search parser does not identify xml tag when attribute name's contains underscore

2009-09-27 Thread Robert Haas
On Wed, Sep 23, 2009 at 7:31 PM, Euler Taveira de Oliveira wrote: > Marek Lewczuk escreveu: >> Please execute following example: >> select * from ts_debug('english', '> align="right" style="margin: 0px 0px 5px 5px;" test_aa="26461"/>') >> >> As the result you will see, that is not identified as X

Re: [BUGS] BUG #5081: ON INSERT rule does not work correctly

2009-09-28 Thread Robert Haas
On Mon, Sep 28, 2009 at 10:12 AM, Jacques Caron wrote: > Hi, > > You can use a trigger before insert and a pl/pgsql function that goes: > > BEGIN >  UPDATE table SET ... WHERE pk=NEW.pk >  IF FOUND THEN >  RETURN NULL; >  ELSE >  RETURN NEW; >  END IF; > END; > > Jacques. That seems about right.

[BUGS] Re: 答复: [BUGS] Encounter shared memory error whe n running createlang command!

2009-09-28 Thread Robert Haas
On Mon, Sep 28, 2009 at 2:51 AM, Yaming Gu wrote: > > Thank you so much for your kind reply. > Your analysis sounds very reasonable. I checked my Perl version, it is "Perl > 5.8.9 Build 826" which is the latest version in the series of 5.8.*. > The whole process of installation of Perl goes well

Re: [BUGS] BUG #5088: community account not working

2009-09-30 Thread Robert Haas
On Tue, Sep 29, 2009 at 11:15 PM, Ian Small wrote: > > The following bug has been logged online: > > Bug reference:      5088 > Logged by:          Ian Small > Email address:      i...@omniconnect.com.au > PostgreSQL version: any > Operating system:   any > Description:        community account no

Re: Re[BUGS] g: 25P02, current transaction is aborted, commands ignored until end of transaction block

2009-09-30 Thread Robert Haas
On Wed, Sep 30, 2009 at 5:23 AM, ajay labade wrote: >>     I am trying to port my application from Oracle to PostGREs. I have a >> problem while doing so. In my application i need to update record if the >> delete on the respective record is failed due to Constraint Violation. But >> SQL Error: 0,

Re: [BUGS] BUG #5090: erro

2009-10-02 Thread Robert Haas
On Wed, Sep 30, 2009 at 7:11 AM, Edinei wrote: > > The following bug has been logged online: > > Bug reference:      5090 > Logged by:          Edinei > Email address:      edi...@guaporepecuaria.com.br > PostgreSQL version: 8.4 > Operating system:   Windows XP > Description:        erro > Details

Re: [BUGS] BUG #5089: not supported plpsql

2009-10-02 Thread Robert Haas
On Wed, Sep 30, 2009 at 4:33 AM, Yamashkin Alex wrote: > > The following bug has been logged online: > > Bug reference:      5089 > Logged by:          Yamashkin Alex > Email address:      defa...@smart-soft.ru > PostgreSQL version: 8.4.0.1 > Operating system:   windows XP Embeded > Description:  

[SPAM?]Re: [BUGS] BUG #5089: not supported plpsql

2009-10-02 Thread Robert Haas
On Wed, Sep 30, 2009 at 4:33 AM, Yamashkin Alex wrote: > > The following bug has been logged online: > > Bug reference:      5089 > Logged by:          Yamashkin Alex > Email address:      defa...@smart-soft.ru > PostgreSQL version: 8.4.0.1 > Operating system:   windows XP Embeded > Description:  

Re: [BUGS] BUG #5083: Problem create account.

2009-10-03 Thread Robert Haas
On Sun, Sep 27, 2009 at 5:29 PM, Jesper wrote: > > The following bug has been logged online: > > Bug reference:      5083 > Logged by:          Jesper > Email address:      sol...@hotmail.com > PostgreSQL version: 8,3 > Operating system:   Vista > Description:        Problem create account. > Deta

Re: [BUGS] vacuumdb error

2009-10-16 Thread Robert Haas
On Fri, Oct 16, 2009 at 6:39 AM, Heikki Linnakangas wrote: > Thom Brown wrote: >> This is either a bug in vacuumdb with it not using the correct order, >> or postgres shouldn't be paying attention to the order of the >> keywords.  In any case, it doesn't work.  I've searched the postgres >> FAQs,

Re: [BUGS] BUG #5118: start-status-insert-fatal

2009-10-16 Thread Robert Haas
On Fri, Oct 16, 2009 at 10:33 AM, Kevin Grittner wrote: > Pedro Gimeno wrote: >> Tom Lane wrote: >> >>> This could be addressed by having the postmaster report its $PGDATA >>> value in the pg_ping response, but I would be against that on >>> security grounds.  We don't let nonprivileged users kno

Re: [BUGS] BUG #5118: start-status-insert-fatal

2009-10-16 Thread Robert Haas
On Fri, Oct 16, 2009 at 11:08 AM, Kevin Grittner wrote: > Robert Haas wrote: > >> Well, then Tom's idea of using a random number seems pretty solid no >> matter how you slice it.  Maybe a UUID. > > A random number is looking like the best option.  I'm not

Re: [BUGS] BUG #5118: start-status-insert-fatal

2009-10-16 Thread Robert Haas
On Fri, Oct 16, 2009 at 2:04 PM, Kevin Grittner wrote: > Robert Haas wrote: > >> UUIDs throw away 6 bits? > > http://en.wikipedia.org/wiki/Universally_Unique_Identifier#Version_4_.28random.29 How about that. You learn something new every day. ...Robert -- Sent via pgsql

Re: [BUGS] BUG #5124: visualizacion de registros

2009-10-17 Thread Robert Haas
2009/10/16 malu : > > The following bug has been logged online: > > Bug reference:      5124 > Logged by:          malu > Email address:      maluulam_l...@yahoo.com.mx > PostgreSQL version: 8.3 > Operating system:   windows xp proffeional > Description:        visualizacion de registros > Details:

Re: [BUGS] BUG #5114: database initialization

2009-10-17 Thread Robert Haas
On Wed, Oct 14, 2009 at 9:56 AM, wrote: > > The following bug has been logged online: > > Bug reference:      5114 > Logged by: > Email address:      flamindrag...@gmail.com > PostgreSQL version: any > Operating system:   Win XP Pro SP2 > Description:        database initialization > Details: > >

Re: [BUGS] BUG #5098: Levenshtein with costs is broken

2009-10-17 Thread Robert Haas
On Tue, Oct 6, 2009 at 9:38 PM, Matthew Byrne wrote: > > The following bug has been logged online: > > Bug reference:      5098 > Logged by:          Matthew Byrne > Email address:      matt...@hairybrain.co.uk > PostgreSQL version: 8.4.1 > Operating system:   Linux x86_64 (Ubuntu 9.04) > Descript

Re: [BUGS] BUG #5131: The pgsql will lost

2009-10-22 Thread Robert Haas
On Wed, Oct 21, 2009 at 11:23 PM, aihongwei wrote: > > The following bug has been logged online: > > Bug reference:      5131 > Logged by:          aihongwei > Email address:      ufo008...@163.com > PostgreSQL version: 8.0.0 > Operating system:   linux x86_64 > Description:        The pgsql will

Re: [BUGS] BUG #5130: Failed to run initdb:1

2009-10-22 Thread Robert Haas
On Wed, Oct 21, 2009 at 12:51 PM, wrote: > > The following bug has been logged online: > > Bug reference:      5130 > Logged by: > Email address:      flamindrag...@gmail.com > PostgreSQL version: any > Operating system:   Win XP Pro SP2 > Description:        Failed to run initdb:1 > Details: > >

Re: [BUGS] BUG #5132: Invalid Function

2009-10-22 Thread Robert Haas
On Thu, Oct 22, 2009 at 3:23 AM, Geok Hua Yap wrote: > > The following bug has been logged online: > > Bug reference:      5132 > Logged by:          Geok Hua Yap > Email address:      geokhua8...@yahoo.com.sg > PostgreSQL version: 8.3.1 > Operating system:   CentOS 5.2 > Description:        Inval

[BUGS] Re: 答复: 答复: [BUGS] Encounter shared memory e rror when running createlang command!

2009-10-22 Thread Robert Haas
2009/9/29 Yaming Gu : > Hi, Robert, > >  According to your recommendations, I tried to load plperu, almost the same > error messages have shown: > > D:\Program Files\Postgresql\8.3\bin>createlang -U postgres plperlu example > > Password: > > createlang: language installation failed: server closed t

Re: [BUGS] BUG #5039: 'i' flag i in regexp_replace ignored for polish letters

2009-10-22 Thread Robert Haas
On Sat, Sep 5, 2009 at 5:42 AM, Kamil Roman wrote: > > The following bug has been logged online: > > Bug reference:      5039 > Logged by:          Kamil Roman > Email address:      kamil.lech.ro...@gmail.com > PostgreSQL version: 8.3.7 > Operating system:   Windows XP > Description:        'i' fl

Re: [BUGS] BUG #5130: Failed to run initdb:1

2009-10-22 Thread Robert Haas
On Thu, Oct 22, 2009 at 10:47 AM, flamin dragon wrote: > > > 2009/10/22 Robert Haas >> >> On Wed, Oct 21, 2009 at 12:51 PM,   wrote: >> > >> > The following bug has been logged online: >> > >> > Bug reference:      5130 >>

Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores

2009-10-22 Thread Robert Haas
On Fri, Aug 28, 2009 at 9:59 AM, Dan O'Hara wrote: > > The following bug has been logged online: > > Bug reference:      5021 > Logged by:          Dan O'Hara > Email address:      danarasoftw...@gmail.com > PostgreSQL version: 8.3.7 > Operating system:   win32 > Description:        ts_parse doesn

  1   2   3   4   5   6   7   8   >