"Robert B. Easter" <[EMAIL PROTECTED]> writes:
> What is there for a user or admin or programmer to know about the new WAL
> stuff?
Vadim is the man who ought to answer this (and he's on the hook to write
a lot of documentation before 7.1 ships ;-)). But my understanding is
that as of 7.1, WAL
> In this case the planner is doing *exactly* the right thing; it is
> smarter than you are. If you want to prove it, force the planner to
> use an indexscan by doing SET ENABLE_SEQSCAN TO OFF. Then time the
> query, and compare the runtime against the seqscan version.
>
> The bottom line here
> EXECUTE ''UPDATE table SET '' || fieldname ||
> '' = '' || newvalue || '' WHERE ...'';
>
> None of this stuff is in the docs yet :-(. Seems we've been a tad
> sloppy about adding documentation for new features this time around.
> Anyone want to submit a documentatio
Lee Joramo <[EMAIL PROTECTED]> writes:
> [PostgreSQL 6.5.2 on powerpc-unknown-linux-gnu, compiled by gcc 2.95.2]
Hm. Did you compile at -O0? Pre-7.1 PG is known to have a lot of
problems on PPC if compiled with any optimization at all.
> The 'classifieds.dat' consists of about 2200 lines. I ha
I looked through all the docs, and I couldn't find a function which
would simply DES encrypt a string. Is DES not implemented in
Postgres? Or am I just not finding the function?
Thanks
Hi all,
As I not familiar with the linux newsgroups and mailing lists, can
anyone give me some
guidance as to where I should post details of a java development job?
It's a Java GUI application which interfaces to a PostgreSQL database
backend
through JDBC.
Regards and best wishes,
Justin Clift
Quick question: Is there a way to find out how many rows an UPDATE
affected in pl/pgsql?
Thanks
What is there for a user or admin or programmer to know about the new WAL
stuff? What all does it do? Does it allow for an audit file to be created,
which can be used to playback and/or rewind the transactions on the database
by user/admin commands? How do checkpoints limit or affect how far
Does anyone know if there are prebuilt binaries for PostgreSQL 6.x
or 7.x for Sparc Solaris 2.5, and where they can be found. Thanks in advance
for any assistance.
Mike Cianflone
how does one change the time intervals between 'checkpoints'?
On Tue, 9 Jan 2001, Peter Eisentraut wrote:
> > after i ran vacuum analyze, i see that all my database directories with
> > respect to their database names have changed to all numbers:
>
> > is this normal?
>
> Yes, and it surely was like that before the vacuum analyze as well. This
> is new w
I am running to the following error when copying a file to a table:
"backend closed the channel unexpectedly"
My basic system info:
[PostgreSQL 6.5.2 on powerpc-unknown-linux-gnu, compiled by gcc 2.95.2]
The Table:
able= classifieds
+-
Thomas T. Thai writes:
> after i ran vacuum analyze, i see that all my database directories with
> respect to their database names have changed to all numbers:
> is this normal?
Yes, and it surely was like that before the vacuum analyze as well. This
is new with 7.1.
--
Peter Eisentraut
mnogosearch only does inserts into the database, it doesn't check for a
previous occurance of the record first, so you are getting what is
expected ...
I think they work under teh guise that better return an error then do two
queries ...
On Mon, 8 Jan 2001, Thomas T. Thai wrote:
> i'm starting
Dangling large objects? I thought this was a family list. :-)
-- Brett
PS. Sorry, couldn't resist...
http://www.chapelperilous.net/~bmccoy/
---
Unnamed Law:
If it happens, it mu
after i ran vacuum analyze, i see that all my database directories with
respect to their database names have changed to all numbers:
# ls -l /var/pgsql/data
total 17
-rw--- 1 pgsql wheel 4 Dec 30 15:45 PG_VERSION
drwx-- 6 pgsql wheel 512 Jan 8 05:28 base
drwx-- 2 pgsql wh
i'm starting to use mnogosearch 3.1.8 and pgsql-cvs on
NetBSD/Alpha.
i'm getting a tremendous amount of these errors in my log file when i'm
running indexer:
...
ERROR: Cannot insert a duplicate key into unique index url_url
ERROR: Cannot insert a duplicate key into unique index url_url
ERROR:
Adam Haberlach <[EMAIL PROTECTED]> writes:
> Is there any simple way for me to get a list of all large objects
> in a database, so I can see if there are actually rows referring to them
> and delete the ones that were not unlinked earlier?
Look at the vacuum_lo contrib module.
BTW, I belie
Brian Troxell <[EMAIL PROTECTED]> writes:
> I have a PG/plSQL function get_attribute()) that does a simple lookup
> using this code:
> EXECUTE ''CREATE TEMPORARY TABLE random_tab (item) AS SELECT '' ||
>quote_ident(v_column) || '' FROM '' ||
>quote_ident(v_table_name) || '' WHERE '
I'm in a bit of a bind here. I wrote some code in our abstraction
layer to automatically unlink large objects when the row referencing
them is deleted (I know that they are only referenced once). However,
I neglected to include them in a transaction, so I'm pretty sure that
those unlinks
I cannot seem to insert hex values into an int column.
I must be doing something really stupid wrong, but I
can't see it.
insert into mytable (intcolumn) values (0xaabbcc);
parser error at "xaabbcc"
insert into mytable (intcolumn) values ('0xaabbcc');
pg_atoi...can't part "xaabb
Hello again everyone. This is the next message in my series of troubles
regarding EXECUTE and SELECT INTO (or CREATE TABLE). Hopefully the list
will be as helpful and informative as with my previous queries.
I have a PG/plSQL function get_attribute()) that does a simple lookup
using this code:
EX
Are you using the right name for the sequence> I am very new to sql
so I might be off base here but the name of the sequence is:
__id_seq
sql snippet
DROP TABLE members;
DROP
DROP SEQUENCE members_member_id_seq;
DROP
CREATE TABLE members (
member_id serial,
member_type
On 5 Jan 01, at 14:37, Scott Teglasi wrote:
> When I add a record, I fill in the relevant fields, but when I
proceed
> to the next row, the row I just added shows "#Deleted" in all of
the
> columns. It continues to do this as I add records. When I close
the
> table, then reopen it, my data i
Peter Eisentraut <[EMAIL PROTECTED]> writes:
>> Have you tried it lately? I suspect that you are depending on code that
>> is not in libpq's current sources anymore. I fully agree with Peter E's
>> reasons for removing it, too. We do not need to overload the definition
>> of libpq's dbname para
> I think that under 7.1, pg_log is not so critical anymore, but I'm not
> sure. Vadim, any comment?
Still critical till we implement UNDO and true changes rollback on
transaction abort.
Vadim
Thanks, Tom, and also to Alex Pilosov for his answer.
I was extrapolating from the plpgsql docs, which I probably didn't
understand correctly.
Programming By Example (which is what we non-programmers are obliged to do)
doesn't work so well when the docs are somewhat sparse.
Are there any plans to
Tom Lane writes:
> > Not exactly. It is possible to use PGHOST but you also can add the hostname
> > to the dbname.
>
> Have you tried it lately? I suspect that you are depending on code that
> is not in libpq's current sources anymore. I fully agree with Peter E's
> reasons for removing it, to
28 matches
Mail list logo
