dear all,
I currently using postgresql v7.0.3
when i import text file to table with command "copy tablename from
'/tmp/a.txt';
and it shows
"copy: line 20, Cannot insert a duplicate key into unique index testpri_pk"
,then it exits with doing nothing.
I want to ignore this errors and continue copy
I had deleted a very large number of records out of my SQL table in order to
decrease the harddisk space. But after I use command 'ls -l
/usr/local/pgsql/data/base/', it is found that the size of concerning files
do not reduce due to the effect of 'delete' SQL command. What should I do
if I woul
dear all
I hava 2 problems about view
1. i can't insert into view
2. i can't create view with union
I try to insert into view as following
create table t1 (id int,name varchar(12) check(id<=10));
create table t2 (id int,name varchar(12) check(id>10));
create view v1 as select * from t1,t2;
insert
Dear Sir.
Would you like to inform me how to modify type
in table?
For example , I define type as varchar(14) , but
I want to modify to varchar(120). How to do this.
Thank you so much
Jaruwan
Dear Sir,
I will highly appreciated if anyone could
inform me how to solve the following problems in Postgres.
Specifically, sometimes there are the following messages
informed by postgres.
NOTICE: Message from PostgreSQL
backend:
