Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
COMP9315
Assignment
Frequently Asked Questions
DBMS Implementation
Last updated: Sunday 10th March 419pm
Most recent changes are shown in red ... older changes are shown in brown.
Frequently Asked Questions
The Forum has a search function, but nobody seems to use it, so here are answers to often-asked
questions that people would have found if they'd searched for them:
I get messages about UTF8 and locale when I run initdb
Run it using the command: initdb --no-locale --encoding=UTF8
I get told that pgxs is missing when ting to compile
You most likely have an old installation of PostgreSQL (e.g. from COMP9311) in your
/localstorage/$USER/ directo. Remove it and install again.
$ cd /localstorage/$USER
$ rm -fr pgsql
$ cd postgresql-15.6
$ make install
Then follow the rest of the installation instructions from P01.
I get told that postgres.h is not found when ting to compile assignment code.
Add the following line to your env le:
C_INCLUDE_PATH=/localstorage/$USER/postgresql-15.6/src/include/
and then source it again.
Which titles (e.g. Dr, Mr, Ms, ...) do I have to check for?
None. Simply use the grammar to check for validity of names. Any title you can think of looks like
a valid name. Treat it as such.
My code recognises valid and invalid names (sanity tests), but crashes the seer as soon as I
t to store and retrieve tuples containing names.
My PersonName data structure looks like:
typedef struct PersonName {
char *family;
char *given;
} PersonName;
Go and look at the Week 04 Thursday lecture notes again to see why this is wrong and to get
some hints on how to do it properly.
I can't seem to get the system to use the hash index. It always uses a sequential scan rather
than a "Bitmap Heap Scan".
You need to give additional information for the que optimiser when you dene the equality
operator:
restrict = eqsel, HASHES
I get error messages about compressed data (e.g. lz4).
I'm still ting to work out what causes this ...