Re: [GENERAL] [SQL] Database Design tool

2002-11-05 Thread Robert Treat
Well, actually ERWin does work with PostgreSQL via ODBC. The version I tried was I think the last release of the 3.x series, and I had enough trouble with it to decide against using it. I am told the 4.x series improved things, though if your already familiar with erwin you probably could get by.

Re: [GENERAL] [SQL] Database Design tool

2002-11-05 Thread Patrick Bakker
Title: RE: [GENERAL] [SQL] Database Design tool I had gASQL working once but that was awhile ago. gASQL has now been renamed as Mergeant and is being developed in conjunction with the gnome-db libraries as far as I know. I don't think there has been a stable release of it yet, although it is

Re: [GENERAL] [SQL] Database Design tool

2002-11-05 Thread tony
On Tue, 2002-11-05 at 15:00, Thomas Good wrote: > Is there a page at PostgreSQL.org where all these links are listed? > I've been saving each bit of mail that goes by on this thread...but > a page on Pg would be very nice. ;-) you mean like techdocs.postgresql.org ??? The page that is mentionn

Re: [GENERAL] [SQL] Database Design tool

2002-11-05 Thread Kaare Rasmussen
> Thanks. This gives me a few more tools to look at. Boy, do we have an > answer for the folks who complain "there are no GUI tools for Postgres". While there are a number of GUI tools for PostgreSQL, there's still no real database design tool like ErWin or so. -- Kaare Rasmussen

Re: [GENERAL] [SQL] Database Design tool

2002-11-05 Thread Josh Berkus
Robert, > There are actually two sections on the techdocs site now relating to > this at http://techdocs.postgresql.org/oresources.php > look under the sections ERD Tools and Database Design > > Not that I'm not looking forward to your article Josh ;-) Thanks. This gives me a few more tools to

Re: [GENERAL] [SQL] Database Design tool

2002-11-05 Thread Robert Treat
There are actually two sections on the techdocs site now relating to this at http://techdocs.postgresql.org/oresources.php look under the sections ERD Tools and Database Design Not that I'm not looking forward to your article Josh ;-) Robert Treat On Tue, 2002-11-05 at 11:33, Josh Berkus wrote:

Re: [SQL] Copying a rowtype variable.

2002-11-05 Thread Josh Berkus
Stuart, > Just doing a bit of PL/PGSQL so my first question is: > > 1) should PL/PGSQL questions be posted to the general mailing list, > the sql > mailing list or both? The SQL list is the best place. > 2) I am looking for an elegant way of copying a rowtype variable: > > eg. > > DECLARE >

Re: [GENERAL] [SQL] Database Design tool

2002-11-05 Thread Josh Berkus
Thomas, > > DBVisualizer is pretty good. > > Is there a page at PostgreSQL.org where all these links are listed? > I've been saving each bit of mail that goes by on this thread...but > a page on Pg would be very nice. ;-) I was planning on writing an article; so far, I have a list of about 14 i

Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread Richard Huxton
On Tuesday 05 Nov 2002 2:32 pm, cristi wrote: > On Tuesday 05 Nov 2002 1:03 pm, cristi wrote: > >But - you have deleted the "refcursor" type which is not a good idea! If > Ooo > Yes, I see... > You right. > > >If so, drop and recreate the database, restoring the data to it. If not, I > think y

Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread cristi
On Tuesday 05 Nov 2002 1:03 pm, cristi wrote: > It shouldn't be this the solution of the problem? >> salt=# delete from pg_type where typname='refcursor'; >> DELETE 1 >> Now, I don't have the error message! > >Mr.Richard Huxton, thank you very much! >But - you have deleted the "refcursor" ty

Re: [GENERAL] [SQL] Database Design tool

2002-11-05 Thread Thomas Good
On Tue, 5 Nov 2002, Michael Ansley (UK) wrote: > DBVisualizer is pretty good. Is there a page at PostgreSQL.org where all these links are listed? I've been saving each bit of mail that goes by on this thread...but a page on Pg would be very nice. ;-) Cheers,

[SQL] Copying a rowtype variable.

2002-11-05 Thread Rison, Stuart
Hello, Just doing a bit of PL/PGSQL so my first question is: 1) should PL/PGSQL questions be posted to the general mailing list, the sql mailing list or both? My second question is: 2) I am looking for an elegant way of copying a rowtype variable: eg. DECLARE current_row orf%ROWTYPE;

Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread Richard Huxton
On Tuesday 05 Nov 2002 1:03 pm, cristi wrote: > It shouldn't be this the solution of the problem? > > salt=# delete from pg_type where typname='refcursor'; > DELETE 1 > salt=# delete from pg_type where typname='eee'; > DELETE 1 > salt=# delete from pg_type where typname='mmm'; > DELETE 1 > > Now, I

Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread cristi
It shouldn't be this the solution of the problem? salt=# delete from pg_type where typname='refcursor'; DELETE 1 salt=# delete from pg_type where typname='eee'; DELETE 1 salt=# delete from pg_type where typname='mmm'; DELETE 1 Now, I don't have the error message! Mr.Richard Huxton, thank you ver

Re: [GENERAL] [SQL] Database Design tool

2002-11-05 Thread Michael Ansley (UK)
Title: RE: [GENERAL] [SQL] Database Design tool   -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 DBVisualizer is pretty good. >> -Original Message- >> From: Johannes Lochmann [mailto:[EMAIL PROTECTED]] >> Sent: 30 October 2002 14:36 >> To: [EMAIL PROTECTED]; [EMAIL PROTECTED] >> Sub

Re: [SQL] owner of type 'mmm' apperars to be invalid

2002-11-05 Thread Richard Huxton
On Tuesday 05 Nov 2002 5:57 am, cristi wrote: > When I'm trying to make pg_dump on a data base I have this message: > > WARNING: owner of type 'mmm' apperars to be invalid > WARNING: owner of type 'eee' apperars to be invalid > WARNING: owner of type 'refcursor' apperars to be invalid > > Where ar