DbSchema does not see function text in PostgreSQL 9.1 DB

PostgreSQL - related issues
Post Reply
petr.fedorov
Posts: 32
Joined: Sun Aug 19, 2012 8:57 am
Location: Russia

DbSchema does not see function text in PostgreSQL 9.1 DB

Post by petr.fedorov » Sun Aug 19, 2012 9:19 am

Hello,

After synchronization with PostgreSQL databse, only names of the functions are copied into .dbs file. Text of the functions is missing (see below). If I create a function within DbSchema and then save it to database, the result is the same - DbSchema does not see text of the function in database. Next time I'm trying to syncrhonize, DbSchema behaves like function are without code

I'm on Fedora 16, PostgreSQL 9.1
Attachments
dbconnection.png
Database connection
dbconnection.png (121.09 KiB) Viewed 10610 times
jdbcdriver.png
JDBC driver I'm using
jdbcdriver.png (100 KiB) Viewed 10610 times
screen.png
Missing function code
screen.png (125.79 KiB) Viewed 10610 times

Martin.Sawyer
Posts: 21
Joined: Mon Dec 19, 2011 11:46 am

Re: DbSchema does not see function text in PostgreSQL 9.1 DB

Post by Martin.Sawyer » Mon Aug 20, 2012 6:42 am

Hello,

A ticket has been opened for this issue, ID: 0001161

jwhitten
Posts: 31
Joined: Thu Aug 16, 2012 3:29 pm

Re: DbSchema does not see function text in PostgreSQL 9.1 DB

Post by jwhitten » Fri Sep 14, 2012 1:27 pm

I have this same issue with Postgresql 8.4

donose.mihai
Posts: 470
Joined: Thu Apr 07, 2011 11:05 am

Re: DbSchema does not see function text in PostgreSQL 9.1 DB

Post by donose.mihai » Sat Sep 15, 2012 12:07 pm

Our engineers replayed and closed this issue:

Works the best until Postgres9. On Postgres8 works too, but does not show the function parameters.

This is a Postgres related issue.

Fence
Posts: 1
Joined: Wed Jan 07, 2015 5:41 am

Re: DbSchema does not see function text in PostgreSQL 9.1 DB

Post by Fence » Wed Jan 07, 2015 5:43 am

Hapyy new year to all of you and also glad to you

Post Reply