Nolan Interesting, I created a custom query but didn't add any grant execute statements, and it seems to run without errors. Is it just running and returning null?
Nolan By 'run without errors' I mean the client returns 0 errors according to the logs. Haven't looked at the network request yet.
Nolan Happy to see RLS making my query logic cleaner, not having to tack on a bunch of where clauses based on roles in each and every query.
Of course empty string doesnât delete it. I use nullif
But reset is strictly more correct and accurate
Personally I use transactions and set local; then when transaction finishes everything is cleared
Deploy it any way youâd deploy a Node.js Express app; personally I use Heroku for most things. PostGraphile will run on Lambda but itâs not optimised for that environment and it loses the concurrency benefits PostGraphile has. https://github.com/graphile/postgraphile-lambda-example
Nolan Having some trouble porting my first update mutation to postgraphile. https://pastebin.com/hu7virAn That's with DEBUG set to postgraphile:graphql,postgraphile:postgres,postgraphile:postgres:error. Looks like there's no query, and the result of updateOrder is null.
Hey @benjie, any idea why this
"set-returning functions must appear at top level of FROM", would happen?
postgraphile:postgres begin +22s
postgraphile:postgres select set_config($1, $2, true), set_config($3, $4, true) +2ms
postgraphile:postgres with __local_0__ as (
postgraphile:postgres select to_json(__local_1__.__local_1__) as "value"
postgraphile:postgres from unnest("crtrs"."get_notifications_alt"()) as __local_1__
postgraphile:postgres
postgraphile:postgres where (TRUE) and (TRUE)
postgraphile:postgres
postgraphile:postgres
postgraphile:postgres
postgraphile:postgres ), __local_2__ as (select json_agg(to_json(__local_0__)) as data from __local_0__) select coalesce((select __local_2__.data from __local_2__), '[]'::json) as "data" +2ms
postgraphile:postgres:error error: set-returning functions must appear at top level of FROM
Iâm guessing youâre using does âselect my_func(..)â instead of âselect * from my_func(..)â
when I do
select * from crtrs.get_notifications_alt(); on my ide, it works ok
Any way I could force postgraphile to select it like that?
If not I could just make a separate api endpoint no problem
And I have no rush, if you can look on it when you have the time I'd appreciate it a lot
Ah we donât support combining setof with arrays; sorry this restriction isnât documented; itâs effectively because arrays in pg are not so strongly typed (they can change dimensionality/etc) and also because we use unnest which goes deep rather than just one level (I think)
If you need that wrap it in a custom composite type and return setof that.
âConnection (list) of arrays (lists) of jsonâ seems a weird thing to want; perhaps use json_aggregate instead and have the json itself be the array?
I am trying to create a computed column that creates the column by pulling it from from a different table. I don't seem to be having an success and therefore I think it may not be possible to do this, can someone confirm if this is possible or not please? See code below.
create or replace function admin.event_startdatetime(event admin.event)
returns timestamp as $$
select
event_start_datetime.event_start_datetime
from
admin.event
left join
(select
admin.event_date_time.event_id,
min(to_timestamp(EXTRACT(EPOCH FROM (min(admin.event_date_time.event_date) || ' ' || min(admin.event_date_time.start_time))::timestamp))::timestamp) over (partition by admin.event_date_time.event_id) as event_start_datetime
from
admin.event_date_time
group by
admin.event_date_time.event_id
) as event_start_datetime
on event.id = event_start_datetime.event_id;
$$ language sql stable security definer;
comment on function admin.event_startdatetime(admin.event) is 'Get the start date/time of each event - computed column on admin.events table';
The function works fine but I am not getting the computed column in GraphQL
Are you using no-ignore-rbac? If so, check youâve granted execute on the function.
Functions are a black box to PostGraphile; we only see whatâs in the declaration, not the body.
