Ned Lilly wrote:
>
> Er... let me put it this way. Proprietary 2 prefers to run on Windows NT.
The performance is so bad it must be MS-Access :-).
> Chris Bitmead wrote:
>
> > That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
> > 2 was definitely NOT MS-SQL Server?
Ned Lilly wrote:
>
> Oh, Dan, I'm not that clever... ;-)
>
> But I *can* tell you that the market leading proprietary RDBMS products we
> tested were not IBM, Informix, or Sybase.
That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
2 was definitely NOT MS-SQL Server?
>
> R
Michael Talbot-Wilson wrote:
>
> > I want to alter the size of a column, say from char(40) to char(80),
> > but it seem that
> > the ALTER does not support such operation, nor does it support column
> > removing.
> >
> > How can I do for this ?
>
> I would also like to know how to do
I guess if you don't do deletes then something like selecting all the
records with an oid greater than the last replication cycle would
find the most recent additions.
Erich wrote:
>
> I am setting up a system that processes transactions, and it needs to
> be highly reliable. Once a transact
Hi,
Originally postgres had a "recursive select" to handle cases like this.
Some syntax like...
retrieve* (notice the "*") which meant keep executing until you can't
anymore, and using an
appropriate where clause it would decend tree-like structures.
This feature disappeared somewhere along the
hate it, but it
> does work.
> e) OIDs could be scrapped in favour of some other system.
>
> Well, that's my two pence worth.
>
> Brad
>
> Paul Caskey wrote:
>
> > Tom Lane wrote:
> > >
> > > Chris Bitmead <[EMAIL PROTECTED]> writes:
Tom Lane wrote:
>
> Chris Bitmead <[EMAIL PROTECTED]> writes:
> > ... The attnum and the name should
> > probably be individual to each class in the hierarchy. (The name should
> > be individual to support subclass renaming to avoid naming conflicts,
> > like
Stephan Szabo wrote:
>
> Of course I had to be half asleep when I wrote the second paragraph of my
> response, since I totally missed he was using a serial. The rest still
> applies though...
>
> As an aside to Chris, what interactions do you expect between the OO stuff
> you've been working on
MOD is the remainder after division.
MOD(10, 3) = 1
MOD(11, 3) = 2
MOD(12, 3) = 0
MOD(13, 3) = 1
etc.
Tyler Wood wrote:
>
> Hello,
> I'm updating an existing postgres database, and using
> perl with dbi to
> access it.
>
> Everything works fine,
> I'm just not sure what this MOD command mean
that hard.
Chris Bitmead.
Felipe Alvarez Harnecker wrote:
>
> Hi, Postgresistas
>
> I'm running 7.0.2 in a Debian system, and a have this problem:
>
> SELECT * FROM some_base_table*
>
> works fine, but
>
> UPDATE some_base_table* SET a = b WHERE some_condit
Philip Warner wrote:
> My legal advice is that, assuming they knew it was a BSD project, they
> can't take it out of PostgreSQL. But you could, for example, stop Microsoft
> using your compression code in one of their products. The new license
> removes this right from you.
Why wouldn't MS be ab
Philip Warner wrote:
>
> At 14:38 5/07/00 +1000, Chris Bitmead wrote:
> >
> >Then what happens if I fork the project and remove all these printf's
> >from the code?
>
> Then I'd guess that the organization that removed them becomes liable.
> That'
> Good point. But the USA is the demon spawning ground for lawyers, and is
> at the leading edge of aggressive new legal territory.
Actually that is the exact reason you _don't_ want to be based in the
USA. Do you really want Postgres to be breaking new ground in the
courts? The USA is at the l
Emmanuel Motchane wrote:
>
> Hi,
>
> I am trying to figure out how to restrict user access to a database to
> a few defined functions, so that users could use the database (and update
> it) but only through a set of procedures, written for exemple in C and
> using the Server Programming
> interf
Sungchul Park wrote:
>
> Because I want to use same table name. I mean... For example, I have a
> BBS code. That code store data into 'pubbbs' table. As you know I need
> 4 tables for one service.
> Yes, I can use 4 different table name. As 'pubbbs_en', 'pubbbs_jp',
> 'pubbbs_kr', 'pubbbs_cn'. Bu
> I am developing WWW site that is serviced in 4 difference language,
> english, chinese, japanese, korean.
> I allocated one database for one language.
Why?
Mike Mascari wrote:
> At a minimum, it seems to me, the backend must support the
> concept of multiple tuples with different attributes at the
> relation level since concurrency and rollback-ability of ALTER
> TABLE ADD COLUMN will cause two concurrent transactions to see a
> single relation with
hink returning multple row-types is going to happen, not that I have any
> authority one way or the other! :-)
>
> --
> Robert B. Easter
> [EMAIL PROTECTED]
--
Chris Bitmead
mailto:[EMAIL PROTECTED]
http://www.techphoto.org - Photography News, Stuff that Matters
able
> would always incur a join, perhaps some optimizing could be done in this
> direction. But the bottom line is that the compatibility issue looms big.
>
> -Peter
>
> On Thu, 3 Feb 2000, Chris Bitmead wrote:
>
> > Hi,
> >
> > I've been spen
Mathijs Brands wrote:
>
> On Wed, Feb 02, 2000 at 09:57:48PM -0500, Bruce Momjian allegedly wrote:
> > > > > 3) The ability to return different types of rows from a SELECT. This
> > > > > is to allow implementation of ODBMS functionality where a query could
> > > > > be required to instantiate ob
Bruce Momjian wrote:
> > I already have a patch for this one. The change is a few pretty simple
> > changes
> > to gram.y.
>
> OK, you will have to canvas the general list to make sure this does not
> break things for people, though our inheritance system needs an overhaul
> badly.
This is alre
Bruce Momjian wrote:
> So the field is created on the fly to show what table it came from.
> Seems like a good idea, though implementing another usually-invisible
> column will be tough.
What problems do you forsee?
> However, because it is not really a column like
> the oid is a column, it sh
You need to look at the system tables. Like pg_class and the other pg_*
tables.
pg_dump will output CREATE statements to re-create the database. I'm not
sure
that's what you want though.
Marzullo Laurent wrote:
>
> Hello,
>
> is there a prog to generate C file describing table structure
> of
ique
whereas unique index doesn't.
>
> It's not a huge deal, but I was wondering if there was reasoning behind it
> of which I am unaware.
>
> -Dan
--
Chris Bitmead
mailto:[EMAIL PROTECTED]
http://www.techphoto.org - Photography News, Stuff that Matters
e docs themselves say "Oracle doesn't support
inheritance". It's a bit rich really to call it Oracle "object" in any
shape or form.
--
Chris Bitmead
mailto:[EMAIL PROTECTED]
I think you are missing something. Threads and processes, to a great
extent are 6 of one and half a dozen of the other. Postgres uses
multiple processes accessing a shared memory area. A multithreaded
database would use multiple threads accessing a shared memory area. In
most OSes, threads and pro
What is MVCC?
Bruce Momjian wrote:
>
> >
> > Hmm a very interesing theoretical topic...
> > Wouldnt make sense to tie this in with the implementation of a Foriegn Key?
> > So when the foriegn key is defined you create anoter index that stores all
> > the relevant child to parent relationships a
Dustin Sallings wrote:
>
> On Thu, 3 Jun 1999, The Hermit Hacker wrote:
>
> # One of the long-term projects that PostgreSQL, Inc is planning on
> # working on is exactly this, unless someone jumps at it before we get a
> # chance to...
>
> It should be a trivial change, right? :)
Will
astr. 3
> 80538 München
> Zimmer: 404
> www: http://www.bayern.de/vermessung/
> --
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:[EMAIL PROTECTED]
Bruce,
I've put up a script for ftp that shows some wierd behaviour. This
script was created by hand, so it's possible that some errors are caused
by syntax errors (although I spent a while trying to find them without
success).
I think the point is that it is not recovering from/ reporting the er
I've seen this problem too in 6.5 beta. I don't have a solution, but I'd
just like to add my voice to say that this problem is real.
Actually, I did have a kind of solution. If you dump proper insert
statements into the dump and then run every insert in a separate
process. Ugly but workable if t
Unfortunately tuples cannot be bigger than 8k. Many of us I think look
forward to the day when this restriction doesn't apply (it is on the
to-do list), but at this point in time 8k is the limit.
Large objects will work, but they have other problems that make them
fairly impractical.
John Browni
/
> > // >
> > // >
> > // >
> > //
> > //
> > //
> >
> > --
> > Principal Member Technical Staff, beyond.comThe world is watching America,
> > pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <[EMAIL PROTECTED]>
> > |Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
> > L__ and America is watching TV. __
> >
> >
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:[EMAIL PROTECTED]
> Chesapeake, VA 23320 977 Centerville Trnpk CSB 317
> [EMAIL PROTECTED] Va Beach, VA 23463
> Check out our site at:http://www.strategicnetwork.org
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:[EMAIL PROTECTED]
Engenharia Informática
> Universidade de Coimbra
> PORTUGAL
> ---------
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:[EMAIL PROTECTED]
Doo Suk Yang wrote:
>
> I'm novice in database world.
> Now I have to make design a database where categorized items should be
> stored. It resembles the structure something like seen in Yahoo.
>
> Thanks for reading and generous comments of yours.
I do it something like this..
create table cat
It's not a timezone problem is it? Did the dates get re-loaded
correctly?
Andy Lewis wrote:
>
> I have 2 tables both of which have a datetime field and both have an
> identifier of date_submitted.
>
> I've been using(via PHP) a query of the following for a month or so with
> no problem:
>
> se
or
> doing all sorts of things in response to alarms etc ( including sending email
> ).
>
> Thanks again.
>
> Chris Bitmead wrote:
>
> > I'm a bit vague on what you mean. Are you saying you want to be able to
> > say to postgres...
> >
> >
darold wrote:
> I'm using Large Object to store images and displayed them on the fly. I never found
> any problems and it
> is very quiet. "When Postgre starts using large objects it is going to make a lot
> of noise." ???
How many images are you stori
Dustin Sallings wrote:
>
> On Tue, 4 May 1999, Raphael Finkel wrote:
>
> # Is PostgreSQL appropriate for a database of documents? I see several
> # potential problems.
> #
> # 1. Tuples are limited to 8KB. I assume even the "text" type is limited
> # that way. But my documents may be longer
Only PostgreSQL 6.5 Beta supports LIMIT.
> I've an elementary question. What's wrong with the following :
>
> dbtest=> select * from testusers limit 10;
> ERROR: parser: parse error at or near "10"
> dbtest=> select version();
> version
> ---
on the other hand,
> win98 shouldn't even be touching that disk, there's only linux
> partitions on it).
You think you're hard done by. Think about the rabbit!
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:[EMAIL PROTECTED]
ty nets. Sometimes, these
> safety nets are important.
Never lost a file to Linux in 5 years.
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:[EMAIL PROTECTED]
Does CREATE INDEX properly support the * notation ?
Like if I go CREATE INDEX on foobar*, does that index foobar and all its
subclasses?
If I want to have an index on oid, which will obviously be unique
anyway, is it more efficient to have or not to have the UNIQUE option on
CREATE INDEX ?
If I have a UNIQUE or PRIMARY KEY clause on my class, does that create a
btree or hash index?
I guess if I have a UNIQUE constraint or PRIMARY KEY at class creation,
I don't have to create an index explicitely via CREATE INDEX ?
odice_fiscale|bpchar |-1|8|f |f
> 5|cap |bpchar |-1|9|f |f
> 6|regione |bpchar |-1|7|f |f
> 7|distretto |bpchar |-1|8|f |f
> (7 rows)
>
>
> José
>
> Chris
What's the best way to do this in postgres? (basicly finding the type of
objects).
I want to run a web site with different types of content - question and
answers, stories etc. I propose an object hierarchy...
webobject (title, body)
question inherits webobject
story (image) inherits (webob
Kevin Heflin wrote:
>
> I've been asked if there is a way to LIMIT the number of results displayed
> when doing a SELECT with postgresql, by a former user of mysql. Wasn't
> sure if there is an easy way to do this or not. I've don't it before, but
> in a very round about way... any suggestions.
49 matches
Mail list logo
