Martijn van Oosterhout kleptog@svana.org writes:
It's slightly surprising though. I havn't seen anyone else complain
about this before though. The only way to fix this is to make the
LISTEN completely atransactional, so NOTIFY can see uncomitted LISTENs
also.
There isn't anything very
Martijn van Oosterhout wrote:
A: BEGIN
A: SELECT * FROM foo and cache the result.
A: LISTEN foochange
B: BEGIN
B: update foo
B: NOTIFY foochange
B: COMMIT
A: COMMIT
Eh? At the point the LISTEN is run, the NOTIFY hasn't committed, so a
row is inserted. At the time the NOTIFY is
Tom Lane wrote:
However, I'm unconvinced that the OP's complaint is valid.
I'm unconvinced that I've stated the problem clearly enough.
I would still expect any
reimplementation of notify messaging to honor the principle that a
LISTEN doesn't take effect till you commit.
Naturally, the
I use PHP.When I make juste a simple insert likeInsert Into my_table (my_field) values ('value')I get back the OID of the inserted line.But when i use the prepareInsert fonction, I get nothing back. That's a pprobleme becaus i need to take the primary key of the line inserted in order to make
Hi everyone,
can please somebody let me know what this error message is supposed to mean:
ERROR: could not open relation 1663/16858/9469857: Permission denied
Strange thing about it is that i do not have a relation with that name.
This somehow seems to go along with this other strange error
it seems as if in /pg_xlog/archive_status the respective file
0001002000D2.ready was not changed to
0001002000D2.done. Can this be done manually? About the persmission
denied error i still have absolutely no clue!
Christian Rengstl [EMAIL PROTECTED] wrote on 08/02/06
On Wed, Aug 02, 2006 at 09:25:43AM +0200, phazon wrote:
When I make juste a simple insert like
Insert Into my_table (my_field) values ('value')
I get back the OID of the inserted line.
You really don't want to use OID, you want a sequence. (Hint: OIDs are
not really unique, not a primary
am 02.08.2006, um 9:27:22 +0200 mailte Christian Rengstl folgendes:
Postgre copied the file 0001002000D2 to the specified directory
and now it says it can't be copied...I really, really don't get it!
My guess: Access Denied on the filesystem for the postgres-User.
PS.: Windows,
On Wed, Aug 02, 2006 at 09:34:25AM +0200, Christian Rengstl wrote:
it seems as if in /pg_xlog/archive_status the respective file
0001002000D2.ready was not changed to
0001002000D2.done. Can this be done manually? About the
persmission denied error i still have
Unfortunately it's windows, but nevertheless it worked now for weeks and
suddenly the postgre user should not be able to copy anymore? Besides, the file
was copied and then disappeared from the pg_xlog directory, nevertheless
postgre kept trying to copy the very same file.
A. Kretschmer [EMAIL
The thing is that the very same file was copied to the specified directory.
Martijn van Oosterhout kleptog@svana.org wrote on 08/02/06 9:43 am:
On Wed, Aug 02, 2006 at 09:34:25AM +0200, Christian Rengstl wrote:
it seems as if in /pg_xlog/archive_status the respective file
phazon wrote:
I use PHP.
When I make juste a simple insert like
Insert Into my_table (my_field) values ('value')
I get back the OID of the inserted line.
But when i use the prepareInsert fonction, I get nothing back. That's a
pprobleme becaus i need to take the primary key of the line
Disk full or otherwise problems with the disk?
I remember I saw somthing similiar some months ago and the reason was (AFAIR)
something like a full partition or a partition set to readonly, or a broken
mountpoint because of hardware errors. With Linux, not MSW.
Regards, Frank
On Wed, 02 Aug
Hi list,I have a table which is referenced with foreign keys from multiple other tables. Records in this table are deleted by on delete rules on those other tables. This means that if I want to drop one of the referencing tables, I first have to delete all records in that referencing table to
On Mon, Mar 06, 2006 at 10:15:06AM -0500, Bruce Momjian wrote:
Added for ecpg TODO:
o Add COPY TO STDIN / STDOUT handling
COPY TO STDOUT has been implemented, but I'm unsure whether COPY FROM
STDIN really makes sense. Does anyone know a real life example where
this would be needed and
* Michael Meskes:
COPY TO STDOUT has been implemented, but I'm unsure whether COPY FROM
STDIN really makes sense. Does anyone know a real life example where
this would be needed and the work couldn't be done easier using psql?
COPY FROM STDIN saves lots of network round-trips.
--
Florian
On Wed, Aug 02, 2006 at 12:03:45PM +0200, Florian Weimer wrote:
* Michael Meskes:
COPY TO STDOUT has been implemented, but I'm unsure whether COPY FROM
STDIN really makes sense. Does anyone know a real life example where
this would be needed and the work couldn't be done easier using
Hello!
I've came across recent change of
postmaster/pgstat.c with comment
regarding send/EINTR issue.
Does it make sense to amend,
for example, secure_write() in
be_secure.c (part of libpq)
in the same way?
Am I right thinking it may
fail during reloading configuration?
Is it the only dangerous
Christopher Browne wrote:
Martha Stewart called it a Good Thing when "Carlo Stonebanks" [EMAIL PROTECTED] wrote:
I am interested in finding out a "non-religious" answer to which
procedural language has the richest and most robust implementation
for Postgres. C is at the bottom of
Hi,I have performed some tests earlier on today, and i think
the problem lies with Postgres and it's bad performance when being used
with container managed persistence. I am covinced of it being an issue
with postgres because it works really well with MySQL and Hypersonic,
but not with Postgres. I
On Wed, Aug 02, 2006 at 02:57:59PM +0400, Ilja Golshtein wrote:
Hello!
I've came across recent change of
postmaster/pgstat.c with comment
regarding send/EINTR issue.
Does it make sense to amend,
for example, secure_write() in
be_secure.c (part of libpq)
in the same way?
Am I right
Andy Dale wrote:
Hi,
I have performed some tests earlier on today, and i think the problem lies
with Postgres and it's bad performance when being used with container
managed persistence.
Is your problem performance or an error? It sounded like you were
getting errors in your first post.
I create 2 temp tables on each connection to store session relevant variables.It works beautifully with code I robbed accross postgresql mailinglists:CREATE OR REPLACE FUNCTION set_quarant(mylvlquarant int4)
RETURNS int4 AS$BODY$ BEGIN perform relname from pg_class where relname = 'quara_tmp' and
In article [EMAIL PROTECTED],
Flemming Frandsen [EMAIL PROTECTED] writes:
I would still expect any
reimplementation of notify messaging to honor the principle that a
LISTEN doesn't take effect till you commit.
Naturally, the listen should not do anything at all when followed by a
rollback.
Flemming Frandsen [EMAIL PROTECTED] writes:
The listen should simply listen for events issued at the start of the
transaction it's executed in.
BEGIN;
SELECT sleep(10);
LISTEN foo;
No, I don't think so.
regards, tom lane
Christian Rengstl [EMAIL PROTECTED] writes:
Unfortunately it's windows, but nevertheless it worked now for weeks
and suddenly the postgre user should not be able to copy anymore?
Broken anti-virus software. We've seen essentially identical reports
before ...
regards,
Ilja Golshtein [EMAIL PROTECTED] writes:
Does it make sense to amend,
for example, secure_write() in
be_secure.c (part of libpq)
in the same way?
It's already done, see the only caller of secure_write ...
regards, tom lane
---(end of
Harald Armin Massa [EMAIL PROTECTED] writes:
Now I looked at system objects and detected, that schemas named PG_TEMPn,
where n is a slowly growing integer,
are created.
Those schemas seem to get more and more and more. Is anyprocess taking care
of purging the ones no longer needed?
We don't
Tom, Those schemas seem to get more and more and more. Is anyprocess taking care
of purging the ones no longer needed?We don't bother.One row in pg_namespace is not worth removing,especially when it's likely to be needed again someday.thanks for the information! Now I understand: every backend
Tom Lane wrote:
Flemming Frandsen [EMAIL PROTECTED] writes:
The listen should simply listen for events issued at the start of the
transaction it's executed in.
BEGIN;
SELECT sleep(10);
LISTEN foo;
No, I don't think so.
regards,
On 8/1/06, Carlo Stonebanks [EMAIL PROTECTED] wrote:
I have been trying to figure out where to put my plTcl questions, and where
the people most knowledgable about that topic may be – either on these mail
lists or elsewhere.
TCL is dead. Long live TCL.
PLTCL was taken out of the core
I didn't see you answer on the mail list - so please forgive the direct
reply. Thanks you very much for the response - do you develop in plTcl?
I also see that this package is for pgtcl - I am looking for server-side
support, i.e. plTcl. Where can I find that? More specifically, I am looking
for
*Alexander Bodnar
*
Try
ObjectSeqName TEXT := foobar;
EXECUTE 'CREATE SEQUENCE ' || ObjectSeqName || ' start 1 increment 1
maxvalue 2147483647';
Thanks,
Chris Steffen
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will
Michael Meskes wrote:
On Mon, Mar 06, 2006 at 10:15:06AM -0500, Bruce Momjian wrote:
Added for ecpg TODO:
o Add COPY TO STDIN / STDOUT handling
COPY TO STDOUT has been implemented, but I'm unsure whether COPY FROM
STDIN really makes sense. Does anyone know a real life example
* Michael Meskes:
Could you please explain what this has to do with my original question?
I assumed that ECPG did something special with TO STDOUT, like other
interfaces do. This is not the case (that is, STDOUT is really
standard output, so the functionality is not very useful.
--
Florian
Florian Weimer wrote:
* Michael Meskes:
Could you please explain what this has to do with my original question?
I assumed that ECPG did something special with TO STDOUT, like other
interfaces do. This is not the case (that is, STDOUT is really
standard output, so the functionality is
True, I cannot find this in the current docs - that statement about the
conditional compile was from some documentation I found from googling
pltcl_modules pltcl_modfuncs
I went back to the site i found it and snooped around and saw that it was a
copy of docs from 1998.
Sorry about the
Tom Lane [EMAIL PROTECTED] writes:
I would still expect any reimplementation of notify messaging to honor the
principle that a LISTEN doesn't take effect till you commit. Otherwise, what
of
BEGIN;
LISTEN foo;
ROLLBACK;
? If I get some events for foo after this I'd
On Wed, Aug 02, 2006 at 09:15:46AM -0400, Oisin Glynn wrote:
I was just about to say that if someone was to do the following they
would get the previously commited state of foo after the sleep not how
foo looked before the sleep otherwise every begin would need an entire
DB snapshot to be
On Wed, Aug 02, 2006 at 09:49:40AM -0400, Bruce Momjian wrote:
I assumed that ECPG did something special with TO STDOUT, like other
interfaces do. This is not the case (that is, STDOUT is really
standard output, so the functionality is not very useful.
I am confused. STDOUT is already
I would dearly love to see plPHP join the family as a real supported
language, right in the distribution.
You mean as opposed a real support language outside of the distribution?
Being in core doesn't really gain us much except a prestige moniker.
But to answer your question, there is some
Thanks again. I am wondering as to why the state changes to Transaction in
idle when a query is executed. It'll be nice if that happens only when
a real change is made (transaction starts) to the database and not when
a select query occurs.
This makes no sense. A select query is
On Wed, Aug 02, 2006 at 09:25:43AM +0200, phazon wrote:
I use PHP.
When I make juste a simple insert like
Insert Into my_table (my_field) values ('value')
I get back the OID of the inserted line.
But when i use the prepareInsert fonction, I get nothing back. That's a
pprobleme becaus i
plPHP is not as mature as plTcl (or is that plTclng). However it is very
well developed and maintained. Heck, companies are even holding talks and
training classes on it now.
What is lacking in plPHP? To be honest, even though I am a Tcl developer I
would rather develop in PHP, and I know
Carlo Stonebanks wrote:
plPHP is not as mature as plTcl (or is that plTclng). However it is very
well developed and maintained. Heck, companies are even holding talks and
training classes on it now.
What is lacking in plPHP? To be honest, even though I am a Tcl developer I
On Aug 2, 2006, at 2:07 AM, Tom Lane wrote:
that the OP's complaint is valid. I would still expect any
reimplementation of notify messaging to honor the principle that a
LISTEN doesn't take effect till you commit. Otherwise, what of
Well, it would break our usage of LISTEN/NOTIFY if they
Andy Dale wrote:
Hi,
I will explain in more details what the test (extremely simple) program is
actually doing. A session bean receives some data (roughly 3K) and then
persists this data to the database with EntityManager.persist() (using the
EJB 3.0 Persistence API that comes with JBoss).
Hi, this maybe a more general question and not limited to postgresql.We are generating some matrix like data, e.g. one object will have a fixed number 10 values, and we have currently 300 objects. We can visualized the data as a 10 by 300 matrix, and each object/column has an identifier,
On Wed, Aug 02, 2006 at 07:36:09AM -0700, Sundar Narayanaswamy wrote:
select * from ;
read rows from result set
Idle in transaction (autovacuum cannot remove dead rows)
LONG time elapses
(autovacuum cannot remove dead rows)
.
.
The last select operation is the one of concern. I was
ww.commandprompt.com/community/plphp/
Last release was 2005. This is the first release that is actually
useful, IMHO, because it allows SQL commands buried in the code, prior
releases did not.
That is actually wrong. Go here:
http://projects.commandprompt.com/public/plphp
There was
Carlo Stonebanks wrote:
plPHP is not as mature as plTcl (or is that plTclng). However it is very
well developed and maintained. Heck, companies are even holding talks and
training classes on it now.
What is lacking in plPHP? To be honest, even though I am a Tcl developer I
would rather
Joshua D. Drake wrote:
ww.commandprompt.com/community/plphp/
Last release was 2005. This is the first release that is actually
useful, IMHO, because it allows SQL commands buried in the code,
prior releases did not.
That is actually wrong. Go here:
Well I took it from your home
# [EMAIL PROTECTED] / 2006-08-02 07:57:55 +0200:
I'm bothered by listen listening from the end of the transaction in
stead of the start of the transaction.
Sorry if this isn't what you're after, instead just a question:
Why don't you issue the LISTEN in a separate transaction before
Ian Harding [EMAIL PROTECTED] writes:
PLTCL was taken out of the core distribution, and is not in contrib.
I think you confused pltcl with pgtcl. Totally different things
(pltcl is server side, pgtcl client side).
regards, tom lane
---(end of
Carlo Stonebanks [EMAIL PROTECTED] writes:
... More specifically, I am looking
for the scripts pltcl_loadmod, pltcl_listmod and pltcl_delmod mentioned in
the PostgreSQL documentation of the unknown command.
They should be in the same directory as the other postgres executables,
if you have
Yes - this statement actually came from a helpful soul who had replied but
did not realise I was talking about pltcl.
I am looking into the unknown command because I believe there may be
security issues with using spource or package commands to access proc
libraries - and that the unknown
If you don't see them, you should take it up with whoever created the
package you're using.
I thought that's what I was doing - I downloaded postgresql-8.1.4-1.zip from
http://www.postgresql.org/ftp/binary/v8.1.4/win32/
Is there somewhere else I should be directing my question?
Carlo
On 8/1/06, Reece Hart [EMAIL PROTECTED] wrote:
Eric Andrews wrote:
I am not much of a schema designer and have a general questoin about
the proper use of the array datatype. In my example, I have
destinations, and destinations can have multiple boxes, and inside
those boxes are a
Diagnosing JBossCMP issues is not for the faint of heart, in that one
of its main raison d'etre's is to hide SQL knowledge away from the
casual coder. Add into the mix the concurrency issues which naturally
occur since an EJB container is multithreaded and the overly
complicated JTA stuff
I'm working on a postgres instance (8.1.2 running on Solaris 10) where the data directory (including WAL) is being mounted on tmpfs. Based on this, and with knowledge that fsync is disabled, I'm operating under the assumption that recoverability is not a precondition for optimized performance.
hi...
i have a tbl
fooTBL
name
parentID
ID
so a name can have might have a parentID, as well as an ID. 'name's are
associated with other 'name's via the parentID. in other words, if a name's
parentID == a name's ID, name1 is the parent of name2.
name parentIDID
foo
Carlo Stonebanks wrote:
plPHP is not as mature as plTcl (or is that plTclng). However it is very
well developed and maintained. Heck, companies are even holding talks and
training classes on it now.
What is lacking in plPHP? To be honest, even though I am a Tcl developer I
would
Question,What is the difference between left join, and left outer join?I know the difference between inner and outer joins, but I was thinking that left join == inner join. But from what I am now seeing, it appears that PG is equating left join to left outer join. Is this correct?
Thanks,Chris
On Wed, 2006-08-02 at 14:32, Chris Hoover wrote:
Question,
What is the difference between left join, and left outer join?
I know the difference between inner and outer joins, but I was
thinking that left join == inner join. But from what I am now seeing,
it appears that PG is equating
I disagree. And I was the maintainer last time I checked, so you'd say
my opinion carries some weight.
Because it is not currently being worked does not mean it is not
maintained. It means that it is not currently being worked on. It is by
no means a dead project.
Heck, companies are
Yesterday a consultant upgraded me from 7.3.4
to 8.1.4 on a RedHat 9 server. To make sure everything was okay we left
the server so that both versions of Postgresql load. 7.3.4 loads on the
default port of 5432 and 8.1.4 loads on port 55432 . My database was moved
into the new version so both the
Typically, a temp table is used for this.
Beware of circular references.
Fred - Wilma - Betty - Barney - Fred
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of bruce
Sent: Wednesday, August 02, 2006 11:55 AM
To: 'PgSQL-General'
You'll need to specify the non-default port explicitly in your pg_dump command in order to back up the postmaster running on 55432.E.g., pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date+%F)owl.sql owlBy default, the postgres command-line utilities attempt to connect to 5432 (or $PGPORT or
Thomas F. O'Connell [EMAIL PROTECTED]
wrote on 08/02/2006 02:04:35 PM:
You'll need to specify the non-default port explicitly in your
pg_dump command in order to back up the postmaster running on 55432.
E.g., pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date+%F)owl.sql
owl
By default,
On 8/2/06, bruce [EMAIL PROTECTED] wrote:
hi...
i have a tbl
fooTBL
name
parentID
ID
so a name can have might have a parentID, as well as an ID. 'name's are
associated with other 'name's via the parentID. in other words, if a name's
parentID == a name's ID, name1 is the parent of
On 8/2/06, Chris Hoover [EMAIL PROTECTED] wrote:
Question,
What is the difference between left join, and left outer join?
I know the difference between inner and outer joins, but I was thinking that
left join == inner join. But from what I am now seeing, it appears that PG
is equating left
Your confirmation is correct with one slight technical exception: specifying the port doesn't technically cause the system to know which version of postgres to use.In my previous post, I forgot to mention a related note: the version of pg_dump that you're using matters slightly. pg_dump can
Your confirmation is correct with one slight
technical exception:
specifying the port doesn't technically cause the system to know
which version of postgres to use.
In my previous post, I forgot to mention a related note: the version
of pg_dump that you're using matters slightly. pg_dump
On Aug 2, 2006, at 4:27 PM, [EMAIL PROTECTED] wrote:You're correct, I cannot use the pg_dump. I get a error message that the pg_dump is aborting because of a version mismatch, then it says to use the i opt. How do I call the pg_dump from the 8.1.4 version?You'll probably need to specify an
It needed /bin in the path. Works fine
this way.
/usr/local/pgsql/bin/pg_dump -p 55432 -U postgres -C -D -f /tmp/$(date+%F)owl.sql
owl
Thank you again for your help.
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** ***
Margaret Gillon, IS Dept., Chromalloy Los
On 2 Aug 2006, Harald Fuchs wrote:
all events that have happened after the snapshot that the transaction
represents (the start of the transaction).
Here you're contradicting yourself. In your second paragraph you
state that LISTEN should get events unless later cancelled by a
ROLLBACK.
On Wed, 2 Aug 2006, Tom Lane wrote:
Flemming Frandsen [EMAIL PROTECTED] writes:
The listen should simply listen for events issued at the start of the
transaction it's executed in.
BEGIN;
SELECT sleep(10);
LISTEN foo;
No, I don't think so.
And why would that
On Wed, 2 Aug 2006, Roman Neuhauser wrote:
I'm bothered by listen listening from the end of the transaction in
stead of the start of the transaction.
Sorry if this isn't what you're after, instead just a question:
Why don't you issue the LISTEN in a separate transaction before
Folks,
This may have come up before, but I didn't see a specific answer in
the archives.
When I try to do:
CREATE TABLESPACE foo LOCATION '/path/to/foo/which/is/not/under/$PGDATA';
I get:
ERROR: could not set permissions on directory
/path/to/foo/which/is/not/under/$PGDATA
Apparently this
On Wed, Aug 02, 2006 at 04:47:36PM -0700, David Fetter wrote:
Folks,
This may have come up before, but I didn't see a specific answer in
the archives.
When I try to do:
CREATE TABLESPACE foo LOCATION '/path/to/foo/which/is/not/under/$PGDATA';
I get:
ERROR: could not set
80 matches
Mail list logo
