Re: [BUGS] BUG #8388: Remote connections

2013-08-19 Thread bricklen
On Mon, Aug 19, 2013 at 7:32 AM, pah...@psu.edu 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

Re: [BUGS]

2013-08-16 Thread bricklen
On Thu, Aug 15, 2013 at 1:16 PM, Cal Martin c.j.mar...@shaw.ca 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

Re: [BUGS] PGSQL Bug

2013-07-18 Thread bricklen
On Wed, Jul 17, 2013 at 10:46 PM, Michael Kunzmann m...@michaelkunzmann.com 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

Re: [BUGS] PGSQL Bug

2013-07-18 Thread bricklen
On Thu, Jul 18, 2013 at 10:52 AM, Michael Kunzmann m...@michaelkunzmann.com 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 PostgreSQL under Ubuntu 12.04

Re: [BUGS] BUG #8290: broken/unexpected locking behavior

2013-07-09 Thread bricklen
On Tue, Jul 9, 2013 at 9:02 AM, pgn...@gmail.com 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

Re: [BUGS] Postgres crash? could not write to log file: No spaceleft on device

2013-06-25 Thread bricklen
On Tue, Jun 25, 2013 at 9:43 AM, Yuri Levinsky yu...@celltick.com 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

Re: [BUGS] BUG #8211: Syntax error when creating index on expression

2013-06-05 Thread bricklen
On Wed, Jun 5, 2013 at 8:24 AM, aci...@gmail.com 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

Re: [BUGS] BUG #8027: Get generated key value while inserting in partitioned table

2013-04-02 Thread bricklen
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, mohansamm...@gmail.com wrote: The following

Re: [BUGS] BUG #7927: MEDIAN FUNCTION IN POSTGRE REQUIRED

2013-03-11 Thread bricklen
On Mon, Mar 11, 2013 at 12:01 AM, sivakumar...@gmail.com 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

Re: [BUGS] new BUG: postgresql 9.2.3: very long query time

2013-02-20 Thread bricklen
On Wed, Feb 20, 2013 at 5:42 AM, Claude Speed gta3u...@gmail.com 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.

Re: [BUGS] BUG #6400: function arguments not accepted

2012-01-18 Thread bricklen
On Wed, Jan 18, 2012 at 5:38 AM, kn...@ipa.fraunhofer.de 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

Re: [BUGS] BUG #6335: Weird planner decision with exists (a join b) condition

2011-12-14 Thread bricklen
On Wed, Dec 14, 2011 at 4:53 PM, Maxim Boguk maxim.bo...@gmail.com 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)

Re: [BUGS] BUG #6330: Incorrect select results when using mutually exclusive conditions for nullable column with index

2011-12-07 Thread bricklen
On Wed, Dec 7, 2011 at 5:42 AM, nikolay.gorsh...@gmail.com 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

Re: [BUGS] BUG #6303: ROW_NUMBER()

2011-11-21 Thread bricklen
On Mon, Nov 21, 2011 at 8:40 AM, Alessandro Bellanda a.bella...@gmail.com 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

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

2011-11-03 Thread bricklen
On Thu, Nov 3, 2011 at 10:57 AM, Greg Fausak g...@named.com 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

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

2011-10-25 Thread bricklen
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 Casanova        

[BUGS] auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)

2011-10-25 Thread bricklen
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 =

Re: [BUGS] auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)

2011-10-25 Thread bricklen
On Tue, Oct 25, 2011 at 9:22 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com 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 PostgreSQL 9.0.3 on x86_64

Re: [BUGS] auto_explain causes cluster crash if pg_ctl reload is used (not pg_ctl restart)

2011-10-25 Thread bricklen
On Tue, Oct 25, 2011 at 2:01 PM, Tom Lane t...@sss.pgh.pa.us wrote: bricklen brick...@gmail.com writes: The steps to reproduce are pretty simple. Set the following in the postgresql.conf file: shared_preload_libraries = 'pg_stat_statements,auto_explain' custom_variable_classes

[BUGS] pg 9.1.1 - ERROR: could not find pathkey item to sort

2011-09-26 Thread bricklen
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

Re: [BUGS] SELECT '(1, nan, 3)'::cube;

2011-03-16 Thread bricklen
On Tue, Mar 15, 2011 at 9:08 AM, Robert Brewer fuman...@aminus.org 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