Re: Loss of some parts of the function definition

2015-04-30 15:08 GMT+02:00 Sergey Grinko <sergey.grinko@gmail.com>:

That's what I have to do now.

But there is some problem.

When you try to build the update script I get to Git code is always different from what I see in the database. 

It is not right.

MSSQL Server, Oracle, ... always saving of the full text DDL.

I do not understand why PostgreSQL believe that part of the source function must be removed !?

I can understand to problem, but it doesn't help to you. Postgres displays the code, that is really used. So we can speak what is more wrong - displaying original but not used code, or displaying really used code.

I am thinking so current solution is better - any other solution mean 2x stored data, that can be partially inconsistent.

It cannot be comparable with Oracle - because it is different technology.

 

2015-04-30 15:59 GMT+03:00 Pavel Stehule <pavel.stehule@gmail.com>:

2015-04-30 14:52 GMT+02:00 Sergey Grinko <sergey.grinko@gmail.com>:

Yes, I understand that.

So I ask to implement saving of the full text DDL.

This will allow developers to be able to save a meaning at the level of the source code.

I ask to make sure that the function pg_get_function_def () returns previously stored full text DDL, instead of generating input and output parameters based on metadata.

I don't see a sense of this - usually much better is storing code to files and using GIT and other.

Surely, you can safe code to any custom table.

Regards

Pavel

 

2015-04-30 15:46 GMT+03:00 Pavel Stehule <pavel.stehule@gmail.com>:

Hi

2015-04-30 13:44 GMT+02:00 Sergey Grinko <sergey.grinko@gmail.com>:

Hi,

Dear developers, I have a request to you.

Now create a script in the application of its function parameters and return values can be declared using %TYPE. 

However, when you save the script is stored inside the server only what is considered his body. Thus, we obtain:

1) loss of the custom formatting.

2) loss of communication parameters and return types with these types of fields to create the function.

3) multidimensional arrays are transformed into one-dimensional: [][] -> []

4) loss of data accuracy: numeric(n,m) -> numeric

Please - how to save and restore the entire text of the definition to CREATE END; unchanged.

I am afraid, it is not possible

Postgres doesn't distinguish between multidimensional and one dimensional arrays - multidimensional is just syntax suger, same is function arguments - Postgres doesn't store precision for parameters. type%TYPE is translated to target type outside plpgsql function. These informations are not saved, so you cannot to take it from PostgreSQL

Regards

Pavel Stehule

 

--

Yours faithfully, Sergey Grinko
Email: sergey.grinko@gmail.com

--

Yours faithfully, Sergey Grinko
Email: sergey.grinko@gmail.com

--

Yours faithfully, Sergey Grinko
Email: sergey.grinko@gmail.com