Lincoln Yeoh <[EMAIL PROTECTED]> writes:
> At 10:53 AM 05-06-2000 +0200, Marcin Inkielman wrote:
>> drop index oceny_stud_numer_albumu_protokoloceny_stud;
>> failed
>> so I used:
>> drop index "oceny_stud_numer_albumu_protokoloceny_stud";
>> and it worked for me 8-)))
> I wonder why it worked
On Wed, 7 Jun 2000, Bruce Momjian wrote:
> [ Charset ISO-8859-1 unsupported, converting... ]
> > 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 Po
Trurl McByte <[EMAIL PROTECTED]> writes:
> Error in dumpig defaults on serial type!
> If table name have non-statndart name (example: "Order")
> sequenser auto created with name "Order_id_seq".
> In the dump filed definition is:
> ...
> "id" int4 DEFAULT nextval ( 'Order_id_seq' ) NOT NULL,
> ...
Patrick Welche wrote:
> On Tue, Jun 06, 2000 at 06:42:08PM +0200, Jurgen Defurne wrote:
> > A 'tuple' is an element of a set. A set is also called a table. When you do N
> > insertions on a table, then you get a table/set of N tuples. When you
> > query a table/set, then your result is also a set
Travis Bauer <[EMAIL PROTECTED]> writes:
> I'm trying to get the tree from the cvs:
> cvs -d :pserver:[EMAIL PROTECTED]:/usr/local/cvsroot login
It's /home/projects/pgsql/cvsroot now.
I notice http://www.postgresql.org/docs/postgres/cvs28436.htm
still has the old location :-( ... that needs to b
Mihai Gheorghiu <[EMAIL PROTECTED]> writes:
>>> I wanted to back up a database prior to upgrading to 7.0.2
>>> pg_dump dbname > dbname.bak
>>> FATAL 1: Memory exhausted in AllocSetAlloc()
>>> PQendcopy: resetting connection
>>> SQL query to dump the contents of Table 'tblname' did not execute
>>>
Tom,
Thanks for your feedback and insight. Consider this: Wouldn't it be
fantastically powerful and also type-behavior-consistent if user-defined
composite types (using CREATE TABLE) behave somewhat similar to base types
defined by CREATE TYPE? Again, going back to the earlier example,
the compos
On Wed, 7 Jun 2000, Tom Lane wrote:
> Travis Bauer <[EMAIL PROTECTED]> writes:
> > I'm trying to get the tree from the cvs:
> > cvs -d :pserver:[EMAIL PROTECTED]:/usr/local/cvsroot login
>
> It's /home/projects/pgsql/cvsroot now.
>
> I notice http://www.postgresql.org/docs/postgres/cvs28436.htm
Installed PostgreSQL 7.0 on FreeBSD 4.0, went
prefectly.
Installed PostgreSQL ODBC Driver/manager on NT Workstation
4.0, went perfectly.
Tried to establish a connection between ODBC and FreeBSD, the
driver says
the connection can not be established.
Does there need to be a port entry i
On Wed, 7 Jun 2000 (Yesterday), Tom Lane wrote:
TL> Trurl McByte <[EMAIL PROTECTED]> writes:
TL> > Error in dumpig defaults on serial type!
TL> > If table name have non-statndart name (example: "Order")
TL> > sequenser auto created with name "Order_id_seq".
TL> > In the dump filed defin
I agree Bruce!
Sounds like a quote from an Oracle or SQL Server sales rep/consultant to me!
Postgres is fantastic!
Thanks to the team and keep up the great work!
Regards,
Jim
At 15:57 6/7/2000 -0400, you wrote:
>[ Charset ISO-8859-1 unsupported, converting... ]
>> The following is a quote fr
mikeo wrote:
>
> thanks for the response. oid is equivalent to oracle rowid.
> rownum can be used similar to the limit option of select in postgres
> but in oracle it can also be used in a where clause, or as an assigment
> in an update statement for instance.
>
> eg: update ctmaster set bsc_id
I have been told by the publisher that most changes to the book must be
done by next week.
The book is at:
http://www.postgresql.org/docs/awbook.html
Again, many thanks to those that have supplied suggestions for the book.
--
Bruce Momjian| http://www.op.net
Mihai Gheorghiu <[EMAIL PROTECTED]> writes:
> pg_dump... outputs nothing!? I did it with -f filename too, and the file is
> empty.
> Size of the file in question: 5MB, 7062 rows. Name of table:
> tblReservations.
Mixed case huh? It's a little tricky to get pg_dump's -t switch to work
with that;
> 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* rownum can be
used for fast lookups, where oid, unles
Steve Wampler <[EMAIL PROTECTED]> writes:
> PostgreSQL 6.5.3
>
> appdb=> create function insert_or_update() returns opaque as '
> appdb'> begin
> appdb'> insert into attributes_table values(new.id,new.name,
> appdb'>new.units,new.value);
> appdb'> return NULL;
> appdb
Marcos Lloret <[EMAIL PROTECTED]> writes:
> i want to make us of an old recovered database from a dead hard
> disk. i just copied the directory
> /usr/local/pgsl/data/base/[database-name]
> i install postgres 6..4 (as before) and i created a new database
> directory and copied all the data
Hello,
I'm still looking for a php_pgsql.dll file for PHP4/win9x. Currently working with
PG 6.5.3, but probably 7.0.x soon. Does anybody out there have one I can get a copy
of?
Please reply directly, since I doubt many people on these lists care :)
Thanks,
John
--
/* SteeleSoft Consul
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 varchar as above. The 7.0 version k
excuse me but I have been attempting to drop my subscription ti this list
How does one get off of this list?
Jim Jennis wrote:
> I agree Bruce!
>
> Sounds like a quote from an Oracle or SQL Server sales rep/consultant to me!
>
> Postgres is fantastic!
>
> Thanks to the team and keep up the grea
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Ed Loehr
>
> mikeo wrote:
> >
> > thanks for the response. oid is equivalent to oracle rowid.
IMHO,tid is equivalent to Oracle's rowid.
> > rownum can be used similar to the limit option of select in
21 matches
Mail list logo
