pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to set ownership of tables?
2+ messages / 2 participants
[nested] [flat]
* how to set ownership of tables?
@ 2001-05-21 20:28 Bruno Boettcher <bboett@erm1.u-strasbg.fr>
2001-05-22 11:42 ` Re: how to set ownership of tables? Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: bboett@erm1.u-strasbg.fr @ 2001-05-21 20:28 UTC (permalink / raw)
To: pgsql-sql
Hello!
how can i change the ownership of a table? i have the problem that i
create table with CONSTRAINTS on other tables, those others have a
different owner... and thus the creation of the table is refused....
is it possible to make constraints on tables whithout having their
ownership? is it possible to grant those rights?
or otherwise, how can i change the owenership of the concerned table?
--
ciao bboett
==============================================================
bboett@earthling.net
http://inforezo.u-strasbg.fr/~bboett http://erm1.u-strasbg.fr/~bboett
===============================================================
the total amount of intelligence on earth is constant.
human population is growing....
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: how to set ownership of tables?
2001-05-21 20:28 how to set ownership of tables? Bruno Boettcher <bboett@erm1.u-strasbg.fr>
@ 2001-05-22 11:42 ` Bruce Momjian <pgman@candle.pha.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Bruce Momjian @ 2001-05-22 11:42 UTC (permalink / raw)
To: Bruno Boettcher <bboett@erm1.u-strasbg.fr>; +Cc: pgsql-sql
> Hello!
>
> how can i change the ownership of a table? i have the problem that i
> create table with CONSTRAINTS on other tables, those others have a
> different owner... and thus the creation of the table is refused....
>
> is it possible to make constraints on tables whithout having their
> ownership? is it possible to grant those rights?
>
> or otherwise, how can i change the owenership of the concerned table?
7.1.X has ALTER TABLE ... OWNER.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-05-22 11:42 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-21 20:28 how to set ownership of tables? Bruno Boettcher <bboett@erm1.u-strasbg.fr>
2001-05-22 11:42 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox