[ADMIN] 'create view' error

2001-09-06 Thread Dong B Calmada
Hi. This is a newbie concern. I'm trying to create a view from a relation called 'words'. This is what my command looked like: create view words_v as select term, meaning1 from words order by term; I was greeted with an error message, that is: "ERROR: ORDER BY and DISTINCT on views are not imp

Re: [ADMIN] Vacuum and deadlock.

2001-09-06 Thread Jeremy Buchmann
On Wednesday, September 5, 2001, at 07:11 AM, Sébastien HEITZMANN wrote: > Since some week I have some trouble with my database. I use postgres v > 7.1.2 on redhat 7.0 >   > The trouble is that the database lock when in the night some user left > an application open ( which do some read on som

Re: [ADMIN] Need help or advices : databases and tables invisibles and not accessibles !

2001-09-06 Thread Tom Lane
Richard NAGY <[EMAIL PROTECTED]> writes: > Recently, we have found that our databases (all of them) and their > tables are not visible and not accessible > We are using the version 7.0.2 of postgresql on a Linux Red Hat 6.2. > What is the binary file pg_log ? It's very huge ! Is it exactly 1

[ADMIN] pg_dump & windows (what a mess...!)

2001-09-06 Thread pmiranda
Hi, I think I'm closer than yesterday to solving my troubles, but still need some help (remember I couldn't start pg_dump from DOS' command line? well, I still can't). As I couldn't what I was trying to, I tried to connect to Postgres via psql (from the command line) and I got the message: