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
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
On Sat, Jan 5, 2013 at 4:28 AM, Kirk Wythers 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 actually d
> 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.
>
On Fri, Jan 4, 2013 at 3:42 PM, Greg Donald 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 which address are
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
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 w
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 w
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 the
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
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
Hello
2013/1/3 Jeff Trout :
> 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, '{}');
>
> select a, b from
Hello
2013/1/4 Kirk Wythers
> 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
> wit
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 w
2012/12/14 Karl Denninger
> 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 it.
Can you se
> -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
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 eff
17 matches
Mail list logo
