From: | Steven Hirsch <snhirsch(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Odd behavior with 'currval' |
Date: | 2018-02-08 18:20:23 |
Message-ID: | alpine.DEB.2.20.1802081313150.5809@z87 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, 8 Feb 2018, Adrian Klaver wrote:
> What if you do?:
>
> SELECT * FROM udm_asset_type_definition_def_id_seq;
I get:
udm_asset_type_definition_def_id_seq 21 1 1 9223372036854775807 1 1 32 false true
> SELECT currval('udm_asset_type_definition_id_seq');
I get:
[Code: , SQL State: 42P01] ERROR: relation
"udm_asset_type_definition_id_seq" does not exist
Position: 16
> Also what happens if you do:
>
> pg_dump -d db_name -U some_user -s -t udm_asset_type_definition > out.sql
This:
--
-- Name: udm_asset_type_definition; Type: TABLE; Schema: main; Owner:
asset_registry_admins
--
CREATE TABLE udm_asset_type_definition (
def_id bigint DEFAULT nextval('udm_asset_type_definition_def_id_seq'::regclass) NOT NULL,
def_name character varying(32) NOT NULL,
);
ALTER TABLE udm_asset_type_definition OWNER TO asset_registry_admins;
--
-- Name: udm_asset_type_definition udm_asset_type_definition_def_name_key;
Type: CONSTRAINT; Schema: main; Owner: asset_registry_admins
--
ALTER TABLE ONLY udm_asset_type_definition
ADD CONSTRAINT udm_asset_type_definition_def_name_key UNIQUE
(def_name);
--
-- Name: udm_asset_type_definition; Type: ACL; Schema: main; Owner:
asset_registry_admins
--
GRANT SELECT ON TABLE udm_asset_type_definition TO asset_registry_readers;
GRANT ALL ON TABLE udm_asset_type_definition TO asset_registry_writers;
--
From | Date | Subject | |
---|---|---|---|
Next Message | Melvin Davidson | 2018-02-08 18:21:33 | Re: Odd behavior with 'currval' |
Previous Message | Melvin Davidson | 2018-02-08 18:17:54 | Re: Odd behavior with 'currval' |