I downloaded it. The directories are two characters in length, the
files are numbers, and it is a mixture of C++, Python, and Pascal. Need
I say more. :-)
Yes!
You, or better someone who knows SAP DB could tell if it's probably the most
complete free database system available right now,
Thanks for the fixes. I have committed your patches and they should
appear in 7.1.1.
BTW, I have not added cp1251.txt cp866.txt koi8-r.txt, since they
come from Unicode.org and are not permitted to re-distribute.
--
Tatsuo Ishii
From: Victor Wagner [EMAIL PROTECTED]
Subject: [PATCHES]
I found it myself:
SQL Features
- SQL 92 entry level with several extensions
- Oracle 7 compatibility mode
Key benefits
- Referential integrity (to be defined in CREATE TABLE or ALTER Table
statement)
- Stored procedures
- After statement trigger (INSERT/UPDATE/DELETE)
- Updateable views,
Bruce Momjian wrote:
I downloaded it. The directories are two characters in length, the
files are numbers, and it is a mixture of C++, Python, and Pascal. Need
I say more. :-)
OK, I'll bite: you need to say more.
What is it like at handling transactions? What sort of full-text indexing
Many thanks to you!!!
It now works (did'nt realize that strings where not null
terminated) stupid me!!!
Regards,
On Sat, 28 Apr 2001, mlw wrote:
You actually almost have it right.
You are passing VARDATA(user) to crypt, this is wrong.
You must do something like this:
int ulen =
BTW, I have not added cp1251.txt cp866.txt koi8-r.txt, since they
come from Unicode.org and are not permitted to re-distribute.
It is not true for koi8-r.txt. At least one which is included into catdoc
distribution I've made myself from RFC1483, and only afterward it has
appear on
Thus spake special agent k
I'm new to postgresql...but so far i love it...after working with companies
that have spent millions of dollars on the big O i must say pgsql is a
breath of fresh air...nice work to all who contributed.
I'm looking at building a fault tolerant/failover
Hi guys (and girls),
Firstly, I must say that everyone has been quite helpful to me while I've
been migrating my database to PostgreSQL 7.1.
One feature I would like to see would be the ability to set a usage and
idle threshold, so that tables automatically get vacuumed once they have
had more
Alastair D'Silva wrote:
Hi guys (and girls),
Firstly, I must say that everyone has been quite helpful to me while I've
been migrating my database to PostgreSQL 7.1.
One feature I would like to see would be the ability to set a usage and
idle threshold, so that tables automatically get
Bruce Momjian wrote:I downloaded it. The directories are
two characters in length, the files are numbers, and it is a
mixture of C++, Python, and Pascal. Need I say more. :-)
OK, I'll bite: you need to say more.
What is it like at handling transactions? What sort of full-text
You, or better someone who knows SAP DB could tell if it's probably the most
complete free database system available right now, with much more features
than interbase, mysql or postgresql as this guy Hemos says on Slashdot.
I remember the same being said about Interbase when it was
[ Charset ISO-8859-1 unsupported, converting... ]
I found it myself:
Yes, this was on the Features web page.
SQL Features
- SQL 92 entry level with several extensions
- Oracle 7 compatibility mode
Yes, that was a major feature to me. I just couldn't find it in the
code.
- Updateable
Don Baccus wrote:
Hi guys,
I've used the open source SAPDB and the performance is pretty damned
impressive. However, 'open source' in application to it is somewhat
deceptive, since you have to make it with SAP's proprietary build
tools/environment.
In my opinion, however, it
On Sat, Apr 28, 2001 at 06:45:39PM -0400, Bruce Momjian wrote:
Sorry, only in 7.2. No new features in minor releases unless they are
very safe.
So how was that patch not safe?
It sure would make porting Oracle apps to PostgreSQL _much_ easier.
How far down the line
I swore I'd never post to the hackers list again, but this is an amazing
statement by Bruce.
Boy, the robustness of the software is determined by the number of characters
in the directory name?
By the languages used?
[Snip]
My guess is that Bruce was implying that the code
Have you considered that the development tools may
be abstracting out the directory names in their development
environment?
I never considered this, but it makes sense. I didn't try the
development tools and went right to the code. I did find a web site
that described the two-letter
I have attached the original message and my reply. The person was
asking how we could used SAP to see what postgres can learn. My reply
was to say that I couldn't figure how how to learn anything from the
code. That was my only statement.
I did not trash SAP DB. Seems using their development
I see one of my mistakes here. The person clearly said you have to
make it with SAP's proprietary build tools/environment. I didn't
realize you need the build tools/environment to meaningfully view the
code. Of course, as someone else stated, the build tools/environment
have been open-sourced.
* Bruce Momjian [EMAIL PROTECTED] [010429 10:44] wrote:
I swore I'd never post to the hackers list again, but this is an amazing
statement by Bruce.
Boy, the robustness of the software is determined by the number of characters
in the directory name?
By the languages used?
Here is a general call for people to review other open-source database
software and report back on things PostgreSQL can learn from them.
I can see Interbase, MySQL, and SAP DB as being three database that
would be worth researching. I am willing to assist anyone who wants to
give it a try. I
On Sat, Apr 28, 2001 at 06:45:39PM -0400, Bruce Momjian wrote:
Sorry, only in 7.2. No new features in minor releases unless they are
very safe.
So how was that patch not safe?
It sure would make porting Oracle apps to PostgreSQL _much_ easier.
How far down the line
First off I just wanted to give a big 'thank you' to all the developers and
contributors
who have made PostgreSQL what it is today. I haven't come across a single thing
since my first experience with it a few years ago that hasn't been corrected, sped
up, or otherwise postively enhanced!
In
First off I just wanted to give a big 'thank you' to all the
developers and contributors who have made PostgreSQL what it is
today. I haven't come across a single thing since my first
experience with it a few years ago that hasn't been corrected,
sped up, or otherwise postively enhanced!
doesn't this defeat the reasons for going to numerics? is there a reason
why its such a difficult thing to do a SELECT oid on pg_database and
pg_class to get this information? that's what I've been doing when I need
to know *shrug*
On Sun, 29 Apr 2001, Bruce Momjian wrote:
First off I just
doesn't this defeat the reasons for going to numerics? is there a reason
why its such a difficult thing to do a SELECT oid on pg_database and
pg_class to get this information? that's what I've been doing when I need
to know *shrug*
Yes, but you can't do that if you can't start the
doesn't this defeat the reasons for going to numerics? is there a reason
why its such a difficult thing to do a SELECT oid on pg_database and
pg_class to get this information? that's what I've been doing when I need
to know *shrug*
Yes, but you can't do that if you can't start the
On Sun, 29 Apr 2001, Bruce Momjian wrote:
doesn't this defeat the reasons for going to numerics? is there a reason
why its such a difficult thing to do a SELECT oid on pg_database and
pg_class to get this information? that's what I've been doing when I need
to know *shrug*
Yes, but
On Sun, 29 Apr 2001, Bruce Momjian wrote:
doesn't this defeat the reasons for going to numerics? is there a reason
why its such a difficult thing to do a SELECT oid on pg_database and
pg_class to get this information? that's what I've been doing when I need
to know *shrug*
On Sun, 29 Apr 2001, Bruce Momjian wrote:
I don't know the answers to these questions, which is why I'm asking them
... if this is something safe to do, and doesn't break us again, then
sounds like a good idea to me too ...
I was suggesting the symlinks purely for admin convenience. The
I can even think of a situation, as unlikely as it can be, where this
could happen ... run out of inodes on the file system ... last inode used
by the table, no inode to stick the symlink onto ...
If you run out of inodes, you are going to have much bigger problems
than symlinks. Sort file
* Bruce Momjian [EMAIL PROTECTED] [010429 20:14] wrote:
Yes, I like that idea, but the problem is that it is hard to update just
one table in the file. You sort of have to update the entire file each
time a table changes. That is why I liked symlinks because they are
per-table, but you are
On Sun, 29 Apr 2001, Bruce Momjian wrote:
I can even think of a situation, as unlikely as it can be, where this
could happen ... run out of inodes on the file system ... last inode used
by the table, no inode to stick the symlink onto ...
If you run out of inodes, you are going to have
* Bruce Momjian [EMAIL PROTECTED] [010429 20:14] wrote:
Yes, I like that idea, but the problem is that it is hard to update just
one table in the file. You sort of have to update the entire file each
time a table changes. That is why I liked symlinks because they are
per-table, but
2 points:
- I thought that a big part of the reason we got rid of filenames was
so we would use arbitrary table / db names that were not restricted by
the file system / OS. Using links would then return this restriction.
- What is the format for the table? Could we write a tool that can
read
On Sun, 29 Apr 2001, Bruce Momjian wrote:
Yes, I like that idea, but the problem is that it is hard to update just
one table in the file. You sort of have to update the entire file each
time a table changes. That is why I liked symlinks because they are
per-table, but you are right
- Original Message -
From: Alfred Perlstein [EMAIL PROTECTED]
To: Bruce Momjian [EMAIL PROTECTED]
Cc: The Hermit Hacker [EMAIL PROTECTED]; Casey Lyon [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Sunday, April 29, 2001 11:17 PM
Subject: Re: [HACKERS] Thanks, naming conventions, and
It certainly works quickly for smaller tables, however the 21.7 million
record table I ran this on takes a touch longer as shown here:
database=# explain select count(*) from table;
NOTICE: QUERY PLAN:
Aggregate (cost=478056.20..478056.20 rows=1 width=0)
- Seq Scan on table
I think parsing the file contents is too hard. The database would have
to be running and I would use psql.
I don't know, I recovered someone's database using a raw connection ...
wasn't that difficult once I figured out the format *shrug*
the following gets the oid,relname's for a
If this isn't incorporated into a utility, it would certainly be prime
for inclusion for the yet-to-be-written chapter 11 of the PG Admin Manual
Database Recovery.
Thanks for your responses, -Casey
The Hermit Hacker wrote:
On Sun, 29 Apr 2001, Bruce Momjian wrote:
Yes, I like that
Here is what I suggested for oid2name to do with file names:
---
Just seems like a major pain; not worth the work.
If you do a ls and pipe it, here is what you would need to do:
- find out where $PWD is
- in that
"Mikheev, Vadim" wrote:
There's a report of startup recovery failure in Japan.
DEBUG: redo done at (1, 3923880100)
FATAL 2: XLogFlush: request is not satisfied
postmaster: Startup proc 4228 exited with status 512 - abort
Is this person using 7.1 release, or a beta/RC
Magnus Naeslund\(f\) [EMAIL PROTECTED] writes:
Where do get a listing of what PQftype() can return to me?
select oid, typname from pg_type
regards, tom lane
---(end of broadcast)---
TIP 3: if posting/reading through
Okay, maybe this query isn't quite as simple as I think it is, but does
this raise any flags for anyone? How did I get into a COPY? It appears
re-creatable, as I've done it twice so far ...
eceb=# select e.idnumber,e.password from egi e, auth_info a where e.idnumber !=
a.idnumber;
Backend
The Hermit Hacker [EMAIL PROTECTED] writes:
Okay, maybe this query isn't quite as simple as I think it is, but does
this raise any flags for anyone? How did I get into a COPY? It appears
re-creatable, as I've done it twice so far ...
eceb=# select e.idnumber,e.password from egi e,
On Mon, 30 Apr 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Okay, maybe this query isn't quite as simple as I think it is, but does
this raise any flags for anyone? How did I get into a COPY? It appears
re-creatable, as I've done it twice so far ...
eceb=# select
Peter Eisentraut [EMAIL PROTECTED] writes:
Ian Lance Taylor writes:
`make depend' is broken in the CVS sources.
'make depend' doesn't exist anymore. Use configure --enable-depend.
However, the makefiles are still full of depend targets --- so someone
who hadn't read the configure docs with
* Tom Lane [EMAIL PROTECTED] [010429 23:12] wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
big problem is that there is no good way to make the symlinks reliable
because in a crash, the symlink could point to a table creation that got
rolled back or the renaming of a table that got rolled
47 matches
Mail list logo
