I am trying to work through my own problems with new(). In doing so I ran into
a problem with the Postgres
driver not finding the sequence on my table. The details are below. I pulled
the query from getLastInsertID
and ran with the result shown below, no relname. Below that is the schema for
the table and below that
a query against pg_class that shows that the sequence does exist.
Dabo:
Platform: GTK
Python Version: 2.5.1c1 on linux2
Dabo Version: Version 0.8.3; Revision ~3849
UI Version: 2.8.7.1 on wxGTK (gtk2)
Postgres:
version | PostgreSQL 8.2.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
4.0.3 (Ubuntu 4.0.3-1ubuntu5)
SELECT seq.relname::text
production-# FROM pg_class src, pg_class seq,
pg_namespace, pg_attribute,
production-# pg_depend
production-# WHERE
production-# pg_depend.refobjsubid =
pg_attribute.attnum AND
production-# pg_depend.refobjid = src.oid AND
production-# seq.oid = pg_depend.objid AND
production-# src.relnamespace = pg_namespace.oid AND
production-# pg_attribute.attrelid = src.oid AND
production-# pg_namespace.nspname = 'public' AND
production-# src.relname = 'plant1' AND
production-# pg_attribute.attname = 'p_item_no'
production-# ;
relname
---------
(0 rows)
Table "public.plant1"
Column | Type |
Modifiers
-------------------+--------------------------------+--------------------------------------------------------------------
p_item_no | smallint | not null default
nextval(('plant1_p_item_no_seq'::text)::regclass)
common | character varying(40) | not null
genus | character varying(20) |
species | character varying(30) |
variety | character varying(40) |
plant_type | character varying(6) | not null
series | character varying(20) |
season | character varying(9) |
ts_insert | timestamp(0) without time zone | default now()
ts_update | timestamp(0) without time zone |
user_update | character varying(20) |
user_insert | character varying(20) | default "session_user"()
color | character varying(30) |
category_type | character varying(5) | not null default
'plant'::character varying
category_sub_type | character varying(15) | not null default
'normal'::character varying
Indexes:
"p_no_pkey" PRIMARY KEY, btree (p_item_no)
"common_idx" btree (common)
"genus_idx" btree (genus)
SELECT * from pg_class where relname='plant1_p_item_no_seq';
-[ RECORD 1 ]--+----------------------------------------------
relname | plant1_p_item_no_seq
relnamespace | 2200
reltype | 1093291
relowner | 10
relam | 0
relfilenode | 1093290
reltablespace | 0
relpages | 1
reltuples | 1
reltoastrelid | 0
reltoastidxid | 0
relhasindex | f
relisshared | f
relkind | S
relnatts | 9
relchecks | 0
reltriggers | 0
relukeys | 0
relfkeys | 0
relrefs | 0
relhasoids | f
relhaspkey | f
relhasrules | f
relhassubclass | f
relfrozenxid | 0
relacl | {postgres=rw/postgres,production=rw/postgres}
reloptions | NULL
Thanks,
--
Adrian Klaver
[EMAIL PROTECTED]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
