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
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
> 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
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
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
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
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
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
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
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 '
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
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:
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
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
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
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
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
+-
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
how does one change the time intervals between 'checkpoints'?
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
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
Quick question: Is there a way to find out how many rows an UPDATE
affected in pl/pgsql?
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
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
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
> 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
> 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
"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
28 matches
Mail list logo
