SEO

#1 (**permalink**) 04-17-2008, 07:36 PM

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

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

#2 (**permalink**) 04-17-2008, 07:36 PM

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto

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

#3 (**permalink**) 04-17-2008, 07:36 PM

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/s...l-comment.html) and for 8.2
(http://developer.postgresql.org/pgdo...-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

#4 (**permalink**) 04-17-2008, 07:36 PM

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto

gadmin-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/s...l-comment.html)
> and for 8.2
> (http://developer.postgresql.org/pgdo...-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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode