Hi all,
Database: 7.1.3 (RPM)
OS: Redhat 7.1
Table: Create table jquserdata (
Username varchar(20) not null, primary
key,
¡)
Copy some corrupted data from a 7.1.3 (Encoding ASCII) with pg_dump,
Hi,
I am running a productive server of postgresql 7.03, but sometimes it have a high
load average value more than 10, it must be caused by a trouble query, although I have
carefully checked my queries, I still can not find which query made this. I wish there
is a way to monitor the query,
,
other columns;
on each table I excute a query to find a user:
explain select * from users where
username='lt';
and the result
Index Scan using users_username_key on
users (cost=0.00..267.01 rows=306 width=142)
the 2nd:
explain select * from wquserdata where
username='lt';
result
Hi,
I am using Postgresql 7.0.2, and have used some
foreign key in my database, but I get some error like "the backend ended the
connection" where I am trying to insert or delete a row to the master
table(Delete cascade and update cascade). Of course, this error is no use to
find