> 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 no
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] Cyrill
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, alt
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 index
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
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 d
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 mo
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 automat
> 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 f
> 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.
> - Updateabl
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, h
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 implyin
> 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 d
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 developmen
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
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 h
> 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 dow
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 work
> 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 jus
>
> 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 da
> >
> > 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'
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:
>
> > >
> > > 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
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 convenienc
> 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 fil
* 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 yo
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
> * 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-t
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 t
> > 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 that the symlink creation could fail
>
I could even see a utility that does a dump of this info into a flat file,
entirely overwriting the file every time.
This would be quick to reference and usable in a meltdown scenario. Could
easily be incorporated into vacuum and other db maintenance cron scripts.
-Casey
Bruce Momjian wrote:
Bruce Momjian wrote:
> The problem here is that now we don't have commit status in the index
> rows, so they have to check the heap for every row. One idea is to
> update the index status on an index scan, and if we can do that, we can
> easily use the index. However, the table scan is pretty
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 yo
- 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, a
> 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 tabl
> > 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
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
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 databas
"G. Anthony Reina" <[EMAIL PROTECTED]> writes:
> I'm trying to use pg_dump to backup my tables one at a time from
> Postgres 7.0.3 (I'll upgrade to 7.1 in a few weeks). I'm getting a
> strange error that I've never encountered before.
> The error is : failed sanity check, table ro_ellipse was not
"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
"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 U
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 sen
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, aut
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 ...
>
> > ec
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
Tatsuo Ishii <[EMAIL PROTECTED]> writes:
> I'm playing with wal parameters and found that wal_sync_method =
> open_sync enormously enhance the performance on my machine. Without it
> (using default fsync) I got only 90 tps at the best using pgbench (-s
> 2). However if I set wal_sync_method = open
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 back.
Yes. Have you already forgotten the very lo
* 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 g
53 matches
Mail list logo
