hi,
this simple update closes the connection. I use the database to dynamically update titles and directory on my web
pages.
I show table structure first then the command then, uh, the closed connection.
calling=# \d calling;
Table "public.calling"
Column | Type | Modifiers
-------------+------------------------+-----------
filename | character varying(40) |
description | character varying(180) |
uname | character varying(30) |
Indexes: unique_filename unique btree (filename),
unique_filename_idx btree (filename)
calling=# select * from calling limit 5;
filename | description | uname
-----------------+-------------------------------------+-------
c_java_python | |
conf | old conf directory |
mod_perl_webapp | main weba pplication, now a symlink |
python | |
ssh+ssl | |
(5 rows)
calling=# update calling set uname='pencilhead';
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!# \q
[pencilhead@www postgres]$ psql -d calling
Password:
Welcome to psql 7.3.1, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
calling=# select count(*) from calling;
count
-------
1683
(1 row)
calling=# \dp calling
Access privileges for database "calling"
Schema | Table | Access privileges
--------+-------+---------------------------------
public | calling | {=,pencilhead=arwdRxt}
(1 row)
joe speigle
