Re: [BUGS] BUG #8362: postres webserver

2013-08-05 Thread Christopher Browne
There are several things confusing here that seem to indicate that this is not a bug... 1. Postgres is not a web server. It is a database management system, and thus extensions one might hope to add to a web server are not logical to expect to connect to Postgres. 2. It sounds as though you ar

Re: [BUGS] BUG #8260: problem with sequence and tablename

2013-06-27 Thread Christopher Browne
Object names are limited to a length of NAMEDATALEN-1, which defaults to 63, and are documented to be truncated. http://www.postgresql.org/docs/9.2/static/sql-syntax-lexical.html The behaviour you are observing appears to conform to the documentation, and seems reasonable, so I wouldn't think thi

Re: [BUGS] 9.2.4: Strange behavior when wildcard is on left side of search string

2013-04-07 Thread Christopher Browne
This doesn't seem either buggy or strange... An index on the ordering of that column is not helpful in handling a leading wildcard, and so the query optimizer will, in such cases, revert, correctly, to using a sequential scan and filtering the results. If you have cases where this sort of wildcar

Re: [BUGS] How to run query by command prompt in Postgres

2013-03-20 Thread Christopher Browne
On Wed, Mar 20, 2013 at 8:22 AM, Kapil Kr. Khandelwal wrote: > Dear Team > > I want to a favour from your side. I want to implement clustering in > postgres on windows server. Please provide the list of steps. I want the > answers of followings doubts. > > 1. How to write archive command > 2. How

Re: [BUGS] EnterpriseDB Advanced Server 8.2 Supported Platforms

2012-10-16 Thread Christopher Browne
On Tue, Oct 16, 2012 at 2:24 AM, Ricky Wong wrote: > EnterpriseDB team, > > ** ** > > I was wondering which Linux OS (i.e. CentOS) the Advanced Server 8.2 > supports. > > ** ** > > I was able to found Documentation for 8.3 (but not 8.2): > > http://www.enterprisedb.com/docs/en/8.3/ser

Re: [BUGS] How to run query by command prompt in Postgres

2012-06-27 Thread Christopher Browne
On Wed, Jun 27, 2012 at 7:15 AM, Kapil Kr. Khandelwal wrote: > I want to a favour from your side. I want to know, how to run sql query by > command prompt in postgres sql. This doesn't sound like a bug, and this mailing list is intended to capture bugs discovered in Postgres. Perhaps you should

Re: [BUGS] postgresql 9.1 replicaiton query ( GNU/Linux replicate to Windows)

2012-03-12 Thread Christopher Browne
On Mon, Mar 12, 2012 at 5:31 AM, Nie, Guocong wrote: > Hi Team, > > I am doing postgresql 9.1  replication , the Master database is on GNU/Linux > operation system , the Slave  database is on Windows 32 bit system.  But > when I copy the Master database from Linux to Windows , then I am unlucky to

Re: [BUGS] BUG #6516: how to mound data folder in remote location

2012-03-05 Thread Christopher Browne
On Mon, Mar 5, 2012 at 5:02 AM, wrote: > The following bug has been logged on the website: > > Bug reference:      6516 > Logged by:          Shiva > Email address:      skambhap...@tripodtech.net > PostgreSQL version: 8.4.3 > Operating system:   RHEL5.5 > Description: > > Hi Team, > I installed

Re: [BUGS] BUG #6514: mount data folder in remote location

2012-03-05 Thread Christopher Browne
On Mon, Mar 5, 2012 at 12:41 AM, wrote: > The following bug has been logged on the website: > > Bug reference:      6514 > Logged by:          Shanker > Email address:      sanker...@gmail.com > PostgreSQL version: 8.4.3 > Operating system:   RHEL5.5 > Description: > > Hi All, > I am using Postgr

Re: [BUGS] slony replication issue

2012-03-02 Thread Christopher Browne
On Fri, Mar 2, 2012 at 4:15 AM, Nie, Guocong wrote: > I use  slony version “slony1-1.2.20” , and postgresql version 9.1 You should really take this over to the Slony mailing list, it's not a generic Postgres problem. http://lists.slony.info/mailman/listinfo/slony1-general > LOG:  server process

Re: [BUGS] Add statistics_collector_listen_addresses to fix hard-coding of "localhost"

2011-11-09 Thread Christopher Browne
On Thu, Nov 10, 2011 at 12:09 AM, Robert Young wrote: > The basic philosophy of system design is isolation. > One system component's crash should better not interfere others. > System should restrict destruction to minimum. The "minimum" may not be able to be lowered to zero. Such a lowering may

Re: [BUGS] BUG #6266: Create temp tables on Slave

2011-10-25 Thread Christopher Browne
Well, it is imaginable for there to be some side mechanism to enable use of temporary tables on a WAL-based replica, after all, we have leapt through enough hoops to get read transactions working. That being said... A) a solution for how to do this has not yet emerged, so it seems not too likely

Re: [BUGS] PostGre compatible to RHEL 6.1

2011-09-29 Thread Christopher Browne
On Thu, Sep 29, 2011 at 7:23 AM, Yaamini Bist wrote: > > Hi, > > It would be really great if you can provide me information Is PostGre > compatible to RHEL 6.1 ? This is a mailing list for addressing bugs that are found with PostgreSQL. There isn't any such system as "PostGre", and whether that

Fwd: [BUGS] Behaviour of triggers on replicated and non replicated tables

2011-06-16 Thread Christopher Browne
2011/6/10 Luiz K. Matsumura : > Hi, > I need help to know if the follow scenario is a expected behaviour, a bug of > postgres or a bug of slony: > > Postgres v8.4.8 > Slony-I v 2.0.5 > > I have table replicated with slony and that do some updates in another table > not replicated. > > The trigger o

