On Tuesday 02 March 2004 06:29, Paul Tillotson wrote:
> However, for this to be useful, your table must not have any indexes,
> views, foreign keys, sequences, triggers, etc., or else you must be
> prepared to re-create all of them using application level code.
Which isn't a big deal is it? You ca
Dennis Bjorklund <[EMAIL PROTECTED]> writes:
> Hmm, the draft seems to be broken since I can only find ANY defined for
> subqueries in other sections, and not for value lists. Strange but not
> uncommon. Now I don't know what the standard says about this. Maybe
> someone with the sql99 spec wants
On Mon, Feb 23, 2004 at 05:14:09PM +0100, Peter Eisentraut wrote:
> Thomas Hallgren wrote:
> > 1. Select Pl/Java_JNI.
> > 2. Select Pl/Java_remote
> > 3. Choose both and agree on the SQL + Java semantics
> > 4. Make the postmaster spawn threads rather than processes
> > (controversial? Nah :-) )
>
The IN and ANY constructs works with different kinds of collections to the
right. This is the current situation:
SUB QUERY VALUE LIST ARRAY
IN X X
ANY X X
The SQL standard specifies that = ANY should be equivalent to IN
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> sizes all look about right, if someone wants to download and confirm?
The full gz and bz2 tarballs match what I have here. Didn't check the
partial tarballs.
regards, tom lane
---(end of broadcast)-
On Mon, 1 Mar 2004, Tom Lane wrote:
> Curt Sampson <[EMAIL PROTECTED]> writes:
> > Can you explain how to do this? There is no reference to a plan in the
> > contract table; the constraint just checks to see that, if a contract
> > exists, there is at least one plan referencing that contract.
> >
Rod Taylor <[EMAIL PROTECTED]> writes:
> On Mon, 2004-03-01 at 20:43, Bruno Wolff III wrote:
>> Tom Lane <[EMAIL PROTECTED]> wrote:
>>> Michael Glaesemann <[EMAIL PROTECTED]> writes:
In both cases, the CHECK constraint uses a function that is stable or
volatile. It was suggested that fun
Curt Sampson <[EMAIL PROTECTED]> writes:
> Can you explain how to do this? There is no reference to a plan in the
> contract table; the constraint just checks to see that, if a contract
> exists, there is at least one plan referencing that contract.
> There is of course a foreign key constraint use
Will create all the linages in the morning, but the bundle is created
under /pub/source/v7.3.6 on the main web site (soon to be on the mirrors)
... I added code to the mk script for the 7.3.x branch so that bz2 copies
are also made ...
sizes all look about right, if someone wants to download and
On Mon, 2004-03-01 at 20:43, Bruno Wolff III wrote:
> On Mon, Mar 01, 2004 at 20:28:02 -0500,
> Tom Lane <[EMAIL PROTECTED]> wrote:
> > Michael Glaesemann <[EMAIL PROTECTED]> writes:
> > > In both cases, the CHECK constraint uses a function that is stable or
> > > volatile. It was suggested that
On Thu, 26 Feb 2004, Tom Lane wrote:
> Jonathan Scott <[EMAIL PROTECTED]> writes:
> > The functions and tables create just fine, but when it gets to the
> > COPY part of the sql script, it tries to load tables in what really is
> > the wrong order. The check constraint is making sure there is a "p
On Mon, Mar 01, 2004 at 20:28:02 -0500,
Tom Lane <[EMAIL PROTECTED]> wrote:
> Michael Glaesemann <[EMAIL PROTECTED]> writes:
> > In both cases, the CHECK constraint uses a function that is stable or
> > volatile. It was suggested that functions used in CHECK constraints be
> > restricted to imm
Paul Tillotson <[EMAIL PROTECTED]> writes:
> I use this type of approach when mirroring data from a foxpro database
> (yuck) to a read-only postgres database. It is quicker and cleaner than
> deleting all of the rows and inserting them again (TRUNCATE is not
> transaction safe, which I need).
Michael Glaesemann <[EMAIL PROTECTED]> writes:
> In both cases, the CHECK constraint uses a function that is stable or
> volatile. It was suggested that functions used in CHECK constraints be
> restricted to immutable,
This seems reasonable to me. I'm a bit surprised we do not have such a
check
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> Gavin Sherry wrote:
>> I do not intend to work on such a system for the initial introduction of
>> table spaces. The problem is, of course, knowing when you're actually out
>> of space in a table space in any given transaction. Given that WAL is on a
>> d
I use this type of approach when mirroring data from a foxpro database
(yuck) to a read-only postgres database. It is quicker and cleaner than
deleting all of the rows and inserting them again (TRUNCATE is not
transaction safe, which I need).
However, for this to be useful, your table must not
"Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> On Sat, 28 Feb 2004, Tom Lane wrote:
>> AFAIK we are good to go in terms of the code --- there are no open
>> issues that I'd want to back-patch to 7.3. We just need release notes.
>> But I don't have time this weekend to do the release notes either
>Gavin Sherry
> On Fri, 27 Feb 2004 [EMAIL PROTECTED] wrote:
> > Most people I know want tablespaces in order to limit or preallocate
the
> > disk space used by a table or database in addition to controlling
the
> > physical location of a table or database.
> I do not intend to work on such a syst
>Shridhar Daithankar
> > Recently, I ran a huge update on an Integer column affecting 100
million
> > rows in my database. What happened was my disk space increased in
size
> and
> > my IO load was very high. It appears that MVCC wants to rewrite each
row
> > (each row was about 5kB due to a bytea
The Pl/Java (the JNI version) will utilize a class loader that uses tables
in the SQLJ schema. Java has a fairly extensive mechanism for "module"
loading so I think it's hard to collaborate on that.
The Java standard came up with an idea that I think is pretty neat that
other pl's might use. When
Larry Rosenman <[EMAIL PROTECTED]> writes:
>> okay, if I'm reading you right here, this is one that virus checkers
>> wouldn't pick up?? or is clamav's signatures just not updated yet? :(
> I had to pick up an extra.dat for McAfee, and this is BRAND NEW (3/1/4).
> I don't think ClamAV's been upda
--On Monday, March 01, 2004 15:19:17 -0400 "Marc G. Fournier"
<[EMAIL PROTECTED]> wrote:
On Mon, 1 Mar 2004, Larry Rosenman wrote:
--On Monday, March 01, 2004 15:02:50 -0400 "Marc G. Fournier"
<[EMAIL PROTECTED]> wrote:
>
> are you and larryr the same person? *scratch head*
No, but when I go
On Mon, 1 Mar 2004, Larry Rosenman wrote:
>
>
> --On Monday, March 01, 2004 15:02:50 -0400 "Marc G. Fournier"
> <[EMAIL PROTECTED]> wrote:
>
> >
> > are you and larryr the same person? *scratch head*
> No, but when I got the file, I fed it to www.webimmune.net and
> after feeding the .zip the pass
On Mon, 2004-03-01 at 08:24, Kaare Rasmussen wrote:
> > http://gforge.org/ is not a hosting site, that is why you only found
> 4
>
> Well that's what you get when you write messages at 2:30 AM. Should
> know
> better.
>
> But on this topic, does a site based on GForge similar to Sourceforge
> ex
--On Monday, March 01, 2004 15:02:50 -0400 "Marc G. Fournier"
<[EMAIL PROTECTED]> wrote:
are you and larryr the same person? *scratch head*
No, but when I got the file, I fed it to www.webimmune.net and
after feeding the .zip the password from the message, it told me
that it was a virus.
LER
O
are you and larryr the same person? *scratch head*
On Mon, 1 Mar 2004, Larry Rosenman wrote:
> It was a virus, FWIW.
>
> w32/[EMAIL PROTECTED]
>
> LER
>
>
> --On Monday, March 01, 2004 14:48:14 -0400 "Marc G. Fournier"
> <[EMAIL PROTECTED]> wrote:
>
> >
> > removed from the mailing lists
> >
> >
It was a virus, FWIW.
w32/[EMAIL PROTECTED]
LER
--On Monday, March 01, 2004 14:48:14 -0400 "Marc G. Fournier"
<[EMAIL PROTECTED]> wrote:
removed from the mailing lists
On Mon, 1 Mar 2004 [EMAIL PROTECTED] wrote:
I don't bite, weah!
pass: 74574
Marc G. Fournier Hub.Org Ne
removed from the mailing lists
On Mon, 1 Mar 2004 [EMAIL PROTECTED] wrote:
> I don't bite, weah!
>
> pass: 74574
>
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
On Friday 27 February 2004 12:01 pm, Halasipuram seshadri ramanujam wrote:
> Hello ,
>
> Can somebody please tell me how to get the name of the
> relation (Attribute also) from the Oid and the
> otherway back (Oid from name) ??
>
There is a document on the system tables in the PostgreSQL documenta
I don't bite, weah!
pass: 74574
<>
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Tom,
> I was quite surprised to read this, and I'm sure Dave Lawrence (RH's BZ
> maintainer) would be too. As would be the thousands of people who
> regularly use bugzilla.redhat.com.
My sincerest apologies to you and Dave Lawrence. I misunderstood what I was
being told on this list.
A rev
On 27 Feb 2004, Chad wrote:
> Is it possible for Postgres Btrees to support access by logical row number ?
> If not available is ti a huge job to support for sombebody willing to have a go ?
Are talking about logical row operators as maintained by your own code
outside the database, or having po
When grilled further on (29 Feb 2004 08:46:36 -0800),
[EMAIL PROTECTED] (Hammer) confessed:
> Quick one:
> Anyone know how to use Putty to open a connection up under SSH which
> will allow pgAdmin III to connect to a postgresql database ie. Only
> access to server postgresql is on is via ssh.
>
On Sun, Feb 29, 2004 at 10:43:34AM -0500, Tom Lane wrote:
> general I think our VACUUM-based approach is superior to the
> Oracle-style UNDO approach, because it pushes the maintenance overhead
> out of foreground transaction processing and into a schedulable
> background process. Certainly any Or
On Thu, Feb 26, 2004 at 05:28:41PM -0500, Alex J. Avriette wrote:
> The only reason I mentioned it to begin with was the recommendation of
> directio for databases in the Sun Blueprint, _Tuning Databases on the
> Solaris Platform_ (and being a Solaris geek, I asked, but apparently
> nobody else is
El Lun 01 Mar 2004 11:11, ivan escribió:
> hi,
>
> is there same packets (or sources to compile) only for client-systems
> ( headers and libs like libpq, and so on) ?
On a normal Linux distribution, you would have packages like this:
postgresql - PostgreSQL client programs and libraries.
postgres
hi,
is there same packets (or sources to compile) only for client-systems
( headers and libs like libpq, and so on) ?
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Tom Lane said:
> Josh Berkus <[EMAIL PROTECTED]> writes:
>> C. BZ does not have any PG support in its default branch, and the RH
>> port is currently unmaintained.
>
> I was quite surprised to read this, and I'm sure Dave Lawrence (RH's BZ
> maintainer) would be too. As would be the thousands of
> http://gforge.org/ is not a hosting site, that is why you only found 4
Well that's what you get when you write messages at 2:30 AM. Should know
better.
But on this topic, does a site based on GForge similar to Sourceforge exist ?
--
Kaare Rasmussen--Linux, spil,--Tlf:
39 matches
Mail list logo