All pastes #120257 Raw Edit

StarScream

public text v1 · immutable
·published 2006-08-07 07:00 UTC
rendered paste body
designaname=# select currval('product_id_seq');
ERROR:  currval of sequence "product_id_seq" is not yet defined in this session
designaname=# \d product;
                                  Table "public.product"
   Column    |          Type          |                     Modifiers
-------------+------------------------+----------------------------------------------------
 id          | integer                | not null default nextval('"product_id_seq"'::text)
 labelcode   | character varying(20)  |
 active      | boolean                | default true
 name        | character varying(255) |
 description | character varying(255) |
 width       | integer                |
 height      | integer                |
 customprice | numeric(8,2)           |
 rank        | integer                |
 max_custom  | integer                |
 summary     | character varying      |
 banner      | character varying      |
 copy        | character varying      |
 ispack      | boolean                | default false
Indexes:
    "product_pkey" primary key, btree (id)
    "product_labelcode_key" unique, btree (labelcode)
    "product_rank_key" btree (rank)