Hello all,
I just reproduced the same phenomenon on my installation (PostgreSQL
7.0.2 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66) and it seems
to me that maybe the index is not correctly actualized while inserting
the record? It seems that any (!) update on blah (before executing the
dele
I've sent a message of mine to this list twice now, and it never comes
through. Odd.
- - - - - - -
- - - - -
WARNING: Some experts believe that use of any keyboard may cause serious
injury.
Consult
> This is a misunderstanding. You can still use the old-style large
> objects (in fact 7.1 has an improved implementation of them too),
> and there's always been support for either over-the-wire or
> server-filesystem read and write of large objects. In fact the former
> is the preferred way; th
what is the tentative date for 7.1 release?
what is the release date for replication?
sandeep
Joe Kislo <[EMAIL PROTECTED]> writes:
> ... this lack of BLOB support. I understand that the C
> API can read/write -files- off the server's filesystem and load them
> into the database. Unfortunately we would absolutely require true
> over-the-wire blob support through JDBC. AFAIK, even with t
> Of course, people really shouldn't be inserting
> objects which already exist, ...
On the contrary, the best way to test if
something already exists is to just try the
INSERT and let the database tell you if
it's already there. Both faster and more
reliable than doing SELECT then INSERT.
Peter Eisentraut wrote:
> Fernan Aguero writes:
> > I am having trouble with large files on a Linux box (RH 6.2). I know there
> > is a limit of 2 GB on the file size,
> ...but that doesn't affect table size, database size, or whatever you're
> thinking of.
Nope, PostgreSQL segments nicely for
Joe Kislo writes:
> First, I was evaluating Postgre for a medium scale application I will
I'm just wondering what this "Postgre" thing is you keep talking about...
;-)
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
> > What I think we _really_ need is a large object interface to TOAST data.
> > We already have a nice API, and even psql local large object handling.
> >
> > If I have a file that I want loaded in/out of a TOAST column, we really
> > should make a set of functions to do it, just like we do with
> What I think we _really_ need is a large object interface to TOAST data.
> We already have a nice API, and even psql local large object handling.
>
> If I have a file that I want loaded in/out of a TOAST column, we really
> should make a set of functions to do it, just like we do with large
> o
Alfred Perlstein schrieb:
> * Fernan Aguero <[EMAIL PROTECTED]> [001211 12:45] wrote:
> > Dear all:
> >
> > I am having trouble with large files on a Linux box (RH 6.2). I know there
> > is a limit of 2 GB on the file size, but do not know if this is kernel
> > related, filesystem related or both
Fernan Aguero writes:
> I am having trouble with large files on a Linux box (RH 6.2). I know there
> is a limit of 2 GB on the file size,
...but that doesn't affect table size, database size, or whatever you're
thinking of.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e
* Fernan Aguero <[EMAIL PROTECTED]> [001211 12:45] wrote:
> Dear all:
>
> I am having trouble with large files on a Linux box (RH 6.2). I know there
> is a limit of 2 GB on the file size, but do not know if this is kernel
> related, filesystem related or both.
Afaik it's both.
Honestly Postgre
Fernan Aguero <[EMAIL PROTECTED]> writes:
> I am having trouble with large files on a Linux box (RH 6.2). I know there
> is a limit of 2 GB on the file size, but do not know if this is kernel
> related, filesystem related or both.
>
> I am researchiing the issue (having some trouble to find inf
On Mon, Dec 11, 2000 at 05:09:40PM -0300, Martin A. Marques wrote:
> On Monday 11 December 2000 15:56, Juriy Goloveshkin wrote:
> > is it posible to shop query time in psql frontend?
> What do you mean with: shop query time?
oops... s/shop/show/
I want to know how many time the query executed. lik
>
> We have some demographics available at http://www.pgsql.com/user_gallery
>
I believe what was intended was:
http://www.pgsql.com/register
Tim
I've come up with this example and I want to know why it does what it
does.
-- snip --
You are now connected to database template1.
CREATE DATABASE
You are now connected to database testing.
psql:test2.sql:11: NOTICE: CREATE TABLE/UNIQUE will create implicit
index 'subdivs_name_key' for table 's
Dear all:
I am having trouble with large files on a Linux box (RH 6.2). I know there
is a limit of 2 GB on the file size, but do not know if this is kernel
related, filesystem related or both.
I am researchiing the issue (having some trouble to find info) and found
that there are several altern
On Monday 11 December 2000 15:56, Juriy Goloveshkin wrote:
> is it posible to shop query time in psql frontend?
What do you mean with: shop query time?
--
System Administration: It's a dirty job,
but someone told I had to do it.
Hi,
We have some demographics available at http://www.pgsql.com/user_gallery
Jeff
On Thu, 7 Dec 2000, GH wrote:
>
> Has anybody collected information about what people use Postgres how and
> to do what? I think it would be interesting to see where our Collective
> got its roots.
>
> Persona
is it posible to shop query time in psql frontend?
(like in mysql)
--
Bye
Juriy Goloveshkin
At 03:43 PM 12/11/2000 +, [EMAIL PROTECTED] wrote:
>As an aside in DB2 there is the concept of a shared weight index which
>depending
>on
>locale lumps lower/upper case characters together so that you don't have to
>include
>an UPPER in the SQL - and it will use the index. Perhaps postgres c
Hello all,
Great Bridge formally announced its first product and service offerings
today. Here are the highlights:
* QA-tested distribution of PostgreSQL 7.0.3 for Linux (free, source
and binaries available at http://www.greatbridge.com/download)
* Automated graphical installer
Tomas Berndtsson <[EMAIL PROTECTED]> writes:
> Related to this, is there any way to make an index for a table
> case-insensitive? If you have an index, but use upper() in the select,
> the index is not used.
Sure, make a functional index:
play=> create table foo (f1 text);
CREATE
play=> create i
Steve Heaven <[EMAIL PROTECTED]> writes:
> Does the regular expression parser have anything equivalent to Perl's \w
> word boundary metacharacter?
src/backend/regex/re_format.7 contains the whole scoop (for some reason
this page doesn't seem to get installed with the rest of the
documentation).
Title: RE: [GENERAL] Regular expression question
Yes, that's right :-0 Sorry!
-Original Message-
From: Steve Heaven [mailto:[EMAIL PROTECTED]]
Sent: 11 December 2000 15:09
To: Michael Ansley; [EMAIL PROTECTED]
Subject: RE: [GENERAL] Regular expression question
At 14:58 11/12/00 -
Hi,
Forgot one other biggy:
-00-00 00:00:00
is legal for a default value of '' of a datetime
column defined as not null.
create table test (
funkydate datetime not null;
);
insert into test values ('');
select * from test where funkydate = '-00-00
00:00:00';
all those wor
On Tue, 5 Dec 2000, Adam Lang wrote:
> I got a magazine dropped on my desk just now called Storage Management
> Solutions. On the cover they have a listing for "Open Source
> Databases".They talk about Postgresql, MySQL and Interbase. Just a snippet
> of the article:
Web Techniques has a pretty
On Mon, 11 Dec 2000, Matthew wrote:
> > I agree that the key developers shouldn't spend much time on such a
> > thing, but on the other hand this isn't a project that requires a key
> > developer to get done. If Matthew or someone else feels like spending
> > time on it, I wouldn't object...
> >
> "Brett W. McCoy" <[EMAIL PROTECTED]> writes:
> > On Sun, 10 Dec 2000, Matthew wrote:
> >> [Matthew] Would it make sense for postgre to have a mysql
> >> compatibility module? An add on package (perhaps in contrib) that
> >> would add many of the functions that mysql has that postgre does not.
Bruce Momjian wrote:
>
> > The bottom line is that the marketing of PostgreSQL is not even close to
> > that of MySQL. Thank god the code, community and support doesn't follow
> > suit!
>
> I think MySQL got a big start by migrating mSQL users years ago and
> having a compatibility module for
Hi,
My mailer crashed, but before I had to delete all
the messages I saw a thread regarding making it easier for mysql users to port
over to postgresql. Well guys, you've gone and made a hole for yourself,
ESPECIALLY by adding the limitless row lengths in 7.1. With the
performance gains,
"Hancock, David (DHANCOCK)" <[EMAIL PROTECTED]> writes:
> Abe: It's an SQL thing or a scripting thing. It's probably easiest and
> safest in the SQL:
>
>select firstname, surname from employees
> where upper(firstname) like upper('%$criteria%') or
> upper(surname) like upper('%$
> > Is there significant overhead involoved in using large objects that
> > aren't very large?
>
> Yes, since each large object is a separate table in 7.0.* and before.
> The allocation unit for table space is 8K, so your 10K objects chew up
> 16K of table space. What's worse, each LO table has a
Does the regular expression parser have anything equivalent to Perl's \w
word boundary metacharacter?
I want to select tuples where a text field contains a certail whole word.
Using fieldname ~* 'searchword' wont work because it picks up the
searchword emdedded in other words. Using ~*' searchwor
Tom Lane wrote:
> A plain kill (SIGTERM) should remove the socket file on its way out.
> The only thing that wouldn't is kill -9 ... if you're doing it that
> way, don't.
The problem is an unexpected crash/reboot of the machine (which
shouldn't happen, but...) that leaves socket files in /tmp an
Hi All,
I would like to write a function that returns multiple rows and multiple
fields, something like this. I know the syntax is probably wrong, any helps
would be appreciated.
CREATE FUNCTION GetGuestbookMessages (int4) RETURNS SETOF VARCHAR AS
'
SELECT guestname, guestemai
On Mon, Dec 11, 2000 at 04:28:24AM +0100, some SMTP stream spewed forth:
> Hi,
>
> I'm thinking about, what might be faster on SELECTs: a column with index
> which is NOT NULL and takes the value of 0 or a column which can take
> the NULL value instead of 0, also with index.
>
> My feeling sais
38 matches
Mail list logo
