PostgreSQL Source Code  git master
 All Data Structures Namespaces Files Functions Variables Typedefs Enumerations Enumerator Macros
foreigncmds.c File Reference
#include "postgres.h"
#include "access/heapam.h"
#include "access/htup_details.h"
#include "access/reloptions.h"
#include "access/xact.h"
#include "catalog/dependency.h"
#include "catalog/indexing.h"
#include "catalog/objectaccess.h"
#include "catalog/pg_foreign_data_wrapper.h"
#include "catalog/pg_foreign_server.h"
#include "catalog/pg_foreign_table.h"
#include "catalog/pg_proc.h"
#include "catalog/pg_type.h"
#include "catalog/pg_user_mapping.h"
#include "commands/defrem.h"
#include "foreign/fdwapi.h"
#include "foreign/foreign.h"
#include "miscadmin.h"
#include "parser/parse_func.h"
#include "tcop/utility.h"
#include "utils/acl.h"
#include "utils/builtins.h"
#include "utils/lsyscache.h"
#include "utils/rel.h"
#include "utils/syscache.h"
Include dependency graph for foreigncmds.c:

Go to the source code of this file.

Data Structures

struct  import_error_callback_arg
 

Functions

static void import_error_callback (void *arg)
 
static Datum optionListToArray (List *options)
 
Datum transformGenericOptions (Oid catalogId, Datum oldOptions, List *options, Oid fdwvalidator)
 
static void AlterForeignDataWrapperOwner_internal (Relation rel, HeapTuple tup, Oid newOwnerId)
 
ObjectAddress AlterForeignDataWrapperOwner (const char *name, Oid newOwnerId)
 
void AlterForeignDataWrapperOwner_oid (Oid fwdId, Oid newOwnerId)
 
static void AlterForeignServerOwner_internal (Relation rel, HeapTuple tup, Oid newOwnerId)
 
ObjectAddress AlterForeignServerOwner (const char *name, Oid newOwnerId)
 
void AlterForeignServerOwner_oid (Oid srvId, Oid newOwnerId)
 
static Oid lookup_fdw_handler_func (DefElem *handler)
 
static Oid lookup_fdw_validator_func (DefElem *validator)
 
static void parse_func_options (List *func_options, bool *handler_given, Oid *fdwhandler, bool *validator_given, Oid *fdwvalidator)
 
ObjectAddress CreateForeignDataWrapper (CreateFdwStmt *stmt)
 
ObjectAddress AlterForeignDataWrapper (AlterFdwStmt *stmt)
 
void RemoveForeignDataWrapperById (Oid fdwId)
 
ObjectAddress CreateForeignServer (CreateForeignServerStmt *stmt)
 
ObjectAddress AlterForeignServer (AlterForeignServerStmt *stmt)
 
void RemoveForeignServerById (Oid srvId)
 
static void user_mapping_ddl_aclcheck (Oid umuserid, Oid serverid, const char *servername)
 
ObjectAddress CreateUserMapping (CreateUserMappingStmt *stmt)
 
ObjectAddress AlterUserMapping (AlterUserMappingStmt *stmt)
 
Oid RemoveUserMapping (DropUserMappingStmt *stmt)
 
void RemoveUserMappingById (Oid umId)
 
void CreateForeignTable (CreateForeignTableStmt *stmt, Oid relid)
 
void ImportForeignSchema (ImportForeignSchemaStmt *stmt)
 

Function Documentation

ObjectAddress AlterForeignDataWrapper ( AlterFdwStmt stmt)

Definition at line 673 of file foreigncmds.c.

References Anum_pg_foreign_data_wrapper_fdwhandler, Anum_pg_foreign_data_wrapper_fdwoptions, Anum_pg_foreign_data_wrapper_fdwvalidator, CatalogTupleUpdate(), ObjectAddress::classId, CStringGetDatum, DatumGetPointer, deleteDependencyRecordsForClass(), DEPENDENCY_NORMAL, ereport, errcode(), errhint(), errmsg(), ERROR, AlterFdwStmt::fdwname, FOREIGNDATAWRAPPERNAME, FOREIGNDATAWRAPPEROID, ForeignDataWrapperRelationId, AlterFdwStmt::func_options, GETSTRUCT, heap_close, heap_freetuple(), heap_modify_tuple(), heap_open(), HeapTupleGetOid, HeapTupleIsValid, InvokeObjectPostAlterHook, Natts_pg_foreign_data_wrapper, NULL, ObjectAddressSet, ObjectAddress::objectId, ObjectIdGetDatum, ObjectAddress::objectSubId, OidIsValid, AlterFdwStmt::options, parse_func_options(), PointerGetDatum, PointerIsValid, ProcedureRelationId, recordDependencyOn(), RelationGetDescr, RowExclusiveLock, SearchSysCacheCopy1, superuser(), SysCacheGetAttr(), HeapTupleData::t_self, transformGenericOptions(), and WARNING.

Referenced by ProcessUtilitySlow().

674 {
675  Relation rel;
676  HeapTuple tp;
679  bool repl_null[Natts_pg_foreign_data_wrapper];
680  bool repl_repl[Natts_pg_foreign_data_wrapper];
681  Oid fdwId;
682  bool isnull;
683  Datum datum;
684  bool handler_given;
685  bool validator_given;
686  Oid fdwhandler;
687  Oid fdwvalidator;
688  ObjectAddress myself;
689 
691 
692  /* Must be super user */
693  if (!superuser())
694  ereport(ERROR,
695  (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
696  errmsg("permission denied to alter foreign-data wrapper \"%s\"",
697  stmt->fdwname),
698  errhint("Must be superuser to alter a foreign-data wrapper.")));
699 
701  CStringGetDatum(stmt->fdwname));
702 
703  if (!HeapTupleIsValid(tp))
704  ereport(ERROR,
705  (errcode(ERRCODE_UNDEFINED_OBJECT),
706  errmsg("foreign-data wrapper \"%s\" does not exist", stmt->fdwname)));
707 
708  fdwForm = (Form_pg_foreign_data_wrapper) GETSTRUCT(tp);
709  fdwId = HeapTupleGetOid(tp);
710 
711  memset(repl_val, 0, sizeof(repl_val));
712  memset(repl_null, false, sizeof(repl_null));
713  memset(repl_repl, false, sizeof(repl_repl));
714 
716  &handler_given, &fdwhandler,
717  &validator_given, &fdwvalidator);
718 
719  if (handler_given)
720  {
721  repl_val[Anum_pg_foreign_data_wrapper_fdwhandler - 1] = ObjectIdGetDatum(fdwhandler);
722  repl_repl[Anum_pg_foreign_data_wrapper_fdwhandler - 1] = true;
723 
724  /*
725  * It could be that the behavior of accessing foreign table changes
726  * with the new handler. Warn about this.
727  */
729  (errmsg("changing the foreign-data wrapper handler can change behavior of existing foreign tables")));
730  }
731 
732  if (validator_given)
733  {
734  repl_val[Anum_pg_foreign_data_wrapper_fdwvalidator - 1] = ObjectIdGetDatum(fdwvalidator);
735  repl_repl[Anum_pg_foreign_data_wrapper_fdwvalidator - 1] = true;
736 
737  /*
738  * It could be that existing options for the FDW or dependent SERVER,
739  * USER MAPPING or FOREIGN TABLE objects are no longer valid according
740  * to the new validator. Warn about this.
741  */
742  if (OidIsValid(fdwvalidator))
744  (errmsg("changing the foreign-data wrapper validator can cause "
745  "the options for dependent objects to become invalid")));
746  }
747  else
748  {
749  /*
750  * Validator is not changed, but we need it for validating options.
751  */
752  fdwvalidator = fdwForm->fdwvalidator;
753  }
754 
755  /*
756  * If options specified, validate and update.
757  */
758  if (stmt->options)
759  {
760  /* Extract the current options */
762  tp,
764  &isnull);
765  if (isnull)
766  datum = PointerGetDatum(NULL);
767 
768  /* Transform the options */
770  datum,
771  stmt->options,
772  fdwvalidator);
773 
774  if (PointerIsValid(DatumGetPointer(datum)))
775  repl_val[Anum_pg_foreign_data_wrapper_fdwoptions - 1] = datum;
776  else
777  repl_null[Anum_pg_foreign_data_wrapper_fdwoptions - 1] = true;
778 
779  repl_repl[Anum_pg_foreign_data_wrapper_fdwoptions - 1] = true;
780  }
781 
782  /* Everything looks good - update the tuple */
783  tp = heap_modify_tuple(tp, RelationGetDescr(rel),
784  repl_val, repl_null, repl_repl);
785 
786  CatalogTupleUpdate(rel, &tp->t_self, tp);
787 
788  heap_freetuple(tp);
789 
791 
792  /* Update function dependencies if we changed them */
793  if (handler_given || validator_given)
794  {
795  ObjectAddress referenced;
796 
797  /*
798  * Flush all existing dependency records of this FDW on functions; we
799  * assume there can be none other than the ones we are fixing.
800  */
802  fdwId,
805 
806  /* And build new ones. */
807 
808  if (OidIsValid(fdwhandler))
809  {
810  referenced.classId = ProcedureRelationId;
811  referenced.objectId = fdwhandler;
812  referenced.objectSubId = 0;
813  recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL);
814  }
815 
816  if (OidIsValid(fdwvalidator))
817  {
818  referenced.classId = ProcedureRelationId;
819  referenced.objectId = fdwvalidator;
820  referenced.objectSubId = 0;
821  recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL);
822  }
823  }
824 
826 
828 
829  return myself;
830 }
int errhint(const char *fmt,...)
Definition: elog.c:987
#define GETSTRUCT(TUP)
Definition: htup_details.h:656
static void parse_func_options(List *func_options, bool *handler_given, Oid *fdwhandler, bool *validator_given, Oid *fdwvalidator)
Definition: foreigncmds.c:516
#define RelationGetDescr(relation)
Definition: rel.h:425
Datum transformGenericOptions(Oid catalogId, Datum oldOptions, List *options, Oid fdwvalidator)
Definition: foreigncmds.c:109
#define PointerGetDatum(X)
Definition: postgres.h:564
#define ProcedureRelationId
Definition: pg_proc.h:33
int errcode(int sqlerrcode)
Definition: elog.c:575
bool superuser(void)
Definition: superuser.c:47
#define Anum_pg_foreign_data_wrapper_fdwhandler
void recordDependencyOn(const ObjectAddress *depender, const ObjectAddress *referenced, DependencyType behavior)
Definition: pg_depend.c:44
#define heap_close(r, l)
Definition: heapam.h:97
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
unsigned int Oid
Definition: postgres_ext.h:31
#define OidIsValid(objectId)
Definition: c.h:533
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
ItemPointerData t_self
Definition: htup.h:65
#define RowExclusiveLock
Definition: lockdefs.h:38
#define CStringGetDatum(X)
Definition: postgres.h:586
char * fdwname
Definition: parsenodes.h:2099
#define ereport(elevel, rest)
Definition: elog.h:122
#define InvokeObjectPostAlterHook(classId, objectId, subId)
Definition: objectaccess.h:163
List * func_options
Definition: parsenodes.h:2100
#define WARNING
Definition: elog.h:40
uintptr_t Datum
Definition: postgres.h:374
Datum SysCacheGetAttr(int cacheId, HeapTuple tup, AttrNumber attributeNumber, bool *isNull)
Definition: syscache.c:1245
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
long deleteDependencyRecordsForClass(Oid classId, Oid objectId, Oid refclassId, char deptype)
Definition: pg_depend.c:241
#define Anum_pg_foreign_data_wrapper_fdwvalidator
#define Natts_pg_foreign_data_wrapper
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
#define NULL
Definition: c.h:226
FormData_pg_foreign_data_wrapper * Form_pg_foreign_data_wrapper
void CatalogTupleUpdate(Relation heapRel, ItemPointer otid, HeapTuple tup)
Definition: indexing.c:210
#define ForeignDataWrapperRelationId
#define ObjectAddressSet(addr, class_id, object_id)
Definition: objectaddress.h:40
#define DatumGetPointer(X)
Definition: postgres.h:557
List * options
Definition: parsenodes.h:2101
#define SearchSysCacheCopy1(cacheId, key1)
Definition: syscache.h:158
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define HeapTupleGetOid(tuple)
Definition: htup_details.h:695
HeapTuple heap_modify_tuple(HeapTuple tuple, TupleDesc tupleDesc, Datum *replValues, bool *replIsnull, bool *doReplace)
Definition: heaptuple.c:793
#define PointerIsValid(pointer)
Definition: c.h:521
#define Anum_pg_foreign_data_wrapper_fdwoptions
ObjectAddress AlterForeignDataWrapperOwner ( const char *  name,
Oid  newOwnerId 
)

Definition at line 277 of file foreigncmds.c.

References AlterForeignDataWrapperOwner_internal(), CStringGetDatum, ereport, errcode(), errmsg(), ERROR, FOREIGNDATAWRAPPERNAME, ForeignDataWrapperRelationId, heap_close, heap_freetuple(), heap_open(), HeapTupleGetOid, HeapTupleIsValid, ObjectAddressSet, RowExclusiveLock, and SearchSysCacheCopy1.

Referenced by ExecAlterOwnerStmt().

