> -----Original Message-----
> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> Milen A. Radev
> Sent: 26 October 2006 10:16
> To: pgadmin-support@postgresql.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.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match

Reply via email to