[pgadmin-support] Error dropping constraint (case sensitivity)

2006-12-15 Thread M S
Hi, I just produced and error message when trying to drop a constraint on a table which is in a schema with a mixed-case name. --- pgAdmin III --- An error has occurred: ERROR: schema "mycomponent" does not exist --- OK

Re: [pgadmin-support] Newbie questions, diff between functions and

2006-12-15 Thread M S
I'd be in favour of removing the distinction - a few people have asked me about the difference. > It's a historic thing - procedures actually appeared in > early versions of EnterpriseDB originally where they were > considered different objects from functions if memory > serves. The distinction

Re: [pgadmin-support] Empty tables show no field headings

2006-12-15 Thread M S
I see this as well, Win XP, pgAdmin 1.6.1, Postgres 8.2. Cheers. >In v1.6.1, when I go to view the data for a table with no (zero) rows, I don't see the columns of the table and no place to key a new record. The table does >have a primary key, and when it's got rows in, I can edit and add new