278 {
279  Oid fdwId;
280  HeapTuple tup;
281  Relation rel;
282  ObjectAddress address;
283 
285 
287 
288  if (!HeapTupleIsValid(tup))
289  ereport(ERROR,
290  (errcode(ERRCODE_UNDEFINED_OBJECT),
291  errmsg("foreign-data wrapper \"%s\" does not exist", name)));
292 
293  fdwId = HeapTupleGetOid(tup);
294 
295  AlterForeignDataWrapperOwner_internal(rel, tup, newOwnerId);
296 
298 
299  heap_freetuple(tup);
300 
302 
303  return address;
304 }
int errcode(int sqlerrcode)
Definition: elog.c:575
#define heap_close(r, l)
Definition: heapam.h:97
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
unsigned int Oid
Definition: postgres_ext.h:31
#define ERROR
Definition: elog.h:43
#define RowExclusiveLock
Definition: lockdefs.h:38
#define CStringGetDatum(X)
Definition: postgres.h:586
#define ereport(elevel, rest)
Definition: elog.h:122
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
#define ForeignDataWrapperRelationId
const char * name
Definition: encode.c:521
#define ObjectAddressSet(addr, class_id, object_id)
Definition: objectaddress.h:40
#define SearchSysCacheCopy1(cacheId, key1)
Definition: syscache.h:158
int errmsg(const char *fmt,...)
Definition: elog.c:797
static void AlterForeignDataWrapperOwner_internal(Relation rel, HeapTuple tup, Oid newOwnerId)
Definition: foreigncmds.c:207
#define HeapTupleGetOid(tuple)
Definition: htup_details.h:695
static void AlterForeignDataWrapperOwner_internal ( Relation  rel,
HeapTuple  tup,
Oid  newOwnerId 
)
static

Definition at line 207 of file foreigncmds.c.

References aclnewowner(), Anum_pg_foreign_data_wrapper_fdwacl, Anum_pg_foreign_data_wrapper_fdwowner, CatalogTupleUpdate(), changeDependencyOnOwner(), DatumGetAclP, ereport, errcode(), errhint(), errmsg(), ERROR, ForeignDataWrapperRelationId, GETSTRUCT, heap_getattr, heap_modify_tuple(), HeapTupleGetOid, InvokeObjectPostAlterHook, NameStr, Natts_pg_foreign_data_wrapper, ObjectIdGetDatum, PointerGetDatum, RelationGetDescr, superuser(), superuser_arg(), and HeapTupleData::t_self.

Referenced by AlterForeignDataWrapperOwner(), and AlterForeignDataWrapperOwner_oid().

208 {
211  bool repl_null[Natts_pg_foreign_data_wrapper];
212  bool repl_repl[Natts_pg_foreign_data_wrapper];
213  Acl *newAcl;
214  Datum aclDatum;
215  bool isNull;
216 
218 
219  /* Must be a superuser to change a FDW owner */
220  if (!superuser())
221  ereport(ERROR,
222  (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
223  errmsg("permission denied to change owner of foreign-data wrapper \"%s\"",
224  NameStr(form->fdwname)),
225  errhint("Must be superuser to change owner of a foreign-data wrapper.")));
226 
227  /* New owner must also be a superuser */
228  if (!superuser_arg(newOwnerId))
229  ereport(ERROR,
230  (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
231  errmsg("permission denied to change owner of foreign-data wrapper \"%s\"",
232  NameStr(form->fdwname)),
233  errhint("The owner of a foreign-data wrapper must be a superuser.")));
234 
235  if (form->fdwowner != newOwnerId)
236  {
237  memset(repl_null, false, sizeof(repl_null));
238  memset(repl_repl, false, sizeof(repl_repl));
239 
240  repl_repl[Anum_pg_foreign_data_wrapper_fdwowner - 1] = true;
241  repl_val[Anum_pg_foreign_data_wrapper_fdwowner - 1] = ObjectIdGetDatum(newOwnerId);
242 
243  aclDatum = heap_getattr(tup,
245  RelationGetDescr(rel),
246  &isNull);
247  /* Null ACLs do not require changes */
248  if (!isNull)
249  {
250  newAcl = aclnewowner(DatumGetAclP(aclDatum),
251  form->fdwowner, newOwnerId);
252  repl_repl[Anum_pg_foreign_data_wrapper_fdwacl - 1] = true;
254  }
255 
256  tup = heap_modify_tuple(tup, RelationGetDescr(rel), repl_val, repl_null,
257  repl_repl);
258 
259  CatalogTupleUpdate(rel, &tup->t_self, tup);
260 
261  /* Update owner dependency reference */
263  HeapTupleGetOid(tup),
264  newOwnerId);
265  }
266 
268  HeapTupleGetOid(tup), 0);
269 }
int errhint(const char *fmt,...)
Definition: elog.c:987
#define GETSTRUCT(TUP)
Definition: htup_details.h:656
#define Anum_pg_foreign_data_wrapper_fdwowner
#define RelationGetDescr(relation)
Definition: rel.h:425
#define DatumGetAclP(X)
Definition: acl.h:113
#define PointerGetDatum(X)
Definition: postgres.h:564
int errcode(int sqlerrcode)
Definition: elog.c:575
bool superuser(void)
Definition: superuser.c:47
#define Anum_pg_foreign_data_wrapper_fdwacl
void changeDependencyOnOwner(Oid classId, Oid objectId, Oid newOwnerId)
Definition: pg_shdepend.c:303
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
ItemPointerData t_self
Definition: htup.h:65
#define ereport(elevel, rest)
Definition: elog.h:122
#define InvokeObjectPostAlterHook(classId, objectId, subId)
Definition: objectaccess.h:163
bool superuser_arg(Oid roleid)
Definition: superuser.c:57
#define heap_getattr(tup, attnum, tupleDesc, isnull)
Definition: htup_details.h:769
uintptr_t Datum
Definition: postgres.h:374
#define Natts_pg_foreign_data_wrapper
FormData_pg_foreign_data_wrapper * Form_pg_foreign_data_wrapper
void CatalogTupleUpdate(Relation heapRel, ItemPointer otid, HeapTuple tup)
Definition: indexing.c:210
#define ForeignDataWrapperRelationId
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define NameStr(name)
Definition: c.h:494
#define HeapTupleGetOid(tuple)
Definition: htup_details.h:695
HeapTuple heap_modify_tuple(HeapTuple tuple, TupleDesc tupleDesc, Datum *replValues, bool *replIsnull, bool *doReplace)
Definition: heaptuple.c:793
Acl * aclnewowner(const Acl *old_acl, Oid oldOwnerId, Oid newOwnerId)
Definition: acl.c:1036
void AlterForeignDataWrapperOwner_oid ( Oid  fwdId,
Oid  newOwnerId 
)

Definition at line 312 of file foreigncmds.c.

References AlterForeignDataWrapperOwner_internal(), ereport, errcode(), errmsg(), ERROR, FOREIGNDATAWRAPPEROID, ForeignDataWrapperRelationId, heap_close, heap_freetuple(), heap_open(), HeapTupleIsValid, ObjectIdGetDatum, RowExclusiveLock, and SearchSysCacheCopy1.

Referenced by shdepReassignOwned().

313 {
314  HeapTuple tup;
315  Relation rel;
316 
318 
320 
321  if (!HeapTupleIsValid(tup))
322  ereport(ERROR,
323  (errcode(ERRCODE_UNDEFINED_OBJECT),
324  errmsg("foreign-data wrapper with OID %u does not exist", fwdId)));
325 
326  AlterForeignDataWrapperOwner_internal(rel, tup, newOwnerId);
327 
328  heap_freetuple(tup);
329 
331 }
int errcode(int sqlerrcode)
Definition: elog.c:575
#define heap_close(r, l)
Definition: heapam.h:97
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
#define RowExclusiveLock
Definition: lockdefs.h:38
#define ereport(elevel, rest)
Definition: elog.h:122
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
#define ForeignDataWrapperRelationId
#define SearchSysCacheCopy1(cacheId, key1)
Definition: syscache.h:158
int errmsg(const char *fmt,...)
Definition: elog.c:797
static void AlterForeignDataWrapperOwner_internal(Relation rel, HeapTuple tup, Oid newOwnerId)
Definition: foreigncmds.c:207
ObjectAddress AlterForeignServer ( AlterForeignServerStmt stmt)

Definition at line 972 of file foreigncmds.c.

References ACL_KIND_FOREIGN_SERVER, aclcheck_error(), ACLCHECK_NOT_OWNER, Anum_pg_foreign_server_srvoptions, Anum_pg_foreign_server_srvversion, CatalogTupleUpdate(), CStringGetDatum, CStringGetTextDatum, DatumGetPointer, ereport, errcode(), errmsg(), ERROR, ForeignDataWrapper::fdwvalidator, FOREIGNSERVERNAME, FOREIGNSERVEROID, ForeignServerRelationId, GetForeignDataWrapper(), GETSTRUCT, GetUserId(), AlterForeignServerStmt::has_version, heap_close, heap_freetuple(), heap_modify_tuple(), heap_open(), HeapTupleGetOid, HeapTupleIsValid, InvokeObjectPostAlterHook, Natts_pg_foreign_server, NULL, ObjectAddressSet, AlterForeignServerStmt::options, pg_foreign_server_ownercheck(), PointerGetDatum, PointerIsValid, RelationGetDescr, RowExclusiveLock, SearchSysCacheCopy1, AlterForeignServerStmt::servername, SysCacheGetAttr(), HeapTupleData::t_self, transformGenericOptions(), and AlterForeignServerStmt::version.

Referenced by ProcessUtilitySlow().

973 {
974  Relation rel;
975  HeapTuple tp;
976  Datum repl_val[Natts_pg_foreign_server];
977  bool repl_null[Natts_pg_foreign_server];
978  bool repl_repl[Natts_pg_foreign_server];
979  Oid srvId;
980  Form_pg_foreign_server srvForm;
981  ObjectAddress address;
982 
984 
986  CStringGetDatum(stmt->servername));
987 
988  if (!HeapTupleIsValid(tp))
989  ereport(ERROR,
990  (errcode(ERRCODE_UNDEFINED_OBJECT),
991  errmsg("server \"%s\" does not exist", stmt->servername)));
992 
993  srvId = HeapTupleGetOid(tp);
994  srvForm = (Form_pg_foreign_server) GETSTRUCT(tp);
995 
996  /*
997  * Only owner or a superuser can ALTER a SERVER.
998  */
1001  stmt->servername);
1002 
1003  memset(repl_val, 0, sizeof(repl_val));
1004  memset(repl_null, false, sizeof(repl_null));
1005  memset(repl_repl, false, sizeof(repl_repl));
1006 
1007  if (stmt->has_version)
1008  {
1009  /*
1010  * Change the server VERSION string.
1011  */
1012  if (stmt->version)
1013  repl_val[Anum_pg_foreign_server_srvversion - 1] =
1015  else
1016  repl_null[Anum_pg_foreign_server_srvversion - 1] = true;
1017 
1018  repl_repl[Anum_pg_foreign_server_srvversion - 1] = true;
1019  }
1020 
1021  if (stmt->options)
1022  {
1023  ForeignDataWrapper *fdw = GetForeignDataWrapper(srvForm->srvfdw);
1024  Datum datum;
1025  bool isnull;
1026 
1027  /* Extract the current srvoptions */
1029  tp,
1031  &isnull);
1032  if (isnull)
1033  datum = PointerGetDatum(NULL);
1034 
1035  /* Prepare the options array */
1037  datum,
1038  stmt->options,
1039  fdw->fdwvalidator);
1040 
1041  if (PointerIsValid(DatumGetPointer(datum)))
1042  repl_val[Anum_pg_foreign_server_srvoptions - 1] = datum;
1043  else
1044  repl_null[Anum_pg_foreign_server_srvoptions - 1] = true;
1045 
1046  repl_repl[Anum_pg_foreign_server_srvoptions - 1] = true;
1047  }
1048 
1049  /* Everything looks good - update the tuple */
1050  tp = heap_modify_tuple(tp, RelationGetDescr(rel),
1051  repl_val, repl_null, repl_repl);
1052 
1053  CatalogTupleUpdate(rel, &tp->t_self, tp);
1054 
1056 
1057  ObjectAddressSet(address, ForeignServerRelationId, srvId);
1058 
1059  heap_freetuple(tp);
1060 
1062 
1063  return address;
1064 }
#define GETSTRUCT(TUP)
Definition: htup_details.h:656
#define RelationGetDescr(relation)
Definition: rel.h:425
Oid GetUserId(void)
Definition: miscinit.c:283
Datum transformGenericOptions(Oid catalogId, Datum oldOptions, List *options, Oid fdwvalidator)
Definition: foreigncmds.c:109
#define Anum_pg_foreign_server_srvversion
#define PointerGetDatum(X)
Definition: postgres.h:564
bool pg_foreign_server_ownercheck(Oid srv_oid, Oid roleid)
Definition: aclchk.c:4885
int errcode(int sqlerrcode)
Definition: elog.c:575
#define heap_close(r, l)
Definition: heapam.h:97
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
unsigned int Oid
Definition: postgres_ext.h:31
ForeignDataWrapper * GetForeignDataWrapper(Oid fdwid)
Definition: foreign.c:35
#define ERROR
Definition: elog.h:43
ItemPointerData t_self
Definition: htup.h:65
void aclcheck_error(AclResult aclerr, AclObjectKind objectkind, const char *objectname)
Definition: aclchk.c:3378
#define RowExclusiveLock
Definition: lockdefs.h:38
#define CStringGetDatum(X)
Definition: postgres.h:586
#define ereport(elevel, rest)
Definition: elog.h:122
#define InvokeObjectPostAlterHook(classId, objectId, subId)
Definition: objectaccess.h:163
#define Natts_pg_foreign_server
uintptr_t Datum
Definition: postgres.h:374
Datum SysCacheGetAttr(int cacheId, HeapTuple tup, AttrNumber attributeNumber, bool *isNull)
Definition: syscache.c:1245
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
FormData_pg_foreign_server * Form_pg_foreign_server
#define ForeignServerRelationId
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
#define NULL
Definition: c.h:226
void CatalogTupleUpdate(Relation heapRel, ItemPointer otid, HeapTuple tup)
Definition: indexing.c:210
#define ObjectAddressSet(addr, class_id, object_id)
Definition: objectaddress.h:40
#define DatumGetPointer(X)
Definition: postgres.h:557
#define SearchSysCacheCopy1(cacheId, key1)
Definition: syscache.h:158
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define CStringGetTextDatum(s)
Definition: builtins.h:90
#define HeapTupleGetOid(tuple)
Definition: htup_details.h:695
#define Anum_pg_foreign_server_srvoptions
HeapTuple heap_modify_tuple(HeapTuple tuple, TupleDesc tupleDesc, Datum *replValues, bool *replIsnull, bool *doReplace)
Definition: heaptuple.c:793
#define PointerIsValid(pointer)
Definition: c.h:521
ObjectAddress AlterForeignServerOwner ( const char *  name,
Oid  newOwnerId 
)

