From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Milen A(dot) Radev" <milen(at)radev(dot)net>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Help link error |
Date: | 2006-10-26 09:39:32 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40176D8F8@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of
> Milen A. Radev
> Sent: 26 October 2006 10:16
> To: pgadmin-support(at)postgresql(dot)org
> Subject: Re: [pgadmin-support] Help link error
>
> Dave Page написа:
> [...]
> >
> >> 2 - In creation of database, I cannot add a comment directly,
> >> I am obliged to turn over in the properties of the
> >> database after his creation to be able to add a comment
> >
> > Yes - the dialogue executes its SQL against a different database
> > (because of course the new database doesn't exist yet) so
> it can't put
> > the comment in the new database in the same transaction. There's not
> > really any sensible way around this unfortunately.
>
> I believe that is changed in 8.2 - compare the notes for "COMMENT" in
> the docs for 8.1.x
> (http://www.postgresql.org/docs/8.1/static/sql-comment.html)
> and for 8.2
> (http://developer.postgresql.org/pgdocs/postgres/sql-comment.html)
>
> But I didn't test it yet.
Per Milen's reminder of the 8.2 change, I've updated the SVN code to read the description from pg_shdescription for 8.2, and allow the create database dialogue to set the description.
Thanks Milen!
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Proud | 2006-10-26 12:40:21 | Re: Hide databases |
Previous Message | Milen A. Radev | 2006-10-26 09:16:12 | Re: Help link error |