Re: [HACKERS] possibly updating techdocs; mysql2pgsql on gborg

hi
,
I am on a mission to simply keep a starving project off the ground by updating an old mysql->pgsql perl conversion script which does its conversion very differently from the one under contrib/. There is an old link to
http://www.rot13.org/~dpavlin/sql.html
on techdocs under the section

Converting from other Databases to PostgreSQL

in a section which was apparently "Last updated 7th September 2002"

If anybody still has access to that page, the project has moved to gborg specifically
over to

http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

where a new version of the perl conversion script is located.

"Can the link be updated?"

The version on gborg has cvs access and multiple developers, and is being maintained bymyself. I would be amazed if nobody else tweaked it in its weak spots.

thanks,

joe speigle

I don't see the old link you are referring to (and neither did grep); is
this on the main page of techdocs or someplace else?

Robert Treat

On Thu, 2004-07-01 at 01:02, joseph speigle wrote:
> hi
> ,
> I am on a mission to simply keep a starving project off the ground by updating an old mysql->pgsql perl conversion script which does its conversion very differently from the one under contrib/. There is an old link to
> http://www.rot13.org/~dpavlin/sql.html
> on techdocs under the section
>
> Converting from other Databases to PostgreSQL
>
> in a section which was apparently "Last updated 7th September 2002"
>
> If anybody still has access to that page, the project has moved to gborg specifically
> over to
>
> http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
>
> where a new version of the perl conversion script is located.
>
> "Can the link be updated?"
>
> The version on gborg has cvs access and multiple developers, and is being maintained bymyself. I would be amazed if nobody else tweaked it in its weak spots.
>
> thanks,
>
> joe speigle
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

I have updated the /contrib/mysql/README file to point to the new URL's.
Thanks.

---------------------------------------------------------------------------

Robert Treat wrote:
> I don't see the old link you are referring to (and neither did grep); is
> this on the main page of techdocs or someplace else?
>
> Robert Treat
>
> On Thu, 2004-07-01 at 01:02, joseph speigle wrote:
> > hi
> > ,
> > I am on a mission to simply keep a starving project off the ground by updating an old mysql->pgsql perl conversion script which does its conversion very differently from the one under contrib/. There is an old link to
> > http://www.rot13.org/~dpavlin/sql.html
> > on techdocs under the section
> >
> > Converting from other Databases to PostgreSQL
> >
> > in a section which was apparently "Last updated 7th September 2002"
> >
> > If anybody still has access to that page, the project has moved to gborg specifically
> > over to
> >
> > http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
> >
> > where a new version of the perl conversion script is located.
> >
> > "Can the link be updated?"
> >
> > The version on gborg has cvs access and multiple developers, and is being maintained bymyself. I would be amazed if nobody else tweaked it in its weak spots.
> >
> > thanks,
> >
> > joe speigle
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
> !DSPAM:40e46b7246695510113564!
>
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

hi,
just a contrib/mysql/README patch. Somehow the links got reversed.

5c5
< http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
---
> http://www.omnistarinc.com/~fonin/downloads.php#my2pg
9c9
< Another tool, mysql2pgsql, can be found at:
---
> A third tool, mysql2pgsql.perl, can be found at:
11c11
< http://www.omnistarinc.com/~fonin/downloads.php#my2pg
---
> http://gborg.postgresql.org/project/mysql2psql/projdisplay.php

