My question about the transaction

the single-statement also be treated as a simple transaction), but why the update works?(I think terminal 1 will block until the terminal 2's transaction commit or rollback). Can someone share you opinion to me? Thanks in advance! Yours, Wen Yi

[Beginner Question]What should I do if I want to achieve lsm-tree index in postgresql?

thub.com/HypoPG/hypopg'? Or directly change the kernel? Can someone give me some advice? Thanks in advance! Yours, Wen Yi

Re: A Good Beginner's Book

I think the postgresql's document is the best place to learn. Yours, Wen Yi ---Original--- From: "Amn Ojee Uw"

Re:How to solve the warning?

Hi, I check the image you send, I think you pass on a incompatible pointer: The PostgreSQL want you to pass on a 'List*' but you give a  'Node*'. And please send plain text next time, the PostgreSQL community archieve always just store the patch & pla

[Question] Can someone provide the explain of the relation between PGPROC and transaction?

dvance! Yours, Wen Yi.

Re:How to build a new grammer for pg?

If you want to add some new function to postgresql, just check this ducument: https://www.postgresql.org/docs/current/extend-how.html -- Original -- From:

Re: Upgrading

You can see this document. https://www.postgresql.org/docs/current/pgupgrade.html Yours, Wen Yi ---Original--- From: "Amn Ojee Uw"

[Question]Can someone explain the context_freelists?

view? Thanks in advance! Yours, Wen Yi

logging_collector is off, but the logging is opening

. Can someone give me some advice? Thanks in advance! Yours, Wen Yi

[Beginner Question]Is there way to test the postgres's kernel function?

me some advice? Thanks in advance! Yours, Wen Yi.

\d don't print all the tables

le on namespace_a & namespace_b, not just public, it really confused me. Can someone give me some advice? Yours, Wen Yi.

Re: Reset Postgresql users password

I think maybe you can check the pg_hba.conf, change the method to the 'trust'. (Allow the connection unconditionally. This method allows anyone that can connect to the PostgreSQL database server to login as any PostgreSQL user they wish, without the need for a password or any other authentication

[Beginner Question]What is query jumbling?

word 'query jumbling'. Can someone provide me some advice? Thanks in advance! Yours, Wen Yi

[Beginner Question] Will the vxid replace xid?

Hi community, When I read the newest document, I find there seems to be a new concept "vxid", and It's 64 bit. Is there a plan to replace xid? Or just my careless? Can someone give me some advice? Thanks in advance! Yours, Wen Yi

[Beginner Question]What's the use of ResTarget?

lause, like INSERT, far from what I imagined. So what's the use of ResTarget? Can someone give me some advice? Thanks in advance! Yours, Wen Yi

Re: [Beginner Question] How to print the call link graph?

OK, that helps me a lot. I just want to get the trace of function call. Thanks very much! Yours, Wen Yi

[Beginner Question] How to print the call link graph?

print the function name and code line I want to it print like this: ... -> pq_getbyte () at pqcomm.c:980 -> SocketBackend (inBuf=0x7ffc8f7e1310) at postgres.c:372 -> ... Can someone provide me some advice? Thanks in advance! Yours, Wen Yi

A question about the postgres's website

Hi community, When I check the postgres's website, I find something confused: https://www.postgresql.org/community/ (Quick Links: Don't see the slack item) https://www.postgresql.org/list/ (Quick Links: See the slack item) Can someone give me some advice? Thanks in advance! Yours, Wen Yi

Re: Why can't lseek the STDIN_FILENO?

OK, I see, I'm so sorry for my action. I will ask in cpplang slack community in the future. And really thanks for your advice. Your, Wen Yi -- Original --

Why can't lseek the STDIN_FILENO?

Hi community, I am testing the lseek & write & read, and I write the code like this: /*     lseek_test.c    Test the lseek     Wen Yi */ #include

[Beginner Question]How to let the lex && yacc parsing the string? Instead of the console.

want_to_analyse) {   yacc_init = lex_analyse(string_want_to_analyse);   yacc_analyse(yacc_init); }  Can someone provide me some advice? Yours, Wen Yi

Re: Is there a way make the lex program match multiple line?

