Tue, Jun 06, 2000 at 03:24:56PM -0300, The Hermit Hacker ÐÉÛÅÔ:
On Tue, 6 Jun 2000, Eugene Karpachov wrote:
Excuse me, but why postgresql team doesn't release patches? I mean something
like postgresql-7.0-7.0.1.diff.gz etc. It is big waste of traffic to download
all the source
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 tho. How
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 Postgres
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,
...
, but
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. This
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 be
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
correctly.
Hmm,
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
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
still
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 in
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 definition is:
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 from
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|
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; I
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,
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' end;'
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 database.
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
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
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 great
-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 postgres
22 matches
Mail list logo