i'm redirecting you to -general because -hackers is not the place for
this question.
some answers below
On 8/2/06, Yoon <[EMAIL PROTECTED]> wrote:
I was trying postgres for about a year and the hard drive died.
Using some block copy and other tools I was able to retrieve some data
however it's
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 se
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, 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 bef
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
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
> ROLL
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 Angeles
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 absolut
> 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
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 typical
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 j
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 na
"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 d
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 whatever
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'
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
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 e
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 equat
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
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
> wou
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
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. With
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 a
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
> 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
--
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 "unkn
"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
"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 o
# [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
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 pag
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 develo
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 a
On Wed, Aug 02, 2006 at 07:36:09AM -0700, Sundar Narayanaswamy wrote:
> select * from ;
> read rows from result set
> (autovacuum cannot remove dead rows)
>
> (autovacuum cannot remove dead rows)
> .
> .
> The last select operation is the one of concern. I was just raising the point
> that s
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, ea
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). Onc
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 di
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
> 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
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
> >
> > 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
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 wo
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 al
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 b
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 t
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 conf
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 functionalit
* 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 W
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 e
*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 ignore
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 t
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 d
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
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
"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?
"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 br
"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 ...
regar
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
---
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
>
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
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.
>
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
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.
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
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
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 usi
* 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 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 an
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 ensur
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 20
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 inserte
The thing is that the very same file was copied to the specified directory.
Martijn van Oosterhout 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
>> 0001002000D2.ready was
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" <[EMA
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 absolu
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: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 prima
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
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 mess
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 post-
78 matches
Mail list logo
