can't set sequence

Поиск
Список
Период
Сортировка
От Keith Worthington
Тема can't set sequence
Дата
Msg-id 20041210204719.M37555@narrowpathinc.com
обсуждение исходный текст
Ответы Re: can't set sequence  (Michael Fuhr <mike@fuhr.org>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Hammond
Дата:
Сообщение: Re: Slow delete
Следующее
От: "Kevin B."
Дата:
Сообщение: Version 8 & column order