Re: [BUGS] BUG #5946: Long exclusive lock taken by vacuum (not full)

2011-03-28 Thread Christopher Browne
On Mon, Mar 28, 2011 at 4:01 PM, Tom Lane wrote: > Christopher Browne writes: >> - Grab timestamp >> - Grab exclusive lock >> - Process [Some number of pages] >> - Check time. >> - If [# of ms] have passed then check to see if anyone else has a lock >> O/

Re: [BUGS] BUG #5946: Long exclusive lock taken by vacuum (not full)

2011-03-28 Thread Christopher Browne
On Mon, Mar 28, 2011 at 2:20 PM, Robert Haas wrote: > On Mon, Mar 28, 2011 at 12:29 AM, Tom Lane wrote: >> Robert Haas writes: >>> I think we've had a number of pieces of evidence that suggest that >>> extending 8kB at a time is too costly, but I agree with Greg that the >>> idea of extending an

Re: [BUGS] BUG #5946: Long exclusive lock taken by vacuum (not full)

2011-03-25 Thread Christopher Browne
On Fri, Mar 25, 2011 at 5:09 PM, Greg Stark wrote: > On Fri, Mar 25, 2011 at 8:48 PM, Tom Lane wrote: >> Interesting, but I don't understand/believe your argument as to why this >> is a bad idea or fixed-size extents are better.  It sounds to me just >> like the typical Oracle DBA compulsion to h

Re: [BUGS] BUG #5946: Long exclusive lock taken by vacuum (not full)

2011-03-25 Thread Christopher Browne
On Fri, Mar 25, 2011 at 11:17 AM, Tom Lane wrote: > "Maxim Boguk" writes: >> In my case vacuum tried to truncate last 10-15GB from 100Gb relation, and >> each time (3) it was cost 10+ minutes of service downtime (because that >> table was completely locked). > >> Is  that correct behaviour? Are h

Re: [BUGS] DDL triggers

2009-05-22 Thread Christopher Browne
In an attempt to throw the authorities off his trail, pete...@gmx.net (Peter Eisentraut) transmitted: > On Thursday 21 May 2009 10:52:33 Целуйко Дмитрий wrote: >> When DDL triggers will be supported by PostgreSQL? > > There are currently no concrete plans for that, but if someone com

Re: [BUGS] BUG #2810: restore to lower version of dump

2006-12-06 Thread Christopher Browne
Quoth [EMAIL PROTECTED] ("Murali"): > The following bug has been logged online: > > Bug reference: 2810 > Logged by: Murali > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.4 > Operating system: WINXP > Description:restore to lower version of dump > Details:

Re: [BUGS] BUG #2608: dblink compile fails on AIX 5.3

2006-09-10 Thread Christopher Browne
Quoth [EMAIL PROTECTED] (Tom Lane): > I wrote: >> Done, but it's really pretty ugly. I am thinking it'd make more sense >> for Makefile.global to define a macro for the libraries libpq depends >> on ... > > I went ahead and did this as per discussion here: > http://archives.postgresql.org/pgsql-bu

Re: [BUGS] BUG #2608: dblink compile fails on AIX 5.3

2006-09-10 Thread Christopher Browne
In the last exciting episode, [EMAIL PROTECTED] ("Michael Hoffmann") wrote: > The following bug has been logged online: > > Bug reference: 2608 > Logged by: Michael Hoffmann > Email address: [EMAIL PROTECTED] > PostgreSQL version: 8.1.2 > Operating system: AIX 5.3 > Description

Re: [BUGS] BUG #2600: dblink compile with SSL missing

2006-09-07 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Bruce Momjian) wrote: > Where are we on this? Nothing submitted so far. If someone magically does something about it, that's super. I'm on vacation 'til Tuesday; if it's not dealt with, I'll see if I can find something. -- (format

[BUGS] BUG #2600: dblink compile with SSL missing libraries

2006-08-30 Thread Christopher Browne
The following bug has been logged online: Bug reference: 2600 Logged by: Christopher Browne Email address: [EMAIL PROTECTED] PostgreSQL version: CVS HEAD (8.2) Operating system: AIX 5.3 Description:dblink compile with SSL missing libraries Details: If I try to

Re: [BUGS] buglet in 7.1.4

2004-03-13 Thread Christopher Browne
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Mike Mascari) wrote: > Lamar Owen wrote: > >> On Tuesday 09 March 2004 10:46 am, Tom Lane wrote: >> >>>Neil Conway <[EMAIL PROTECTED]> writes: >>> BTW, I can't really see the harm in putting out 7.1.x and 7.2.x releases to fix c

Re: [BUGS] BUG #1053: Configuration should be in /etc/postgres

2004-01-18 Thread Christopher Browne
="libertyrms.info" in String.concat "@" [name;tld];; <http://dev6.int.libertyrms.com/> Christopher Browne (416) 646 3304 x124 (land) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] Postgresql 'eats' all mi data partition

2003-09-28 Thread Christopher Browne
obably it's better to regularly do "ordinary VACUUMs." -- "cbbrowne","@","libertyrms.info" <http://dev6.int.libertyrms.com/> Christopher Browne (416) 646 3304 x124 (land) ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [BUGS] Postgresql 'eats' all mi data partition

2003-09-26 Thread Christopher Browne
icient. -- "cbbrowne","@","libertyrms.info" <http://dev6.int.libertyrms.com/> Christopher Browne (416) 646 3304 x124 (land) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster