[pgadmin-support] Security settings

2003-07-17 Thread Armbrust, Daniel C.
I've managed to mess up the permissions on all of the tables in one of my databases One way or another. I'm not sure of the actual sequence of events, but I think that a user of the database got deleted, while it was set as having privileges on these tables. Ever since then, things have be

[pgadmin-support] pgAdmin II 1.6.0 Released

2003-07-17 Thread Dave Page
I'm pleased to announce the release of pgAdmin II v1.6.0. pgAdmin II is a comprehensive PostgreSQL management and administration tool for Microsoft Windows platforms. For more information and downloads, please visit the website at http://www.pgadmin.org/ (kindly hosted by hub.org). This release i

Re: [pgadmin-support] pgAdmin III - SECURE DEFINER instead of SECURITY DEFINER

2003-07-17 Thread Dave Page
Title: Message Thanks, fixed in CVS.   Regards, Dave. -Original Message-From: Donald Fraser [mailto:[EMAIL PROTECTED] Sent: 17 July 2003 11:41To: [pgADMIN]Subject: [pgadmin-support] pgAdmin III - SECURE DEFINER instead of SECURITY DEFINER pgAdmin III July 16th build.  

[pgadmin-support] pgAdmin III - SECURE DEFINER instead of SECURITY DEFINER

2003-07-17 Thread Donald Fraser
pgAdmin III July 16th build.   When I try to edit a function via the properties dialog and I have the "Secure definer" check box item selected on the first tab-page I get errors like: ERROR: parser: parse error at or near "SECURE" at character 364 Looking at the log file it is appending the te

Re: [pgadmin-support] double quoted object names

2003-07-17 Thread Andreas Pflug
Terence Kearns wrote: Doesn't seem like there are many words left in the english language that aren't reserved ;) I didn't realise there were so many [non-]reserved words. Postgres reserves GLOBAL as a "non-reserved" word as opposed to a "reserved" word (just read the docs from the above link)

Re: [pgadmin-support] double quoted object names

2003-07-17 Thread Terence Kearns
Dave Page wrote: It has to otherwise PostgreSQL will fold the identifier to lowercase. I prefer mixed-case multi-word identifiers rather than identifiers with words separated by underscors but I think I will use lowercase everywhere from now on :/ Also, I created a schema called global (no mix

Re: [pgadmin-support] changing comment for a table makes pgadmin

2003-07-17 Thread Marc Cuypers
Andreas Pflug wrote: Marc Cuypers wrote: Hi, I tried to add a comment to an existing column and pgadmin crashed. I'm using the WIN32 snapshot of today. I can't reproduce this, neither in debugging mode nor with the release 20030716. What exactly are the steps you're doing? I can't reproduc

Re: [pgadmin-support] double quoted object names

2003-07-17 Thread Dave Page
> -Original Message- > From: Terence Kearns [mailto:[EMAIL PROTECTED] > Sent: 17 July 2003 07:34 > To: Andreas Pflug > Cc: Dave Page; [EMAIL PROTECTED] > Subject: double quoted object names > > > Andreas Pflug wrote: > > and fooCol is not the same as "fooCol" > > What is the deal with