Re: [BUGS] BUG #7802: Cannot drop table because of dependant sequence, but there is link to sequence

2013-01-14 Thread Christiaan Willemsen
Hi Tom,   To bad, I don't have the exact logging... I do however need to de-partition two more tables, probably this week, so I will do some more extensive statement logging and I I get stuck again, I'll post it.   Kind regards,   Christiaan Willemsen  -Original message- From:Tom

[BUGS] BUG #7807: sign function returns double

2013-01-14 Thread a_rares
The following bug has been logged on the website: Bug reference: 7807 Logged by: Andrei Rares Email address: a_ra...@yahoo.com PostgreSQL version: 9.1.7 Operating system: GNU/Linux 3.2.0-35-generic x86_64 Description: In the documentation

[BUGS] BUG #7804: timeofday() output string is not compatible with timestamp with time zone data type

2013-01-14 Thread dotbrat
The following bug has been logged on the website: Bug reference: 7804 Logged by: Ruslan Izmaylov Email address: dotb...@gmail.com PostgreSQL version: 9.1.7 Operating system: Fedora release 17 Description: Query: SET TIME ZONE 'Europe/Minsk'; select

[BUGS] BUG #7806: installation failed for postgis on Windows

2013-01-14 Thread fahar . abbas
The following bug has been logged on the website: Bug reference: 7806 Logged by: Fahar Abbas Email address: fahar.ab...@enterprisedb.com PostgreSQL version: 9.2.2 Operating system: Windows 7, Windows 2003 Server Description: I am facing an issue while installed

[BUGS] BUG #7805: Inconsistency, multiple versions

2013-01-14 Thread gerydeft
The following bug has been logged on the website: Bug reference: 7805 Logged by: Gery Deft Email address: geryd...@gmail.com PostgreSQL version: 9.2.2 Operating system: Windows Server, Windows 7,Ubuntu linux Description: Hi, Versions: 9.2.*,8.4.* Our project uses

Re: [BUGS] wrong search_path being used

2013-01-14 Thread Casey Allen Shobe
Just adding in my two cents... At my last company we had several hundred stored procedures which all set a search path dynamically based on an input argument prior to running any queries. The current behavior is very alarming and challenging to consistently workaround. Would be very happy to

Re: [BUGS] BUG #7807: sign function returns double

2013-01-14 Thread Heikki Linnakangas
On 14.01.2013 16:21, a_ra...@yahoo.com wrote: In the documentation (http://www.postgresql.org/docs/9.1/static/functions-math.html) it is written that the return type is the same as the input, but a query like 'select sign(1::int)' returns a double It says that the input type is dp or numeric,

Re: [BUGS] BUG #7804: timeofday() output string is not compatible with timestamp with time zone data type

2013-01-14 Thread Tom Lane
dotb...@gmail.com writes: SET TIME ZONE 'Europe/Minsk'; select timeofday()::timestamp with time zone; ERROR: invalid input syntax for type timestamp with time zone: Mon Jan 14 08:18:20.333915 2013 FET The issue seems to be that the recently-invented abbreviation FET isn't anywhere in our

[BUGS] BUG #7808: unnest doesn't handle nulls in array of composite types correctly

2013-01-14 Thread joe
The following bug has been logged on the website: Bug reference: 7808 Logged by: Joe Van Dyk Email address: j...@tanga.com PostgreSQL version: 9.2.1 Operating system: OSX Description: RhodiumToad says this is a bug in unnest, but honestly I don't quite understand it

Re: [BUGS] BUG #7808: unnest doesn't handle nulls in array of composite types correctly

2013-01-14 Thread Stephen Frost
* j...@tanga.com (j...@tanga.com) wrote: My goal is to remove nulls from an array. The array could be an array of a composite type. A much simpler case is: = create type xt as (a integer); CREATE TYPE = select * from unnest(array[null::xt]); ERROR: function returning set of rows cannot return

Re: [BUGS] BUG #7806: installation failed for postgis on Windows

2013-01-14 Thread John R Pierce
On 1/14/2013 3:04 AM, fahar.ab...@enterprisedb.com wrote: PostgreSQL version: 9.2.2 Operating system: Windows 7, Windows 2003 Server Description: I am facing an issue while installed downloaded postgis build. Version: PostgreSQL-9.2.2 Steps: 1. Install PostgreSQL 9.2 windows 64 on Windows 7

[BUGS] BUG #7809: Running pg_dump on slave w/ streaming replication fails if there are unlogged tables

2013-01-14 Thread joe
The following bug has been logged on the website: Bug reference: 7809 Logged by: Joe Van Dyk Email address: j...@tanga.com PostgreSQL version: 9.2.2 Operating system: Ubuntu Description: Running pg_dump on a streaming replication slave with a database that has

Re: [BUGS] BUG #7804: timeofday() output string is not compatible with timestamp with time zone data type

2013-01-14 Thread Руслан Измайлов
I need a real-time clock value so I will use clock_timestamp() to get it. Thanks for the answer. 2013/1/15 Tom Lane t...@sss.pgh.pa.us dotb...@gmail.com writes: SET TIME ZONE 'Europe/Minsk'; select timeofday()::timestamp with time zone; ERROR: invalid input syntax for type timestamp with

[BUGS] BUG #7810: cant uninstall or install program

2013-01-14 Thread richardbrown360
The following bug has been logged on the website: Bug reference: 7810 Logged by: rich Email address: richardbrown...@hotmail.com PostgreSQL version: 8.4.13 Operating system: windows 7 Description: I can't seem to get rid of all the application. I cant reinstall the

Re: [BUGS] BUG #7803: Replication Problem(no master is there)

2013-01-14 Thread Tomonari Katsumata
Hi, Sorry for late response. (2013/01/11 23:11), Simon Riggs wrote: On 11 January 2013 12:18, Tomonari Katsumata katsumata.tomon...@po.ntts.co.jp wrote: I'm not sure but what about adding the parameter(cascade_mode) on recovery.conf ? The parameter represents a will to connect to standby