On Tue, 2004-08-10 at 19:30, lec wrote:
> Chris Travers wrote:
> The first hardware that got replaced was the SCSI controller. After
> that there were still hardware "hanging" and eventually the system
> engineers replaced the whole server and they weren't sure what the fault
> was. The lost
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 thoug
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
-
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 appropriate
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
> mysq
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 re
> 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 f
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, you
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
"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 i
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 possibl
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...
>
>
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), text())
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? Th
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 surfac
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"
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 th
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 WHE
"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
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
--
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
-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
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?
--
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:\TEMP>pg_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
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
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 to
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
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 broadcast)--
-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 SIGNATURE
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 comm
"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
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, inser
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
Gaetan
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 an
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 Fre
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
> --
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 referr
-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 fix
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 feat
-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
|
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 no
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 t
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
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
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.
"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 value
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
Title: nested transaction
Hello,
The new release includes savepoints, but I need to do a begin inside another begin and a commit/rollback after another commit/rollback.
For example, I have a pA procedure that update some data, so this procedure execute a begin, after manipulate data and end
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 broadcast)-
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, an
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
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
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 rel
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 suggestio
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
Dňa Utorok 10. August 2004 11:51 ste napísali:
> Scott Marlowe wrote:
> > On Tue, 2004-08-10 at 02:05, [EMAIL P
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
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 lo
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
cur
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
th
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 broadcast)---
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
61 matches
Mail list logo
