Dear all,

I would like to try compile Debian DPKG and APT-GET under Windows.

This would allow us to create a modern Windows installer for Cygwin, KDE2/3 
and PostgreSQL. There are already existing project at 
http://debian-cygwin.sourceforge.net/ and http://kde-cygwin.sourceforge.net/. 

The example of http://fink.sourceforge.net/ for MacOSX is quite interesting 
because it includes PostgreSQL. The installation method is so much better 
than Cygwin!!! There is no GUI installer yet, but it will come for sure.

IMHO, this would be the best solution complying with the open-source 
philosophy and goals. Basically, this would provide the framework for :

- creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB 
packages would be downloaded and installed from Debian mirrors, with little 
user intervention. PostgreSQL would be installed as a service.

- a cross-platform GUI environment for (future) pgAdmin. Please note I am not 
dealing with pgAdmin future. Dave Page thinks Mono is the solution. I don't 
agree and think we should use Cygwin-KDE or native Windows libraries.

Is it safe to compile Cygwin using Dev-C++? Is anyone interested in the 
project?

Mark : as you said you were a Windows code-storm, how much time do you think 
it would take for someone like you to port DPKD + APT-GET to Windows and 
create a debian GUI package installer for Cygwin?

Cheers,
Jean-Michel POURE

Wed, 8 May 2002 12:12:42 +0200
Jean-Michel POURE <jm.poure@freesurf.fr>
Cygwin / Debian dpkg / PostgreSQL / KDE2 and 3
On Wed, 8 May 2002, Jean-Michel POURE wrote:

> This would allow us to create a modern Windows installer for Cygwin, KDE2/3
> and PostgreSQL. There are already existing project at
> http://debian-cygwin.sourceforge.net/
I'm subscribed to debian-win32@lists.debian.org mailing list but do no
active development there.  (I think it would be sane to ask this question
there but I do not like to start cross-posting so I leave it in your
hands to post your question there.)

If I'm not completely wrong this project had some success in porting dpkg
and apt might be available in the not so far future - but I might be
wrong.

> and http://kde-cygwin.sourceforge.net/.
I do not know this project.

> IMHO, this would be the best solution complying with the open-source
> philosophy and goals.
I like this project and I hope it will evolve - but my Win knowledge is
nearly zero.

> - creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB
> packages would be downloaded and installed from Debian mirrors, with little
> user intervention. PostgreSQL would be installed as a service.
For sure this is the goal.

> - a cross-platform GUI environment for (future) pgAdmin. Please note I am not
> dealing with pgAdmin future. Dave Page thinks Mono is the solution. I don't
> agree and think we should use Cygwin-KDE or native Windows libraries.
Or alternatively wxGtk/wxWindows which has more options to choose the
programming language if I'm not completely wrong.

> Mark : as you said you were a Windows code-storm, how much time do you think
> it would take for someone like you to port DPKD + APT-GET to Windows and
> create a debian GUI package installer for Cygwin?
Please make sure to ask on debian-win32@lists.debian.org before starting an
additional project.  You can subscribe to this list on the general Debian
subscription page
       http://www.debian.org/MailingLists/subscribe

Kind regards and good luck for the project

           Andreas.

Wed, 8 May 2002 12:42:33 +0200 (CEST)
"Tille, Andreas" <TilleA@rki.de>
Re: Cygwin / Debian dpkg / PostgreSQL / KDE2 and 3
Jean-Michel POURE wrote:
> - creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB 
> packages would be downloaded and installed from Debian mirrors, with little 
> user intervention. PostgreSQL would be installed as a service.
> 
> - a cross-platform GUI environment for (future) pgAdmin. Please note I am not 
> dealing with pgAdmin future. Dave Page thinks Mono is the solution. I don't 
> agree and think we should use Cygwin-KDE or native Windows libraries.

This may be a stupid question, but could the new Mozilla be used as a
cross-platform GUI?  Seems like a natural because it is supposed to be
more of a platform with a browser built on top.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Tue, 4 Jun 2002 01:08:38 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: Cygwin / Debian dpkg / PostgreSQL / KDE2 and 3
Java is another possibility, since it is already cross platform.

Dave
On Tue, 2002-06-04 at 01:08, Bruce Momjian wrote:
> Jean-Michel POURE wrote:
> > - creating a PostgreSQL + Cygwin modern GUI installer. All required .DEB 
> > packages would be downloaded and installed from Debian mirrors, with little 
> > user intervention. PostgreSQL would be installed as a service.
> > 
> > - a cross-platform GUI environment for (future) pgAdmin. Please note I am not 
> > dealing with pgAdmin future. Dave Page thinks Mono is the solution. I don't 
> > agree and think we should use Cygwin-KDE or native Windows libraries.
> 
> This may be a stupid question, but could the new Mozilla be used as a
> cross-platform GUI?  Seems like a natural because it is supposed to be
> more of a platform with a browser built on top.
> 
> -- 
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 853-3000
>   +  If your life is a hard drive,     |  830 Blythe Avenue
>   +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
> http://www.postgresql.org/users-lounge/docs/faq.html
> 
> 




04 Jun 2002 05:29:39 -0400
Dave Cramer <dave@fastcrypt.com>
Re: Cygwin / Debian dpkg / PostgreSQL / KDE2 and 3
On 4 Jun 2002, Dave Cramer wrote:

> Java is another possibility, since it is already cross platform.
... with certain licensing issues ...

Just a remark

          Andreas.

Tue, 4 Jun 2002 15:09:35 +0200 (CEST)
"Tille, Andreas" <TilleA@rki.de>
Re: Cygwin / Debian dpkg / PostgreSQL / KDE2 and 3
The jdbc driver has a method to return the exported keys from a table,
we require essentially what the following select returns, but it is
slow, can anyone suggest ways to optimize it?

Regards,
Dave

 SELECT
        c.relname as primary,
        c2.relname as foreign,
        t.tgconstrname,
        ic.relname as fkeyname,
        af.attnum as fkeyseq,
        ipc.relname as pkeyname,
        ap.attnum as pkeyseq,
        t.tgdeferrable,
        t.tginitdeferred,
        t.tgnargs,t.tgargs,
        p1.proname as updaterule,
        p2.proname as deleterule
FROM
        pg_trigger t,
        pg_trigger t1,
        pg_class c,
        pg_class c2,
        pg_class ic,
        pg_class ipc,
        pg_proc p1,
        pg_proc p2,
        pg_index if,
        pg_index ip,
        pg_attribute af,
        pg_attribute ap
WHERE
        (t.tgrelid=c.oid
        AND t.tgisconstraint
        AND t.tgconstrrelid=c2.oid
        AND t.tgfoid=p1.oid
        and p1.proname like '%%upd')

        and
        (t1.tgrelid=c.oid
        and t1.tgisconstraint
        and t1.tgconstrrelid=c2.oid
        AND t1.tgfoid=p2.oid
        and p2.proname like '%%del')

        AND c2.relname='users'

        AND
        (if.indrelid=c.oid
        AND if.indexrelid=ic.oid
        and ic.oid=af.attrelid
        AND if.indisprimary)

        and
        (ip.indrelid=c2.oid
        and ip.indexrelid=ipc.oid
        and ipc.oid=ap.attrelid
        and ip.indisprimary)
;



04 Jun 2002 09:48:56 -0400
Dave Cramer <dave@fastcrypt.com>
looking for optimum select for exported keys