Definition at line 414 of file foreigncmds.c.

References AlterForeignServerOwner_internal(), CStringGetDatum, ereport, errcode(), errmsg(), ERROR, FOREIGNSERVERNAME, ForeignServerRelationId, heap_close, heap_freetuple(), heap_open(), HeapTupleGetOid, HeapTupleIsValid, ObjectAddressSet, RowExclusiveLock, and SearchSysCacheCopy1.

Referenced by ExecAlterOwnerStmt().

415 {
416  Oid servOid;
417  HeapTuple tup;
418  Relation rel;
419  ObjectAddress address;
420 
422 
424 
425  if (!HeapTupleIsValid(tup))
426  ereport(ERROR,
427  (errcode(ERRCODE_UNDEFINED_OBJECT),
428  errmsg("server \"%s\" does not exist", name)));
429 
430  servOid = HeapTupleGetOid(tup);
431 
432  AlterForeignServerOwner_internal(rel, tup, newOwnerId);
433 
434  ObjectAddressSet(address, ForeignServerRelationId, servOid);
435 
436  heap_freetuple(tup);
437 
439 
440  return address;
441 }
int errcode(int sqlerrcode)
Definition: elog.c:575
#define heap_close(r, l)
Definition: heapam.h:97
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
unsigned int Oid
Definition: postgres_ext.h:31
#define ERROR
Definition: elog.h:43
#define RowExclusiveLock
Definition: lockdefs.h:38
#define CStringGetDatum(X)
Definition: postgres.h:586
#define ereport(elevel, rest)
Definition: elog.h:122
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
#define ForeignServerRelationId
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
static void AlterForeignServerOwner_internal(Relation rel, HeapTuple tup, Oid newOwnerId)
Definition: foreigncmds.c:337
const char * name
Definition: encode.c:521
#define ObjectAddressSet(addr, class_id, object_id)
Definition: objectaddress.h:40
#define SearchSysCacheCopy1(cacheId, key1)
Definition: syscache.h:158
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define HeapTupleGetOid(tuple)
Definition: htup_details.h:695
static void AlterForeignServerOwner_internal ( Relation  rel,
HeapTuple  tup,
Oid  newOwnerId 
)
static

Definition at line 337 of file foreigncmds.c.

References ACL_KIND_FDW, ACL_KIND_FOREIGN_SERVER, ACL_USAGE, aclcheck_error(), ACLCHECK_NOT_OWNER, ACLCHECK_OK, aclnewowner(), Anum_pg_foreign_server_srvacl, Anum_pg_foreign_server_srvowner, CatalogTupleUpdate(), changeDependencyOnOwner(), check_is_member_of_role(), DatumGetAclP, ForeignDataWrapper::fdwname, ForeignServerRelationId, GetForeignDataWrapper(), GETSTRUCT, GetUserId(), heap_getattr, heap_modify_tuple(), HeapTupleGetOid, InvokeObjectPostAlterHook, NameStr, Natts_pg_foreign_server, ObjectIdGetDatum, pg_foreign_data_wrapper_aclcheck(), pg_foreign_server_ownercheck(), PointerGetDatum, RelationGetDescr, superuser(), and HeapTupleData::t_self.

Referenced by AlterForeignServerOwner(), and AlterForeignServerOwner_oid().

338 {
340  Datum repl_val[Natts_pg_foreign_server];
341  bool repl_null[Natts_pg_foreign_server];
342  bool repl_repl[Natts_pg_foreign_server];
343  Acl *newAcl;
344  Datum aclDatum;
345  bool isNull;
346 
347  form = (Form_pg_foreign_server) GETSTRUCT(tup);
348 
349  if (form->srvowner != newOwnerId)
350  {
351  /* Superusers can always do it */
352  if (!superuser())
353  {
354  Oid srvId;
355  AclResult aclresult;
356 
357  srvId = HeapTupleGetOid(tup);
358 
359  /* Must be owner */
362  NameStr(form->srvname));
363 
364  /* Must be able to become new owner */
365  check_is_member_of_role(GetUserId(), newOwnerId);
366 
367  /* New owner must have USAGE privilege on foreign-data wrapper */
368  aclresult = pg_foreign_data_wrapper_aclcheck(form->srvfdw, newOwnerId, ACL_USAGE);
369  if (aclresult != ACLCHECK_OK)
370  {
371  ForeignDataWrapper *fdw = GetForeignDataWrapper(form->srvfdw);
372 
373  aclcheck_error(aclresult, ACL_KIND_FDW, fdw->fdwname);
374  }
375  }
376 
377  memset(repl_null, false, sizeof(repl_null));
378  memset(repl_repl, false, sizeof(repl_repl));
379 
380  repl_repl[Anum_pg_foreign_server_srvowner - 1] = true;
381  repl_val[Anum_pg_foreign_server_srvowner - 1] = ObjectIdGetDatum(newOwnerId);
382 
383  aclDatum = heap_getattr(tup,
385  RelationGetDescr(rel),
386  &isNull);
387  /* Null ACLs do not require changes */
388  if (!isNull)
389  {
390  newAcl = aclnewowner(DatumGetAclP(aclDatum),
391  form->srvowner, newOwnerId);
392  repl_repl[Anum_pg_foreign_server_srvacl - 1] = true;
393  repl_val[Anum_pg_foreign_server_srvacl - 1] = PointerGetDatum(newAcl);
394  }
395 
396  tup = heap_modify_tuple(tup, RelationGetDescr(rel), repl_val, repl_null,
397  repl_repl);
398 
399  CatalogTupleUpdate(rel, &tup->t_self, tup);
400 
401  /* Update owner dependency reference */
403  newOwnerId);
404  }
405 
407  HeapTupleGetOid(tup), 0);
408 }
#define GETSTRUCT(TUP)
Definition: htup_details.h:656
#define RelationGetDescr(relation)
Definition: rel.h:425
Oid GetUserId(void)
Definition: miscinit.c:283
char * fdwname
Definition: foreign.h:39
#define DatumGetAclP(X)
Definition: acl.h:113
#define PointerGetDatum(X)
Definition: postgres.h:564
AclResult pg_foreign_data_wrapper_aclcheck(Oid fdw_oid, Oid roleid, AclMode mode)
Definition: aclchk.c:4484
bool pg_foreign_server_ownercheck(Oid srv_oid, Oid roleid)
Definition: aclchk.c:4885
bool superuser(void)
Definition: superuser.c:47
unsigned int Oid
Definition: postgres_ext.h:31
void changeDependencyOnOwner(Oid classId, Oid objectId, Oid newOwnerId)
Definition: pg_shdepend.c:303
ForeignDataWrapper * GetForeignDataWrapper(Oid fdwid)
Definition: foreign.c:35
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
ItemPointerData t_self
Definition: htup.h:65
void aclcheck_error(AclResult aclerr, AclObjectKind objectkind, const char *objectname)
Definition: aclchk.c:3378
#define ACL_USAGE
Definition: parsenodes.h:73
void check_is_member_of_role(Oid member, Oid role)
Definition: acl.c:4877
#define InvokeObjectPostAlterHook(classId, objectId, subId)
Definition: objectaccess.h:163
#define Anum_pg_foreign_server_srvacl
#define Natts_pg_foreign_server
#define Anum_pg_foreign_server_srvowner
#define heap_getattr(tup, attnum, tupleDesc, isnull)
Definition: htup_details.h:769
AclResult
Definition: acl.h:170
uintptr_t Datum
Definition: postgres.h:374
FormData_pg_foreign_server * Form_pg_foreign_server
#define ForeignServerRelationId
void CatalogTupleUpdate(Relation heapRel, ItemPointer otid, HeapTuple tup)
Definition: indexing.c:210
#define NameStr(name)
Definition: c.h:494
#define HeapTupleGetOid(tuple)
Definition: htup_details.h:695
HeapTuple heap_modify_tuple(HeapTuple tuple, TupleDesc tupleDesc, Datum *replValues, bool *replIsnull, bool *doReplace)
Definition: heaptuple.c:793
Acl * aclnewowner(const Acl *old_acl, Oid oldOwnerId, Oid newOwnerId)
Definition: acl.c:1036
void AlterForeignServerOwner_oid ( Oid  srvId,
Oid  newOwnerId 
)

Definition at line 447 of file foreigncmds.c.

References AlterForeignServerOwner_internal(), ereport, errcode(), errmsg(), ERROR, FOREIGNSERVEROID, ForeignServerRelationId, heap_close, heap_freetuple(), heap_open(), HeapTupleIsValid, ObjectIdGetDatum, RowExclusiveLock, and SearchSysCacheCopy1.

Referenced by shdepReassignOwned().

448 {
449  HeapTuple tup;
450  Relation rel;
451 
453 
455 
456  if (!HeapTupleIsValid(tup))
457  ereport(ERROR,
458  (errcode(ERRCODE_UNDEFINED_OBJECT),
459  errmsg("foreign server with OID %u does not exist", srvId)));
460 
461  AlterForeignServerOwner_internal(rel, tup, newOwnerId);
462 
463  heap_freetuple(tup);
464 
466 }
int errcode(int sqlerrcode)
Definition: elog.c:575
#define heap_close(r, l)
Definition: heapam.h:97
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
#define RowExclusiveLock
Definition: lockdefs.h:38
#define ereport(elevel, rest)
Definition: elog.h:122
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
#define ForeignServerRelationId
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
static void AlterForeignServerOwner_internal(Relation rel, HeapTuple tup, Oid newOwnerId)
Definition: foreigncmds.c:337
#define SearchSysCacheCopy1(cacheId, key1)
Definition: syscache.h:158
int errmsg(const char *fmt,...)
Definition: elog.c:797
ObjectAddress AlterUserMapping ( AlterUserMappingStmt stmt)

Definition at line 1222 of file foreigncmds.c.

References ACL_ID_PUBLIC, Anum_pg_user_mapping_umoptions, CatalogTupleUpdate(), DatumGetPointer, elog, ereport, errcode(), errmsg(), ERROR, ForeignServer::fdwid, ForeignDataWrapper::fdwvalidator, get_rolespec_oid(), GetForeignDataWrapper(), GetForeignServerByName(), GetSysCacheOid2, heap_close, heap_freetuple(), heap_modify_tuple(), heap_open(), HeapTupleIsValid, MappingUserName, Natts_pg_user_mapping, NULL, ObjectAddressSet, ObjectIdGetDatum, OidIsValid, AlterUserMappingStmt::options, PointerGetDatum, PointerIsValid, RelationGetDescr, ROLESPEC_PUBLIC, RoleSpec::roletype, RowExclusiveLock, SearchSysCacheCopy1, ForeignServer::serverid, AlterUserMappingStmt::servername, SysCacheGetAttr(), HeapTupleData::t_self, transformGenericOptions(), AlterUserMappingStmt::user, user_mapping_ddl_aclcheck(), USERMAPPINGOID, UserMappingRelationId, and USERMAPPINGUSERSERVER.

Referenced by ProcessUtilitySlow().

