[ADMIN] Keep a user from creating tables ?

In postgres 7.4, is there any way to stop a user from creating tables in a given database ? I tried (as postgres user): REVOKE ALL ON DATABASE test FROM testuser; testuser can still connect and can still select from the tables I want them to see, but as user "testuser": test=> CREATE TABLE fo

Re: [ADMIN] How to determine if ODBC was compiled in?

Jared Evans wrote: > How would I determine if the Debian Postgresql package I installed > was configured with --enable-odbc option? This is fairly uninteresting, since all this switch controls is whether the ODBC driver gets built. Clearly, there is a Debian package for the ODBC driver. -

Re: [ADMIN] Problems installing 7.4.2

John D. Tiedeman wrote: > With a dying hard disc, I backed up my db files from 7.4.1 and > installed 7.4.2 on my new disc after installing Fedora Core 1. Two > problems: 1. User postgres seems to have been set up automatically, > and I can't find a password that works. There probably isn't one.

Re: [ADMIN] initdb problem (cygwin)

Robert wrote: > creating template1 database in /usr/shared/postgresql/data/base/1... > FATAL: invalid value for parameter "lc_messages": "3079" Perhaps you should set your locale environment to something less bizarre. ---(end of broadcast)--- TIP

Re: [ADMIN] Query

=?iso-8859-15?Q?J=F8rgen_Lie_Pettersen?= <[EMAIL PROTECTED]> wrote: > > Dear Sir or Madam! > > I am a student at a university in Norway, and I'm working on a project > where I shall be a "seller" for PostgreSQL. > I was just wondering, why the name PostgreSQL? Is it a shortening for > something

[ADMIN] Query

Dear Sir or Madam! I am a student at a university in Norway, and I'm working on a project where I shall be a "seller" for PostgreSQL. I was just wondering, why the name PostgreSQL? Is it a shortening for something? Kind regards, Jørgen Lie Pettersen ---(end of broadcast)-

[ADMIN] the schema public

can someone explain me how this works: on a newly created software db the schema 'public' has the right temporary, and the schema itself (within the db) has the right create and usage, but the creates for example are not temporary.. as in create temporary table.. i'm confused:) help me out plz

[ADMIN] initdb problem (cygwin)

hi, i installed postgres (latest version) under cygwin / WinXP. i started ipc-daemon2 when i want to run the initdb routine I got the following error message (watch this) $ initdb -E LATIN1 /usr/shared/postgresql/data The files belonging to this database system will be owned by user This user m

Re: [ADMIN] [SQL] \set

Hi, On Tue, 11 May 2004, Jie Liang wrote: Hi, How to use an internal variable? Original question was how to set a variable in postgresql? If I want to set a variable like start_date='2004-05-10'; How could I use it in my SQL statement? E.g. Db> set start_date '2004-05-10' Db> select start_date as '

[ADMIN] Problems installing 7.4.2

With a dying hard disc, I backed up my db files from 7.4.1 and installed 7.4.2 on my new disc after installing Fedora Core 1. Two problems: 1. User postgres seems to have been set up automatically, and I can't find a password that works. 2. When I try to start psql under my own username, I

[ADMIN] How to determine if ODBC was compiled in?

Hi, How would I determine if the Debian Postgresql package I installed was configured with --enable-odbc option? Jared ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[ADMIN] Installing PostgreSQL on Fedora from RPM

Hello, I just want to install the latest PostgeSQL database server (7.4.2). I am running a Red Hat Fedora Core 1 OS, and I just found a link (ftp://ftp10.us.postgresql.org/pub/postgresql/binary/v7.4.2/fedora/fedora-core-1/) where I can download the RPM's, but I don't know which of them I need

[ADMIN] IPv6 connection / JDBC (?)

Hi! I run pg7.4 on a SuSE 9.1 (IPv6) machine (linux 2.6); despite I added hostall all ::1 :::::::password to my pg_hba.conf, connecting to the database via JDBC (pg74.213.jdbc3.jar) fails: org.postgresql.util.PSQLExcep