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.

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

Java is another possibility, since it is already cross platform.

Dave

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.

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