On Mon, Jan 7, 2013 at 6:47 AM, Aleksander Shniperson
wrote:
> There is no install-pgagent.log file.
> Anyway i try to "sudo find" no result.
>
> 07.01.2013, в 9:19, Sandeep Thakkar написал(а):
>
> The ini file clearly says that the pgAgent has been installed in
> /Library/pgAgent. Can you please
On Mon, Jan 7, 2013 at 1:32 AM, Tom Lane wrote:
> emes...@redhat.com writes:
>> 1) pg_dump -F t -U postgres -f test.tar test
>> 2) tar xvf test.tar to any directory
>> 3) vi restore.sql
>> * restore.sql includes DROP statements for each object even tough -c flag
>> was not given
>
> I believe thi
The following bug has been logged on the website:
Bug reference: 7798
Logged by: Lars Kanis
Email address: l...@greiz-reinsdorf.de
PostgreSQL version: 9.1.7
Operating system: Linux - Ubuntu 12.04
Description:
Everything in isolation level "read committed".
Database s
Magnus Hagander writes:
> On Mon, Jan 7, 2013 at 1:32 AM, Tom Lane wrote:
>> emes...@redhat.com writes:
>>> * restore.sql includes DROP statements for each object even tough -c flag
>>> was not given
>> I believe this is intentional - at least, pg_backup_tar.c goes out of
>> its way to make it h
On Mon, Jan 7, 2013 at 4:41 PM, Tom Lane wrote:
> Magnus Hagander writes:
>> On Mon, Jan 7, 2013 at 1:32 AM, Tom Lane wrote:
>>> emes...@redhat.com writes:
* restore.sql includes DROP statements for each object even tough -c flag
was not given
>
>>> I believe this is intentional - at l
There is no install-pgagent.log file.
Anyway i try to "sudo find" no result.
07.01.2013, в 9:19, Sandeep Thakkar написал(а):
> The ini file clearly says that the pgAgent has been installed in
> /Library/pgAgent. Can you please share install-pgagent.log from your system
> temp (/tmp)?
>
> On Sa
- Original Message -
> From: "Tom Lane"
> To: emes...@redhat.com
> Cc: pgsql-bugs@postgresql.org
> Sent: Monday, January 7, 2013 2:32:06 AM
> Subject: Re: [BUGS] BUG #7792: pg_dump does not treat -c flag correctly when
> using tar format
>
> emes...@redhat.com writes:
> > 1) pg_dump -F
The following bug has been logged on the website:
Bug reference: 7795
Logged by: Paul
Email address: paul.wat...@zephyr-consulting.com
PostgreSQL version: 9.2.2
Operating system: Microsoft Windows [Version 6.0.6002] Vista 64-bit
Description:
C:\Program Files\PostgreSQ
The following bug has been logged on the website:
Bug reference: 7797
Logged by: Jared Thompson
Email address: afo...@gmail.com
PostgreSQL version: 9.2.2
Operating system: Ubuntu 12.04
Description:
This query:
select
'2012-01-31'::date + '1 month'::interval
P
Looks like worked, thanks!
have a nice day.
07.01.2013, в 13:43, Dave Page написал(а):
> On Mon, Jan 7, 2013 at 6:47 AM, Aleksander Shniperson
> wrote:
>> There is no install-pgagent.log file.
>> Anyway i try to "sudo find" no result.
>>
>> 07.01.2013, в 9:19, Sandeep Thakkar написал(а):
>>
>
The following bug has been logged on the website:
Bug reference: 7796
Logged by: Michael
Email address: funnybon...@yahoo.com
PostgreSQL version: 9.1.7
Operating system: Windows 7
Description:
Hello, my engish is not so good, but i try to describe what seems not to
w
On Mon, Jan 01/07/13, 2013 at 02:29:43PM +, afo...@gmail.com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7797
> Logged by: Jared Thompson
> Email address: afo...@gmail.com
> PostgreSQL version: 9.2.2
> Operating system: Ubuntu 12.04
On Mon, Jan 7, 2013 at 5:19 PM, Ryan Kelly wrote:
> '1 month'::interval is the same as '30 days'::interval.
No, it's not.
# select '2012-07-31'::date + '1 month'::interval, '2012-07-31'::date
+ '30 days'::interval;
?column? | ?column?
-+-
On Mon, Jan 01/07/13, 2013 at 05:42:40PM +, Daniele Varrazzo wrote:
> On Mon, Jan 7, 2013 at 5:19 PM, Ryan Kelly wrote:
>
> > '1 month'::interval is the same as '30 days'::interval.
>
> No, it's not.
>
> # select '2012-07-31'::date + '1 month'::interval, '2012-07-31'::date
> + '30 days'::in
On Mon, Jan 7, 2013 at 5:47 PM, Ryan Kelly wrote:
> Alright, now I'm thoroughly confused. What magic makes this true:
"""
Internally interval values are stored as months, days, and seconds.
This is done because the number of days in a month varies, and a day
can have 23 or 25 hours if a daylight
On 1/7/2013 9:47 AM, Ryan Kelly wrote:
On Mon, Jan 01/07/13, 2013 at 05:42:40PM +, Daniele Varrazzo wrote:
On Mon, Jan 7, 2013 at 5:19 PM, Ryan Kelly wrote:
'1 month'::interval is the same as '30 days'::interval.
No, it's not.
# select '2012-07-31'::date + '1 month'::interval, '2012-07-
afo...@gmail.com writes:
> This query:
> select
> '2012-01-31'::date + '1 month'::interval
> Produces this result:
> "2012-02-29 00:00:00"
> 2012-02-29 is not a valid date. February only goes to 28 days.
Uh, 2012 was a leap year, and so 2012-02-29 is a perfectly valid date.
> I am not sure wha
Ryan Kelly writes:
> On Mon, Jan 01/07/13, 2013 at 05:42:40PM +, Daniele Varrazzo wrote:
>> On Mon, Jan 7, 2013 at 5:19 PM, Ryan Kelly wrote:
>>> '1 month'::interval is the same as '30 days'::interval.
>> No, it's not.
> Alright, now I'm thoroughly confused. What magic makes this true:
> #
I didn't want to report the bug using the form before confirming it here.
Here is a gist of what I'm trying:
https://gist.github.com/49fcc8c4a5a810f66833#file-cleanup-sql
The relevant part being this:
old_path := pg_catalog.current_setting('search_path');
raise notice 'setting search_path fro
On Mon, Jan 7, 2013 at 12:19 PM, Ryan Kelly wrote:
>
> February has 29 days in 2012.
>
> Thanks I realize now I was looking at 2013's calendar while typing in 2012
> '1 month'::interval is the same as '30 days'::interval.
>
> -Ryan Kelly
>
Thank you.
Rodrigo Rosenfeld Rosas writes:
> perform pg_catalog.set_config('search_path', templ, true);
> ...
> select count(distinct transaction_id) from public.transaction_condition
> into temp_count;
> raise notice '% remaining transactions in public!', temp_count;
> select count(distinct transa
Em 07-01-2013 17:17, Tom Lane escreveu:
Rodrigo Rosenfeld Rosas writes:
perform pg_catalog.set_config('search_path', templ, true);
...
select count(distinct transaction_id) from public.transaction_condition
into temp_count;
raise notice '% remaining transactions in public!', temp_count;
s
The following bug has been logged on the website:
Bug reference: 7799
Logged by: Tianyin Xu
Email address: t...@cs.ucsd.edu
PostgreSQL version: 9.2.2
Operating system: any
Description:
Hi, I just noticed that several developer options do not have descriptions
(in src/
23 matches
Mail list logo
