Thread: Fwd: Re: data type change

Fwd: Re: data type change

From
Aarni Ruuhimäki
Date:
Hi !

Or you can take a dump -c, edit the dump file's appropriate CREATE statement
for your table and column and just read the data back in.

BR,

aarni

----------  Forwarded Message  ----------

Subject: Re: [NOVICE] data type change
Date: Mon, 6 Jan 2003 13:48:16 +0100
From: Alberto Bolchini <alberto@melloni49.it>
To: postgresql novice <pgsql-novice@postgresql.org>
Cc: renzo rizzato <renzorizzato@iol.it>

<quote who="renzo rizzato">

> does anybody know if any sql instruction exists to allow
> change of a column data type? In my case I need to convert a
> money type into numeric without any success.

AFAIK you cannot in Postgresql. I suggest you recreate the table with the
correct column datatypes (i.e. rename the table, create the new table and
populate it with values from the original table.) Watch out for triggers and
procedures.

Regards,

    Alberto.

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

-------------------------------------------------------



Sorry, to many clients already.

From
"cristi"
Date:
Hen I'm trying to connect I have this error message:

Something unusual has occured to cause the driver to fail.Please report this
exception: java.sql.SQLException: Sorry, to many clients already.


What should I do?


Re: Sorry, to many clients already.

From
Tom Lane
Date:
"cristi" <cristi@dmhi.ct.ro> writes:
> Hen I'm trying to connect I have this error message:
> Something unusual has occured to cause the driver to fail.Please report this
> exception: java.sql.SQLException: Sorry, to many clients already.
> What should I do?

Increase the max_connections setting of your server.  Or look around to
see if there are idle clients that should be shut down.

            regards, tom lane