[ADMIN] primary key problem

2001-09-10 Thread Mohammad Faisal
hey all, the primary key in postgreSQL is implemented as unique index and the unique index can be deleted and as a result the primary key constraints finishes.(oh a problem) what if i don't want an index on a table then in this case how can i implement Primary key constraint. any help t

[ADMIN] Books

2001-09-10 Thread Egon Reetz
Hi, this is only an information. I just found Bruce Momjian's German book in our bookstore. It has a hardcover and it's typo looks much better than the American original. Text is in German, examples in English. Cost about DM 90,-. Egon ---(end of broadcast)

Re: [ADMIN] Changing column modifiers?

2001-09-10 Thread Arne Weiner
It seems that it is not possible to alter column constraints and table constraints do not include NOT NUL. But you can use CHECK as workaround: ALTER TABLE authors ADD CHECK (NOT authorfirstname = NULL); Arne. Tim Boring wrote: > > Can you change a column modifier after you've created

Re: [ADMIN] 'create view' error

2001-09-10 Thread Dong B Calmada
I was also thinking of that. Thanks. On Fri Sep 07, 2001 at 03:38:17PM +0200, Peter Eisentraut ([EMAIL PROTECTED]) wrote: > Dong B Calmada writes: > > > "ERROR: ORDER BY and DISTINCT on views are not implemented." > > Upgrade to 7.1.3. > > -- > Peter Eisentraut [EMAIL PROTECTED] http://

Re: [ADMIN] 'create view' error

2001-09-10 Thread Dong B Calmada
I was also thiking of that. Thanks. On Fri Sep 07, 2001 at 03:38:17PM +0200, Peter Eisentraut ([EMAIL PROTECTED]) wrote: > Dong B Calmada writes: > > > "ERROR: ORDER BY and DISTINCT on views are not implemented." > > Upgrade to 7.1.3. > > -- > Peter Eisentraut [EMAIL PROTECTED] http://f

Re: [ADMIN] 'create view' error

2001-09-10 Thread Dong B Calmada
I was also thinking of that. Thanks. On Fri Sep 07, 2001 at 03:38:17PM +0200, Peter Eisentraut ([EMAIL PROTECTED]) wrote: > Dong B Calmada writes: > > > "ERROR: ORDER BY and DISTINCT on views are not implemented." > > Upgrade to 7.1.3. > > -- > Peter Eisentraut [EMAIL PROTECTED] http://

Re: [ADMIN] FINAL: Multi-User PostgreSQL usage SECURITY

2001-09-10 Thread Henshall, Stuart - WCP
If you want them with the ability to alter the schema within there own database you could create them with createdb enable, create their db and then remove that privilidge, or create the db and change the db owner. I'm not sure how you'd grant them rights to create users. Maybe wit

Re: [ADMIN] primary key problem

2001-09-10 Thread Stephan Szabo
On Mon, 10 Sep 2001, Mohammad Faisal wrote: > the primary key in postgreSQL is implemented as unique > index and the unique index can be deleted and as a > result the primary key constraints finishes.(oh a > problem) > what if i don't want an index on a table then in this > case how can i impleme

[ADMIN] Can't discover database size

2001-09-10 Thread Leandro Rodrigo Saad Cruz
Hi all. This is a PITA and I can find the answer ! how can I discover the size of a single database inside data/ ??? -- Leandro Rodrigo Saad Cruz IT - Inter Business Tecnologia e Servicos (IB) begin:vcard n:Saad Cruz;Leandro x-mozilla-html:FALSE org:Inter Business;IT adr:;; version:2.1 ema

Re: [ADMIN] Can't discover database size

2001-09-10 Thread Oliver Elphick
Leandro Rodrigo Saad Cruz wrote: >how can I discover the size of a single database inside data/ Assuming that by "size" you mean disk blocks: template1=# select oid from pg_database where datname = 'junk'; oid -- 12585534 (1 row) template1=# \q olly@linda:.../debian$ sudo du -