On Tue, Sep 22, 2020 at 6:34 PM raf wrote:
> Hi,
>
> I just wrote a query that I didn't expect to work but I
> was pleasantly surprised that it did. It looked
> something like this:
>
> select
> a.aaa,
> c.ccc,
> d.ddd1,
> d.ddd2
> from
> tbla a,
> tblb b,
> tblc c
Hi,
I just wrote a query that I didn't expect to work but I
was pleasantly surprised that it did. It looked
something like this:
select
a.aaa,
c.ccc,
d.ddd1,
d.ddd2
from
tbla a,
tblb b,
tblc c,
funcd(c.id) d
where
a.something = something and
b.somethi
On 9/22/20 3:28 PM, tutilu...@tutanota.com wrote:
Sep 21, 2020, 7:53 PM by j...@commandprompt.com:
I have to agree that pg_dump is largely a step child backup program.
It has consistently been found over the years to be lacking in a
number of areas. Unfortunately, working on pg_dump
Sep 21, 2020, 7:53 PM by j...@commandprompt.com:
> I have to agree that pg_dump is largely a step child backup program. It has
> consistently been found over the years to be lacking in a number of areas.
> Unfortunately, working on pg_dump isn't sexy and it is difficult to get
> volunteers or
Joshua - adding to what Fabio said (with which I agree wholeheartedly!) -
It will be worthwhile for you to itemize the attributes and needed features
for making a final decision about the architecture of the application you
plan to deploy.
While you are familiar with PostgreSQL and like its featu
Hi guys,
I am not sure if this problem is really related to PostgreSQL but maybe
someone could have some idea?
We run several Debian instances with PostgreSQL on Google compute engine
and lately we have already seen several occurrences of the following
problem.
Instance becomes suddenly non resp
On 21/09/2020 17:53, Joshua Drake wrote:
3. The ability to embed PG to run in an automatic, quiet manner as part
of something else. I know about SQLite, but it's extremely limited to
the point of being virtually useless IMO, which is why I cannot use that
for anything nontrivial. I want my fa
Niels Jespersen writes:
> I can create a user mapping for a group (role). This works, but it is not
> enough to grant the role to the end user (that has inherit defined). The end
> user must explicitly use "set role" before accessing the foreign table.
Seems right to me. If the user is a membe
>>On Mon, 2020-09-21 at 08:21 +, Niels Jespersen wrote:
>> create user mapping for current_user server s... (user 'remoteuser',
>> password 'remotepassword');
>>
>> create foreign table t ( a int) server s... options (table_name
>> 't_remote');
>>
>> This works fine. Except only the u
