Mark Forums Read

Internal functions show up in PostgreSQL DB

Go Back

comp.databases.postgresql comp.databases.postgresql

Reply

#1

Old

Titus Barik

Posts: n/a

Internal functions show up in PostgreSQL DB - 05-28-2008 , 11:47 AM

All,

Not sure what happened here, but 'internal functions' now just up when I
do a restore from a previous pg_dump file that I have. Functions such as
_int_contained, int_different, _int_overlap, g_intbig_compress, and
many more now show up in my Functions list in pgAdmin as well as other IDEs.

What can I do to fix this, and why is it happening in the first place?

Thanks,

Titus Barik

Reply With Quote

#2

Old

Titus Barik

Posts: n/a

Re: Internal functions show up in PostgreSQL DB - 05-28-2008 , 01:16 PM

Titus Barik wrote:

Quote:

All,

Not sure what happened here, but 'internal functions' now just up when I
do a restore from a previous pg_dump file that I have. Functions such as
_int_contained, int_different, _int_overlap, g_intbig_compress, and
many more now show up in my Functions list in pgAdmin as well as other
IDEs.

Okay, figured it out. Looks like these modules all came from __int.sql
at some point in contrib.

Thanks,

Titus

Reply With Quote

#3

Old

Titus Barik

Posts: n/a

Re: Internal functions show up in PostgreSQL DB - 05-28-2008 , 01:16 PM

Titus Barik wrote:

Quote:

All,

Not sure what happened here, but 'internal functions' now just up when I
do a restore from a previous pg_dump file that I have. Functions such as
_int_contained, int_different, _int_overlap, g_intbig_compress, and
many more now show up in my Functions list in pgAdmin as well as other
IDEs.

Okay, figured it out. Looks like these modules all came from __int.sql
at some point in contrib.

Thanks,

Titus

Reply With Quote

#4

Old

Titus Barik

Posts: n/a

Re: Internal functions show up in PostgreSQL DB - 05-28-2008 , 01:16 PM

Titus Barik wrote:

Quote:

All,

Not sure what happened here, but 'internal functions' now just up when I
do a restore from a previous pg_dump file that I have. Functions such as
_int_contained, int_different, _int_overlap, g_intbig_compress, and
many more now show up in my Functions list in pgAdmin as well as other
IDEs.

Okay, figured it out. Looks like these modules all came from __int.sql
at some point in contrib.

Thanks,

Titus

Reply With Quote

#5

Old

Titus Barik

Posts: n/a

Re: Internal functions show up in PostgreSQL DB - 05-28-2008 , 01:16 PM

Titus Barik wrote:

Quote:

All,

Not sure what happened here, but 'internal functions' now just up when I
do a restore from a previous pg_dump file that I have. Functions such as
_int_contained, int_different, _int_overlap, g_intbig_compress, and
many more now show up in my Functions list in pgAdmin as well as other
IDEs.

Okay, figured it out. Looks like these modules all came from __int.sql
at some point in contrib.

Thanks,

Titus

Reply With Quote

#6

Old

Titus Barik

Posts: n/a

Re: Internal functions show up in PostgreSQL DB - 05-28-2008 , 01:16 PM

Titus Barik wrote:

Quote:

All,

Not sure what happened here, but 'internal functions' now just up when I
do a restore from a previous pg_dump file that I have. Functions such as
_int_contained, int_different, _int_overlap, g_intbig_compress, and
many more now show up in my Functions list in pgAdmin as well as other
IDEs.

Okay, figured it out. Looks like these modules all came from __int.sql
at some point in contrib.

Thanks,

Titus

Reply With Quote

#7

Old

Titus Barik

Posts: n/a

Re: Internal functions show up in PostgreSQL DB - 05-28-2008 , 01:16 PM

Titus Barik wrote:

Quote:

All,

Not sure what happened here, but 'internal functions' now just up when I
do a restore from a previous pg_dump file that I have. Functions such as
_int_contained, int_different, _int_overlap, g_intbig_compress, and
many more now show up in my Functions list in pgAdmin as well as other
IDEs.

Okay, figured it out. Looks like these modules all came from __int.sql
at some point in contrib.

Thanks,

Titus

Reply With Quote

#8

Old

Titus Barik

Posts: n/a

Re: Internal functions show up in PostgreSQL DB - 05-28-2008 , 01:16 PM

Titus Barik wrote:

Quote:

All,

Not sure what happened here, but 'internal functions' now just up when I
do a restore from a previous pg_dump file that I have. Functions such as
_int_contained, int_different, _int_overlap, g_intbig_compress, and
many more now show up in my Functions list in pgAdmin as well as other
IDEs.

Okay, figured it out. Looks like these modules all came from __int.sql
at some point in contrib.

Thanks,

Titus

Reply With Quote

#9

Old

Titus Barik

Posts: n/a

Re: Internal functions show up in PostgreSQL DB - 05-28-2008 , 01:16 PM

Titus Barik wrote:

Quote:

All,

Not sure what happened here, but 'internal functions' now just up when I
do a restore from a previous pg_dump file that I have. Functions such as
_int_contained, int_different, _int_overlap, g_intbig_compress, and
many more now show up in my Functions list in pgAdmin as well as other
IDEs.

Okay, figured it out. Looks like these modules all came from __int.sql
at some point in contrib.

Thanks,

Titus

Reply With Quote

Reply

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.