1223 {
1224  Relation rel;
1225  HeapTuple tp;
1226  Datum repl_val[Natts_pg_user_mapping];
1227  bool repl_null[Natts_pg_user_mapping];
1228  bool repl_repl[Natts_pg_user_mapping];
1229  Oid useId;
1230  Oid umId;
1231  ForeignServer *srv;
1232  ObjectAddress address;
1233  RoleSpec *role = (RoleSpec *) stmt->user;
1234 
1236 
1237  if (role->roletype == ROLESPEC_PUBLIC)
1238  useId = ACL_ID_PUBLIC;
1239  else
1240  useId = get_rolespec_oid(stmt->user, false);
1241 
1242  srv = GetForeignServerByName(stmt->servername, false);
1243 
1245  ObjectIdGetDatum(useId),
1246  ObjectIdGetDatum(srv->serverid));
1247  if (!OidIsValid(umId))
1248  ereport(ERROR,
1249  (errcode(ERRCODE_UNDEFINED_OBJECT),
1250  errmsg("user mapping \"%s\" does not exist for the server",
1251  MappingUserName(useId))));
1252 
1253  user_mapping_ddl_aclcheck(useId, srv->serverid, stmt->servername);
1254 
1256 
1257  if (!HeapTupleIsValid(tp))
1258  elog(ERROR, "cache lookup failed for user mapping %u", umId);
1259 
1260  memset(repl_val, 0, sizeof(repl_val));
1261  memset(repl_null, false, sizeof(repl_null));
1262  memset(repl_repl, false, sizeof(repl_repl));
1263 
1264  if (stmt->options)
1265  {
1266  ForeignDataWrapper *fdw;
1267  Datum datum;
1268  bool isnull;
1269 
1270  /*
1271  * Process the options.
1272  */
1273 
1274  fdw = GetForeignDataWrapper(srv->fdwid);
1275 
1277  tp,
1279  &isnull);
1280  if (isnull)
1281  datum = PointerGetDatum(NULL);
1282 
1283  /* Prepare the options array */
1285  datum,
1286  stmt->options,
1287  fdw->fdwvalidator);
1288 
1289  if (PointerIsValid(DatumGetPointer(datum)))
1290  repl_val[Anum_pg_user_mapping_umoptions - 1] = datum;
1291  else
1292  repl_null[Anum_pg_user_mapping_umoptions - 1] = true;
1293 
1294  repl_repl[Anum_pg_user_mapping_umoptions - 1] = true;
1295  }
1296 
1297  /* Everything looks good - update the tuple */
1298  tp = heap_modify_tuple(tp, RelationGetDescr(rel),
1299  repl_val, repl_null, repl_repl);
1300 
1301  CatalogTupleUpdate(rel, &tp->t_self, tp);
1302 
1303  ObjectAddressSet(address, UserMappingRelationId, umId);
1304 
1305  heap_freetuple(tp);
1306 
1308 
1309  return address;
1310 }
#define RelationGetDescr(relation)
Definition: rel.h:425
Datum transformGenericOptions(Oid catalogId, Datum oldOptions, List *options, Oid fdwvalidator)
Definition: foreigncmds.c:109
#define PointerGetDatum(X)
Definition: postgres.h:564
int errcode(int sqlerrcode)
Definition: elog.c:575
static void user_mapping_ddl_aclcheck(Oid umuserid, Oid serverid, const char *servername)
Definition: foreigncmds.c:1097
#define heap_close(r, l)
Definition: heapam.h:97
#define Natts_pg_user_mapping
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
unsigned int Oid
Definition: postgres_ext.h:31
#define OidIsValid(objectId)
Definition: c.h:533
#define GetSysCacheOid2(cacheId, key1, key2)
Definition: syscache.h:178
ForeignDataWrapper * GetForeignDataWrapper(Oid fdwid)
Definition: foreign.c:35
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
#define Anum_pg_user_mapping_umoptions
ItemPointerData t_self
Definition: htup.h:65
#define RowExclusiveLock
Definition: lockdefs.h:38
ForeignServer * GetForeignServerByName(const char *srvname, bool missing_ok)
Definition: foreign.c:148
#define ereport(elevel, rest)
Definition: elog.h:122
uintptr_t Datum
Definition: postgres.h:374
RoleSpecType roletype
Definition: parsenodes.h:319
Datum SysCacheGetAttr(int cacheId, HeapTuple tup, AttrNumber attributeNumber, bool *isNull)
Definition: syscache.c:1245
Oid get_rolespec_oid(const RoleSpec *role, bool missing_ok)
Definition: acl.c:5147
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
#define NULL
Definition: c.h:226
void CatalogTupleUpdate(Relation heapRel, ItemPointer otid, HeapTuple tup)
Definition: indexing.c:210
#define ObjectAddressSet(addr, class_id, object_id)
Definition: objectaddress.h:40
#define DatumGetPointer(X)
Definition: postgres.h:557
#define SearchSysCacheCopy1(cacheId, key1)
Definition: syscache.h:158
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define UserMappingRelationId
#define ACL_ID_PUBLIC
Definition: acl.h:39
#define elog
Definition: elog.h:219
HeapTuple heap_modify_tuple(HeapTuple tuple, TupleDesc tupleDesc, Datum *replValues, bool *replIsnull, bool *doReplace)
Definition: heaptuple.c:793
#define PointerIsValid(pointer)
Definition: c.h:521
Oid serverid
Definition: foreign.h:47
#define MappingUserName(userid)
Definition: foreign.h:20
ObjectAddress CreateForeignDataWrapper ( CreateFdwStmt stmt)

Definition at line 560 of file foreigncmds.c.

References Anum_pg_foreign_data_wrapper_fdwacl, Anum_pg_foreign_data_wrapper_fdwhandler, Anum_pg_foreign_data_wrapper_fdwname, Anum_pg_foreign_data_wrapper_fdwoptions, Anum_pg_foreign_data_wrapper_fdwowner, Anum_pg_foreign_data_wrapper_fdwvalidator, CatalogTupleInsert(), ObjectAddress::classId, CStringGetDatum, DatumGetPointer, DEPENDENCY_NORMAL, DirectFunctionCall1, ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errhint(), errmsg(), ERROR, CreateFdwStmt::fdwname, ForeignDataWrapperRelationId, CreateFdwStmt::func_options, GetForeignDataWrapperByName(), GetUserId(), heap_close, heap_form_tuple(), heap_freetuple(), heap_open(), InvokeObjectPostCreateHook, namein(), Natts_pg_foreign_data_wrapper, NULL, ObjectAddress::objectId, ObjectIdGetDatum, ObjectAddress::objectSubId, OidIsValid, CreateFdwStmt::options, parse_func_options(), PointerGetDatum, PointerIsValid, ProcedureRelationId, RelationData::rd_att, recordDependencyOn(), recordDependencyOnCurrentExtension(), recordDependencyOnOwner(), RowExclusiveLock, superuser(), transformGenericOptions(), and values.

Referenced by ProcessUtilitySlow().

561 {
562  Relation rel;
564  bool nulls[Natts_pg_foreign_data_wrapper];
565  HeapTuple tuple;
566  Oid fdwId;
567  bool handler_given;
568  bool validator_given;
569  Oid fdwhandler;
570  Oid fdwvalidator;
571  Datum fdwoptions;
572  Oid ownerId;
573  ObjectAddress myself;
574  ObjectAddress referenced;
575 
577 
578  /* Must be super user */
579  if (!superuser())
580  ereport(ERROR,
581  (errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),
582  errmsg("permission denied to create foreign-data wrapper \"%s\"",
583  stmt->fdwname),
584  errhint("Must be superuser to create a foreign-data wrapper.")));
585 
586  /* For now the owner cannot be specified on create. Use effective user ID. */
587  ownerId = GetUserId();
588 
589  /*
590  * Check that there is no other foreign-data wrapper by this name.
591  */
592  if (GetForeignDataWrapperByName(stmt->fdwname, true) != NULL)
593  ereport(ERROR,
595  errmsg("foreign-data wrapper \"%s\" already exists",
596  stmt->fdwname)));
597 
598  /*
599  * Insert tuple into pg_foreign_data_wrapper.
600  */
601  memset(values, 0, sizeof(values));
602  memset(nulls, false, sizeof(nulls));
603 
607 
608  /* Lookup handler and validator functions, if given */
610  &handler_given, &fdwhandler,
611  &validator_given, &fdwvalidator);
612 
615 
616  nulls[Anum_pg_foreign_data_wrapper_fdwacl - 1] = true;
617 
620  stmt->options,
621  fdwvalidator);
622 
623  if (PointerIsValid(DatumGetPointer(fdwoptions)))
624  values[Anum_pg_foreign_data_wrapper_fdwoptions - 1] = fdwoptions;
625  else
626  nulls[Anum_pg_foreign_data_wrapper_fdwoptions - 1] = true;
627 
628  tuple = heap_form_tuple(rel->rd_att, values, nulls);
629 
630  fdwId = CatalogTupleInsert(rel, tuple);
631 
632  heap_freetuple(tuple);
633 
634  /* record dependencies */
636  myself.objectId = fdwId;
637  myself.objectSubId = 0;
638 
639  if (OidIsValid(fdwhandler))
640  {
641  referenced.classId = ProcedureRelationId;
642  referenced.objectId = fdwhandler;
643  referenced.objectSubId = 0;
644  recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL);
645  }
646 
647  if (OidIsValid(fdwvalidator))
648  {
649  referenced.classId = ProcedureRelationId;
650  referenced.objectId = fdwvalidator;
651  referenced.objectSubId = 0;
652  recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL);
653  }
654 
656 
657  /* dependency on extension */
658  recordDependencyOnCurrentExtension(&myself, false);
659 
660  /* Post creation hook for new foreign data wrapper */
662 
664 
665  return myself;
666 }
Datum namein(PG_FUNCTION_ARGS)
Definition: name.c:46
int errhint(const char *fmt,...)
Definition: elog.c:987
static void parse_func_options(List *func_options, bool *handler_given, Oid *fdwhandler, bool *validator_given, Oid *fdwvalidator)
Definition: foreigncmds.c:516
#define Anum_pg_foreign_data_wrapper_fdwowner
#define InvokeObjectPostCreateHook(classId, objectId, subId)
Definition: objectaccess.h:145
Oid GetUserId(void)
Definition: miscinit.c:283
Datum transformGenericOptions(Oid catalogId, Datum oldOptions, List *options, Oid fdwvalidator)
Definition: foreigncmds.c:109
#define PointerGetDatum(X)
Definition: postgres.h:564
#define ProcedureRelationId
Definition: pg_proc.h:33
int errcode(int sqlerrcode)
Definition: elog.c:575
bool superuser(void)
Definition: superuser.c:47
#define Anum_pg_foreign_data_wrapper_fdwhandler
void recordDependencyOn(const ObjectAddress *depender, const ObjectAddress *referenced, DependencyType behavior)
Definition: pg_depend.c:44
HeapTuple heap_form_tuple(TupleDesc tupleDescriptor, Datum *values, bool *isnull)
Definition: heaptuple.c:692
#define heap_close(r, l)
Definition: heapam.h:97
#define DirectFunctionCall1(func, arg1)
Definition: fmgr.h:555
void recordDependencyOnOwner(Oid classId, Oid objectId, Oid owner)
Definition: pg_shdepend.c:158
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
unsigned int Oid
Definition: postgres_ext.h:31
#define OidIsValid(objectId)
Definition: c.h:533
#define Anum_pg_foreign_data_wrapper_fdwacl
List * options
Definition: parsenodes.h:2093
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
Oid CatalogTupleInsert(Relation heapRel, HeapTuple tup)
Definition: indexing.c:162
#define RowExclusiveLock
Definition: lockdefs.h:38
char * fdwname
Definition: parsenodes.h:2091
#define CStringGetDatum(X)
Definition: postgres.h:586
#define Anum_pg_foreign_data_wrapper_fdwname
#define ereport(elevel, rest)
Definition: elog.h:122
uintptr_t Datum
Definition: postgres.h:374
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
TupleDesc rd_att
Definition: rel.h:114
#define Anum_pg_foreign_data_wrapper_fdwvalidator
#define Natts_pg_foreign_data_wrapper
#define NULL
Definition: c.h:226
ForeignDataWrapper * GetForeignDataWrapperByName(const char *fdwname, bool missing_ok)
Definition: foreign.c:78
void recordDependencyOnCurrentExtension(const ObjectAddress *object, bool isReplace)
Definition: pg_depend.c:139
#define ForeignDataWrapperRelationId
#define DatumGetPointer(X)
Definition: postgres.h:557
static Datum values[MAXATTR]
Definition: bootstrap.c:162
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define ERRCODE_DUPLICATE_OBJECT
Definition: streamutil.c:34
#define PointerIsValid(pointer)
Definition: c.h:521
#define Anum_pg_foreign_data_wrapper_fdwoptions
List * func_options
Definition: parsenodes.h:2092
ObjectAddress CreateForeignServer ( CreateForeignServerStmt stmt)

Definition at line 861 of file foreigncmds.c.

References ACL_KIND_FDW, ACL_USAGE, aclcheck_error(), ACLCHECK_OK, Anum_pg_foreign_server_srvacl, Anum_pg_foreign_server_srvfdw, Anum_pg_foreign_server_srvname, Anum_pg_foreign_server_srvoptions, Anum_pg_foreign_server_srvowner, Anum_pg_foreign_server_srvtype, Anum_pg_foreign_server_srvversion, CatalogTupleInsert(), ObjectAddress::classId, CStringGetDatum, CStringGetTextDatum, DatumGetPointer, DEPENDENCY_NORMAL, DirectFunctionCall1, ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errmsg(), ERROR, ForeignDataWrapper::fdwid, ForeignDataWrapper::fdwname, CreateForeignServerStmt::fdwname, ForeignDataWrapper::fdwvalidator, ForeignDataWrapperRelationId, ForeignServerRelationId, GetForeignDataWrapperByName(), GetForeignServerByName(), GetUserId(), heap_close, heap_form_tuple(), heap_freetuple(), heap_open(), InvokeObjectPostCreateHook, namein(), Natts_pg_foreign_server, NULL, ObjectAddress::objectId, ObjectIdGetDatum, ObjectAddress::objectSubId, CreateForeignServerStmt::options, pg_foreign_data_wrapper_aclcheck(), PointerGetDatum, PointerIsValid, RelationData::rd_att, recordDependencyOn(), recordDependencyOnCurrentExtension(), recordDependencyOnOwner(), RowExclusiveLock, CreateForeignServerStmt::servername, CreateForeignServerStmt::servertype, transformGenericOptions(), values, and CreateForeignServerStmt::version.

