[ADMIN] primary key problem
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 thanks in advance Faisal __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[ADMIN] Books
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)--- TIP 4: Don't 'kill -9' the postmaster
Re: [ADMIN] Changing column modifiers?
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 the table? For > example, I have a table called "authors" with the following columns: > authorid, authorfirstname, authorlastname, authormi, statecode, country, > born, deceased. > > When I created the table, I forgot to make the "authorfirstname" and > "authorlastname" columns NOT NULL. I've looked at ALTER TABLE but I > don't see a way to use it to add NOT NULL...maybe I'm just missing the > obvious? > > Any help/suggestions are appreciated. > > Thanks, > Tim > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] 'create view' error
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://funkturm.homeip.net/~peter > > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- DONG B. CALMADA Polmap Chief Information Officer Institute for Popular Democracy http://www.ipd.ph Tel. (63-2) 4346674 Fax (63-2) 9262893 Mobile Phone No. 0917-9339099 Alternate email addresses: [EMAIL PROTECTED] [EMAIL PROTECTED] --- Information is power! Set it free! ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] 'create view' error
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://funkturm.homeip.net/~peter > > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- DONG B. CALMADA Polmap Chief Information Officer Institute for Popular Democracy http://www.ipd.ph Tel. (63-2) 4346674 Fax (63-2) 9262893 Mobile Phone No. 0917-9339099 Alternate email addresses: [EMAIL PROTECTED] [EMAIL PROTECTED] --- Information is power! Set it free! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
Re: [ADMIN] 'create view' error
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://funkturm.homeip.net/~peter > > > ---(end of broadcast)--- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html -- DONG B. CALMADA Polmap Chief Information Officer Institute for Popular Democracy http://www.ipd.ph Tel. (63-2) 4346674 Fax (63-2) 9262893 Mobile Phone No. 0917-9339099 Alternate email addresses: [EMAIL PROTECTED] [EMAIL PROTECTED] --- Information is power! Set it free! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
Re: [ADMIN] FINAL: Multi-User PostgreSQL usage SECURITY
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 with an external C function that would check that who was doing what was allowed then update stuff appropriatly (maybe connecting to a special db storing any extra user info you need, probably which owner controls which user/group, although you might be able to do this by having a group for each db with all users a member and a special user for a db which all groups have as a member). - Stuart > -Original Message- > From: Mike Rogers [SMTP:[EMAIL PROTECTED]] > Sent: Friday, September 07, 2001 11:08 PM > To: [EMAIL PROTECTED] > Subject: FINAL: Multi-User PostgreSQL usage SECURITY > > Greets all; > So this issue was raised quite some time ago by many many people and > seems to contantly be asked by new PostgreSQL users. I never seem to find > any real answers for it. > > I am running a multi-user system and wish to have 10 user accounts > with > 10 different corresponding databases. I do not want user 'a' to be able > to > access user 'b's database- Only their own 'a' database. It really > shouldn't be this difficult. I realize that I can revoke access to all > users on the 'a' tables, but then user B can still create tables within > user > A's database. > There has to be an easy solution. As a hosting solutions provider for > a > small number of clients, I have always steered in the direction of MySQL > for > this feature, but I am seeing some demand for PostgreSQL. I do not have > the > resources to run each user with their own copy of PostgreSQL. > > I have tried chaning pg_hba.conf to add the database field to the > user, > but that doesn't seem to help at all. > > Any thoughts? If it makes a difference, i can make the databases the same > name as the username if I must. > > Please let me know if anyone knows of a way to do this. > > Thanks in advance; > -- > Mike ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Re: [ADMIN] primary key problem
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 implement Primary key constraint. If you really want to do it yourself, you could write a trigger procedure that locks the table and then checks to see if the value is already in the table throwing an error if it is. However, that's not going to show up as a primary key for things that might require it (like foreign keys). If you want to use the primary key specification, you need to leave the index alone. ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
[ADMIN] Can't discover database size
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 email;internet:[EMAIL PROTECTED] x-mozilla-cpt:;0 fn:Leandro Saad Cruz end:vcard ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [ADMIN] Can't discover database size
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 -s $PGDATA/base/12585534 Password: 1831/usr1/postgres/data/base/12585534 -- Oliver Elphick[EMAIL PROTECTED] Isle of Wight http://www.lfix.co.uk/oliver PGP: 1024R/32B8FAA1: 97 EA 1D 47 72 3F 28 47 6B 7E 39 CC 56 E4 C1 47 GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "Draw near to God and he will draw near to you. Cleanse your hands, you sinners; and purify your hearts, you double minded." James 4:8 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
