On Mon, Jan 7, 2013 at 6:47 AM, Aleksander Shniperson
alex.shniper...@gmail.com 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
On Mon, Jan 7, 2013 at 1:32 AM, Tom Lane t...@sss.pgh.pa.us 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
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
Magnus Hagander mag...@hagander.net writes:
On Mon, Jan 7, 2013 at 1:32 AM, Tom Lane t...@sss.pgh.pa.us 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
On Mon, Jan 7, 2013 at 4:41 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Magnus Hagander mag...@hagander.net writes:
On Mon, Jan 7, 2013 at 1:32 AM, Tom Lane t...@sss.pgh.pa.us wrote:
emes...@redhat.com writes:
* restore.sql includes DROP statements for each object even tough -c flag
was not given
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 Sat, Jan
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
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
alex.shniper...@gmail.com 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
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 rpkell...@gmail.com 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 rpkell...@gmail.com 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
+
On Mon, Jan 7, 2013 at 5:47 PM, Ryan Kelly rpkell...@gmail.com 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
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 rpkell...@gmail.com wrote:
'1 month'::interval is the same as '30 days'::interval.
No, it's not.
# select '2012-07-31'::date + '1
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 what the
Ryan Kelly rpkell...@gmail.com 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 rpkell...@gmail.com wrote:
'1 month'::interval is the same as '30 days'::interval.
No, it's not.
Alright, now I'm thoroughly confused.
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
On Mon, Jan 7, 2013 at 12:19 PM, Ryan Kelly rpkell...@gmail.com 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 rr.ro...@gmail.com 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
Em 07-01-2013 17:17, Tom Lane escreveu:
Rodrigo Rosenfeld Rosasrr.ro...@gmail.com 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
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
21 matches
Mail list logo