src / test / regress / sql / triggers.sql first 10 lines.

Started by aliasover 3 years ago2 messages
#1alias
postgres.rocks@gmail.com

1
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l1&gt;
--
2
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l2&gt;
-- TRIGGERS
3
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l3&gt;
--
4
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l4&gt;
5
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l5&gt;
-- directory paths and dlsuffix are passed to us in environment variables
6
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l6&gt;
\getenv libdir PG_LIBDIR
7
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l7&gt;
\getenv dlsuffix PG_DLSUFFIX
8
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l8&gt;
9
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l9&gt;
\set autoinclib :libdir '/autoinc' :dlsuffix
10
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c#l10&gt;
\set refintlib :libdir '/refint' :dlsuffix

git.postgresql.org Git - postgresql.git/blob -
src/test/regress/sql/triggers.sql
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob;f=src/test/regress/sql/triggers.sql;h=83cd00f54f0f45ffc73e7ffc3f02506f346cfcdd;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c&gt;

I want to play around with src
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c&gt;
/ test
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src/test;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c&gt;
/ regress
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src/test/regress;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c&gt;
/ sql
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=tree;f=src/test/regress/sql;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c&gt;
/ triggers.sql
<https://git.postgresql.org/gitweb/?p=postgresql.git;a=blob_plain;f=src/test/regress/sql/triggers.sql;hb=7103ebb7aae8ab8076b7e85f335ceb8fe799097c&gt;
Now I am not sure what the first 10 lines mean.
Should I just copy these 10 lines in the terminal and not worry about it?
Or to get the same result as triggers.out,
I need to properly understand these 10 lines first.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: alias (#1)
Re: src / test / regress / sql / triggers.sql first 10 lines.

alias <postgres.rocks@gmail.com> writes:

Now I am not sure what the first 10 lines mean.

Those are computing the file pathnames of regress.so and a couple of
other .so files that contain the C functions referred to in the
CREATE commands just below here. We can't just hard-wire those file
names into the script; they have to be computed at run-time because
everybody's paths will be different.

regards, tom lane