Yes, this was my point. We now have TOAST, but by not going the extra
mile to enable storage of binary files, we really aren't taking full
advantage of our new TOAST feature.
I can see people saying, "Wow, you can store rows of unlimited length
now. Let me store this jpeg. Oh, I can't
Quoting Fernan Aguero [EMAIL PROTECTED]:
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.
IIRC Partly Kernel, Partly FileSystem.
For large
Quoting Tom Lane [EMAIL PROTECTED]:
The JDBC support for over-the-wire access to large objects used to
have some bugs, but AFAIK those are cleaned up in current sources
(right Peter?)
Yes except for DatabaseMetaData.getTables() but thats not directly to do with
large objects.
As long as
Hello everyone,
For storing character data such as surname, email address which
is the best data type to use?
This is my guess:
Char - For small columns, fixed length in record
VarChar - Is this fixed length in record? If not then is it stored in an
'overflow' area
which will effect
How do you mean "reliable"?
This raises an interesting question though. How do I _reliably_ INSERT or
UPDATE a row?
I can't INSERT - fail - UPDATE as someone might delete the record in between
my two statements.
I can't BEGIN - INSERT - fail - UPDATE - COMMIT as the failing INSERT will
All,
I want to do a LIKE on a column of type macaddr, looking (for example) for
all MAC addresses with the prefix "00:80", and so on. There's no ~~ operator
for macaddr though... I tried casting macaddr to text, but that's undefined
apparently (WTF?) - any ideas?
Regards,
Phil
Hello!
I've been trying to install 7.0.3, but I'm always getting the same error,
even if I try to install in another computer. What can I do?
[root@localhost /tmp]# rpm -i postgresql-7.0.3-2.i386.rpm
[root@localhost /tmp]# rpm -i postgresql-devel-7.0.3-2.i386.rpm
[root@localhost /tmp]# rpm -i
I also had a problem installing the 7.0.3 RPM - it was conflicting with an old
version of postgresql
I had to uninstall the old RPM's first before it would work, I also found
Kpackage sorts some problems out
NB Are you logged in as root?
MC
Sorry, I see you are logged in as root, very strange error!
MC
hi, what kind of organization file does postgresql use?
Hi. I'm not sure what you mean by "file organization". Are you asking
about the file format of tables, or about the directory layout? Both are
discussed in the documentation afaik.
- Thomas
Hi,
I started using the JDBC driver and have been slamming it with production
level queries, quite a number of simultaneous threads etc. I have noticed
some oddities as far as large resultsets returning off the database close to
each other (threads finishing around the same time) and some
Hello, Can anybody check and confirm(or not) this:
if pgsql(DEVEL, from cvs-server) is built with locale and multibyte then
"select * from table where row ilike '%a%'" crashes pgsql.
"select * from table where row ilike 'a%'" doesn't craches.
"select * from table where row like '%a%'"
I'm attempting, for the first time, to make use of referential integrity,
but I'm getting an error.
Warning: PostgreSQL query failed: ERROR: referential integrity violation -
key referenced from LessonsPages not found in Lessons
Here is the table's structures:
CREATE SEQUENCE
Have the RPMs been published yet? I seem to remember somebody saying that
they should be on the web site by the last weekend, but I can't find them.
A link would be appreciated... I need some of the new features, but I'd
rather avoid working out all the strange file locations (i.e. not
I am currently using PostgreSQL with a production system using JSP's and
Servlets. The system currently services 250,000 SQL hits a day. The only
problem that I have had is with the database pooling. I had to write my own
custom database pooling code because I wasn't able to find any that
Date: Mon, 11 Dec 2000 18:43:55 -0800
To: [EMAIL PROTECTED]
From: Soma Interesting [EMAIL PROTECTED]
Subject: help with referential integrity
I'm attempting, for the first time, to make use of referential integrity,
but I'm getting an error.
Warning: PostgreSQL query failed: ERROR:
Who put 6.5 manuals on top of 7.0 on that web page? Not everyone has
72 inch monitor you know.
I thought I fixed that, but it seems to have moved again. Vince, is
this the page that gets generated automatically?
Don't fix anything. We discussed things generated via a
In Oracle, there is a method bywhich tables can be loaded into memory as a
method of speeding up queries. Is there anyway this can be done in
Postgres?
Does anyone know a good site outlining general methods of database
optimisation?
Thanks,
Hi.
I am
using postgres 7.0.can't_remember_the_rest and I am not able to add aFK
via alter table command. When I try to do it I get an "Feature not implemented"
error message. This is what I've been trying to do:
alter
table foo
add
constraint foo_fk
foreign key (a) references foo_2
At 14:58 07/12/00 -0500, Travis Bauer wrote:
How would I write an sql statement which would select all the
records from a table where some string field contains
some substring? Example: find all the records where f1 contains
the world "cool."
select * from table where f1 ~ 'cool';
or case
On Tue, 12 Dec 2000 12:04:46 +0100, Roger Wernersson wrote:
I can't BEGIN - SELECT FOR UPDATE - INSERT or UPDATE - COMMIT as someone
might insert after my SELECT and before my INSERT.
correct me if i'm wrong, but a select for update locks the table for
an insert or an update until the end
On Tue, 12 Dec 2000, Bruce Momjian wrote:
I'm a newbie.
I have printed out nearly 2 mb of postscript manuals without
realizing that they are for 6.5. I'm going to use 7.0.3
and would like to know whether I'm foolish to rely on 6.5 manuals.
I really don't feel like wasting paper
On Mon, 11 Dec 2000, Soma Interesting wrote:
I'm attempting, for the first time, to make use of referential integrity,
but I'm getting an error.
Warning: PostgreSQL query failed: ERROR: referential integrity violation -
key referenced from LessonsPages not found in Lessons
Here is
On Tue, 12 Dec 2000, Bruce Momjian wrote:
Who put 6.5 manuals on top of 7.0 on that web page? Not everyone has
72 inch monitor you know.
I thought I fixed that, but it seems to have moved again. Vince, is
this the page that gets generated automatically?
Don't fix
Is there any way to specify an index for PostgreSQL to use for a
particular query? My application has to execute a lot of queries like
this : select count(*) from MyTable where IndexedField_1 = value_1 and
IndexedField_2 = value_2 and ... IndexedField_n = value_n
Sometimes Query Planner decides
"Nathan Suderman" [EMAIL PROTECTED] writes:
how can I convert varchar to int? I can not seem to cast the type
(::int2) and there are no conversion functions in the docs
(int(varchar)).
What Postgres version are you using? This works fine for me in 7.0
and later...
Don't fix anything. We discussed things generated via a script. This
is one of those things and there's a link at the top of the page to take
you either to the current version or the development version.
But 6.5 isn't even our current version.
Your point? This appears at
No, SELECT FOR UPDATE locks the rows matching the constraint and if no rows
match, none are locked.
as in (somewhat oracle syntax)
BEGIN
SELECT 'x' INTO a FROM test WHERE y = 10 FOR UPDATE;
UPDATE test SET z = 12;
EXCEPTION
WHEN no_data_found THEN
INSERT INTO test VALUES (10, 12);
Bruce Momjian wrote:
This has nothing to do with PostgreSQL. We don't need large files to go
over 4gig tables. We split them on our own.
Peter Eisentraut wrote:
But, unless you do chunking, it _does_ affect dumpfile size. Someone
posted awhile back a script that did dumpchunking. Should be
I'm out of here. This list has too much traffic. Too bad it's not on usenet.
/Roger, overwhelmed
-Original Message-
From: Jon Brace [mailto:[EMAIL PROTECTED]]
Sent: den 8 december 2000 11:11
To: [EMAIL PROTECTED]
Subject: [GENERAL] Loading tables into Memory
In Oracle, there is a
7.1 isn't released yet, let alone the rpm's.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Gordan Bobic" [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, December 12, 2000 10:26 AM
Subject: [GENERAL] v7.1
Hi, in te postgres manual says "...Postgres offers the read committed and
serializable isolation levels..." but i didn't find how i select betwen
this levels i.e. can i select the level?
Thanks in advance
ivan ...
32 matches
Mail list logo
