[GENERAL] Install issue on Kubuntu

Hello,I am hoping this is the right place.I have recently switched to Kubuntu and I just installed Postgres on it. The installation was successful.When I try psql, I get this error message, though:% psql postgresError: You must install at least one postgresql-client-version package.But I have

[GENERAL] COPY has no access permissions

Hello, I found something interesting when I try to load a text file into a table. I am on Windows XP and I am using the Copy command. If the file is under C:\Documents And Settings or anywhere under that folder, the database complains that it has no access permissions. (The file is on my

Re: [GENERAL] COPY has no access permissions

Thanks, Mike! Your solution seems to have solved it. --- mike [EMAIL PROTECTED] wrote: XP is denying access to your desktop to the postgres account which the database service is running on. If you go to the folder C:\Document and Settings\your_login_id, right click on it, select

[GENERAL] Add columns

I see that one can add a new column to an existing table. The documentation was not clear on how efficient this operation would be. Does PostgreSQL make a copy of the entire table when adding a new column? Or does it simply use extra space in the data blocks to add the new column?

[GENERAL] How: single db, multiple users

Greetings, I am new to PostgreSQL and come from an DB2 background. I currently have v8.0.3 up and running. So far, it looks great! One area I am confused about is how to set up databases and users. I can currently create databases, but I am having difficulty in assigning mutiple users to

Re: [GENERAL] How: single db, multiple users

--- Eric E [EMAIL PROTECTED] wrote: At the database level, you can assign creation and other permissions to users, but (AFAIK) you cannot deny users to a database. However, you can effectively control users' access to a particular database by granting or denying them access to a schema