On Thu, Oct 20, 2005 at 10:30:36AM +0530, sandhya wrote:
> I am able to get the error code as a return value from the function using,
> return (PQresultErrorField(res,PG_DIAG_SQLSTATE));
> Problem is i don't know how to generalize the messages once i get
> thisPls any one help me in this regard
Reg stands for "regarding"
Error in the sence --->
I have a function to create a database and so on.. using libpqxx
library.
And i have a CLInterfacing program through which i can able to select option
which i want to do.
I am able to get the error messages if anything wrong i give..
But
On 8.0 and below, you can't use a simple ALTER TABLE to do this, but you
can modify pg_class. However, this may or may not be safe. In 8.1 you
can do ALTER TABLE name SET SCHEMA blah.
decibel=# create table public.t(t text);
CREATE TABLE
decibel=# alter table public.t rename to decibel.t;
ERROR:
Hi,
With an ever increasing number of tables being added to our research
database, we have come to the conclusion that we need to confine
individual users to private schemas instead of everybody creating their
tables in the default public schema. In order to move the tables, I
have used a CR
On Wed, Oct 19, 2005 at 03:56:57PM +0530, sandhya wrote:
> In error handling suppose if the database already exists..
>
> It is returning : database "sample(say)" doesn't exists.
What is "it"? What error handling are you talking about? What are
you doing that results in the error, and why does
I'm usung postgresql.org RPMS so the RPMS will be exactly the same.
Of course I'll do my pgdump before my try.
Thank to you all !
Scott Marlowe wrote:
On Wed, 2005-10-19 at 10:47, FM wrote:
Hello erverybody,
I need to install a new version of Redhat on my server.
On the distro, pgsql data are
To whom it may concern,
My pgAdmin crashed when I tried to vacuum the "template0" database. It is
of course not needed to vacuum this database, but I clicked on it by accident.
When I tried it again, this time on purpose, it happened again.
The PostgreSQL database that is used is v8.0.4, t
The new version will update your postgresql packages. It shouldn't wipe your
data files, since /etc/init.d/postgresql script checks if there are data in the
specified directory. Then you must erase those postgresql (rpm -qa|grep
postgres will list packages installed), and install yours.
But, if
On Wed, 2005-10-19 at 10:47, FM wrote:
> Hello erverybody,
> I need to install a new version of Redhat on my server.
> On the distro, pgsql data are in : /var/lib/pgsql (which is mounted on
> its own partition).
> Can I "just" install the new version of Redhat, reinstall the same
> version of Pos
Hello erverybody,
I need to install a new version of Redhat on my server.
On the distro, pgsql data are in : /var/lib/pgsql (which is mounted on
its own partition).
Can I "just" install the new version of Redhat, reinstall the same
version of Postgresql (7.4.8) ?
I'll do a pgdump all just in ca
Tom,
Need some help in analyzing the pg_controldata output.
pg_control version number: 72Catalog version number: 200310211Database cluster state: in productionpg_control last modified: Wed 19 Oct 2005 02:40:53 AM PDT
Current log file ID:
In error handling suppose if the database already
exists..
It is returning : database "sample(say)" doesn't
exists.
If i want to return general error messages with out
specifying names how can i?
Tell me where can i get the error codes for this
instead of messages and how can i retrieve
12 matches
Mail list logo