Referenced by ProcessUtilitySlow().

862 {
863  Relation rel;
864  Datum srvoptions;
866  bool nulls[Natts_pg_foreign_server];
867  HeapTuple tuple;
868  Oid srvId;
869  Oid ownerId;
870  AclResult aclresult;
871  ObjectAddress myself;
872  ObjectAddress referenced;
873  ForeignDataWrapper *fdw;
874 
876 
877  /* For now the owner cannot be specified on create. Use effective user ID. */
878  ownerId = GetUserId();
879 
880  /*
881  * Check that there is no other foreign server by this name.
882  */
883  if (GetForeignServerByName(stmt->servername, true) != NULL)
884  ereport(ERROR,
886  errmsg("server \"%s\" already exists",
887  stmt->servername)));
888 
889  /*
890  * Check that the FDW exists and that we have USAGE on it. Also get the
891  * actual FDW for option validation etc.
892  */
893  fdw = GetForeignDataWrapperByName(stmt->fdwname, false);
894 
895  aclresult = pg_foreign_data_wrapper_aclcheck(fdw->fdwid, ownerId, ACL_USAGE);
896  if (aclresult != ACLCHECK_OK)
897  aclcheck_error(aclresult, ACL_KIND_FDW, fdw->fdwname);
898 
899  /*
900  * Insert tuple into pg_foreign_server.
901  */
902  memset(values, 0, sizeof(values));
903  memset(nulls, false, sizeof(nulls));
904 
905  values[Anum_pg_foreign_server_srvname - 1] =
907  values[Anum_pg_foreign_server_srvowner - 1] = ObjectIdGetDatum(ownerId);
909 
910  /* Add server type if supplied */
911  if (stmt->servertype)
912  values[Anum_pg_foreign_server_srvtype - 1] =
914  else
915  nulls[Anum_pg_foreign_server_srvtype - 1] = true;
916 
917  /* Add server version if supplied */
918  if (stmt->version)
921  else
922  nulls[Anum_pg_foreign_server_srvversion - 1] = true;
923 
924  /* Start with a blank acl */
925  nulls[Anum_pg_foreign_server_srvacl - 1] = true;
926 
927  /* Add server options */
930  stmt->options,
931  fdw->fdwvalidator);
932 
933  if (PointerIsValid(DatumGetPointer(srvoptions)))
934  values[Anum_pg_foreign_server_srvoptions - 1] = srvoptions;
935  else
936  nulls[Anum_pg_foreign_server_srvoptions - 1] = true;
937 
938  tuple = heap_form_tuple(rel->rd_att, values, nulls);
939 
940  srvId = CatalogTupleInsert(rel, tuple);
941 
942  heap_freetuple(tuple);
943 
944  /* record dependencies */
946  myself.objectId = srvId;
947  myself.objectSubId = 0;
948 
950  referenced.objectId = fdw->fdwid;
951  referenced.objectSubId = 0;
952  recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL);
953 
955 
956  /* dependency on extension */
957  recordDependencyOnCurrentExtension(&myself, false);
958 
959  /* Post creation hook for new foreign server */
961 
963 
964  return myself;
965 }
Datum namein(PG_FUNCTION_ARGS)
Definition: name.c:46
#define InvokeObjectPostCreateHook(classId, objectId, subId)
Definition: objectaccess.h:145
Oid GetUserId(void)
Definition: miscinit.c:283
Datum transformGenericOptions(Oid catalogId, Datum oldOptions, List *options, Oid fdwvalidator)
Definition: foreigncmds.c:109
#define Anum_pg_foreign_server_srvversion
char * fdwname
Definition: foreign.h:39
#define PointerGetDatum(X)
Definition: postgres.h:564
AclResult pg_foreign_data_wrapper_aclcheck(Oid fdw_oid, Oid roleid, AclMode mode)
Definition: aclchk.c:4484
int errcode(int sqlerrcode)
Definition: elog.c:575
void recordDependencyOn(const ObjectAddress *depender, const ObjectAddress *referenced, DependencyType behavior)
Definition: pg_depend.c:44
HeapTuple heap_form_tuple(TupleDesc tupleDescriptor, Datum *values, bool *isnull)
Definition: heaptuple.c:692
#define heap_close(r, l)
Definition: heapam.h:97
#define DirectFunctionCall1(func, arg1)
Definition: fmgr.h:555
void recordDependencyOnOwner(Oid classId, Oid objectId, Oid owner)
Definition: pg_shdepend.c:158
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
unsigned int Oid
Definition: postgres_ext.h:31
#define Anum_pg_foreign_server_srvname
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
Oid CatalogTupleInsert(Relation heapRel, HeapTuple tup)
Definition: indexing.c:162
void aclcheck_error(AclResult aclerr, AclObjectKind objectkind, const char *objectname)
Definition: aclchk.c:3378
#define RowExclusiveLock
Definition: lockdefs.h:38
#define CStringGetDatum(X)
Definition: postgres.h:586
#define ACL_USAGE
Definition: parsenodes.h:73
ForeignServer * GetForeignServerByName(const char *srvname, bool missing_ok)
Definition: foreign.c:148
#define ereport(elevel, rest)
Definition: elog.h:122
#define Anum_pg_foreign_server_srvacl
#define Natts_pg_foreign_server
#define Anum_pg_foreign_server_srvowner
#define Anum_pg_foreign_server_srvfdw
AclResult
Definition: acl.h:170
uintptr_t Datum
Definition: postgres.h:374
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
TupleDesc rd_att
Definition: rel.h:114
#define ForeignServerRelationId
#define NULL
Definition: c.h:226
ForeignDataWrapper * GetForeignDataWrapperByName(const char *fdwname, bool missing_ok)
Definition: foreign.c:78
void recordDependencyOnCurrentExtension(const ObjectAddress *object, bool isReplace)
Definition: pg_depend.c:139
#define ForeignDataWrapperRelationId
#define Anum_pg_foreign_server_srvtype
#define DatumGetPointer(X)
Definition: postgres.h:557
static Datum values[MAXATTR]
Definition: bootstrap.c:162
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define CStringGetTextDatum(s)
Definition: builtins.h:90
#define Anum_pg_foreign_server_srvoptions
#define ERRCODE_DUPLICATE_OBJECT
Definition: streamutil.c:34
#define PointerIsValid(pointer)
Definition: c.h:521
void CreateForeignTable ( CreateForeignTableStmt stmt,
Oid  relid 
)

Definition at line 1418 of file foreigncmds.c.

References ACL_KIND_FOREIGN_SERVER, ACL_USAGE, aclcheck_error(), ACLCHECK_OK, Anum_pg_foreign_table_ftoptions, Anum_pg_foreign_table_ftrelid, Anum_pg_foreign_table_ftserver, CatalogTupleInsert(), ObjectAddress::classId, CommandCounterIncrement(), DatumGetPointer, DEPENDENCY_NORMAL, ForeignServer::fdwid, ForeignDataWrapper::fdwvalidator, ForeignServerRelationId, ForeignTableRelationId, GetForeignDataWrapper(), GetForeignServerByName(), GetUserId(), heap_close, heap_form_tuple(), heap_freetuple(), heap_open(), Natts_pg_foreign_table, NULL, ObjectAddress::objectId, ObjectIdGetDatum, ObjectAddress::objectSubId, CreateForeignTableStmt::options, pg_foreign_server_aclcheck(), PointerGetDatum, PointerIsValid, RelationData::rd_att, recordDependencyOn(), RelationRelationId, RowExclusiveLock, ForeignServer::serverid, ForeignServer::servername, CreateForeignTableStmt::servername, transformGenericOptions(), and values.

Referenced by ProcessUtilitySlow().

1419 {
1420  Relation ftrel;
1421  Datum ftoptions;
1423  bool nulls[Natts_pg_foreign_table];
1424  HeapTuple tuple;
1425  AclResult aclresult;
1426  ObjectAddress myself;
1427  ObjectAddress referenced;
1428  Oid ownerId;
1429  ForeignDataWrapper *fdw;
1430  ForeignServer *server;
1431 
1432  /*
1433  * Advance command counter to ensure the pg_attribute tuple is visible;
1434  * the tuple might be updated to add constraints in previous step.
1435  */
1437 
1439 
1440  /*
1441  * For now the owner cannot be specified on create. Use effective user ID.
1442  */
1443  ownerId = GetUserId();
1444 
1445  /*
1446  * Check that the foreign server exists and that we have USAGE on it. Also
1447  * get the actual FDW for option validation etc.
1448  */
1449  server = GetForeignServerByName(stmt->servername, false);
1450  aclresult = pg_foreign_server_aclcheck(server->serverid, ownerId, ACL_USAGE);
1451  if (aclresult != ACLCHECK_OK)
1452  aclcheck_error(aclresult, ACL_KIND_FOREIGN_SERVER, server->servername);
1453 
1454  fdw = GetForeignDataWrapper(server->fdwid);
1455 
1456  /*
1457  * Insert tuple into pg_foreign_table.
1458  */
1459  memset(values, 0, sizeof(values));
1460  memset(nulls, false, sizeof(nulls));
1461 
1462  values[Anum_pg_foreign_table_ftrelid - 1] = ObjectIdGetDatum(relid);
1464  /* Add table generic options */
1467  stmt->options,
1468  fdw->fdwvalidator);
1469 
1470  if (PointerIsValid(DatumGetPointer(ftoptions)))
1471  values[Anum_pg_foreign_table_ftoptions - 1] = ftoptions;
1472  else
1473  nulls[Anum_pg_foreign_table_ftoptions - 1] = true;
1474 
1475  tuple = heap_form_tuple(ftrel->rd_att, values, nulls);
1476 
1477  CatalogTupleInsert(ftrel, tuple);
1478 
1479  heap_freetuple(tuple);
1480 
1481  /* Add pg_class dependency on the server */
1482  myself.classId = RelationRelationId;
1483  myself.objectId = relid;
1484  myself.objectSubId = 0;
1485 
1486  referenced.classId = ForeignServerRelationId;
1487  referenced.objectId = server->serverid;
1488  referenced.objectSubId = 0;
1489  recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL);
1490 
1491  heap_close(ftrel, RowExclusiveLock);
1492 }
Oid GetUserId(void)
Definition: miscinit.c:283
Datum transformGenericOptions(Oid catalogId, Datum oldOptions, List *options, Oid fdwvalidator)
Definition: foreigncmds.c:109
#define PointerGetDatum(X)
Definition: postgres.h:564
#define RelationRelationId
Definition: pg_class.h:29
#define Natts_pg_foreign_table
void recordDependencyOn(const ObjectAddress *depender, const ObjectAddress *referenced, DependencyType behavior)
Definition: pg_depend.c:44
HeapTuple heap_form_tuple(TupleDesc tupleDescriptor, Datum *values, bool *isnull)
Definition: heaptuple.c:692
#define heap_close(r, l)
Definition: heapam.h:97
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
unsigned int Oid
Definition: postgres_ext.h:31
#define Anum_pg_foreign_table_ftserver
ForeignDataWrapper * GetForeignDataWrapper(Oid fdwid)
Definition: foreign.c:35
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
Oid CatalogTupleInsert(Relation heapRel, HeapTuple tup)
Definition: indexing.c:162
AclResult pg_foreign_server_aclcheck(Oid srv_oid, Oid roleid, AclMode mode)
Definition: aclchk.c:4497
void aclcheck_error(AclResult aclerr, AclObjectKind objectkind, const char *objectname)
Definition: aclchk.c:3378
#define RowExclusiveLock
Definition: lockdefs.h:38
#define ACL_USAGE
Definition: parsenodes.h:73
ForeignServer * GetForeignServerByName(const char *srvname, bool missing_ok)
Definition: foreign.c:148
#define Anum_pg_foreign_table_ftrelid
#define Anum_pg_foreign_table_ftoptions
AclResult
Definition: acl.h:170
uintptr_t Datum
Definition: postgres.h:374
void CommandCounterIncrement(void)
Definition: xact.c:921
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
TupleDesc rd_att
Definition: rel.h:114
#define ForeignServerRelationId
#define NULL
Definition: c.h:226
#define DatumGetPointer(X)
Definition: postgres.h:557
static Datum values[MAXATTR]
Definition: bootstrap.c:162
char * servername
Definition: foreign.h:50
#define ForeignTableRelationId
#define PointerIsValid(pointer)
Definition: c.h:521
Oid serverid
Definition: foreign.h:47
ObjectAddress CreateUserMapping ( CreateUserMappingStmt stmt)

Definition at line 1122 of file foreigncmds.c.

