Re: Win32 testing needed - 1 Tablespaces

[email protected]
Newsgroups gmane.comp.db.postgresql.devel.win32
Message-ID <[email protected]>
Well, the only suitable punishment seemed to be to apply the patch and check it
out :-)

Looks good :

benchw=# create tablespace big1 location 'c:/databases/pgtablespaces/big1';
CREATE TABLESPACE
benche=# CREATE TABLE dim0 (
        d0key                          INTEGER NOT NULL,
        ddate                          DATE NOT NULL,
        dyr                            INTEGER NOT NULL,
        dmth                           INTEGER NOT NULL,
        dday                           INTEGER NOT NULL
) TABLESPACE big1;
CREATE
benchw=# COPY dim0 FROM 'c:/databases/dim0.dat'
USING DELIMITERS ',';
COPY

benchw=# analyze verbose dim0;
INFO:  analyzing "public.dim0"
INFO:  "dim0": scanned 74 of 74 pages, containing 10000 live rows and 0 dead row
s; 3000 rows in sample, 10000 estimated total rows
ANALYZE


regards

Mark

Quoting Bruce Momjian <[email protected]>:
>
> We have a symlink patch to make it work but it isn't in CVS yet.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [email protected] so that your
      message can get through to the mailing list cleanly
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.