[GENERAL] Re: FreeBSD PostgreSQL7 port and v7.0.2

2000-06-08 Thread The Hermit Hacker
On Thu, 8 Jun 2000, John Daniels wrote: > Hi: > > Thanks, I check into that. I have assumed, from my own reading of the > release history, that: > > 1) 7.0.1 fixes some minor bugs, and > 2) 7.0.2 was released so quickly after 7.0.1 because some documentation was > left out as an

Re: [GENERAL] Postgresql

2000-06-08 Thread The Hermit Hacker
On Wed, 7 Jun 2000, Mihai Gheorghiu wrote: > The following is a quote from a consultant's opinion on my intention to > migrate to Postgresql. > Quote: > The use of Postgres is cautioned for mission critical data by the developers > of Postgres themselves. > Unquote. > Please comment. Maybe way b

Re: [GENERAL] Composite Types

2000-06-08 Thread Jan Wieck
Tom Lane wrote: > [EMAIL PROTECTED] writes: > > I appreciate any help I can get on this...Recently, I've been experimenting > > with the user defined base-types (using CREATE TYPE) with successful results. > > But, when it comes to handling classes as composite types, things are not > > as straigh

Re: [GENERAL] Re: [SQL] oracle rownum equivalent?

2000-06-08 Thread Cary O'Brien
> At 06:47 PM 6/7/00 -0400, Cary O'Brien wrote: > > > >> thanks for the response. oid is equivalent to oracle rowid. > > > >I think there is a fundamentel difference between oid and rownum. > >Oid is just a serial number. Rownum is a long string that tells > >oracle where exactly the row is.

Re: [GENERAL] Re: [SQL] oracle rownum equivalent?

2000-06-08 Thread mikeo
At 06:47 PM 6/7/00 -0400, Cary O'Brien wrote: > >> thanks for the response. oid is equivalent to oracle rowid. > >I think there is a fundamentel difference between oid and rownum. >Oid is just a serial number. Rownum is a long string that tells >oracle where exactly the row is. So *I think* r

Re: [GENERAL] existing but not-existing database.

2000-06-08 Thread Paulo Jan
> > psql todojamon > > FATAL 1: Database 'todojamon' does not exist. > We know this because the directory > '/usr/local/pgsql/data/base/todojamon' does not exist. > You can create a database with the SQL command CREATE > DATABASE. > To see what databases exi

[GENERAL] existing but not-existing database.

2000-06-08 Thread Marcos Lloret
hi, i created a database called todojamon. (i wanted to make up of an old database trying to copy the same directoy to ../base/todojamon as before). but it does not work. i deleted the directory. now i want to restart the procedure creating a new database called todojamon. but it answers >

Re: [GENERAL] Column types via ODBC interface

2000-06-08 Thread Matt Goodall
Tom Lane wrote: > > Matt Goodall <[EMAIL PROTECTED]> writes: > > f10 decimal(9,2) SQL_VARCHAR, 254 SQL_DECIMAL, 9 > > f11 numeric(9,2) SQL_VARCHAR, 254 SQL_DECIMAL, 9 > > The 6.5 ODBC driver doesn't know about type numeric, so it returns its > default assumption, which is varch

[GENERAL] dynamic database

2000-06-08 Thread jprem
hello, 1) can i create a dynamic database in postgresql 7.0 ? if so how many number of databases (maximum number of databases) a postgresql 7.0 installation support ? 2)can i restrict the size of a database while creating it ? later sometime can i change the same ? 3) can i restrict the sizeo