pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: PGaccess can't find 'oids'
2+ messages / 2 participants
[nested] [flat]
* Re: PGaccess can't find 'oids'
@ 2003-05-24 06:57 Constantin Teodorescu <teo@flex.ro>
0 siblings, 0 replies; 2+ messages in thread
From: Constantin Teodorescu @ 2003-05-24 06:57 UTC (permalink / raw)
To: Lynn <windwalker_2000@yahoo.com>; pgsql-interfaces
Lynn wrote:
>Hi.
>
>=============================================================
>I highlight a table name and then I clicked on the button
>"Design" and an error message pop up "Error:Error: Attribute 'oid' not found"
>Clicked "Details" button
>
>ERROR: Attribute "oid" not found
>
>ERROR: Attribute "oid" not found
>
That's irrecoverable.
PgAccess was designed for PostgreSQL tables that have 'oid' that mean
'object identifier', a long integer that's unique for every row in aby
tables across the database.
Your postgresql seems to use tables without oid's.,
That mean you should configure PostgreSQL to use 'oids' for any tables.
But really I don't know how to do that.
I posted your question on pgsql-interfaces@postgresql.org in order to
receive an answer.
Teo
Braila
>
> while executing
>"pg_select pgsql4 {select oid,indexrelid from pg_index where (pg_class.relname='employee_name')
>and (pg_class.oid=pg_index.indrelid)} rec {
> lappend P..."
> ("uplevel" body line 1)
> invoked from within
>"uplevel pg_select $args"
> (procedure "wpg_select" line 3)
> invoked from within
>"wpg_select $CurrentDB "select oid,indexrelid from pg_index where
>(pg_class.relname='$PgAcVar(tblinfo,tablename)') and (pg_class.oid=pg_index.indrelid)..."
> (procedure "refreshTableInformation" line 48)
> invoked from within
>"refreshTableInformation"
> (procedure "Tables::design" line 5)
> invoked from within
>"Tables::design $objname"
> ("Tables" arm line 2)
> invoked from within
>"switch $PgAcVar(activetab) {
> Tables {
> Tables::design $objname
> }
> Schema {
> Schema::open $objname
> }
> Queries {
> Queries::design $objname
> }
> V..."
> (procedure "Mainlib::cmd_Design" line 7)
> invoked from within
>"Mainlib::cmd_Design"
> invoked from within
>".pgaw:Main.btndesign invoke"
> ("uplevel" body line 1)
> invoked from within
>"uplevel #0 [list $w invoke]"
> (procedure "tkButtonUp" line 7)
> invoked from within
>"tkButtonUp .pgaw:Main.btndesign
>"
> (command bound to event)
>
>
>1) How can I get this error message to go away ?
>
>==============================================
>
>I clciked the "OK" button, and I can see a Table Information window appeared.
>I clicked on the colums TAB
>I created a new field, but it default to one character in length. There is
>no place to change the length of the field.
>
>2) How do I change this field to have a length of 11 characters ?
>
>=============================================
>
>Thank you for your help.
>
>Linh
>
>
>
>__________________________________
>Do you Yahoo!?
>The New Yahoo! Search - Faster. Easier. Bingo.
>http://search.yahoo.com
>
>
>
^ permalink raw reply [nested|flat] 2+ messages in thread
* PGaccess can't find 'oids'
@ 2003-08-01 14:53 Patricia Macary <Patricia.Macary@ecmwf.int>
0 siblings, 0 replies; 2+ messages in thread
From: Patricia Macary @ 2003-08-01 14:53 UTC (permalink / raw)
To: pgsql-interfaces
Hello,
I've found the message below in the archives
(http://archives.postgresql.org/pgsql-interfaces/2003-05/msg00056.php) ,
but I don't find the answer, and I've the same problem...
Do you know how to do ?
Thank you.
"=============================================================
I highlight a table name and then I clicked on the button
"Design" and an error message pop up "Error:Error: Attribute 'oid' not
found"
Clicked "Details" button
ERROR: Attribute "oid" not found
ERROR: Attribute "oid" not found
========================================================"
--
|====================================================================|
| Patricia MACARY |
| ECMWF E-mail: patricia.macary@ecmwf.int |
| Shinfield Park Tel. (+44 118) 9499423 |
| Reading, Berkshire |
| RG2 9AX, UK |
|====================================================================|
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-08-01 14:53 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-24 06:57 Re: PGaccess can't find 'oids' Constantin Teodorescu <teo@flex.ro>
2003-08-01 14:53 PGaccess can't find 'oids' Patricia Macary <Patricia.Macary@ecmwf.int>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox