[GENERAL] [Fwd: Maximum filesize of one file]

1999-08-15 Thread CN Liu
> I have a 40 million record database (about 40GB and growing) and I > notice that some of my multicolumn indices are beginning to approach > 2GB on disk. > > Will there be any problems spanning the 32 bit limit here (a la tables > in version 6.4)? Please refer to the attached messages from [EMA

[GENERAL] Are there any limits on index size?

1999-08-15 Thread Martin Weinberg
Folks, I have a 40 million record database (about 40GB and growing) and I notice that some of my multicolumn indices are beginning to approach 2GB on disk. Will there be any problems spanning the 32 bit limit here (a la tables in version 6.4)? Thanks! --Martin ===

Re: [GENERAL] User not in pg_shadow

1999-08-15 Thread Oliver Elphick
"Duncan Kinder" wrote: >I have installed postgresql 6.5.1 on a Redhat Linux 5.2 box. > >As "postgres" I am able to create a database. > >However, when I type the command "createdb whatever" as dckinder, I receive >the following response: > >"Connection to database 'templete1' faile

Re: [GENERAL] User not in pg_shadow

1999-08-15 Thread Herbert Liechti
Duncan Kinder wrote: > I have installed postgresql 6.5.1 on a Redhat Linux 5.2 box. > > As "postgres" I am able to create a database. > > However, when I type the command "createdb whatever" as dckinder, I receive > the following response: > > "Connection to database 'templete1' failed > FATAL 1:

Re: [GENERAL] User not in pg_shadow

1999-08-15 Thread Charles Tassell
As the postgres user run the program "createuser" It will ask fro a username (dckinder) and some other things, including whether the user can create a database. You can do the same thing by connecting to template1 with psql and using the CREATE USER command. (do \h CREATE USER from within psql)

Re: [GENERAL] Autoincremental

1999-08-15 Thread Charles Tassell
Yes, it's called "serial" IE: create table my table ( ndx serial, nametext ); "serial" is just a shortcut that creates a "sequence" (a type that is basically a counter) an sets the ndx field to be an int default nextval('sequence_name') Read the FAQ for a better explan

[GENERAL] Autoincremental

1999-08-15 Thread Matteo Colombo
Pgsql support autoincremental field like mysql ? Thanks

[GENERAL] User not in pg_shadow

1999-08-15 Thread Duncan Kinder
I have installed postgresql 6.5.1 on a Redhat Linux 5.2 box. As "postgres" I am able to create a database. However, when I type the command "createdb whatever" as dckinder, I receive the following response: "Connection to database 'templete1' failed FATAL 1: SetUserId: user 'dckinder' is not in

[GENERAL] Regression issues

1999-08-15 Thread Duncan Kinder
When I run regression tests on Postgres 6.5.1 installed on Redhat 5.2 I get the following results: geometry, tinterval, and abstime fail. Numeric hangs; it gives no result. There is some problem regarding the date, Sat Aug 15 10:17:28 2020 The expected vs. actual results are: *** expect

Re: [GENERAL] storing a tree-like structure and selecting pathfrom leaf to root

1999-08-15 Thread Herouth Maoz
At 09:44 +0300 on 15/08/1999, Jan Vicherek wrote: > Q1: What is a good way to store this tree in ? (This is somewhat generic > question, so it may be a good FAQ candidate.) I want SELECTs to be fast, > and INSERTs/UPDATEs I don't care. Would making custom datatype help ? How? About a year and