Maggie Chan writes:
> I am using postgreSQL 7.0.2. Is it necessary to lock the database before
> backup the database (using pg_dump), if not necessary, will the database corrupt
>when someone is
> accessing the database during pg_dump processing?
No need to lock. The dumped data will be a cons
Hi PostgreSQL folks,
I would like to know is there any way to use indexes
with the views or rules in this situation:
cteate table test1(col1 int,col2 int,col3 int);
insert into test1 .;
..
insert into test1 .;
create index test1_col1_col2 on test1(col1,col2);
create view t
R D <[EMAIL PROTECTED]> writes:
> i'm storing col1 to col3 as integers to save storage
> space(infact they are fixed point).I have many tables
> ctrated using this template only the view devidor
> constants are different for each table. Here they are
> 1000.0 1000.0 and 100.0 but for every table t