References ACL_ID_PUBLIC, Anum_pg_user_mapping_umoptions, Anum_pg_user_mapping_umserver, Anum_pg_user_mapping_umuser, CatalogTupleInsert(), ObjectAddress::classId, DatumGetPointer, DEPENDENCY_NORMAL, ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errmsg(), ERROR, ForeignServer::fdwid, ForeignDataWrapper::fdwvalidator, ForeignServerRelationId, get_rolespec_oid(), GetForeignDataWrapper(), GetForeignServerByName(), GetSysCacheOid2, heap_close, heap_form_tuple(), heap_freetuple(), heap_open(), InvokeObjectPostCreateHook, MappingUserName, Natts_pg_user_mapping, NULL, ObjectAddress::objectId, ObjectIdGetDatum, ObjectAddress::objectSubId, OidIsValid, CreateUserMappingStmt::options, PointerGetDatum, PointerIsValid, RelationData::rd_att, recordDependencyOn(), recordDependencyOnCurrentExtension(), recordDependencyOnOwner(), ROLESPEC_PUBLIC, RoleSpec::roletype, RowExclusiveLock, ForeignServer::serverid, CreateUserMappingStmt::servername, transformGenericOptions(), CreateUserMappingStmt::user, user_mapping_ddl_aclcheck(), UserMappingRelationId, USERMAPPINGUSERSERVER, and values.

Referenced by ProcessUtilitySlow().

1123 {
1124  Relation rel;
1125  Datum useoptions;
1127  bool nulls[Natts_pg_user_mapping];
1128  HeapTuple tuple;
1129  Oid useId;
1130  Oid umId;
1131  ObjectAddress myself;
1132  ObjectAddress referenced;
1133  ForeignServer *srv;
1134  ForeignDataWrapper *fdw;
1135  RoleSpec *role = (RoleSpec *) stmt->user;
1136 
1138 
1139  if (role->roletype == ROLESPEC_PUBLIC)
1140  useId = ACL_ID_PUBLIC;
1141  else
1142  useId = get_rolespec_oid(stmt->user, false);
1143 
1144  /* Check that the server exists. */
1145  srv = GetForeignServerByName(stmt->servername, false);
1146 
1147  user_mapping_ddl_aclcheck(useId, srv->serverid, stmt->servername);
1148 
1149  /*
1150  * Check that the user mapping is unique within server.
1151  */
1153  ObjectIdGetDatum(useId),
1154  ObjectIdGetDatum(srv->serverid));
1155  if (OidIsValid(umId))
1156  ereport(ERROR,
1158  errmsg("user mapping \"%s\" already exists for server %s",
1159  MappingUserName(useId),
1160  stmt->servername)));
1161 
1162  fdw = GetForeignDataWrapper(srv->fdwid);
1163 
1164  /*
1165  * Insert tuple into pg_user_mapping.
1166  */
1167  memset(values, 0, sizeof(values));
1168  memset(nulls, false, sizeof(nulls));
1169 
1170  values[Anum_pg_user_mapping_umuser - 1] = ObjectIdGetDatum(useId);
1172 
1173  /* Add user options */
1176  stmt->options,
1177  fdw->fdwvalidator);
1178 
1179  if (PointerIsValid(DatumGetPointer(useoptions)))
1180  values[Anum_pg_user_mapping_umoptions - 1] = useoptions;
1181  else
1182  nulls[Anum_pg_user_mapping_umoptions - 1] = true;
1183 
1184  tuple = heap_form_tuple(rel->rd_att, values, nulls);
1185 
1186  umId = CatalogTupleInsert(rel, tuple);
1187 
1188  heap_freetuple(tuple);
1189 
1190  /* Add dependency on the server */
1191  myself.classId = UserMappingRelationId;
1192  myself.objectId = umId;
1193  myself.objectSubId = 0;
1194 
1195  referenced.classId = ForeignServerRelationId;
1196  referenced.objectId = srv->serverid;
1197  referenced.objectSubId = 0;
1198  recordDependencyOn(&myself, &referenced, DEPENDENCY_NORMAL);
1199 
1200  if (OidIsValid(useId))
1201  {
1202  /* Record the mapped user dependency */
1204  }
1205 
1206  /* dependency on extension */
1207  recordDependencyOnCurrentExtension(&myself, false);
1208 
1209  /* Post creation hook for new user mapping */
1211 
1213 
1214  return myself;
1215 }
#define InvokeObjectPostCreateHook(classId, objectId, subId)
Definition: objectaccess.h:145
#define Anum_pg_user_mapping_umuser
Datum transformGenericOptions(Oid catalogId, Datum oldOptions, List *options, Oid fdwvalidator)
Definition: foreigncmds.c:109
#define Anum_pg_user_mapping_umserver
#define PointerGetDatum(X)
Definition: postgres.h:564
int errcode(int sqlerrcode)
Definition: elog.c:575
static void user_mapping_ddl_aclcheck(Oid umuserid, Oid serverid, const char *servername)
Definition: foreigncmds.c:1097
void recordDependencyOn(const ObjectAddress *depender, const ObjectAddress *referenced, DependencyType behavior)
Definition: pg_depend.c:44
HeapTuple heap_form_tuple(TupleDesc tupleDescriptor, Datum *values, bool *isnull)
Definition: heaptuple.c:692
#define heap_close(r, l)
Definition: heapam.h:97
#define Natts_pg_user_mapping
void recordDependencyOnOwner(Oid classId, Oid objectId, Oid owner)
Definition: pg_shdepend.c:158
void heap_freetuple(HeapTuple htup)
Definition: heaptuple.c:1374
unsigned int Oid
Definition: postgres_ext.h:31
#define OidIsValid(objectId)
Definition: c.h:533
#define GetSysCacheOid2(cacheId, key1, key2)
Definition: syscache.h:178
ForeignDataWrapper * GetForeignDataWrapper(Oid fdwid)
Definition: foreign.c:35
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
Oid CatalogTupleInsert(Relation heapRel, HeapTuple tup)
Definition: indexing.c:162
#define Anum_pg_user_mapping_umoptions
#define RowExclusiveLock
Definition: lockdefs.h:38
ForeignServer * GetForeignServerByName(const char *srvname, bool missing_ok)
Definition: foreign.c:148
#define ereport(elevel, rest)
Definition: elog.h:122
uintptr_t Datum
Definition: postgres.h:374
RoleSpecType roletype
Definition: parsenodes.h:319
Oid get_rolespec_oid(const RoleSpec *role, bool missing_ok)
Definition: acl.c:5147
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
TupleDesc rd_att
Definition: rel.h:114
#define ForeignServerRelationId
#define NULL
Definition: c.h:226
void recordDependencyOnCurrentExtension(const ObjectAddress *object, bool isReplace)
Definition: pg_depend.c:139
#define DatumGetPointer(X)
Definition: postgres.h:557
static Datum values[MAXATTR]
Definition: bootstrap.c:162
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define UserMappingRelationId
#define ACL_ID_PUBLIC
Definition: acl.h:39
#define ERRCODE_DUPLICATE_OBJECT
Definition: streamutil.c:34
#define PointerIsValid(pointer)
Definition: c.h:521
Oid serverid
Definition: foreign.h:47
#define MappingUserName(userid)
Definition: foreign.h:20
static void import_error_callback ( void *  arg)
static

Definition at line 1615 of file foreigncmds.c.

References import_error_callback_arg::cmd, errcontext, errposition(), geterrposition(), internalerrposition(), internalerrquery(), and import_error_callback_arg::tablename.

Referenced by ImportForeignSchema().

1616 {
1618  int syntaxerrposition;
1619 
1620  /* If it's a syntax error, convert to internal syntax error report */
1621  syntaxerrposition = geterrposition();
1622  if (syntaxerrposition > 0)
1623  {
1624  errposition(0);
1625  internalerrposition(syntaxerrposition);
1626  internalerrquery(callback_arg->cmd);
1627  }
1628 
1629  if (callback_arg->tablename)
1630  errcontext("importing foreign table \"%s\"",
1631  callback_arg->tablename);
1632 }
int geterrposition(void)
Definition: elog.c:1257
int internalerrquery(const char *query)
Definition: elog.c:1161
#define errcontext
Definition: elog.h:164
void * arg
int errposition(int cursorpos)
Definition: elog.c:1125
int internalerrposition(int cursorpos)
Definition: elog.c:1141
void ImportForeignSchema ( ImportForeignSchemaStmt stmt)

Definition at line 1498 of file foreigncmds.c.

References ACL_KIND_FOREIGN_SERVER, ACL_USAGE, aclcheck_error(), ACLCHECK_OK, ErrorContextCallback::arg, CreateForeignTableStmt::base, ErrorContextCallback::callback, castNode, import_error_callback_arg::cmd, CMD_UTILITY, CommandCounterIncrement(), elog, ereport, errcode(), errmsg(), ERROR, error_context_stack, ForeignDataWrapper::fdwhandler, ForeignServer::fdwid, ForeignDataWrapper::fdwname, GetFdwRoutine(), GetForeignDataWrapper(), GetForeignServerByName(), GetUserId(), import_error_callback(), FdwRoutine::ImportForeignSchema, IsA, IsImportableForeignTable(), lfirst, ImportForeignSchemaStmt::local_schema, LookupCreationNamespace(), makeNode, nodeTag, None_Receiver, NULL, OidIsValid, pg_foreign_server_aclcheck(), pg_parse_query(), ErrorContextCallback::previous, PROCESS_UTILITY_SUBCOMMAND, ProcessUtility(), pstrdup(), CreateStmt::relation, RangeVar::relname, RangeVar::schemaname, ImportForeignSchemaStmt::server_name, ForeignServer::serverid, ForeignServer::servername, RawStmt::stmt, RawStmt::stmt_len, RawStmt::stmt_location, and import_error_callback_arg::tablename.

Referenced by ProcessUtilitySlow().

