Thread: Help link error

Help link error

From
Christophe Chauvet
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Dave

i found 2 problem.

1 - The Help link sql-createcolumn.html associated with help button in create column form does not exist, i think that
is the same one as in creation of table (sql-createtable.html)

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

Regards.

Christophe.
- --
Christophe Chauvet <christophe.chauvet@aznetwork.fr>
AZNetwork
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (MingW32)

iD8DBQFFQFkBMl/S4ZhUIzERAp9OAJ9cKG2odlJJkUCPEMJKWWSWH8zKigCePK63
sPoZZLwNaD+cO4dEq7sMR0U=
=T3Jg
-----END PGP SIGNATURE-----


Re: Help link error

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of
> Christophe Chauvet
> Sent: 26 October 2006 07:43
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Help link error
>
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi Dave
>
> i found 2 problem.
>
> 1 - The Help link sql-createcolumn.html associated with help
> button in create column form does not exist, i think that
> is the same one as in creation of table (sql-createtable.html)

Thanks, fixed in SVN.

> 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.

Regards Dave.


Re: Help link error

From
"Milen A. Radev"
Date:
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.




-- 
Milen A. Radev



Re: Help link error

From
"Dave Page"
Date:

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] 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.