tempfile: command not found

[manchikr]

1. I am getting sh: tempfile: command not found
2. goes to vi and stays, I need to quit vi after that
3. it shows column and its type. instead of data

Please let me know how I can setup query for data. Thanks in advance

[dverite]

What is your operating system? In Debian for instance tempfile is provided by the debian-utils package.

Does it work if you replace tempfile with mktemp ?

[manchikr]

Hi Daniel,

Thanks for quick response.

I am on MacOS, either mktemp did not work

Thank you, Ramesh CDK Global | Platform Services

From: Daniel Vérité @.> Date: Thursday, November 17, 2022 at 3:30 PM To: dverite/postgresql-functions @.> Cc: Manchikanti, Ramesh @.>, Author @.> Subject: [EXTERNAL] Re: [dverite/postgresql-functions] tempfile: command not found (Issue #3)

Caution: External email - Please use caution opening links and attachments from external senders

What is your operating system? In Debian for instance tempfile is provided by the debian-utils package.

Does it work if you replace tempfile with mktemp ?

— Reply to this email directly, view it on GitHubhttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_dverite_postgresql-2Dfunctions_issues_3-23issuecomment-2D1319345933&d=DwMCaQ&c=N13-TaG7c-EYAiUNohBk74oLRjUiBTwVm-KSnr4bPSc&r=gat_5hFVIh1Yae_3azixp5zx9VrbFvRQaV4Dccv6b4I&m=rRExva0NK2hyygh5mqe0aiaEvOum3mJFHBcSZfm7hRxe9Qw-pT1qBxI9hfSEl6nG&s=b-lIiNowXTbFPLokGjvQ13PN8SBe7SgxQFptpFDXy5Y&e=, or unsubscribehttps://urldefense.proofpoint.com/v2/url?u=https-3A__github.com_notifications_unsubscribe-2Dauth_A3CGIUGXRI6RWVKE7DALMH3WI25ZBANCNFSM6AAAAAASD44IRE&d=DwMCaQ&c=N13-TaG7c-EYAiUNohBk74oLRjUiBTwVm-KSnr4bPSc&r=gat_5hFVIh1Yae_3azixp5zx9VrbFvRQaV4Dccv6b4I&m=rRExva0NK2hyygh5mqe0aiaEvOum3mJFHBcSZfm7hRxe9Qw-pT1qBxI9hfSEl6nG&s=-pifonurp4niC2C9M0XdAs2hYLr5-C9NohDHBy8yPqE&e=. You are receiving this because you authored the thread.Message ID: @.***>

[dverite]

I'm afraid I don't have access to a MacOS machine to test, but it looks like mktemp does exist there, since people online are discussing how it differs from some other Unix systems, but not that it doesn't exist. For instance https://unix.stackexchange.com/questions/555058/mktemp-on-macos-not-honouring-tmpdir

[dverite]

Committed the tempfile->mktemp substitution (4440fdaf2)