1499 {
1500  ForeignServer *server;
1501  ForeignDataWrapper *fdw;
1502  FdwRoutine *fdw_routine;
1503  AclResult aclresult;
1504  List *cmd_list;
1505  ListCell *lc;
1506 
1507  /* Check that the foreign server exists and that we have USAGE on it */
1508  server = GetForeignServerByName(stmt->server_name, false);
1509  aclresult = pg_foreign_server_aclcheck(server->serverid, GetUserId(), ACL_USAGE);
1510  if (aclresult != ACLCHECK_OK)
1511  aclcheck_error(aclresult, ACL_KIND_FOREIGN_SERVER, server->servername);
1512 
1513  /* Check that the schema exists and we have CREATE permissions on it */
1514  (void) LookupCreationNamespace(stmt->local_schema);
1515 
1516  /* Get the FDW and check it supports IMPORT */
1517  fdw = GetForeignDataWrapper(server->fdwid);
1518  if (!OidIsValid(fdw->fdwhandler))
1519  ereport(ERROR,
1520  (errcode(ERRCODE_OBJECT_NOT_IN_PREREQUISITE_STATE),
1521  errmsg("foreign-data wrapper \"%s\" has no handler",
1522  fdw->fdwname)));
1523  fdw_routine = GetFdwRoutine(fdw->fdwhandler);
1524  if (fdw_routine->ImportForeignSchema == NULL)
1525  ereport(ERROR,
1526  (errcode(ERRCODE_FDW_NO_SCHEMAS),
1527  errmsg("foreign-data wrapper \"%s\" does not support IMPORT FOREIGN SCHEMA",
1528  fdw->fdwname)));
1529 
1530  /* Call FDW to get a list of commands */
1531  cmd_list = fdw_routine->ImportForeignSchema(stmt, server->serverid);
1532 
1533  /* Parse and execute each command */
1534  foreach(lc, cmd_list)
1535  {
1536  char *cmd = (char *) lfirst(lc);
1537  import_error_callback_arg callback_arg;
1538  ErrorContextCallback sqlerrcontext;
1539  List *raw_parsetree_list;
1540  ListCell *lc2;
1541 
1542  /*
1543  * Setup error traceback support for ereport(). This is so that any
1544  * error in the generated SQL will be displayed nicely.
1545  */
1546  callback_arg.tablename = NULL; /* not known yet */
1547  callback_arg.cmd = cmd;
1548  sqlerrcontext.callback = import_error_callback;
1549  sqlerrcontext.arg = (void *) &callback_arg;
1550  sqlerrcontext.previous = error_context_stack;
1551  error_context_stack = &sqlerrcontext;
1552 
1553  /*
1554  * Parse the SQL string into a list of raw parse trees.
1555  */
1556  raw_parsetree_list = pg_parse_query(cmd);
1557 
1558  /*
1559  * Process each parse tree (we allow the FDW to put more than one
1560  * command per string, though this isn't really advised).
1561  */
1562  foreach(lc2, raw_parsetree_list)
1563  {
1564  RawStmt *rs = castNode(RawStmt, lfirst(lc2));
1566  PlannedStmt *pstmt;
1567 
1568  /*
1569  * Because we only allow CreateForeignTableStmt, we can skip parse
1570  * analysis, rewrite, and planning steps here.
1571  */
1572  if (!IsA(cstmt, CreateForeignTableStmt))
1573  elog(ERROR,
1574  "foreign-data wrapper \"%s\" returned incorrect statement type %d",
1575  fdw->fdwname, (int) nodeTag(cstmt));
1576 
1577  /* Ignore commands for tables excluded by filter options */
1578  if (!IsImportableForeignTable(cstmt->base.relation->relname, stmt))
1579  continue;
1580 
1581  /* Enable reporting of current table's name on error */
1582  callback_arg.tablename = cstmt->base.relation->relname;
1583 
1584  /* Ensure creation schema is the one given in IMPORT statement */
1585  cstmt->base.relation->schemaname = pstrdup(stmt->local_schema);
1586 
1587  /* No planning needed, just make a wrapper PlannedStmt */
1588  pstmt = makeNode(PlannedStmt);
1589  pstmt->commandType = CMD_UTILITY;
1590  pstmt->canSetTag = false;
1591  pstmt->utilityStmt = (Node *) cstmt;
1592  pstmt->stmt_location = rs->stmt_location;
1593  pstmt->stmt_len = rs->stmt_len;
1594 
1595  /* Execute statement */
1596  ProcessUtility(pstmt,
1597  cmd,
1599  None_Receiver, NULL);
1600 
1601  /* Be sure to advance the command counter between subcommands */
1603 
1604  callback_arg.tablename = NULL;
1605  }
1606 
1607  error_context_stack = sqlerrcontext.previous;
1608  }
1609 }
RangeVar * relation
Definition: parsenodes.h:1894
#define IsA(nodeptr, _type_)
Definition: nodes.h:559
Oid GetUserId(void)
Definition: miscinit.c:283
#define castNode(_type_, nodeptr)
Definition: nodes.h:577
char * fdwname
Definition: foreign.h:39
Oid LookupCreationNamespace(const char *nspname)
Definition: namespace.c:2730
char * pstrdup(const char *in)
Definition: mcxt.c:1165
Definition: nodes.h:508
int errcode(int sqlerrcode)
Definition: elog.c:575
DestReceiver * None_Receiver
Definition: dest.c:91
struct ErrorContextCallback * previous
Definition: elog.h:238
#define OidIsValid(objectId)
Definition: c.h:533
char * schemaname
Definition: primnodes.h:66
ErrorContextCallback * error_context_stack
Definition: elog.c:88
FdwRoutine * GetFdwRoutine(Oid fdwhandler)
Definition: foreign.c:287
char * relname
Definition: primnodes.h:67
ForeignDataWrapper * GetForeignDataWrapper(Oid fdwid)
Definition: foreign.c:35
#define ERROR
Definition: elog.h:43
List * pg_parse_query(const char *query_string)
Definition: postgres.c:602
AclResult pg_foreign_server_aclcheck(Oid srv_oid, Oid roleid, AclMode mode)
Definition: aclchk.c:4497
bool IsImportableForeignTable(const char *tablename, ImportForeignSchemaStmt *stmt)
Definition: foreign.c:435
Node * stmt
Definition: parsenodes.h:1337
void aclcheck_error(AclResult aclerr, AclObjectKind objectkind, const char *objectname)
Definition: aclchk.c:3378
#define ACL_USAGE
Definition: parsenodes.h:73
ForeignServer * GetForeignServerByName(const char *srvname, bool missing_ok)
Definition: foreign.c:148
ImportForeignSchema_function ImportForeignSchema
Definition: fdwapi.h:220
#define ereport(elevel, rest)
Definition: elog.h:122
void ProcessUtility(PlannedStmt *pstmt, const char *queryString, ProcessUtilityContext context, ParamListInfo params, DestReceiver *dest, char *completionTag)
Definition: utility.c:332
AclResult
Definition: acl.h:170
void CommandCounterIncrement(void)
Definition: xact.c:921
int stmt_len
Definition: parsenodes.h:1339
int stmt_location
Definition: parsenodes.h:1338
#define makeNode(_type_)
Definition: nodes.h:556
#define NULL
Definition: c.h:226
#define lfirst(lc)
Definition: pg_list.h:106
#define nodeTag(nodeptr)
Definition: nodes.h:513
void(* callback)(void *arg)
Definition: elog.h:239
int errmsg(const char *fmt,...)
Definition: elog.c:797
char * servername
Definition: foreign.h:50
#define elog
Definition: elog.h:219
Definition: pg_list.h:45
Oid serverid
Definition: foreign.h:47
static void import_error_callback(void *arg)
Definition: foreigncmds.c:1615
static Oid lookup_fdw_handler_func ( DefElem handler)
static

Definition at line 472 of file foreigncmds.c.

References DefElem::arg, ereport, errcode(), errmsg(), ERROR, FDW_HANDLEROID, get_func_rettype(), InvalidOid, LookupFuncName(), NameListToString(), and NULL.

Referenced by parse_func_options().

473 {
474  Oid handlerOid;
475  Oid funcargtypes[1]; /* dummy */
476 
477  if (handler == NULL || handler->arg == NULL)
478  return InvalidOid;
479 
480  /* handlers have no arguments */
481  handlerOid = LookupFuncName((List *) handler->arg, 0, funcargtypes, false);
482 
483  /* check that handler has correct return type */
484  if (get_func_rettype(handlerOid) != FDW_HANDLEROID)
485  ereport(ERROR,
486  (errcode(ERRCODE_WRONG_OBJECT_TYPE),
487  errmsg("function %s must return type %s",
488  NameListToString((List *) handler->arg), "fdw_handler")));
489 
490  return handlerOid;
491 }
int errcode(int sqlerrcode)
Definition: elog.c:575
unsigned int Oid
Definition: postgres_ext.h:31
Oid get_func_rettype(Oid funcid)
Definition: lsyscache.c:1427
#define ERROR
Definition: elog.h:43
#define ereport(elevel, rest)
Definition: elog.h:122
Node * arg
Definition: parsenodes.h:676
char * NameListToString(List *names)
Definition: namespace.c:2897
#define InvalidOid
Definition: postgres_ext.h:36
#define NULL
Definition: c.h:226
Oid LookupFuncName(List *funcname, int nargs, const Oid *argtypes, bool noError)
Definition: parse_func.c:1909
int errmsg(const char *fmt,...)
Definition: elog.c:797
Definition: pg_list.h:45
#define FDW_HANDLEROID
Definition: pg_type.h:696
static Oid lookup_fdw_validator_func ( DefElem validator)
static

Definition at line 497 of file foreigncmds.c.

References DefElem::arg, InvalidOid, LookupFuncName(), NULL, OIDOID, and TEXTARRAYOID.

Referenced by parse_func_options().

498 {
499  Oid funcargtypes[2];
500 
501  if (validator == NULL || validator->arg == NULL)
502  return InvalidOid;
503 
504  /* validators take text[], oid */
505  funcargtypes[0] = TEXTARRAYOID;
506  funcargtypes[1] = OIDOID;
507 
508  return LookupFuncName((List *) validator->arg, 2, funcargtypes, false);
509  /* validator's return value is ignored, so we don't check the type */
510 }
#define OIDOID
Definition: pg_type.h:328
unsigned int Oid
Definition: postgres_ext.h:31
#define TEXTARRAYOID
Definition: pg_type.h:459
Node * arg
Definition: parsenodes.h:676
#define InvalidOid
Definition: postgres_ext.h:36
#define NULL
Definition: c.h:226
Oid LookupFuncName(List *funcname, int nargs, const Oid *argtypes, bool noError)
Definition: parse_func.c:1909
Definition: pg_list.h:45
static Datum optionListToArray ( List options)
static

Definition at line 65 of file foreigncmds.c.

References accumArrayResult(), CurrentMemoryContext, defGetString(), DefElem::defname, lfirst, makeArrayResult(), NULL, palloc(), PointerGetDatum, SET_VARSIZE, TEXTOID, value, VARDATA, and VARHDRSZ.

Referenced by transformGenericOptions().

66 {
67  ArrayBuildState *astate = NULL;
68  ListCell *cell;
69 
70  foreach(cell, options)
71  {
72  DefElem *def = lfirst(cell);
73  const char *value;
74  Size len;
75  text *t;
76 
77  value = defGetString(def);
78  len = VARHDRSZ + strlen(def->defname) + 1 + strlen(value);
79  t = palloc(len + 1);
80  SET_VARSIZE(t, len);
81  sprintf(VARDATA(t), "%s=%s", def->defname, value);
82 
83  astate = accumArrayResult(astate, PointerGetDatum(t),
84  false, TEXTOID,
86  }
87 
88  if (astate)
89  return makeArrayResult(astate, CurrentMemoryContext);
90 
91  return PointerGetDatum(NULL);
92 }
static struct @76 value
#define VARDATA(PTR)
Definition: postgres.h:305
#define TEXTOID
Definition: pg_type.h:324
#define PointerGetDatum(X)
Definition: postgres.h:564
#define VARHDRSZ
Definition: c.h:440
char * defGetString(DefElem *def)
Definition: define.c:49
MemoryContext CurrentMemoryContext
Definition: mcxt.c:37
Datum makeArrayResult(ArrayBuildState *astate, MemoryContext rcontext)
Definition: arrayfuncs.c:5055
#define NULL
Definition: c.h:226
#define lfirst(lc)
Definition: pg_list.h:106
size_t Size
Definition: c.h:352
ArrayBuildState * accumArrayResult(ArrayBuildState *astate, Datum dvalue, bool disnull, Oid element_type, MemoryContext rcontext)
Definition: arrayfuncs.c:4991
void * palloc(Size size)
Definition: mcxt.c:891
Definition: c.h:434
char * defname
Definition: parsenodes.h:675
#define SET_VARSIZE(PTR, len)
Definition: postgres.h:330
static void parse_func_options ( List func_options,
bool handler_given,
Oid fdwhandler,
bool validator_given,
Oid fdwvalidator 
)
static

Definition at line 516 of file foreigncmds.c.

References DefElem::defname, elog, ereport, errcode(), errmsg(), ERROR, InvalidOid, lfirst, lookup_fdw_handler_func(), and lookup_fdw_validator_func().

Referenced by AlterForeignDataWrapper(), and CreateForeignDataWrapper().

519 {
520  ListCell *cell;
521 
522  *handler_given = false;
523  *validator_given = false;
524  /* return InvalidOid if not given */
525  *fdwhandler = InvalidOid;
526  *fdwvalidator = InvalidOid;
527 
528  foreach(cell, func_options)
529  {
530  DefElem *def = (DefElem *) lfirst(cell);
531 
532  if (strcmp(def->defname, "handler") == 0)
533  {
534  if (*handler_given)
535  ereport(ERROR,
536  (errcode(ERRCODE_SYNTAX_ERROR),
537  errmsg("conflicting or redundant options")));
538  *handler_given = true;
539  *fdwhandler = lookup_fdw_handler_func(def);
540  }
541  else if (strcmp(def->defname, "validator") == 0)
542  {
543  if (*validator_given)
544  ereport(ERROR,
545  (errcode(ERRCODE_SYNTAX_ERROR),
546  errmsg("conflicting or redundant options")));
547  *validator_given = true;
548  *fdwvalidator = lookup_fdw_validator_func(def);
549  }
550  else
551  elog(ERROR, "option \"%s\" not recognized",
552  def->defname);
553  }
554 }
int errcode(int sqlerrcode)
Definition: elog.c:575
static Oid lookup_fdw_validator_func(DefElem *validator)
Definition: foreigncmds.c:497
static Oid lookup_fdw_handler_func(DefElem *handler)
Definition: foreigncmds.c:472
#define ERROR
Definition: elog.h:43
#define ereport(elevel, rest)
Definition: elog.h:122
#define InvalidOid
Definition: postgres_ext.h:36
#define lfirst(lc)
Definition: pg_list.h:106
int errmsg(const char *fmt,...)
Definition: elog.c:797
char * defname
Definition: parsenodes.h:675
#define elog
Definition: elog.h:219
void RemoveForeignDataWrapperById ( Oid  fdwId)

Definition at line 837 of file foreigncmds.c.

References CatalogTupleDelete(), elog, ERROR, FOREIGNDATAWRAPPEROID, ForeignDataWrapperRelationId, heap_close, heap_open(), HeapTupleIsValid, ObjectIdGetDatum, ReleaseSysCache(), RowExclusiveLock, SearchSysCache1, and HeapTupleData::t_self.

Referenced by doDeletion().

838 {
839  HeapTuple tp;
840  Relation rel;
841 
843 
845 
846  if (!HeapTupleIsValid(tp))
847  elog(ERROR, "cache lookup failed for foreign-data wrapper %u", fdwId);
848 
849  CatalogTupleDelete(rel, &tp->t_self);
850 
851  ReleaseSysCache(tp);
852 
854 }
void CatalogTupleDelete(Relation heapRel, ItemPointer tid)
Definition: indexing.c:255
#define heap_close(r, l)
Definition: heapam.h:97
#define SearchSysCache1(cacheId, key1)
Definition: syscache.h:149
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
ItemPointerData t_self
Definition: htup.h:65
#define RowExclusiveLock
Definition: lockdefs.h:38
void ReleaseSysCache(HeapTuple tuple)
Definition: syscache.c:1083
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
#define ForeignDataWrapperRelationId
#define elog
Definition: elog.h:219
void RemoveForeignServerById ( Oid  srvId)

Definition at line 1071 of file foreigncmds.c.

References CatalogTupleDelete(), elog, ERROR, FOREIGNSERVEROID, ForeignServerRelationId, heap_close, heap_open(), HeapTupleIsValid, ObjectIdGetDatum, ReleaseSysCache(), RowExclusiveLock, SearchSysCache1, and HeapTupleData::t_self.

Referenced by doDeletion().

1072 {
1073  HeapTuple tp;
1074  Relation rel;
1075 
1077 
1079 
1080  if (!HeapTupleIsValid(tp))
1081  elog(ERROR, "cache lookup failed for foreign server %u", srvId);
1082 
1083  CatalogTupleDelete(rel, &tp->t_self);
1084 
1085  ReleaseSysCache(tp);
1086 
1088 }
void CatalogTupleDelete(Relation heapRel, ItemPointer tid)
Definition: indexing.c:255
#define heap_close(r, l)
Definition: heapam.h:97
#define SearchSysCache1(cacheId, key1)
Definition: syscache.h:149
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
ItemPointerData t_self
Definition: htup.h:65
#define RowExclusiveLock
Definition: lockdefs.h:38
void ReleaseSysCache(HeapTuple tuple)
Definition: syscache.c:1083
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
#define ForeignServerRelationId
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
#define elog
Definition: elog.h:219
Oid RemoveUserMapping ( DropUserMappingStmt stmt)

Definition at line 1317 of file foreigncmds.c.

References ACL_ID_PUBLIC, DROP_CASCADE, elog, ereport, errcode(), errmsg(), ERROR, get_rolespec_oid(), GetForeignServerByName(), GetSysCacheOid2, InvalidOid, MappingUserName, DropUserMappingStmt::missing_ok, NOTICE, ObjectIdGetDatum, OidIsValid, performDeletion(), RoleSpec::rolename, ROLESPEC_PUBLIC, RoleSpec::roletype, ForeignServer::serverid, ForeignServer::servername, DropUserMappingStmt::servername, DropUserMappingStmt::user, user_mapping_ddl_aclcheck(), UserMappingRelationId, and USERMAPPINGUSERSERVER.

Referenced by ProcessUtilitySlow().

1318 {
1319  ObjectAddress object;
1320  Oid useId;
1321  Oid umId;
1322  ForeignServer *srv;
1323  RoleSpec *role = (RoleSpec *) stmt->user;
1324 
1325  if (role->roletype == ROLESPEC_PUBLIC)
1326  useId = ACL_ID_PUBLIC;
1327  else
1328  {
1329  useId = get_rolespec_oid(stmt->user, stmt->missing_ok);
1330  if (!OidIsValid(useId))
1331  {
1332  /*
1333  * IF EXISTS specified, role not found and not public. Notice this
1334  * and leave.
1335  */
1336  elog(NOTICE, "role \"%s\" does not exist, skipping",
1337  role->rolename);
1338  return InvalidOid;
1339  }
1340  }
1341 
1342  srv = GetForeignServerByName(stmt->servername, true);
1343 
1344  if (!srv)
1345  {
1346  if (!stmt->missing_ok)
1347  ereport(ERROR,
1348  (errcode(ERRCODE_UNDEFINED_OBJECT),
1349  errmsg("server \"%s\" does not exist",
1350  stmt->servername)));
1351  /* IF EXISTS, just note it */
1352  ereport(NOTICE, (errmsg("server does not exist, skipping")));
1353  return InvalidOid;
1354  }
1355 
1357  ObjectIdGetDatum(useId),
1358  ObjectIdGetDatum(srv->serverid));
1359 
1360  if (!OidIsValid(umId))
1361  {
1362  if (!stmt->missing_ok)
1363  ereport(ERROR,
1364  (errcode(ERRCODE_UNDEFINED_OBJECT),
1365  errmsg("user mapping \"%s\" does not exist for the server",
1366  MappingUserName(useId))));
1367 
1368  /* IF EXISTS specified, just note it */
1369  ereport(NOTICE,
1370  (errmsg("user mapping \"%s\" does not exist for the server, skipping",
1371  MappingUserName(useId))));
1372  return InvalidOid;
1373  }
1374 
1375  user_mapping_ddl_aclcheck(useId, srv->serverid, srv->servername);
1376 
1377  /*
1378  * Do the deletion
1379  */
1380  object.classId = UserMappingRelationId;
1381  object.objectId = umId;
1382  object.objectSubId = 0;
1383 
1384  performDeletion(&object, DROP_CASCADE, 0);
1385 
1386  return umId;
1387 }
int errcode(int sqlerrcode)
Definition: elog.c:575
static void user_mapping_ddl_aclcheck(Oid umuserid, Oid serverid, const char *servername)
Definition: foreigncmds.c:1097
unsigned int Oid
Definition: postgres_ext.h:31
#define OidIsValid(objectId)
Definition: c.h:533
#define GetSysCacheOid2(cacheId, key1, key2)
Definition: syscache.h:178
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
void performDeletion(const ObjectAddress *object, DropBehavior behavior, int flags)
Definition: dependency.c:301
ForeignServer * GetForeignServerByName(const char *srvname, bool missing_ok)
Definition: foreign.c:148
#define ereport(elevel, rest)
Definition: elog.h:122
RoleSpecType roletype
Definition: parsenodes.h:319
Oid get_rolespec_oid(const RoleSpec *role, bool missing_ok)
Definition: acl.c:5147
#define InvalidOid
Definition: postgres_ext.h:36
#define NOTICE
Definition: elog.h:37
char * rolename
Definition: parsenodes.h:320
int errmsg(const char *fmt,...)
Definition: elog.c:797
#define UserMappingRelationId
char * servername
Definition: foreign.h:50
#define ACL_ID_PUBLIC
Definition: acl.h:39
#define elog
Definition: elog.h:219
Oid serverid
Definition: foreign.h:47
#define MappingUserName(userid)
Definition: foreign.h:20
void RemoveUserMappingById ( Oid  umId)

