Re:How can udf c function return table, not the rows?

2024-07-19 Thread Wen Yi
You're right, thanks! Wen Yi wen...@qq.com ---Original--- From: "David G. Johnston"

How can udf c function return table, not the rows?

2024-07-19 Thread Wen Yi
Hi hackers, I am trying to design a new "pg_get_functiondef" function extension, like this: CREATE FUNCTION pg_get_functiondef(OID, VARIADIC OID[]) RETURNS TABLE (OID oid, pg_get_functiondef text) AS 'pg_get_functiondef', 'pg_get_functiondef_mul' LANGUAGE C; And I have read the

Re: Things I don't like about \du's "Attributes" column

2024-04-15 Thread Wen Yi
+| | | | | Replication+| | | | | Bypass RLS | | | (3 rows) And I submit my the patch, have a look? Yours, Wen Yi -- Original -- From

Re: Things I don't like about \du's "Attributes" column

2024-04-14 Thread Wen Yi
I think the output need to change, like this: postgres=# \du+ List of roles Role name | Login | Attributes | Password | Valid until | Connection limit | Description ---+---+-+--+-+--+

[May be a bug] double free or corruption

2023-07-26 Thread Wen Yi
- 2023-07-26 22:16:17.489 CST [83554] LOG:  database system is ready to accept connections [postgres@fedora postgres]$ psql psql (17devel) Type "help" for help. postgres=# \q [postgres@fedora postgres]$ ---------- Can someone notice this problem? Thanks in advance Yours, Wen Yi

Re: [PATCH]Add a tip to the check mode

2023-07-12 Thread Wen Yi
postgres --check -D /home/beginnerc/pgsql/data [beginnerc@bogon devel]$ [beginnerc@bogon devel]$ echo $? 0 That's confused me, until I print the return value. So I think we should add this tip. I fix and recommit the patch, thanks very much for your reply. Yours, Wen Yi

[PATCH]Add a tip to the check mode

2023-07-11 Thread Wen Yi
   SetProcessingMode(NormalProcessing);    CheckerModeMain();    abort();     } Instead of if (check_only)     {    SetProcessingMode(NormalProcessing);    CheckerModeMain();     printf("PostgreSQL check success, there's no problem\n");    abort();     }

[Question] Can someone provide some links related to the MemoryContext?

2023-07-11 Thread Wen Yi
Hi hackers, I am learning the MemoryContext subsystem,  but I really don't know where to find it's document (The PostgreSQL Document just provide some spi function). Can someone provide me some solutions? Thanks in advance! Yours, Wen Yi