I rewrite, and I think the [']([^']|\n)['] should be [']([^']|\n)+['] Thanks very much! Yours, Wen Yi.   -- Original -- From:

Is there a way make the lex program match multiple line?

Hi community, I am making a config program, use the lex program to analyse input. /*     config.l    The lex rule file for toysql     Wen Yi */ %option noyywrap %{ #include

[Beginner Question] Will the backup wal file take too much storage space?

the backup wal file take too much storage space? Thanks in advance! Yours, Wen Yi

Re: How to trace the postgres?

That's works, Thanks very much! Yours, Wen Yi   -- Original -- From: "Junwang Zhao"

How to trace the postgres?

imization, and from optimization to execution). Can someone give me some advice? Thanks in advance! Yours, Wen Yi

Re: What is gcda file?

OK, I see. Thanks very much! Yours, Wen Yi -- Original -- From: "David G. Joh

What is gcda file?

not create directory profiling:/home/beginnerc/work/project/postgresql-15.3/src/interfaces/libpq/fe-connect.gcda:Skip profiling:/home/beginnerc/work:Cannot create directory profiling:/home/beginnerc/work/project/postgresql-15.3/src/interfaces/libpq/fe-auth-scram.gcda:Skip _mcleanup: gmon.out: ???? Yours, Wen Yi

Re: initdb can't init the database

OK. I find where the problem is, thanks very much! Yours, Wen Yi -- Original -- From: "Ian Lawrence Barwick"

initdb can't init the database

Hi team, I use the source to install the postgresql 15.3 (Fedora Linux 37), I create a install.sh as this: install.sh: sudo rm -r /home/postgres/pgsql sudo mkdir /home/postgres/pgsql  sudo rm -r /home/postgres/pgsql/lib sudo mkdir /home/postgres/pgsql/lib ./configure --prefix=/home/postg

Why lex & yacc think this is a syntax error?

h a yacc & lex rule file: /*     config.y    The yacc rule file to analyse the config string     Wen Yi */ %{ #include

[Question]What will happen if the server active close the connection?

s, the following step is, the client will write some data(send some data) to the server and then cause the signal SIGNALPIPE. But what will happen if the client died?(Example: was killed by the user) Can someone provide some advice? Thanks in advance! Yours, Wen Yi

Re: "pgsql-zh-general" can't send chinese mail.

Sorry, it's all my fault, I use error mail-box settings. Yours, Wen Yi   -- Original -- From: "postgr

"pgsql-zh-general" can't send chinese mail.

Hi team, I want to use the list "pgsql-zh-general" to communicate with chinese user. But it can't send chinese mail,  because he recognizes all Chinese emails as spam. Can someone provide some solution? Thanks in advance! Yours, Wen Yi

Re: Can't send mail to `pgsql-zh-gene...@lists.postgresql.org`

Sure, I subscribe it, and let it send me a test mail. Yours, Wen Yi -- Original -- From: "Adrian K

Can't send mail to `pgsql-zh-gene...@lists.postgresql.org`

someone provide some advice? Thanks in advance! Yours, Wen Yi

[Beginner Question]A question about yacc & lex

Hi team, now I'm learning the yacc & lex to understand the principle of the postgres's parser. And I write a test program as this: /*     array.l    Array program     Wen Yi */ %option noyywrap %option noinput %{ #include

Is there a bug in psql? (SELECT ''';)

ntrol-D to quit. postgres'# \q Use control-D to quit. postgres'# \q bash-5.1$ And I do another test postgres=# SELECT '''; postgres'# exit Use control-D to quit. postgres'# \q Use control-D to quit. postgres'# \q bash-5.1$ Is there a bug in psql? Yours, Wen Yi

Where I can find the achieve of the 'generate_series' ?

Hi team, I want to figure out the principle of the function 'generate_series', but I don't know it contains in which source file.(I download the pgsql 15.3 source code) Can someone provide some advice? Thanks in advance! Yours, Wen Yi

How to make the generate_series to generate the letter series?

a better solution? Thanks in advance! Yours, Wen Yi

Re: A question about generate_series

Oh, I change my terminal settings (gnome-terminal), it works, thanks very much! Yours, Wen Yi   BeginnerC 896634...@qq.com  

[Beginner question]How to solve multiple definition of `yylval'?

Hi team, I am studying on the yacc & lex to help me understand the parser of the postgres, but now I'm facing some trouble. --- /*   1-3.y */ %{ #include int yylex(); int yyerror(char *s); typedef char* string; #define YYSTPYE string %} %token NUMBER %token ADD SUB MUL DIV A

What type of Compiler to SQL? Memory-Image (Load-and-Go) Format?

Hi team, I am a newbie to the postgres. When I am studying the compiler,the text book tell me there is there type of compiler. 1. Assembly Language Format 2. Relocatable Binary Format 3. Memory-Image (Load-and-Go) Format I check the postgres's sql compiler, and it's achieved by lex & ya

Can one user login in multile machine?

Hi team, can I use same user's information login in multile machines when connect to the postgres? Thanks in advance! Yours, Wen Yi.

Why not use the calloc to replace malloc?

HI team, I'm a newbie to the postgres. When I learn the code of libpq, the achieve of PQmakeEmptyPGresult, cause my curiosity. The old version code: PQmakeEmptyPGresult(PGconn *conn, ExecStatusType status) {   PGresult *result;   result = (PGresult *) malloc(sizeof(PGresult));   

Where to find the Makefile.global?

Hi team, I'm a newbie to the postgres and I want to learn the principle of libpq. When I read the makefile,I can't find the '/src/Makefile.global' Can someone provide a suggestion? Yours, WenYI.

[Beginner Question]How can I use the yacc & lex in right way?

Hello the team: I'm now learning the yacc & lex and want to write a simple SQL parser, Here's part of my code %option noyywrap %option bison-bridge %option reentrant ... enum { UNDEFINED = 1, CREATE, TABLE, UPDATE, SET, INSERT, INTO, VALUES, DELETE, FROM,

[BeginnerQuestion]Why the postgres_fe.h not found?

Hello everyone, I want to study the source of the postgres, but now I faced some problem: (The lsp server can't find the postgres_fe.h) [cid:f46601f4-aa60-4ee4-8776-c1d744c9e4a9] [image.png]

[Beginner Question]How to generate a call-graph for project?

Hi teams, I am a student who are interested in database,and now I want to generate a call-graph for this database that can help me to understand the structure.(The project is written in cpp,not only c) I haved tried the doxygen,but the information that generates is very incomplete(Even if I open

[BeginnerQuestion]Why I compile lex.yy.c failed?

Hi community, I am a beginner who are interested in database,when I do my study on the lex and yacc,I write a example.l like this: %% .\|n ECHO %% and then I generate a lex.yy.c use lex but when I compile this file,something wrong happend: [beginnerc@bogon temp]$ flex '/home/beginnerc/work/tem

Re: [Beginner Question]Where can I get the source of hstore?

Thank you very much! Yours, BeginnerC 获取Outlook for Android<https://aka.ms/AAb9ysg> From: Tom Lane Sent: Sunday, September 11, 2022 10:44:37 AM To: Wen Yi Cc: pgsql-general Subject: Re: [Beginner Question]Where can I get the source of hstore? Wen Yi

[Beginner Question]Where can I get the source of hstore?

Hi community, I want to do some research on the hstore,but I can't find its source. (My postgres distribution doesn't come with this extension) I have looked it up in github,but gained nothing. Can anyone provide me a copy of its code?Or just give a link to me? Thanks in advance! Yours, BeginnerC.

Beginner Question:Why it always make sure that the postgres better than common csv file storage in disaster recovery?

I am a student who are interesting in database kernel.When I am reviewing my database course,a question make me confused. In file system,if a error happen when I insert some data into data saving system,the whole data exists will be broken and can't recovery anymore. But when I check the cod

A error happend when I am clone the git repository

When I reinstall my system,I clone the postgresql repository,but there's something wrong. The console print as these: [beginnerc@fedora Research]$ git clone https://git.postgresql.org/git/postgresql.git Cloning into 'postgresql'... remote: Enumerating objects: 30747, done. remote: Counting objec

Simple question from a beginner: Can I use PostgreSQL as a file database?

Hi everyone! I'm a middle student and new to join this mail list. I just want to ask a simple question: Can I use PostgreSQL as a file database? (I plan to make a web system to store my class note with some personal file) Please give me some suggestions,thank you in advance!