Postgres Pro
Downloads
Home   >   mailing lists

Thread: Once again about 'OID'

Once again about 'OID'

From
Denny Permana
Date:
Hi,
I'm a newbie here and the postgresql. I've installed pgsql through cygwin (on Ms Windows 98), and I use pgadmin II as an interface.
I have a big problem with OID. If I connect with "psql" to database, there were not problems with my job (query, etc). But if I ran pgadmin II and try to open tables or run query, there's something error. The error messages :
 

pgAdmin II Error

An error has occured in pgAdmin II:frmMain.lv_ItemClick:

Number: -2147467259
Description: Error while executing the query
ERROR: Attribute 'oid' not found

I'm curious with oid. How should I do if I want to avoid 'oid' in my tables by using pgadmin II (with psql, I just write "without oid"). Could anybody here give me suggestion how to fix up this problem ?

Regards.

Re: Once again about 'OID'

From
"Josh Berkus"
Date:
Denny,

> pgAdmin II Error
>
> An error has occured in pgAdmin II:frmMain.lv_ItemClick:
>
> Number: -2147467259
> Description: Error while executing the query
> ERROR: Attribute 'oid' not found
>
> I'm curious with oid. How should I do if I want to avoid 'oid' in my
> tables
> by using pgadmin II (with psql, I just write "without oid"). Could
> anybody
> here give me suggestion how to fix up this problem ?

Update to the latest version of PgadminII.  I believe this problem is
fixed. If you have the latest version, try checking your admins
settings for an "allow OID-less tables" checkbox.

-Josh Berkus

Re: Once again about 'OID'

From
"Josh Berkus"
Date:
Denny,

> An error has occured in pgAdmin II:frmSQLInput.cmdExecute_Click:
>
> Number: -2147467259
> Description: Error while executing the query;
> ERROR: Relation "kedua" does not exist.
>
> FYI, this error arise too when using 'psql' command. I tried to use
> both OID
> and not. Table 'kedua' is a really simple table with just one Column.
> Please
> help Me ...

How about sending the query?  From the sound of it, your SQL is bad.

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco