method by allowing the restore on any linux box that
is running postgress as opposed to having to reconstruct the directory
on another server.
Does anyone have any thoughts on this matter. Is one way better than
the other? Thanks in advance.
Bob Powell
Database Administrator
Hello everyone,
Has anyone installed the postgres php driver. I would like to know how to install it on Linux and then what the proper way to access it is from a php web page. I have been unable to find actual code for php and doing this. Please help. Tha
Hello everyone,
I have created a table as follows:
CREATE TABLE document (
image_id int,
image bytea
);
I want to insert a complete file, let's say an open office docu
Hello everyone:
If I excute the following:
CREATE table Test_backup as
SELECT * FROM Test_Scores;
it creates my table without the original table's constraints or
triggers.
Is there a way to preserve them in the copy?
Thanks.
Bob Powell
Database Administ
?
Also, my method for creating another superuser is to update the
pg_shadow files "usesuper" field to 't'. Are there any issues I should
be aware of for doing such a thing. Thanks.
Bob Powell
Database Administrator
---(end of broadcast)-
f it
there either.
I had a user who uses pgamind on occassion for quering the backend who
told me that he did not intterupt any of the criteria he was running.
Do I just chalk it up to a "transient anomaly" ?
Thanks for any help you can give.
Bob Powell
Da
Hello everyone:
I am attempting to upgrade from 7.2 to 7.4 Postgresql. I have successfully installed 7.4 and am attempting to use the pgdump from 7.2 for 7.4. I'm having only one slight error that I would like some help with.
I create
this.
Thanks.
Bob Powell
Database Administrator
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
ously works fine, it's just when I try to create a table when I
runn into problems. Do I have to list all of the fields except the one I don't want,
or is there another way? Thanks in advance.
Bob Powell
---(end of broadcast)---
TIP
