개발자 Q&A

개발하다 막혔다면? 여기서 질문하세요! 초보부터 고수까지, 함께 고민하고 해결하는 공간입니다. 누구나 자유롭게 질문하고 답변을 남겨보세요!

2025.05.19 03:13

pg_last_oid와 관련하여 질문합니다

목록
  • 앱스토어장인 12일 전 2025.05.19 03:13
  • 21
    1
저는 PostgreSQL에서 데이터베이스 오브젝트 ID를 조회할 때 pg_last_oid를 사용하고 있습니다.
하지만 pg_last_oid는 어떤 경우에 NULL 값을 반환하고 어떤 경우에 실제 오브젝트 ID를 반환하는지 이해가 잘 안됩니다.
pg_last_oid가 NULL 값을 반환하는 경우는 언제이며, 실제 오브젝트 ID를 반환하는 경우는 언제인지 알려주시겠습니까?

    댓글목록

    profile_image
    나우호스팅 　12일 전



    pg_last_oid는 PostgreSQL에서 마지막으로 INSERT, UPDATE, DELETE, TRUNCATE, ALTER TABLE, DROP TABLE, CREATE INDEX, DROP INDEX, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLE, DROP TABLE, CREATE INDEX, DROP INDEX, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION, CREATE LANGUAGE, DROP LANGUAGE, CREATE PROCEDURE, DROP PROCEDURE, CREATE TABLESPACE, DROP TABLESPACE, CREATE SEQUENCE, DROP SEQUENCE, CREATE RULE, DROP RULE, CREATE TRIGGER, DROP TRIGGER, CREATE FUNCTION, DROP FUNCTION, CREATE OPERATOR, DROP OPERATOR, CREATE CAST, DROP CAST, CREATE AGGREGATE, DROP AGGREGATE, CREATE TYPE, DROP TYPE, CREATE CONVERSION, DROP CONVERSION

    2025-05-19 03:14

  • 개발자 Q&A 포인트 정책
      글쓰기
      50P
      댓글
      10P
  • 전체 24,069건 / 27 페이지

검색

게시물 검색