Re: [pgadmin-support] Error Message

2003-07-02 Thread Dave Page
> -Original Message- > From: Weiher Martin (LEG) [mailto:[EMAIL PROTECTED] > Sent: 02 July 2003 19:34 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Error Message > > > Description: Fehler bei einer aus mehreren Schritten > bestehenden OLE DB-Operation. Prüfen Sie die einzelne

[pgadmin-support] Error Message

2003-07-02 Thread Weiher Martin (LEG)
-- System Information -- Platform: Windows 2000 Version:5.0 Build: 2195 Service Pack 2 -- Application Information -- Name: pgAdmin II Version:1.5.60 Descripton: Name: pgSchema Version:1.5.60 Descript

[pgadmin-support] Error Message

2003-07-02 Thread Weiher Martin (LEG)
-- System Information -- Platform: Windows 2000 Version:5.0 Build: 2195 Service Pack 2 -- Application Information -- Name: pgAdmin II Version:1.5.60 Descripton: Name: pgSchema Version:1.5.60 Descript

Re: [pgadmin-support] Index not shown

2003-07-02 Thread Dave Page
> -Original Message- > From: Andreas Pflug [mailto:[EMAIL PROTECTED] > Sent: 02 July 2003 18:50 > Cc: Dave Page; Mendola Gaetano; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Index not shown > > > > Fixed and committed. Thanks. ---(end of broadcast)--

[Fwd: Re: [pgadmin-hackers] [pgadmin-support] CVS]

2003-07-02 Thread Adam H. Pendleton
Adam H. Pendleton wrote: John Bercik wrote: [EMAIL PROTECTED] lib]# ls -l total 7192 lrwxrwxrwx1 root root 24 Jul 2 09:40 libwx_gtk2u-2.5.so -> libwx_gtk2u-2.5.so.0.0.0 lrwxrwxrwx1 root root 24 Jul 2 09:40 libwx_gtk2u-2.5.so.0 -> libwx_gtk2u-2.5.so.0.0.0 -r

Re: [pgadmin-support] CVS

2003-07-02 Thread Adam H. Pendleton
John Bercik wrote: Can anyone tell me step by step how to install CVS versions of pgAdmin3? I am doing: cvs -z3 -d :pserver:[EMAIL PROTECTED]:/disk1/cvsroot co pgadmin3 That works but then I do ./configure --prefix=/usr/local/wx2 --enable-gtk2 --enable-unicode make && make install and when I

[pgadmin-support] CVS

2003-07-02 Thread John Bercik
Can anyone tell me step by step how to install CVS versions of pgAdmin3? I am doing: cvs -z3 -d :pserver:[EMAIL PROTECTED]:/disk1/cvsroot co pgadmin3 That works but then I do ./configure --prefix=/usr/local/wx2 --enable-gtk2 --enable-unicode make && make install and when I'm done pgAdmin3 s

Re: [pgadmin-support] Index not shown

2003-07-02 Thread Andreas Pflug
Andreas Pflug wrote: Dave Page wrote: -Original Message- From: Mendola Gaetano [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 13:36 To: Dave Page; [EMAIL PROTECTED] Subject: Re: [pgadmin-support] Index not shown "Dave Page" <[EMAIL PROTECTED]> wrote: -Original Message- From

Re: [pgadmin-support] Index not shown

2003-07-02 Thread Andreas Pflug
Dave Page wrote: -Original Message- From: Mendola Gaetano [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 13:36 To: Dave Page; [EMAIL PROTECTED] Subject: Re: [pgadmin-support] Index not shown "Dave Page" <[EMAIL PROTECTED]> wrote: -Original Message- From: Mendola Gaetano [ma

Re: [pgadmin-support] schema support

2003-07-02 Thread Dave Page
Both fixed now in CVS - thanks for the report. Regards, Dave. > -Original Message- > From: John Bercik [mailto:[EMAIL PROTECTED] > Sent: 02 July 2003 16:53 > To: pgadmin support > Subject: Re: [pgadmin-support] schema support > > > and also a ; is needed after > > -- ALTER TABLE i.tbl

Re: [pgadmin-support] schema support

2003-07-02 Thread John Bercik
and also a ; is needed after -- ALTER TABLE i.tblsitegroups DROP CONSTRAINT > fk_tblsatellitemanager_tblsites_fk On Wed, 2003-07-02 at 11:47, John Bercik wrote: > Hi, My sql appears to be missing my "i" schema. I believe it should > be "REFERENCES i.tblsites". When I make it with "i." it wo

[pgadmin-support] schema support

2003-07-02 Thread John Bercik
Hi, My sql appears to be missing my "i" schema. I believe it should be "REFERENCES i.tblsites". When I make it with "i." it works fine. Thanks for any ideas. John -- Foreign Key: i.fk_tblsatellitemanager_tblsites_fk -- ALTER TABLE i.tblsitegroups DROP CONSTRAINT fk_tblsatellitemanager_tblsi

[pgadmin-support] pgAdmin III - Call for Translators

2003-07-02 Thread Dave Page
As many of you already know, pgAdmin is a widely used Open Source GUI Management tool for PostgreSQL, similar to DB2's Control Center or SQL Server's Enterprise Manager. We are currently working on the next generation pgAdmin III, with the aim of releasing it at approximately the same time as Pos

Re: [pgadmin-support] Index not shown

2003-07-02 Thread Dave Page
> -Original Message- > From: Mendola Gaetano [mailto:[EMAIL PROTECTED] > Sent: 02 July 2003 13:36 > To: Dave Page; [EMAIL PROTECTED] > Subject: Re: [pgadmin-support] Index not shown > > > "Dave Page" <[EMAIL PROTECTED]> wrote: > > > -Original Message- > > > From: Mendola Gaetan

Re: [pgadmin-support] Index not shown

2003-07-02 Thread Mendola Gaetano
"Dave Page" <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: Mendola Gaetano [mailto:[EMAIL PROTECTED] > > Sent: 02 July 2003 13:01 > > To: [EMAIL PROTECTED] > > Subject: [pgadmin-support] Index not shown > > > > > > I hava a table with 16 indexes > > and 2 UNIQUE constraint.

Re: [pgadmin-hackers] [pgadmin-support] copy paste ?

2003-07-02 Thread Dave Page
Title: Message   -Original Message-From: Adam H. Pendleton [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 12:30To: Dave PageCc: John Bercik; pgadmin support; [EMAIL PROTECTED]Subject: Re: [pgadmin-hackers] [pgadmin-support] copy paste ?Dave Page wrote: Hi John, The ma

Re: [pgadmin-support] Index not shown

2003-07-02 Thread Dave Page
> -Original Message- > From: Mendola Gaetano [mailto:[EMAIL PROTECTED] > Sent: 02 July 2003 13:01 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Index not shown > > > I hava a table with 16 indexes > and 2 UNIQUE constraint. > On the indexes list I see only the 16 indexes, > BTW

[pgadmin-support] Index not shown

2003-07-02 Thread Mendola Gaetano
I hava a table with 16 indexes and 2 UNIQUE constraint. On the indexes list I see only the 16 indexes, BTW that 2 UNIQUE constraint are indexes too. Regards Gaetano Mendola ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [pgadmin-support] Tipo error

2003-07-02 Thread Dave Page
> -Original Message- > From: Mendola Gaetano [mailto:[EMAIL PROTECTED] > Sent: 02 July 2003 12:38 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Tipo error > > > One Tip of the Day say: > > PostgreSQL's performance can be improved by VACUUMing your > databases reguarly. > > ^^

[pgadmin-support] Tipo error

2003-07-02 Thread Mendola Gaetano
One Tip of the Day say: PostgreSQL's performance can be improved by VACUUMing your databases reguarly. ^^ Regards Gaetano Mendola ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your join

Re: [pgadmin-hackers] [pgadmin-support] copy paste ?

2003-07-02 Thread Adam H. Pendleton
Dave Page wrote: Hi John, The major part of the problem is that copy/paste is handled by the window manager not pgAdmin, so it's quite difficult for us to fix. Jean-Michel has tested on the same platform as you (Kde 3/Redhat 9 iirc), and it works fine for him, so it's presumably something

Re: [pgadmin-support] Migration to PostgreSQL from Oracle

2003-07-02 Thread Dave Page
Title: Message Hi,   Can you please recreate the error with logging set to Errors + SQL (under Tools -> Options) and post a copy of the resulting logfile, and the contents of the migration log window?   Thanks, Dave. -Original Message-From: Ramaswamy Murali [mailto:[EMAIL PRO

[pgadmin-support] Migration to PostgreSQL from Oracle

2003-07-02 Thread Ramaswamy Murali
Hi,   I am really excited about PostgreSQL. I have installed PostgreSQL(Database) in Windows 2000 Professional Edition (NT). I am acessing the database from remote client through ODBC. I have created sample database and tables through psql and pgAdmin II. I want to migrate Oracle tables to

[pgadmin-support] rpm script

2003-07-02 Thread Craig Jensen
Hello, I am building an rpm for Mitle SME (a scaled down redhat 7.3) and have all functions working except: I need to have the rpm when installed create a database and a user with privilege to that database. These are the command functions I need to execute within the rpm... # service postgres