On Mon, Aug 19, 2013 at 7:32 AM, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8388
> Logged by: Phil Heverly
> Email address: pah...@psu.edu
> PostgreSQL version: 9.1.9
> Operating system: Mac OS 10.7 and 10.8
> Description:
>
> I doubt this i
On Thu, Aug 15, 2013 at 1:16 PM, Cal Martin wrote:
> This error showed up recently can you help me repair it as I do not know
> what caused it.
>
> ** **
>
> Thanking you in advance.
>
> ** **
>
> Cal
>
I notice an error about a missing entry in your pg_hba.conf file. Are you
able t
On Wed, Jul 24, 2013 at 7:45 AM, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8329
> Logged by: Petr
> Email address: chmel...@fit.vutbr.cz
> PostgreSQL version: 9.2.4
> Operating system: Fedora x64
> Description:
>
> Hi there,
> we have an is
On Thu, Jul 18, 2013 at 10:52 AM, Michael Kunzmann wrote:
> Am 18.07.2013 17:33, schrieb bricklen:
>
>
> On Wed, Jul 17, 2013 at 10:46 PM, Michael Kunzmann <
> m...@michaelkunzmann.com> wrote:
>
>>
>> I've noticed the following issue when autostarting
On Wed, Jul 17, 2013 at 10:46 PM, Michael Kunzmann wrote:
>
> I've noticed the following issue when autostarting PostgreSQL under
> Ubuntu 12.04 64bit by bootup. I'm using PostgreSQL 9.1.
>
> 2013-07-18 06:44:12 CEST FATAL: could not create shared memory segment:
>
How much RAM do you have, and
On Tue, Jul 9, 2013 at 9:02 AM, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 8290
> Logged by: pgnoob
> Email address: pgn...@gmail.com
> PostgreSQL version: 8.4.13
> Operating system: CentOS Linux
> Description:
>
> I experienced a db deadloc
On Tue, Jun 25, 2013 at 9:43 AM, Yuri Levinsky wrote:
> I inspected my config file and didn't see any destination that isn't
> /data/postgres. Have I perform any specific setting to limit it into
> /data/postgres?
Execute from psql:
show stats_temp_directory
stats_temp_directory
On Wed, Jun 5, 2013 at 8:24 AM, wrote:
>
> Bug reference: 8211
> Logged by: Andrey Cizov
> Email address: aci...@gmail.com
> PostgreSQL version: 9.2.3
> Operating system: Windows
> Description:
>
> CREATE INDEX heuristic ON foos (1 / (a + b))
>
> causes:
>
> ERROR: syntax err
This is not a bug, so should not be in the bugs list. Try posting in the
pgsql-general list if the point below does not help.
Are your insert statements into the child tables including "RETURNING
email_message_id" ?
On Tue, Apr 2, 2013 at 12:11 AM, wrote:
> The following bug has been logged on
On Mon, Mar 11, 2013 at 12:01 AM, wrote:
> MEDIAN FUNCTION IN POSTGRE REQUIRED
Would something on the following page be useful:
http://wiki.postgresql.org/wiki/Aggregate_Median
Note: this is for PostgreSQL bugs, not requests for help (unless bug
related). You could subscribe to the (very helpfu
On Wed, Feb 20, 2013 at 5:42 AM, Claude Speed wrote:
> Postgresql 9.2.3 is processing my query is much longer than Postgresql
> 9.1.8:
> Postgresql 9.1.8 - 2292 ms
> Postgresql 9.2.3 - 163336 ms
>
> I provided my query in attach and the database dump too,
> this bug is reproducible.
1). Can you s
On Fri, Jan 18, 2013 at 3:26 AM, Tsunezumi wrote:
>
> I installed ordinarily.
> I did not correct postgresql.conf.
>
> Installation Directory
> C:\PostgreSQL\9.2
>
> Data Directory
> C:\PostgreSQL\9.2\data
>
> locale
> C
Please post the results of the following query:
SELECT 'version'::text
On Wed, Jan 18, 2012 at 5:38 AM, wrote:
> INSERT INTO tissue.biopsy (id_biopsy, f_user,introduction_date,
> description, weight, size)
> VALUES
> (
> DEFAULT,
> user,
> in_date,
> in_description,
> in_weight,
> in_size
> );
What happens when you double-quote user in the insert statemen
On Wed, Dec 14, 2011 at 4:53 PM, Maxim Boguk wrote:
> Here goes self-contained test case.
>
> I tested it on the 9.1.2, 9.1.1, 9.0.5, 9.0.4, 8.4.7
I just tested on 9.1.2 and see the same issue.
> --bad
> EXPLAIN ANALYZE select *
> from test1
> where
> test1.user_id in (100, 101)
> and exists (
On Wed, Dec 7, 2011 at 5:42 AM, wrote:
> PostgreSQL version information:
> # select version();
> Result: PostgreSQL 9.0.4 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real
> (Ubuntu 4.4.3-4ubuntu5) 4.4.3, 32-bit
>
> Linux information:
> # uname -a
> Result: Linux hostname 2.6.32-21-generic-pae #
On Mon, Nov 21, 2011 at 8:40 AM, Alessandro Bellanda
wrote:
>
> The following bug has been logged online:
>
> Bug reference: 6303
> Logged by: Alessandro Bellanda
> Email address: a.bella...@gmail.com
> PostgreSQL version: 9.1.1
> Operating system: Linux CentOS release 5.5 64
On Thu, Nov 3, 2011 at 10:57 AM, Greg Fausak wrote:
>
> I create a table partition:
>
> table M
>
> table A (check range) inherits M
> table B (check range) inherits M
> ...
> table X (check range) inherits M
>
> ASSERT: a query with constraint exclusions=on, performed on M will select
> the corre
On Tue, Oct 25, 2011 at 2:01 PM, Tom Lane wrote:
> bricklen writes:
>> The steps to reproduce are pretty simple.
>
>> Set the following in the postgresql.conf file:
>
>> shared_preload_libraries = 'pg_stat_statements,auto_explain'
>&
On Tue, Oct 25, 2011 at 9:22 AM, Heikki Linnakangas
wrote:
> On 25.10.2011 18:42, bricklen wrote:
>>
>> Tried on both
>> PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc
>> (GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
>> and
>> Postg
Tried on both
PostgreSQL 9.0.4 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
and
PostgreSQL 9.0.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc
(GCC) 4.1.2 20080704 (Red Hat 4.1.2-48), 64-bit
shared_preload_libraries = 'pg_stat_statements,auto_
> you can't. this isn't a bug but a known limitation and is documented here:
> http://www.postgresql.org/docs/9.1/static/hot-standby.html#HOT-STANDBY-USERS
>
>> Is there any workaround?
>> How could we create temp database and tables on slave?
>>
>
> not with streaming replication
>
> --
> Jaime Ca
20110214 (Red Hat 4.4.5-6), 64-bit
Any other details needed?
Cheers,
Bricklen
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
On Tue, Mar 15, 2011 at 9:08 AM, Robert Brewer wrote:
> I'm working on a hypercube implementation in Postgres using contrib/cube
>
> and need to insert 80,000 rows in one go from Python. Doing so with
> INSERT, even multiple statements in one call, is pretty slow. I've been
> investigating if usin
23 matches
Mail list logo
