jar
06/12/2022, 6:19 PMmylist jsonb := '[]';
and in loop want to push opjects into it
mylist = mylist || jsonb_build_object(
'id', my_id::uuid,
'myfield', some_text,
);
I think this is actually making the list like jsonb[] type without string around '[]' its like []. Error is operator does not exist: character varying = jsonb
for overall func and I think something like this is issuejar
06/12/2022, 8:03 PMmeluiz
06/12/2022, 8:17 PMSojo
06/12/2022, 10:35 PMHaus Of Alejandro
06/12/2022, 10:42 PMVillage
06/12/2022, 11:07 PMdeath_professor
06/13/2022, 12:46 AMnahtnam
06/13/2022, 2:47 AM.eq
method doesn't support joined tables. Could someone help me out? I'll include details in the threaddaviscup
06/13/2022, 3:12 AMpublicfiles
using this function:
const downloadFile = async (pathToFile) => {
const { data, error } = await supabase
.storage
.from('publicfiles')
.download(pathToFile)
if (error) throw error
return data
}
I logged out pathToFile
and the Url seems to be correct since I can view the image in my browser.
The error I'm getting is:
Uncaught (in promise)
{message: 'Access Denied', status: 400}
message: "Access Denied"
status: 400
[[Prototype]]: Object
My bucket is public and I'm using the standard Enable read access for all users
SELECT
policy for storage.objects. (public bucket itself has no policies)
Is there anything else I need to do?varnit
06/13/2022, 5:11 AMDembe
06/13/2022, 6:39 AMs c a p e g o a t
06/13/2022, 10:31 AMValidation failed (numeric string is expected)
I cannot do anything on my database right now because of this. Luckily there isn't a lot of tables and data yet but I have deleted a few tables three times and recreated them completely as a workaround.anonymouslizard
06/13/2022, 12:35 PMDembe
06/13/2022, 12:38 PMSilver.
06/13/2022, 1:14 PMrunning db migrations: Migrator: problem creating schema migrations: CREATE TABLE \"schema_migrations\" (\n\"version\" VARCHAR (14) NOT NULL\n);\nCREATE UNIQUE INDEX \"schema_migrations_version_idx\" ON \"schema_migrations\" (version);: ERROR: no schema has been selected to create in (SQLSTATE 3F000)
Does anyone have a clue to what I'm doing wrong?madsbuch
06/13/2022, 2:02 PMpocin
06/13/2022, 2:22 PMpsql
from CLI) and now i cant connect and my app hosted on the server is failing too.
Any way to unban my ip?Bicijay
06/13/2022, 4:47 PMHaus Of Alejandro
06/13/2022, 5:11 PMpedrodiaz
06/13/2022, 6:10 PMsunsetblvd
06/13/2022, 9:37 PMnahtnam
06/14/2022, 6:17 AMimages
which belongs to a snapshot
which belongs to a category
. (Snapshot is just an instance from when I scrape from the website). I want to find all images for a certain category by name.Haus Of Alejandro
06/14/2022, 9:38 AMantoninbeaufort
06/14/2022, 9:46 AMwillm
06/14/2022, 5:15 PMHaus Of Alejandro
06/14/2022, 6:38 PMwillm
06/14/2022, 6:39 PMfiles
that contains one file, private.txt
and a rule allowing select access for everyone. When I call supabase.storage.from('files').download('private.txt')
, there is no response data even though the response code is 200. Am I doing something wrong?DevThoughts
06/14/2022, 6:58 PMGitanes
06/14/2022, 7:04 PMevent.target[2].files[0]
to the api but I wonder if i'm not losing data js
// frontend code
saveTestimonial(evt) {
this.isFetching = true
const data = new FormData()
data.append('description', this.description)
data.append('identity', this.identity)
data.append('picture', evt.target[2].files[0])
console.log(evt.target[2].files[0])
fetch('/api/testimonials-add', {
method: 'POST',
body: data,
})
// --- API code
const imageFile = data.files.picture[0]
const imagePath = `public/${imageFile.originalFilename}`
supabase.storage
.from('test_images')
.upload(imagePath, imageFile)
.then(async (response) => {
await this.supabase.from('testimonials').insert({
description: data.fields.description[0],
name: data.fields.identity[0].split('/')[0].trim(),
occupation: data.fields.identity[0].split('/')[1].trim(),
picture:
'https://qroiybphgipjhkmfsvnj.supabase.co/storage/v1/object/public/' +
response.data.Key,
})
})