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 ...
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.
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 metho
>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. Sh
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);
END;
> > > 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? Th
"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...
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 n
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?
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
>
> He
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
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
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 i
Hi.
I am
using postgres 7.0.can't_remember_the_rest and I am not able to add a FK
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
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,
-
> > > 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
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: referent
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 worke
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
/usr/local)
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 "LessonsPages_id
On Thu, 7 Dec 2000, 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 mytable WHERE f1 LIKE '%cool%';
or
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%'" doesn't
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
ArrayS
> 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
Sorry, I see you are logged in as root, very strange error!
MC
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
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 po
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
+
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
invalida
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 performanc
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 a
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 la
> 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 ca
33 matches
Mail list logo
