can't set sequence
| От | Keith Worthington |
|---|---|
| Тема | can't set sequence |
| Дата | |
| Msg-id | 20041210204719.M37555@narrowpathinc.com обсуждение исходный текст |
| Ответы |
Re: can't set sequence
|
| Список | pgsql-novice |
Hi All,
In our database we have a table as described below. When we attempt to write
to the table from our visual basic program we receive an error. "ERROR:
tbl_receiving_receipt_number_seq.nextval: You don't have permissions to set
sequence tbl_receiving_receipt_number_seq" Can someone please explain how to
correct this error? TIA
-- Table: purchase_order.tbl_receiving
-- DROP TABLE purchase_order.tbl_receiving;
CREATE TABLE purchase_order.tbl_receiving
(
po_number int4 NOT NULL,
po_line int2 NOT NULL,
receipt_number serial NOT NULL,
quantity float4 NOT NULL,
receipt_timestamp timestamp NOT NULL DEFAULT ('now'::text)::timestamp(6)
with time zone,
CONSTRAINT tbl_receiving_pkey PRIMARY KEY (po_number, po_line, receipt_number),
CONSTRAINT tbl_receiving_fkey1 FOREIGN KEY (po_number, po_line) REFERENCES
purchase_order.tbl_line_item (po_number, po_line) ON UPDATE CASCADE ON DELETE
RESTRICT
) WITH OIDS;
GRANT ALL ON TABLE purchase_order.tbl_receiving TO public;
GRANT ALL ON TABLE purchase_order.tbl_receiving TO postgres;
GRANT UPDATE, INSERT ON TABLE purchase_order.tbl_receiving TO GROUP loaders;
COMMENT ON TABLE purchase_order.tbl_receiving IS 'Purchase order item
receiving data.';
______________________________________________
99main Internet Services http://www.99main.com
В списке pgsql-novice по дате отправления: