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

Thu, 1 Jul 2004 00:02:22 -0500
joseph speigle <joe.speigle@jklh.us>
possibly updating techdocs; mysql2pgsql on gborg
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@postgresql.org)

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


01 Jul 2004 13:55:20 -0400
Robert Treat <xzilla@users.sourceforge.net>
Re: possibly updating techdocs; mysql2pgsql on gborg

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@postgresql.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Sun, 11 Jul 2004 18:52:34 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: possibly updating techdocs; mysql2pgsql on gborg
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@rot13.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

Thu, 15 Jul 2004 12:02:19 -0500
joe speigle <joe@jklh.us>
Re: [HACKERS] possibly updating techdocs; mysql2pgsql on gborg

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@rot13.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

Thu, 15 Jul 2004 14:53:31 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: [HACKERS] possibly updating techdocs; mysql2pgsql on gborg