diff options
author | Andreas Baumann <abaumann@yahoo.com> | 2012-05-06 12:51:36 +0200 |
---|---|---|
committer | Andreas Baumann <abaumann@yahoo.com> | 2012-05-06 12:51:36 +0200 |
commit | bc26616b1af435f7c7509ff3f5b70bc3991015b2 (patch) | |
tree | 11fd917530d860b3e59bc5d2075729a90f464a72 /schema.sql | |
parent | b80d19d023149d81fc80ff873d96cf14617db06d (diff) | |
download | pgfuse-bc26616b1af435f7c7509ff3f5b70bc3991015b2.tar.gz pgfuse-bc26616b1af435f7c7509ff3f5b70bc3991015b2.tar.bz2 |
added mount option blocksize, can be set when creating the filsystem
(first write), schema.sql doesn't contain block size information anymore
Diffstat (limited to 'schema.sql')
-rw-r--r-- | schema.sql | 9 |
1 files changed, 1 insertions, 8 deletions
@@ -18,7 +18,7 @@ CREATE TABLE dir ( CREATE TABLE data ( dir_id BIGINT, block_no BIGINT NOT NULL DEFAULT 0, - data BYTEA NOT NULL DEFAULT repeat(E'\\000',4096)::bytea, + data BYTEA, PRIMARY KEY( dir_id, block_no ), FOREIGN KEY( dir_id ) REFERENCES dir( id ) ); @@ -35,13 +35,6 @@ CREATE INDEX dir_parent_id_idx ON dir( parent_id ); -- TODO: should be created by the program after checking the OS -- it is running on (for full POSIX compatibility) --- make sure 'dir' entries always get a first block in the 'data' --- table -CREATE OR REPLACE RULE "dir_insert" AS ON - INSERT TO dir WHERE NEW.mode & 16384 = 0 - DO ALSO INSERT INTO data( dir_id ) - VALUES ( currval( 'dir_id_seq' ) ); - -- garbage collect deleted file entries, delete all blocks in 'data' CREATE OR REPLACE RULE "dir_remove" AS ON DELETE TO dir WHERE OLD.mode & 16384 = 0 |