Pgadmin - Help link error

Author

Help link error

Christophe Chauvet

2006-10-26, 5:18 am

-----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/ S4ZhUIzERAp9OAJ9cKG2
odlJJkUCPEMJKWWSWH8z
KigCePK63
sPoZZLwNaD+cO4dEq7sM
R0U=
=T3Jg
-----END PGP SIGNATURE-----

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

Dave Page

2006-10-26, 5:18 am

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Milen A. Radev

2006-10-26, 5:18 am

Dave Page Ð½Ð°Ð¿Ð¸ÑÐ°:
[...]
>
>
> 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/...ql-comment.html) and for 8.2
(http://developer.postgresql.org/pgd...ql-comment.html).

But I didn't test it yet.

--
Milen A. Radev

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Dave Page

2006-10-26, 5:18 am

> -----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 ÎÁÐÉÓÁ:
> [...]
> it can't put
>
> 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/...ql-comment.html)
> and for 8.2
> (http://developer.postgresql.org/pgd...ql-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

Sponsored Links