Definition at line 1394 of file foreigncmds.c.

References CatalogTupleDelete(), elog, ERROR, heap_close, heap_open(), HeapTupleIsValid, ObjectIdGetDatum, ReleaseSysCache(), RowExclusiveLock, SearchSysCache1, HeapTupleData::t_self, USERMAPPINGOID, and UserMappingRelationId.

Referenced by doDeletion().

1395 {
1396  HeapTuple tp;
1397  Relation rel;
1398 
1400 
1402 
1403  if (!HeapTupleIsValid(tp))
1404  elog(ERROR, "cache lookup failed for user mapping %u", umId);
1405 
1406  CatalogTupleDelete(rel, &tp->t_self);
1407 
1408  ReleaseSysCache(tp);
1409 
1411 }
void CatalogTupleDelete(Relation heapRel, ItemPointer tid)
Definition: indexing.c:255
#define heap_close(r, l)
Definition: heapam.h:97
#define SearchSysCache1(cacheId, key1)
Definition: syscache.h:149
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
ItemPointerData t_self
Definition: htup.h:65
#define RowExclusiveLock
Definition: lockdefs.h:38
void ReleaseSysCache(HeapTuple tuple)
Definition: syscache.c:1083
Relation heap_open(Oid relationId, LOCKMODE lockmode)
Definition: heapam.c:1287
#define HeapTupleIsValid(tuple)
Definition: htup.h:77
#define UserMappingRelationId
#define elog
Definition: elog.h:219
Datum transformGenericOptions ( Oid  catalogId,
Datum  oldOptions,
List options,
Oid  fdwvalidator 
)

Definition at line 109 of file foreigncmds.c.

References construct_empty_array(), DatumGetPointer, DefElem::defaction, DEFELEM_ADD, DEFELEM_DROP, DEFELEM_SET, DEFELEM_UNSPEC, DefElem::defname, elog, ereport, errcode(), ERRCODE_DUPLICATE_OBJECT, errmsg(), ERROR, lappend(), lfirst, list_delete_cell(), NULL, ObjectIdGetDatum, OidFunctionCall2, OidIsValid, optionListToArray(), PointerGetDatum, TEXTOID, and untransformRelOptions().

Referenced by AlterForeignDataWrapper(), AlterForeignServer(), AlterUserMapping(), ATExecAlterColumnGenericOptions(), ATExecGenericOptions(), CreateForeignDataWrapper(), CreateForeignServer(), CreateForeignTable(), and CreateUserMapping().

113 {
114  List *resultOptions = untransformRelOptions(oldOptions);
115  ListCell *optcell;
116  Datum result;
117 
118  foreach(optcell, options)
119  {
120  DefElem *od = lfirst(optcell);
121  ListCell *cell;
122  ListCell *prev = NULL;
123 
124  /*
125  * Find the element in resultOptions. We need this for validation in
126  * all cases. Also identify the previous element.
127  */
128  foreach(cell, resultOptions)
129  {
130  DefElem *def = lfirst(cell);
131 
132  if (strcmp(def->defname, od->defname) == 0)
133  break;
134  else
135  prev = cell;
136  }
137 
138  /*
139  * It is possible to perform multiple SET/DROP actions on the same
140  * option. The standard permits this, as long as the options to be
141  * added are unique. Note that an unspecified action is taken to be
142  * ADD.
143  */
144  switch (od->defaction)
145  {
146  case DEFELEM_DROP:
147  if (!cell)
148  ereport(ERROR,
149  (errcode(ERRCODE_UNDEFINED_OBJECT),
150  errmsg("option \"%s\" not found",
151  od->defname)));
152  resultOptions = list_delete_cell(resultOptions, cell, prev);
153  break;
154 
155  case DEFELEM_SET:
156  if (!cell)
157  ereport(ERROR,
158  (errcode(ERRCODE_UNDEFINED_OBJECT),
159  errmsg("option \"%s\" not found",
160  od->defname)));
161  lfirst(cell) = od;
162  break;
163 
164  case DEFELEM_ADD:
165  case DEFELEM_UNSPEC:
166  if (cell)
167  ereport(ERROR,
169  errmsg("option \"%s\" provided more than once",
170  od->defname)));
171  resultOptions = lappend(resultOptions, od);
172  break;
173 
174  default:
175  elog(ERROR, "unrecognized action %d on option \"%s\"",
176  (int) od->defaction, od->defname);
177  break;
178  }
179  }
180 
181  result = optionListToArray(resultOptions);
182 
183  if (OidIsValid(fdwvalidator))
184  {
185  Datum valarg = result;
186 
187  /*
188  * Pass a null options list as an empty array, so that validators
189  * don't have to be declared non-strict to handle the case.
190  */
191  if (DatumGetPointer(valarg) == NULL)
193  OidFunctionCall2(fdwvalidator, valarg, ObjectIdGetDatum(catalogId));
194  }
195 
196  return result;
197 }
#define TEXTOID
Definition: pg_type.h:324
#define PointerGetDatum(X)
Definition: postgres.h:564
DefElemAction defaction
Definition: parsenodes.h:677
int errcode(int sqlerrcode)
Definition: elog.c:575
ArrayType * construct_empty_array(Oid elmtype)
Definition: arrayfuncs.c:3424
#define OidIsValid(objectId)
Definition: c.h:533
#define ObjectIdGetDatum(X)
Definition: postgres.h:515
#define ERROR
Definition: elog.h:43
#define ereport(elevel, rest)
Definition: elog.h:122
List * lappend(List *list, void *datum)
Definition: list.c:128
List * list_delete_cell(List *list, ListCell *cell, ListCell *prev)
Definition: list.c:528
uintptr_t Datum
Definition: postgres.h:374
List * untransformRelOptions(Datum options)
Definition: reloptions.c:861
#define NULL
Definition: c.h:226
#define lfirst(lc)
Definition: pg_list.h:106
#define DatumGetPointer(X)
Definition: postgres.h:557
#define OidFunctionCall2(functionId, arg1, arg2)
Definition: fmgr.h:595
int errmsg(const char *fmt,...)
Definition: elog.c:797
char * defname
Definition: parsenodes.h:675
#define elog
Definition: elog.h:219
#define ERRCODE_DUPLICATE_OBJECT
Definition: streamutil.c:34
Definition: pg_list.h:45
static Datum optionListToArray(List *options)
Definition: foreigncmds.c:65
static void user_mapping_ddl_aclcheck ( Oid  umuserid,
Oid  serverid,
const char *  servername 
)
static

Definition at line 1097 of file foreigncmds.c.

References ACL_KIND_FOREIGN_SERVER, ACL_USAGE, aclcheck_error(), ACLCHECK_NOT_OWNER, ACLCHECK_OK, GetUserId(), pg_foreign_server_aclcheck(), and pg_foreign_server_ownercheck().

Referenced by AlterUserMapping(), CreateUserMapping(), and RemoveUserMapping().

1098 {
1099  Oid curuserid = GetUserId();
1100 
1101  if (!pg_foreign_server_ownercheck(serverid, curuserid))
1102  {
1103  if (umuserid == curuserid)
1104  {
1105  AclResult aclresult;
1106 
1107  aclresult = pg_foreign_server_aclcheck(serverid, curuserid, ACL_USAGE);
1108  if (aclresult != ACLCHECK_OK)
1109  aclcheck_error(aclresult, ACL_KIND_FOREIGN_SERVER, servername);
1110  }
1111  else
1113  servername);
1114  }
1115 }
Oid GetUserId(void)
Definition: miscinit.c:283
bool pg_foreign_server_ownercheck(Oid srv_oid, Oid roleid)
Definition: aclchk.c:4885
unsigned int Oid
Definition: postgres_ext.h:31
AclResult pg_foreign_server_aclcheck(Oid srv_oid, Oid roleid, AclMode mode)
Definition: aclchk.c:4497
void aclcheck_error(AclResult aclerr, AclObjectKind objectkind, const char *objectname)
Definition: aclchk.c:3378
#define ACL_USAGE
Definition: parsenodes.h:73
AclResult
Definition: acl.h:170