On Thursday, January 03, 2013 9:56 PM Jose Martinez wrote:
Hi,
I made some changes to postgresql.conf and I want them to take effect
without having to restart the server.
I tried
select pg_reload_conf();
/usr/pgsql-9.1/bin/pg_ctl reload
but when I do 'show all', I see no changes take effect.
-Original Message-
From: Thomas Kellerer [mailto:spam_ea...@gmx.net]
Sent: Thursday, January 03, 2013 12:31 PM
To: pgsql-general@postgresql.org
Subject: Re: Large number of rows in pg_type and slow gui (pgadmin)
refresh
Robert Klaus wrote on 03.01.2013 16:50:
We have 36,000+
2012/12/14 Karl Denninger k...@denninger.net
If it's whether the replication is caught up, I have a small C program
that will do that and have posted it before (I can do that again if you'd
like.)
Hi Karl,
I am interested to have your C program. I searched in the archives but
could not find
I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I actually do not want to mess with
time zones, but it seems that postgres
Hello
2013/1/4 Kirk Wythers kirk.wyth...@gmail.com
I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I actually do not want
Hello
2013/1/3 Jeff Trout thres...@real.jefftrout.com:
I just ran into an interesting thing with unnest and empty arrays.
create table x (
a int,
b int[]
);
insert into x(a,b) values (1, '{}');
insert into x(a,b) values (1, '{}');
insert into x(a,b) values (1, '{}');
Edson Richter wrote:
I would like to have two schemas:
MyDB.sales
MyDB.security
Users that have rights in sales schema should be able to
select/insert/update/delete. The same users must have rights to check
foreign keys against users table (but they are now allowed to execute
select
Igor Neyman wrote:
Thomas Kellerer wrote:
Why do you need so many types?
Probably those are not the types Robert created explicitly.
There must be lots of tables/views (m.b. lots of partitions) in
the database. Every table/view adds couple records to pg_type:
one type for table/view record
Sorry if this is the wrong list, but I've been stuck for a couple days
now. I tried pgpool-general but that list appears to not like me.
I'm not getting any posts and my post hasn't shown up in the archives.
I have a Python/Django app that will require database load balancing
at some point in
I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I actually do not want to mess with
time zones, but it seems that postgres
I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I actually do not want to mess with
time zones, but it seems that postgres
Hello,
I have installed v9.2 on Windows XP and configured SSPI authentication for
a Windows user Administrateur in pg_hba.conf
Using psql or Pgadmin, authentication with the user Administrateur works
without problem.
However I couldn't create a connection using DbLink and the Windows user, I
On Fri, Jan 4, 2013 at 3:42 PM, Greg Donald gdon...@gmail.com wrote:
Sorry if this is the wrong list, but I've been stuck for a couple days
now. I tried pgpool-general but that list appears to not like me.
I'm not getting any posts and my post hasn't shown up in the archives.
Specifically
Sorry if this is the wrong list, but I've been stuck for a couple days
now. I tried pgpool-general but that list appears to not like me.
I'm not getting any posts and my post hasn't shown up in the archives.
I am the admin of the list. Please contact me directly if you need
help on this.
I
On Sat, Jan 5, 2013 at 4:28 AM, Kirk Wythers wythe...@umn.edu wrote:
I am trying to re-cast a column as a timestamp
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
The column time2 is currently a varchar. I
On Wednesday, January 2, 2013, John R Pierce wrote:
On 1/2/2013 7:45 PM, Craig Ringer wrote:
You really need to put a connection pool in place to limit the number of
concurrent workers. Look at PgBouncer or PgPool-II. As far as I know
neither of them runs on Windows; you might want to think
On 1/4/2013 9:28 AM, Kirk Wythers wrote:
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp;
ERROR: column time2 cannot be cast to type timestamp without time zone
you need to give it some hints as to how to do that casting.
ALTER TABLE sixty_min ALTER COLUMN time2 TYPE timestamp USING
17 matches
Mail list logo