Here's the code that reproduces the behavior:
http://paste.debian.net/1035412/
I have already discussed this in the IRC channel but there doesn't seem to
be a consensus on whether this is a bug here's a brief transcript of
RhodiumToad's opinion:
> this isn't new, goes back to 9.1 at least
> basic
> CREATE OR REPLACE FUNCTION myfunction(myrow mytable)
> RETURNS INTEGER AS $$
> SELECT myrow.c + myrow.b FROM myrow;
> $$ LANGUAGE sql;
> where "myrow" is a table with a different set of column names from
> "mytable". The existing behavior for that is to seek the column name
> in "myrow" (th
I was trying to get postgres to warn me that I'm referencing a table that
it doesn't exists inside a function so I was told on the IRC to check the
setting "check_function_bodies", however when I use it in a plpgsql
function it doesn't actually check if the tables in the body exist. Is this
the cor
#x27;t taken in account for the validation of whether a
change to the structure of the database breaks the APIs that the database
exposes.
On Tue, Aug 7, 2018 at 6:44 PM Merlin Moncure wrote:
> On Tue, Aug 7, 2018 at 2:31 PM Tom Lane wrote:
> >
> > Marcelo Lacerda writes:
> >
I'll take a look at it. Thanks for the recommendation.
On Tue, Aug 7, 2018 at 7:22 PM Pavel Stehule
wrote:
>
>
> 2018-08-08 0:02 GMT+02:00 Marcelo Lacerda :
>
>> That's a whole different nightmare that I'm expecting.
>>
>
>
>
>>
>>
There are a few instances where the release notes seem to indicate that the
administrator should use pg_dump to upgrade a database so that improvements
on btree can be available.
Here are they:
1.
>In new btree indexes, the maximum index entry length is reduced by eight
bytes, to improve handlin
I'm having some trouble configuring ldap login to postgres. I have
configured LDAP on pg_hba.conf and postgres picks up the correct
configuration during login but I get an error message whenever I attempt to
login with psql to a database named teste.
psql: error: could not connect to server: FATAL
Thank you joão, that solved the problem!
Our company is looking for commercial training in postgresql. We want a
training option that's as in-depth as possible (going as far as being able
to read and patch postgresql source code). Is there any company that offers
something like that?
Another important thing to mention is that due to lega
