> 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
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'
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
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
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
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
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
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:
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
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
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
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
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?
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.
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
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
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 ?
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 ?
Does CREATE INDEX properly support the * notation ?
Like if I go CREATE INDEX on foobar*, does that index foobar and all its
subclasses?
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]
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]
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
> ---
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
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
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...
> >
> >
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
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
Engenharia Informática
> Universidade de Coimbra
> PORTUGAL
> ---------
--
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]
/
> > // >
> > // >
> > // >
> > //
> > //
> > //
> >
> > --
> > 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]
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
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
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
astr. 3
> 80538 München
> Zimmer: 404
> www: http://www.bayern.de/vermessung/
> --
--
Chris Bitmead
http://www.bigfoot.com/~chris.bitmead
mailto:[EMAIL PROTECTED]
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
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
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
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]
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
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
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
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
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
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
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
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
> I am developing WWW site that is serviced in 4 difference language,
> english, chinese, japanese, korean.
> I allocated one database for one language.
Why?
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
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
49 matches
Mail list logo
