[pgadmin-support]

2002-12-06 Thread irolinux
unsubscribe __ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ -

Re: [pgadmin-support] Explain broken with pg7.3 server

2002-12-06 Thread Tino Wildenhain
Hi Dave, --On Freitag, 6. Dezember 2002 21:45 + Dave Page <[EMAIL PROTECTED]> wrote: Arrgghh I hate when that happens. This was about the first 7.3 update that was done *way* before 7.3 was stable. The code in PostgreSQL must have been changed :-(. I'm sorry Dave, I should have mentioned i

Re: [pgadmin-support] Explain broken with pg7.3 server

2002-12-06 Thread Dave Page
> -Original Message- > From: Matthew Gabeler-Lee [mailto:[EMAIL PROTECTED]] > Sent: 06 December 2002 20:24 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Explain broken with pg7.3 server > > > When I use the explain button in pgadmin2 1.4.2 with a > postgresql 7.3 server, I only

Re: [pgadmin-support] Explain broken with pg7.3 server

2002-12-06 Thread Dave Page
Arrgghh I hate when that happens. This was about the first 7.3 update that was done *way* before 7.3 was stable. The code in PostgreSQL must have been changed :-(. I'll look into a fix. Regards, Dave. > -Original Message- > From: Matthew Gabeler-Lee [mailto:[EMAIL PROTECTED]] > Sent: 06

[pgadmin-support] Explain broken with pg7.3 server

2002-12-06 Thread Matthew Gabeler-Lee
When I use the explain button in pgadmin2 1.4.2 with a postgresql 7.3 server, I only get the top line from the plan. 7.3 looks like it returns plans as multiple line result sets, instead of a big notice. -Matt ---(end of broadcast)--- TIP 6

Re: [pgadmin-support] modifying existing tables

2002-12-06 Thread Dave Page
Title: Message Hi,   Yes, there are some modifications you can make - pretty much they are limited to the capabilities of PostgreSQL. Column related properties are modified from the column properties dialogue, not the table dialogue. Basically if it lets you change something, then you can ed

Re: [pgadmin-support] Updating views does not work

2002-12-06 Thread Michiel Lange
Yes, it looks all OK now! (from my other e-mail address that is registered... will register that one from work too!) Thanks! Michiel Lange At 13:38 6-12-2002 +, Dave Page wrote: > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 06 December 2002 12:5

[pgadmin-support] modifying existing tables

2002-12-06 Thread Johnson, Shaunn
Title: Message Howdy:   Is it possible to change / modify a table in pgAdmin II? That is to say, can I create a table and then go back and modify the columns using one of the tools ... not with the SQL tool ...   Thanks!   -X

Re: [pgadmin-support] Updating views does not work

2002-12-06 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 06 December 2002 12:54 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Updating views does not work > > > In pgAdminII 1.4.2 I get the following error when I update a > view: An error has occurred i

[pgadmin-support] Updating views does not work

2002-12-06 Thread Michiel_Lange
In pgAdminII 1.4.2 I get the following error when I update a view: An error has occurred in pgAdmin II:frmView.cmdOK_Click: Number: -2147467259 Description: ERROR: Relation 'contact_klant_view' already exists (contact_klant_view is a view where I have combined two tables using an INNER JOIN) Am I

Re: [pgadmin-support] Versioning removed?

2002-12-06 Thread Dave Page
> -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: 06 December 2002 08:29 > To: [EMAIL PROTECTED] > Subject: [pgadmin-support] Versioning removed? > > > I have a small question about versioning. In the previous > version of PgAdminII I was able to roll-b

[pgadmin-support] Versioning removed?

2002-12-06 Thread Michiel_Lange
I have a small question about versioning. In the previous version of PgAdminII I was able to roll-back changes I made to the database by saving changes to the repository. It appears this is no longer possible. Did you remove it on purpose, if so, what is the reason behind it (just curious), and the

Re: [pgadmin-support] Problems with pgAdmin V1.4.2

2002-12-06 Thread Dave Page
Title: Message Hi Simon (again :-) ) -Original Message-From: Simon Hart [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 21:29To: [EMAIL PROTECTED]Subject: [pgadmin-support] Problems with pgAdmin V1.4.2   - If I edit table data in the SQL output data viewer, I can

Re: [pgadmin-support] Problems with pgAdmin V1.4.2

2002-12-06 Thread Dave Page
Title: Message   -Original Message-From: Simon Hart [mailto:[EMAIL PROTECTED]] Sent: 05 December 2002 21:29To: [EMAIL PROTECTED]Subject: [pgadmin-support] Problems with pgAdmin V1.4.2 Hi,   First many thanks for pgAdminII.   You're welcome.   I've only just s

[pgadmin-support] Problems with pgAdmin V1.4.2

2002-12-06 Thread Simon Hart
Hi,   First many thanks for pgAdminII.   I've only just started using postgresql with pgAdminII so bear with me if I'm being stupid but:   - If I edit table data in the SQL output data viewer, I cannot delete any fields of type 'date'. I get the error 'bad date external representation' when I