Thread: PostgreSQL overall design
Hi All,
Can anyone please tell/point me where I can get the postgresql system layout (I've an interest to contribute). I would also like to know the files involved for performing each task ( for eg when doing a select operation what is exactly happening in postgres along with the files).
I was wandering inside the source for a while and I couldn't get a start point to go with.
Need a clarification in copydir.c file of src/port directory, In the following snippet the destination directory is created first then the source directory is read. Suppose if I don't have permission to read the source, even then the destination directory would be created.
I just want to know whether there is any reason for doing so?
if (mkdir(todir, S_IRUSR | S_IWUSR | S_IXUSR) != 0)
ereport(ERROR,
(errcode_for_file_access(),
errmsg("could not create directory \"%s\": %m", todir)));
xldir = AllocateDir(fromdir);
if (xldir == NULL)
ereport(ERROR,
(errcode_for_file_access(),
errmsg("could not open directory \"%s\": %m", fromdir)));
--
with thanks & regards,
S.Gnanavel
Satyam Computer Services Ltd.
Can anyone please tell/point me where I can get the postgresql system layout (I've an interest to contribute). I would also like to know the files involved for performing each task ( for eg when doing a select operation what is exactly happening in postgres along with the files).
I was wandering inside the source for a while and I couldn't get a start point to go with.
Need a clarification in copydir.c file of src/port directory, In the following snippet the destination directory is created first then the source directory is read. Suppose if I don't have permission to read the source, even then the destination directory would be created.
I just want to know whether there is any reason for doing so?
if (mkdir(todir, S_IRUSR | S_IWUSR | S_IXUSR) != 0)
ereport(ERROR,
(errcode_for_file_access(),
errmsg("could not create directory \"%s\": %m", todir)));
xldir = AllocateDir(fromdir);
if (xldir == NULL)
ereport(ERROR,
(errcode_for_file_access(),
errmsg("could not open directory \"%s\": %m", fromdir)));
--
with thanks & regards,
S.Gnanavel
Satyam Computer Services Ltd.
On 9/27/05, Abhijit Menon-Sen <ams@toroid.org> wrote:
At 2005-09-27 15:20:05 +0530, s.gnanavel@gmail.com wrote:
>
> Can anyone please tell/point me where I can get the postgresql system
> layout (I've an interest to contribute).
http://www.postgresql.org/developer/coding
And, in particular:
http://www.postgresql.org/docs/faqs.FAQ_DEV.html
-- ams
Thanks. I'll go thru' the documentation.
--
with regards,
S.Gnanavel
Have you read the developers FAQ?
---------------------------------------------------------------------------
Gnanavel S wrote:
> Hi All,
>
> Can anyone please tell/point me where I can get the postgresql system layout
> (I've an interest to contribute). I would also like to know the files
> involved for performing each task ( for eg when doing a select operation
> what is exactly happening in postgres along with the files).
>
> I was wandering inside the source for a while and I couldn't get a start
> point to go with.
>
> Need a clarification in copydir.c file of src/port directory, In the
> following snippet the destination directory is created first then the source
> directory is read. Suppose if I don't have permission to read the source,
> even then the destination directory would be created.
> I just want to know whether there is any reason for doing so?
>
> if (mkdir(todir, S_IRUSR | S_IWUSR | S_IXUSR) != 0)
> ereport(ERROR,
> (errcode_for_file_access(),
> errmsg("could not create directory \"%s\": %m", todir)));
>
> xldir = AllocateDir(fromdir);
> if (xldir == NULL)
> ereport(ERROR,
> (errcode_for_file_access(),
> errmsg("could not open directory \"%s\": %m", fromdir)));
>
>
>
> --
> with thanks & regards,
> S.Gnanavel
> Satyam Computer Services Ltd.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
On 9/27/05, Bruce Momjian <pgman@candle.pha.pa.us> wrote:
Thanks Bruce. I'm going through that.
Have you read the developers FAQ?
Thanks Bruce. I'm going through that.
---------------------------------------------------------------------------
Gnanavel S wrote:
> Hi All,
>
> Can anyone please tell/point me where I can get the postgresql system layout
> (I've an interest to contribute). I would also like to know the files
> involved for performing each task ( for eg when doing a select operation
> what is exactly happening in postgres along with the files).
>
> I was wandering inside the source for a while and I couldn't get a start
> point to go with.
>
> Need a clarification in copydir.c file of src/port directory, In the
> following snippet the destination directory is created first then the source
> directory is read. Suppose if I don't have permission to read the source,
> even then the destination directory would be created.
> I just want to know whether there is any reason for doing so?
>
> if (mkdir(todir, S_IRUSR | S_IWUSR | S_IXUSR) != 0)
> ereport(ERROR,
> (errcode_for_file_access(),
> errmsg("could not create directory \"%s\": %m", todir)));
>
> xldir = AllocateDir(fromdir);
> if (xldir == NULL)
> ereport(ERROR,
> (errcode_for_file_access(),
> errmsg("could not open directory \"%s\": %m", fromdir)));
>
>
>
> --
> with thanks & regards,
> S.Gnanavel
> Satyam Computer Services Ltd.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
--
with regards,
S.Gnanavel