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
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
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
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
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
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
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
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
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
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
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
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
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
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
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/
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
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
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
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
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:
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
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
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
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
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
="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
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
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
28 matches
Mail list logo