Actually it's only the views that have this problem. The funcitons have kept the original table name which is now the name of the view. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org