On Mon, 9 Dec 2019 at 23:35, Julien Delplanque
wrote:
> Hello PostgreSQL hackers,
>
> I hope I am posting on the right mailing-list.
>
> I am actually doing a PhD related to relational databases and software
> engineering.
>
> I use PostgreSQL for my research.
>
> I have a few questions about the
On Tue, 10 Dec 2019 at 01:21, Tom Lane wrote:
> Mark Dilger writes:
> > [ useful tips about finding the code that implements a SQL command ]
>
> BTW, if it wasn't obvious already, you *really* want to have some kind
> of tool that easily finds the definition of a particular C symbol.
> You can f
Thanks for your answer, I will dive into the C code then.
Le 9/12/19 à 16:52, Mark Dilger a écrit :
Not all of them are real tables; some of the pg_catalog relations are
views over others of them. But many of them are real tables with C
structs that back them. Take a look in src/include/catal
Mark Dilger writes:
> [ useful tips about finding the code that implements a SQL command ]
BTW, if it wasn't obvious already, you *really* want to have some kind
of tool that easily finds the definition of a particular C symbol.
You can fall back on "grep -r" or "git grep", but lots of people use
On 12/9/19 7:52 AM, Mark Dilger wrote:
Q1.1 If it is possible, is what is done in reality? I have the feeling
that it is not the case and that DDL queries are implemented in C
directly.
See src/backend/commands/tablecmds.c, function DefineRelation.
I realize I could be a bit more helpfu
Julien Delplanque writes:
> I have a few questions about the internals of PostgreSQL and I think they
> require experts knowledge.
> Q1. Are PostgreSQL's meta-description tables (such as pg_class) the "reality"
> concerning the state of the DB or are they just a virtual representation ?
The sy
Hi Julien!
On 09/12/2019 17:35, Julien Delplanque wrote:
Q1. Are PostgreSQL's meta-description tables (such as pg_class) the "reality"
concerning the state of the DB or are they just a virtual representation ?
Yes, the catalog tables are the authoritative source. The system uses
those tables
On 12/9/19 7:35 AM, Julien Delplanque wrote:
Hello PostgreSQL hackers,
I hope I am posting on the right mailing-list.
I am actually doing a PhD related to relational databases and software
engineering.
I use PostgreSQL for my research.
I have a few questions about the internals of Postgr
