Will PostgreSQL 8.0 include replication server (not contrib/*) and nested transactions
support?
--
WBR, sector119
---(end of broadcast)---
TIP 8: explain analyze is your friend
Am Dienstag, 10. August 2004 10:05 schrieb [EMAIL PROTECTED]:
Will PostgreSQL 8.0 include replication server (not contrib/*) and nested
transactions support?
No and yes.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
---(end of
I'm looking at a database-using program (PostgreSQL/libpq and MySQL) which
does the following: A daemon process opens a database connection, forks
children on request, and those children access the database using that
inherited connection. After one request, the child dies. It seems to me
On Tue, 2004-08-10 at 02:05, [EMAIL PROTECTED] wrote:
Will PostgreSQL 8.0 include replication server (not contrib/*) and nested
transactions support?
What difference does it make if replication is contrib/* or an external
project or integrated? It's still the same thing. Plus, there are
Thanks to all Developers, GREAT JOB!
Just switched from 7.4 cygwin to 8 beta native win32 on my development
system. Everything works so far!
Just a small suggestion for now:
Can you enable file logging (redirect_stderr = true) in the windows
installer by default. I think without you'll see no
Scott Marlowe wrote:
On Tue, 2004-08-10 at 02:05, [EMAIL PROTECTED] wrote:
Will PostgreSQL 8.0 include replication server (not contrib/*)
and nested transactions support?
Slony-I just came out in beta, and it appears to be quite a nice
replication system.
I wonder if it would be a good idea from
As to Slony:
in a few slavonic languages (I know about Czech, Slovak, Russian, maybe others
too, slony is the plural of slon, e.g. elephant. Thus Slony = Elephants.
Cheers
Zoltan
Da Utorok 10. August 2004 11:51 ste napsali:
Scott Marlowe wrote:
On Tue, 2004-08-10 at 02:05, [EMAIL
Hi!
just playing with tablespaces...
- moved a existing table to a new tablespace
- tried to move it back to default tablespace
(ALTER TABLE accounts SET TABLESPACE pg_default;)
Got the following error in logfile:
ERROR: could not create relation 1663/317186/317191: Permission denied
Any
Am Dienstag, 10. August 2004 11:51 schrieb Mike Mascari:
I wonder if it would be a good idea from a propaganda perspective to
include a reference to Slony-I in the press release and possibly the
release notes? Or would such an imprimatur be inappropriate?
It will probably be in the press
Title: row level lock
Hello,
I thought that with the new release I could lock at row level with nowait option, but it seems that nowait option is only for table level lock, so, Can I do a row level lock with nowait option?
Thanks,
pere
Hi,
What about
mydb=# \dv
??
Doesn't it works fine. I don't see any pg views.
Regards,
Kaloyan
Olivier Guilyardi wrote:
Hi,
I'm trying to list views, eliminating internal ones from the output.
Using 7.2, I found this simple statement :
SELECT viewname FROM pg_views WHERE viewname !~ '^pg_';
It
Hi,
I'm looking at the logging of a database we'll put in production soon.
I've seen some posts on this list about history tables, like mentioned in
http://www-106.ibm.com/developerworks/web/library/wa-dbdsgn2.html .
I think I'll go that way too, but I still have some questions on the approach,
On Tuesday 10 August 2004 03:14, Olivier Guilyardi wrote:
SELECT viewname FROM pg_views WHERE viewname !~ '^pg_';
with 7.4 :
SELECT viewname FROM pg_views WHERE schemaname NOT IN
('pg_catalog','information_schema');
Albert
---(end of
On Tue, 10 Aug 2004, Igor Kryltsov wrote:
Table looks like:
select * from test;
name | code | master
--+---+
ABC | 15074 |
ABC1 | 0 | ABC
ABC2 | 0 | ABC
EKL | 15075 |
EKL1 | 0 | EKL
(5 rows)
Now I need to replace 0 values in code column by
Igor Kryltsov [EMAIL PROTECTED] writes:
Now I need to replace 0 values in code column by corresponding code
values by following link between master field in a record where code=0 and
name field where it is not.
This update works in MSSQL but in Postgres it replaces code values as shown
Raphael Bauduin [EMAIL PROTECTED] writes:
- is it possible to write only one function used for all logging triggers?
Yes, but it will be very hard and inefficient (maybe even impossible)
in plpgsql. plpgsql isn't intended for dynamic field access and you'll
really be fighting the language.
I have been able to crash the server a few times with the following function
when it is called on a user and schema that was recently deleted. Following
is a log of what happened and also the function that was called. This is
7.4.3 on Freebsd 5.2.1. It doesn't always panic when it encounters a
This is the way you do it in postgreSQL:
UPDATE
test
SET
code=T2.code
FROM
test T2
WHERE
test.code=0 AND
test.master=T2.name;
you need to specify the join condition in the WHERE clause.
On Tue, 2004-08-10 at 00:34, Igor Kryltsov wrote:
Hi,
If you can help me to correct my mistake.
Brigitte ROLLAND wrote:
Hello !
I need to intreact from VB6 with an PG 7.4.3 database, I've
psqlodbc-7_03_0200 installed.
I use the Microsoft ADO Data Control 6.0, and I've installed the SP5 for
VB6.
Luc,
I have never used the ADO Data Control, so I can't be much help there -
I can tell
Thank you much,
When I perform the google search:
http://www.google.com/search?q=slony-i+review
I do not find reviews and critiques of slony-i. Are there many companies
using for their enterprise level database systems? Without reviews in the
magazines, my bosses uncomfort with PostgreSQL will
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Dan Ruthers wrote:
| Now, if I run this query (note the int8 cast - also tried with the '' cast to
String, same results):
| test= explain select * from dmaildatum where idparent=int8(783219);
| QUERY PLAN
|
eWeek has reviewed Bricolage, the Perl-powered, PostgreSQL-backed
open-source content management system. The article was published
yesterday. An excerpt:
Bricolage is quite possibly the most capable enterprise-class
open-source application available. The Web content management
application
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Marc G. Fournier wrote:
| On Tue, 10 Aug 2004, Rajesh Kumar Mallah wrote:
|
|
| The beta link under ftp://ftp3.us.postgresql.org/pub/postgresql/
| and possible all mirrors leads to nowhere. I guess many people
| would click there.
|
|
| Already fixed
At 8/10/04 9:30 AM, [EMAIL PROTECTED] wrote:
Slony-I is released... [snip]
Also, what is the etymology of the term Slony?
Elephants, especially this one: http://slony.info
Is the project called Slony-1 or Slony1 (numeral one), or Slony-I
(uppercase i)?
It appears to be referred to
On Mon, 9 Aug 2004, Dan Ruthers wrote:
Now, if I run this query (note the int8 cast - also tried with the '' cast to
String, same results):
test= explain select * from dmaildatum where idparent=int8(783219);
QUERY PLAN
Created a pg_dump with Fc (custom format compression) that resulted in a
300+MB file. Now trying to pg_restore this thing fails with either an
out of memory error (as in the subject line) on FreeBSD 4.10-STABLE or
a:
pg_restore in malloc(): error: allocation failed
Abort (core dumped)
error on
Dan Ruthers wrote:
The index is used!
I also did a vacuum analyze, and restarted Postgres and it did not
make any difference. I tried many other ID values (ex 783218 and
783220), and they seem to use the index correctly. Only that value
doesn't.
Possibly, that is the most common value and
Marc G. Fournier wrote:
For a complete list of changes/improvements since 7.4.0 was released,
please see:
http://developer.postgresql.org/beta-history.txt
I think is better write in the Win32 Native Server section that Postgres
is only available on Win32 with NTFS file system.
Regards
In general, it seems to correspond to when there are a lot of inserts being
run. I have one application that maybe does 10 inserts within 15 seconds or
so, at which point the problem seems to crop up.
Any operation that does not use the qualified schema.entity names will error
out (selects,
Rob Klaus [EMAIL PROTECTED] writes:
We are having a problem where intermittently a query will not work,
returning an error:
ERROR: Relation x does not exist
It will do this for a variable period, typically not lasting more than 5
minutes
This certainly seems like a bug, but I have no idea
Can psql be told to exit immediately after an error (especially when
doing commands from a file, -f)? This is the default behaviour of the
mysql client, except when we give it -f option (force).
The problem is, when restoring a dump, a failure at the some point might
cause the subsequent
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Rajesh Kumar Mallah wrote:
|
| The beta link under ftp://ftp3.us.postgresql.org/pub/postgresql/
| and possible all mirrors leads to nowhere. I guess many people
| would click there.
It works for me.
Regards
Gaetano Mendola
-BEGIN PGP
David Garamond wrote:
-- plruby 0.4.2, ruby 1.8.1, pg 7.4.3, linux
Just to note here that the plruby has fixed this issue. He apparently
does not read -general daily, so I'll post to ruby-talk mailing list in
the future.
--
dave
---(end of
Most people are using Sloney for master/slave replication. You can
search for it easily.
---
Liam Lesboch wrote:
Greetings,
Yesterday theres was a brief discuissions about replications software for
PostgreSQL. My
The beta link under ftp://ftp3.us.postgresql.org/pub/postgresql/
and possible all mirrors leads to nowhere. I guess many people
would click there.
Regds
mallah.
Gaetano Mendola wrote:
Marc G. Fournier wrote:
After almost 9 months of development, the PostgreSQL Global
Development Group is proud
Jeff [EMAIL PROTECTED] writes:
I've been bit by this sort of thing before. When you fork() the child
inherits all the file descriptors , including the one connected to PG.
But when the child dies that FD will be closed, thus it will also be
closed in the parent causing odd behavior.
I did the pg_dump with the Linux 7.4.3 version and tried to pg_restore
with Win32 8beta1 version and I got:
C:\TEMPpg_restore -d desarrollo -i -U postgres xdump
pg_restore: [archiver] input file does not appear to be a valid archive
Taken from the help
For best results, however, try to use the
I have varchar column with both numbers and letters, like 1 thru 10 and
5A thru 5G, they are unit numbers for apartments. If I have 1 thru 100,
since it is a varchar field, it sorts like 1,10,11... instead of
1,2,3...
Is there any way to handle this without having to make a sort order
column?
--
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John Haney wrote:
| Postgresql 7.4.3-1 under Cygwin.
|
| I created a table called ServerTypes:
|
| CREATE TABLE ServerTypes(
| ServerTypeID SERIAL UNIQUE NOT NULL,
| Type TEXT PRIMARY KEY);
|
| Works fine.
|
| Now, I want to
Tom Lane wrote:
Sven Willenberger [EMAIL PROTECTED] writes:
pg_restore in malloc(): error: allocation failed
Abort (core dumped)
A stack trace from that core file would be useful in figuring out what
the problem is... also, what PG version is this?
regards, tom lane
psql -V
psql (PostgreSQL)
Sven Willenberger [EMAIL PROTECTED] writes:
pg_restore in malloc(): error: allocation failed
Abort (core dumped)
A stack trace from that core file would be useful in figuring out what
the problem is... also, what PG version is this?
regards, tom lane
Chris Ochs [EMAIL PROTECTED] writes:
ERROR: invalid user ID: 194
PANIC: error during error recovery, giving up
LOG: server process (PID 38302) was terminated by signal 6
Can you get a stack traceback from this crash? The only occurrence of
invalid user ID: that I see in the source code is
sorry, i wrote the funciton wrong. here is what i meant to write:
CREATE OR REPLACE FUNCTION public.sample(varchar)
RETURNS SETOF record AS
'
DECLARE
row RECORD;
BEGIN
LOCK TABLE table1 IN ROW SHARE MODE;
FOR urlrow in EXECUTE \'SELECT * FROM table1\'
LOOP
UPDATE table1 SET col1=5 WHERE
On Tue, 2004-08-10 at 14:45, Jonathan Barnhart wrote:
Is there a way to continue a transaction after an error? I've got a
situation where I have a transaction open and I'm inserting data, but
some of it could fail on validation. I want to keep the good stuff,
leave out the bad, and get the
will locks work inside functions or only in transactions?
will this lock?
CREATE OR REPLACE FUNCTION public.sample(varchar)
RETURNS SETOF record AS
'
DECLARE
row RECORD;
BEGIN
LOCK TABLE URL IN ROW SHARE MODE;
FOR urlrow in EXECUTE \'SELECT * FROM table1\'
LOOP
UPDATE table1 SET
Thes slashdots post today about the beta releases of 8.0 caught the
attention of my boss and I. Many comments about the replicator issue and saw
many posts about Slony-I in particular. Maybe this is the only viable option
in PostgreSQL? There are others that cost money but no where did we
On Tue, 2004-08-10 at 16:53, Liam Lesboch wrote:
Thes slashdots post today about the beta releases of 8.0 caught the
attention of my boss and I. Many comments about the replicator issue and saw
many posts about Slony-I in particular. Maybe this is the only viable option
in PostgreSQL? There
If your string *always* begins with a numeral, this will work:
ORDER BY to_number(text_field, text()), text_field
If it doesn't always begin with a numeral, you have to ensure that it does, so a
textcat of zero
ensure it does...
ORDER BY to_number(textcat('0', text_field),
On Tue, Aug 10, 2004 at 08:54:45PM -0400, Robert Fitzpatrick wrote:
I have varchar column with both numbers and letters, like 1 thru 10 and
5A thru 5G, they are unit numbers for apartments. If I have 1 thru 100,
since it is a varchar field, it sorts like 1,10,11... instead of
1,2,3...
Is
Chris Travers wrote:
lec wrote:
Scott Marlowe wrote:
On Sun, 2004-08-08 at 19:43, lec wrote:
Hi,
I'm observing the following:
If I commit the following records 1,2,3,4,5,6,7,8,9,10 to the
database and the server hangs, I could lose records 5,6,7,8,9 but
record 10 is there. How is this
Chris Ochs [EMAIL PROTECTED] writes:
ERROR: invalid user ID: 194
PANIC: error during error recovery, giving up
LOG: server process (PID 38302) was terminated by signal 6
Can you get a stack traceback from this crash? The only occurrence of
invalid user ID: that I see in the source code is in
I am getting 'postmaster does not shut down' when trying to stop the
database with '.../pg_ctl -D /path/to/datadir stop -m fast. How should I
proceed to get the database shut down and restarted? Are there other
options besides immediate shutdown flag? I dont' want to lose everything
I've worked on
BTW Joe,
I sent my earlier suggestion to you directly. You might want to talk to your
email admin to find out why your server bounced a perfectly innocuous
message thusly:
[EMAIL PROTECTED]:
12.47.0.10 failed after I sent the message.
Remote host said: 550 Message Returned: For some reason, your
Your shared buffers are almost certainly not the problem here. 2000
shared buffers is only 16 Megs of ram, max. More than likely, the
database filled up the data directory / partition because it wasn't
being vacuumed.
Yes.
Also check to make sure that some rogue process somewhere isn't
Christian Traber wrote:
Hi!
just playing with tablespaces...
- moved a existing table to a new tablespace
- tried to move it back to default tablespace
(ALTER TABLE accounts SET TABLESPACE pg_default;)
Got the following error in logfile:
ERROR: could not create
I would think that depends upon how the sql in the file is coded. You can use the
RAISE NOTICE / ERROR commands to abort a function's execution.
Can psql be told to exit immediately after an error (especially when
doing commands from a file, -f)? This is the default behaviour of the
mysql
what does it mean when one lock mode conflicts with another like is
says in the documentation? can somebody explain and maybe give an
example.
thanx, amir
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an
Amir Zicherman [EMAIL PROTECTED] writes:
what does it mean when one lock mode conflicts with another
It means that a holder of the one lock type will block a requestor
of the other lock type (on the same lockable object, of course).
regards, tom lane
Rajesh Kumar Mallah wrote:
are you able to create new tables in the default tablespace ?
Yes, permissions are ok.
looks
like a permission issue did you initdb a fresh folder see if the
owner of $PGDATA/data/base is the user that running postmaster
(usually postgres) . It works fine for me
59 matches
Mail list logo