Hi,
Sorry for late response.
(2013/01/11 23:11), Simon Riggs wrote:
> On 11 January 2013 12:18, Tomonari Katsumata
> 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 server when
starting
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 p
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
> 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:
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
unlogge
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
* 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 ret
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 a
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
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",
On 14.01.2013 11:37, geryd...@gmail.com wrote:
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,
V
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 see
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 Pos
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 downlo
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 timeofday()::times
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
(http://www.postgresql.org/do
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 Lane
16 matches
Mail list logo
