We are moving from PGAdmin III 1.10 on Windows XP Pro 32 bit to PG Admin
III on Windows 7 Enterprise 64-bit. PG Admin III installed without issue
and the computer is running all other database programs normally.
When we open up PG Admin III and click Server-Add, we are entering
exactly the same
Jon Nelson wrote:
> Would the following query be more (most?) correct, assuming the
> oid of the table is known?
It doesn't seem to work for indexes on expressions.
Try this:
create table t (id int not null primary key, txt text);
create index t_weird on t ((substring(txt, 1, id)));
create
On Thu, Apr 21, 2011 at 11:28 AM, Tom Lane wrote:
> Jon Nelson writes:
>> SQLAlchemy encountered an error introspecting the tables. After
>> inspecting the SQL that it was running, I boiled it down to this:
>
>> SELECT c.relname, a.attname
>> FROM pg_index i, pg_class c, pg_attribute a
>> WHERE