On Thu, Jul 15, 2004 at 12:45:51AM -0400, Robert Treat wrote:
> Hey Joseph, just noticed this in my drafts folder... not sure why it was
> there, hope it makes sense to you :-)
>
> ----
> OK, I have updated the link on the techdocs site, and after looking at your
> project statement have a few recommendations for you. The first is that you
> need to put some mention that your script is a descendant of Dobrica's script
> just to give props to those who came before but also so people know to use
> your script over the old one. Second, you need to send a patch to
> pgsql-patches for the postgresql core server that updates
> contrib/mysql/README and contrib/mysql/mysql2pgsql.pl to reference your newer
> script. Since we are technically past feature freeze, you need to include a
> list of any bugs that were fixed in the old script by the new script.
>
> Hope this helps.
>
> Robert Treat
>
> On Thursday 01 July 2004 17:22, you wrote:
> > > I don't see the old link you are referring to (and neither did grep); is
> > > this on the main page of techdocs or someplace else?
> > >
> > > Robert Treat
> >
> > If the main page is http://techdocs.postgresql.org/
> > (which may be index.htm or index.php but my browser doesn't show) that is
> > where the outdated link is.
> >
> > This is what I see when I do "view source" on that page:
> >
> > <li><a
> > href="/redir.php?link=http://docman.sourceforge.net/home_html/projects/sql/
> >mysql2pgsql" target="_blank">mysql2pgsql</a> - A Perl script used to convert
> > MySQL databases dump to a PostgreSQL-compatible format, by <a
> > href="/redir.php?link=mailto:dpavlin(at)rot13(dot)org" target="_blank">Dobrica
> > Pavlinusic</a></li>
> >
> > HISTORY
> > =======
> > Dobrica Pavlinusic has a project called docman at sourceforge
> > In a subdirectory of the project there he put the file mysql2pgsql
> > That file on sourceforge hasn't been edited since 19-Apr-2001 (dir listing)
> > The most recent version of the mysql2pgsql script is at
> > http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
> >
> > thanks for your reply.
> >
> > joesp
>
> --
> Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Thanks, fixed.

---------------------------------------------------------------------------

joe speigle wrote:
> hi,
> just a contrib/mysql/README patch. Somehow the links got reversed.
>
> 5c5
> < http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
> ---
> > http://www.omnistarinc.com/~fonin/downloads.php#my2pg
> 9c9
> < Another tool, mysql2pgsql, can be found at:
> ---
> > A third tool, mysql2pgsql.perl, can be found at:
> 11c11
> < http://www.omnistarinc.com/~fonin/downloads.php#my2pg
> ---
> > http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
>
> On Thu, Jul 15, 2004 at 12:45:51AM -0400, Robert Treat wrote:
> > Hey Joseph, just noticed this in my drafts folder... not sure why it was
> > there, hope it makes sense to you :-)
> >
> > ----
> > OK, I have updated the link on the techdocs site, and after looking at your
> > project statement have a few recommendations for you. The first is that you
> > need to put some mention that your script is a descendant of Dobrica's script
> > just to give props to those who came before but also so people know to use
> > your script over the old one. Second, you need to send a patch to
> > pgsql-patches for the postgresql core server that updates
> > contrib/mysql/README and contrib/mysql/mysql2pgsql.pl to reference your newer
> > script. Since we are technically past feature freeze, you need to include a
> > list of any bugs that were fixed in the old script by the new script.
> >
> > Hope this helps.
> >
> > Robert Treat
> >
> > On Thursday 01 July 2004 17:22, you wrote:
> > > > I don't see the old link you are referring to (and neither did grep); is
> > > > this on the main page of techdocs or someplace else?
> > > >
> > > > Robert Treat
> > >
> > > If the main page is http://techdocs.postgresql.org/
> > > (which may be index.htm or index.php but my browser doesn't show) that is
> > > where the outdated link is.
> > >
> > > This is what I see when I do "view source" on that page:
> > >
> > > <li><a
> > > href="/redir.php?link=http://docman.sourceforge.net/home_html/projects/sql/
> > >mysql2pgsql" target="_blank">mysql2pgsql</a> - A Perl script used to convert
> > > MySQL databases dump to a PostgreSQL-compatible format, by <a
> > > href="/redir.php?link=mailto:dpavlin(at)rot13(dot)org" target="_blank">Dobrica
> > > Pavlinusic</a></li>
> > >
> > > HISTORY
> > > =======
> > > Dobrica Pavlinusic has a project called docman at sourceforge
> > > In a subdirectory of the project there he put the file mysql2pgsql
> > > That file on sourceforge hasn't been edited since 19-Apr-2001 (dir listing)
> > > The most recent version of the mysql2pgsql script is at
> > > http://gborg.postgresql.org/project/mysql2psql/projdisplay.php
> > >
> > > thanks for your reply.
> > >
> > > joesp
> >
> > --
> > Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
> joining column's datatypes do not match
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073