| From: | frank_lupo <frank_lupo(at)email(dot)it> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | alter database/user set problem |
| Date: | 2003-01-28 12:26:29 |
| Message-ID: | H9FBW5$F54F7ADED8EABA16880DD578A4184387@email.it |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I use the PostgreSQL 7.3.1.
pippo=# ALTER user postgres SET "Autocommit" = "on"\g
ALTER USER
pippo=# ALTER user postgres SET "autocommit" = "off"\g
ALTER USER
pippo=# select usename,useconfig from pg_shadow\g
usename | useconfig
---------------+-------------------------------
postgres | {Autocommit=on,autocommit=off}
Which autocommit it used from the user?
Bye !!
Frank Lupo (Wolf) !!
/\_ _/\
\ o o /
--ooo-----ooo---
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
Fare shopping con EmailConto Risparmio è facile e conveniente: con un solo click sconti tutti i tuoi acquisti!
Provalo adesso.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=839&d=28-1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ron | 2003-01-28 13:19:55 | Re: list server problems? |
| Previous Message | Uroš Gruber | 2003-01-28 12:10:09 | Re: tsearch comments |