Brian Hirt wrote:
I got an error doing a vacuum analyze on one of our table:
MSG: 7 (S1000): ERROR: simple_heap_update: tuple concurrently updated
does anyone know what this means, and more importantly... should i be
worried about this?
Are you by chance running analyze concurrently?
At
http:
I got an error doing a vacuum analyze on one of our table:
MSG: 7 (S1000): ERROR: simple_heap_update: tuple concurrently updated
does anyone know what this means, and more importantly... should i be worried about this?
i'm running 7.3.2 on redhat 7.3 dual 1.8 xeon with 1gb ram.
On Friday 21 November 2003 09:33 pm, Lamar Owen wrote:
> On Friday 21 November 2003 09:15 pm, milimeter wrote:
> > errors: ->
> > An old version of the database format was found.\nYou need to upgrade
> > the data format before using PostgreSQL.\nSee
> > /usr/share/doc/postgresql-7.4/README.rpm-
On Friday 21 November 2003 09:33 pm, Lamar Owen wrote:
> On Friday 21 November 2003 09:15 pm, milimeter wrote:
> > errors: ->
> > An old version of the database format was found.\nYou need to upgrade
> > the data format before using PostgreSQL.\nSee
> > /usr/share/doc/postgresql-7.4/README.rpm-
On Friday 21 November 2003 09:15 pm, milimeter wrote:
> errors: ->
> An old version of the database format was found.\nYou need to upgrade
> the data format before using PostgreSQL.\nSee
> /usr/share/doc/postgresql-7.4/README.rpm-dist for more information.
> <--
Argh. Typo. Replace /etc/
Hello, everybody
Thanks to Lamar Owen that I downloaded the rpms for Fedora Core 1 which
I expected all the time after 7.4 was released.
But I found a somewhat weird problem with it. My fedora installation has
no postgresql at all, then I installed all rpms of 7.4, and then run
"service postgresq
On Friday 21 November 2003 01:13 pm, Lamar Owen wrote:
> I have uploaded a first cut at the RPM's to ftp.postgresql.org. While I am
> not 100% convinced of the need to do so, I have restructured the
> directories, and await comment on that.
> I expect RH 7.3, RH9, and RH 6.2 packages shortly fro
I have uploaded a first cut at the RPM's to ftp.postgresql.org. While I am
not 100% convinced of the need to do so, I have restructured the directories,
and await comment on that.
Currently the upload is for Fedora Core 1 only. The source RPM should compile
on most recent Red Hat's and close
On Fri, 2003-11-21 at 11:20, Keith C. Perry wrote:
>
>
> As previously mentioned you could just go with an ISP that has already been
> running PostgreSQL for some time. I've notice quite a few service providers on
> the list. Some are probably listed on techdocs but I noticed my entry hasn't
>
"Patrick Hatcher" <[EMAIL PROTECTED]> writes:
> Trying to dump data from my database using:
> pg_dump -a -Ft -b mdc_oz > mdc.tar
> And I keep receiving the following error:
> pg_dump: [tar archiver] could not write to tar member (wrote 3, attempted
> 203)
IIRC, the -Ft mode requires dumping into
Carmen Gloria Sepulveda Dedes wrote:
Hello!
Can I execute VACUUM ANALYZE from ecpg?
How I do that???
/*
I do: EXEC SQL VACUUM ANALYZE ;
But I get error: 'ERROR: VACUUM cannot run inside a transaction block'
*/
Turn on/off autocommit maybe?
Or fake it with "EXEC SQL COMMIT; VACUUM ANALYZE" ?
Jason Tesser wrote:
> I saw that there is a PAM module for Postgre.
Just out of curiosity, where did you get the notion that the shorthand
for PostgreSQL is "Postgre" and not "Postgres" ?
Marc, would it be possible to have a TIP that reads:
"Postgres + SQL = PostgreSQL"
In fact, could you use
Andrei Ivanov <[EMAIL PROTECTED]> writes:
> template1=> select pg_get_viewdef('pg_tables'::regclass);
> ERROR: nodeRead: did not find '}' at end of plan node
> template1=> select pg_get_viewdef('pg_indexes'::regclass);
> ERROR: nodeRead: did not find '}' at end of plan node
Bizarre. I just chec
Trying to dump data from my database using:
pg_dump -a -Ft -b mdc_oz > mdc.tar
And I keep receiving the following error:
pg_dump: [tar archiver] could not write to tar member (wrote 3, attempted
203)
Any idea what this could be? I've dump other database on the same server
without issue
Patrick
[EMAIL PROTECTED] writes:
> I am not seeing the same news coverage being said about Postgresql.
MySQL AB recently got ~ $20M in venture funding, and they are investing
large chunks of it in marketing. We just have to weather the ad campaign.
At the rate they're going they'll be through that money
Denis Gasparin <[EMAIL PROTECTED]> writes:
> CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCREATEUSER;
> CREATE SCHEMA AUTHORIZATION aaa;
> All worked fine.
> The problem is in the pg_dumpall file.
> SET SESSION AUTHORIZATION aaa;
> CREATE SCHEMA aaa;
This is fixed in 7.4 --- I get
CREATE SCHEMA a
Quoting Robert Treat <[EMAIL PROTECTED]>:
> On Fri, 2003-11-21 at 04:41, Holger Klawitter wrote:
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > Am Friday 21 November 2003 09:49 schrieben Sie:
> > > > i am a newbie to the pgsql world, so pls bear with a possibly stupid
> > > > quest
I'm restoring it as the superuser.
You can try to execute the commands directly from psql.
Denis
Doug McNaught wrote:
Denis Gasparin <[EMAIL PROTECTED]> writes:
Looking into the generated sql, i find that the schema is created with
the command:
CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCRE
Bruce Momjian <[EMAIL PROTECTED]> writes:
> The one problem with the signal approach is how long does the system
> wait before giving up on the app shutdown? Seems that should be
> something controllable by the admin, but without shutdown scripts, it
> isn't.
I believe 20 seconds is the standard
If you'd like to head up this list, I'm sure people will answer any
questions you might have. Getting the two communities to agree will be
tricky, for example, you would have to break down the features into
minute detail: support subselects in SELECT clause, supports subselects
in FROM clause, supp
Tom Lane wrote:
> Alex Satrapa <[EMAIL PROTECTED]> writes:
> > On Mac OS X (desktop version, at least) there are no shutdown scripts.
> > All running applications are simply sent the "TERM" signal, then later
> > sent the "KILL" signal. Luckily enough, PostgreSQL seems to respond to
> > TERM by
On Fri, Nov 21, 2003 at 07:13:46 -0600,
Jason Tesser <[EMAIL PROTECTED]> wrote:
>
> If I did that could I use a table in Postgre as a groups table so I can control
> who can go where or who can see what in a web app? I was wondering if Postgre
> had some built in functions that could help me
Holger Klawitter <[EMAIL PROTECTED]> writes:
>> No. The "make install" step requires a root access.
> Wrong! If you install into a writeable directory e.g.
> ./configure --prefix=/home/user/postgres
> make install will work just fine (or at least it did with me).
> The only problem is that you
Denis Gasparin <[EMAIL PROTECTED]> writes:
> Looking into the generated sql, i find that the schema is created with
> the command:
>
> CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCREATEUSER;
>
> SET SESSION AUTHORIZATION aaa;
> CREATE SCHEMA aaa;
>
> This fails giving me the following error:
>
Hello!
Can I execute VACUUM ANALYZE from ecpg?
How I do that???
/*
I do: EXEC SQL VACUUM ANALYZE ;
But I get error: 'ERROR: VACUUM cannot run inside a transaction block'
*/
Thanks for your help.
CG
---(end of broadcast)---
TIP 2: you can ge
On Fri, 21 Nov 2003, Markus Wollny wrote:
> Hello!
>
> > Von: Oleg Bartunov [mailto:[EMAIL PROTECTED]
> > Gesendet: Freitag, 21. November 2003 13:06
> > An: Markus Wollny
> > Cc: [EMAIL PROTECTED]
> >
> > Word length is limited by 2K. What's exactly the word
> > tsearch2 complained on ?
> > 'Llanf
On Fri, 21 Nov 2003 20:22:17 +0900, Alex <[EMAIL PROTECTED]> wrote:
>Hi,
>is it possible to concatenate two rows (same or different data type)
>into one.
>like First Name, Last Name or ZIP City etc.
If you meant to concatenate two *columns*, it goes like
SELECT firstname || ' ' || las
I created a user with no superuser privileges:
CREATE USER aaa PASSWORD 'bbb' NOCREATEDB NOCREATEUSER;
Then i created an authorization schema:
CREATE SCHEMA AUTHORIZATION aaa;
All worked fine.
The problem is in the pg_dumpall file.
Looking into the generated sql, i find that the schema is cre
Hello!
> Von: Oleg Bartunov [mailto:[EMAIL PROTECTED]
> Gesendet: Freitag, 21. November 2003 13:06
> An: Markus Wollny
> Cc: [EMAIL PROTECTED]
>
> Word length is limited by 2K. What's exactly the word
> tsearch2 complained on ?
> 'Llanfairpwllgwyngyllgogerychwyrndrobwantysiliogogogoch'
> i
Hi,
On Fri, Nov 21, 2003 at 06:27:01AM -0600, Jason Tesser wrote:
> I am looking into using PostgreSQL on the backend here. I work for a Bible College.
> We are putting together a
> new software package. The database would be on a LInux box but our domain is M$ so
> we use active
> directo
On Fri, Nov 21, 2003 at 06:27:01AM -0600, Jason Tesser wrote:
> I am looking into using PostgreSQL on the backend here. I work for a Bible College.
> We are putting together a
> new software package. The database would be on a LInux box but our domain is M$ so
> we use active
> directory. I
On Fri, Nov 21, 2003 at 03:39:42PM +0530, Durai wrote:
> The script content is:
>
> # cat testpgsql.php
>
> $dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test user=postgres");
> $result = pg_exec ($dbconn, "update table2 set C2=C2+1;");
> $result = pg_exec ($dbcon
Julian North wrote:
Hi,
I am in the process of porting a number of large MSSQL databases to
Postgres.
The current id generation model in SQL server is an oracle style sequence
generator i wrote using a pretty simple stored proc and table structure.
I now need to do the same thnig in postgres.
In
Durai wrote:
Hello Sridhar,
Now, It works. Thanks lot.
But Still I have doubt:
1. How MySQL works in this case? It has any default "autocommit"?
Depends. What version of mysql you are using? If you are using mysql 3.x and/or
non-innodb tables, you don't have transactions in
I am looking into using PostgreSQL on the backend here. I work for a Bible College.
We are putting together a
new software package. The database would be on a LInux box but our domain is M$ so we
use active
directory. I saw that there is a PAM module for Postgre. My question is with
applic
Hello Sridhar,
Now, It works. Thanks lot.
But Still I have doubt:
1. How MySQL works in this case? It has any default "autocommit"?
2. Is there any other method to test for "concurrent testing"?
Regs,
Durai.
- Original Message -
From: "Shridhar Daithankar" <[EMAIL
On Fri, 21 Nov 2003, Markus Wollny wrote:
> Hello!
>
> I'm currently testing deployment of tsearch2 on our forum table. The
> table is huge in itself - some 2GB of data without the indexes. I have
> got PostgreSQL 7.4RC2 running on a test machine, installed tsearch2 to
> my database, added the new
Damn.. I forgot to begin the transaction..
Shridhar Daithankar wrote:
Durai wrote:
Hello Shridhar,
The script content is:
** *# cat te**stpgsql.php*
*
*
$dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test
user=postgres");
$result = pg_exec ($dbconn, "begin;");
$resu
Hello Sridhar,
No. Still Its not working.
I used the following command.
# bin/ab -c 5 -n 50 http://127.0.0.1:7070/testpgsql.php
I got the following error:
test=# ERROR: deadlock detected
ERROR: deadlock detected
WARNING: COMMIT: no transaction in progress
WARNING: COMMIT: no transaction in
All,
thanks for the many suggestions
Alex
Manfred Koizar wrote:
On Thu, 20 Nov 2003 16:52:37 +0900, Alex <[EMAIL PROTECTED]> wrote:
Is there an easy way to write a select statement that returns me the
frist free number or any within the range of 200?
For example if 1-30, and 32-50 are occupied
Hi,
is it possible to concatenate two rows (same or different data type)
into one.
like First Name, Last Name or ZIP City etc.
Thanks
Alex
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Hello!
I'm currently testing deployment of tsearch2 on our forum table. The
table is huge in itself - some 2GB of data without the indexes. I have
got PostgreSQL 7.4RC2 running on a test machine, installed tsearch2 to
my database, added the new column to the table and tried to update it in
the rec
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Am Friday 21 November 2003 09:49 schrieben Sie:
> > i am a newbie to the pgsql world, so pls bear with a possibly stupid
> > question. i want to test out pgsql but i only have a shared hosting
> > account. is it possible to install pgsql without root a
Durai wrote:
Hello Shridhar,
The script content is:
**
*# cat te**stpgsql.php*
*
*
$dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test
user=postgres");
$result = pg_exec ($dbconn, "update table2 set C2=C2+1;");
$result = pg_exec ($dbconn, "update table2 set C2=C2-
Użytkownik Durai napisał:
> Hello Shridhar,
>
> The script content is:
> ** *# cat te**stpgsql.php*
> *
> *
> $dbconn = pg_connect("host=172.16.1.158 port=5432 dbname=test
user=postgres");
> $result = pg_exec ($dbconn, "update table2 set C2=C2+1;");
> $result = pg_exec ($dbcon
Hello Shridhar,
The script content
is:
# cat testpgsql.php
$dbconn =
pg_connect("host=172.16.1.158 port=5432 dbname=test user=postgres");$result
= pg_exec ($dbconn, "update table2 set C2=C2+1;");$result = pg_exec
($dbconn, "update table2 set
C2=C2-1;");pg_close($dbc
Durai wrote:
Hi All,
I tested "concurrent testing" in MySQL. It works fine. But I
couldn't do in PostgreSQL 7.3.4 on HPUX IPF. I got deadlock problem. I
used the PHP script to update table( one script increment the column &
another one decrement the column). Is the postgres suppo
Hi Pavel,
Thanks for that.
I hadn't realised there was support for proper sequences.
Usual asking before fully researching.
Thanks,
Julian.
-Original Message-
From: Pavel Stehule [mailto:[EMAIL PROTECTED]
Sent: 21 November 2003 09:42
To: Julian North
Cc: '[EMAIL PROTECTED]'
Subject:
Without wanting to get flamed for gratuitous advertising, my company
offers shared hosting with PostgreSQL 7.4. I'll leave it at that.
Just to make it fair I'll say ditto, then ;)
No. The "make install" step requires a root access.
That's not true, so long as your ./configure --prefix has been se
Hello
why can't use normal sequence? There isn't difference betwen Oracle and
PostgreSQL?
http://www.postgresql.org/docs/7.3/static/sql-createsequence.html
regards
Pavel
On Fri, 21 Nov 2003, Julian North wrote:
> Hi,
>
> I am in the process of porting a number of large MSSQL databases to
On Thu, 20 Nov 2003, Tom Lane wrote:
> Andrei Ivanov <[EMAIL PROTECTED]> writes:
> > select * from pg_rewrite where ev_class = 'pg_user'::regclass gives
> > [ lots of cruft ]
>
> Well, that's interesting, because I get exactly the same data from my
> perfectly-functional 7.3.4 installation.
>
Hi All,
I tested "concurrent testing" in MySQL. It works
fine. But I couldn't do in PostgreSQL 7.3.4 on HPUX IPF. I got deadlock
problem. I used the PHP script to update table( one script increment the
column & another one decrement the column). Is the postgres support the
co
Hi,
I am in the process of porting a number of large MSSQL databases to
Postgres.
The current id generation model in SQL server is an oracle style sequence
generator i wrote using a pretty simple stored proc and table structure.
I now need to do the same thnig in postgres.
In MSSQL I was able t
Hiya,
Without wanting to get flamed for gratuitous advertising, my company
offers shared hosting with PostgreSQL 7.4. I'll leave it at that.
Apologies in advance to anyone I've offended.
Regards
Tony.
Francois Suter wrote:
i am a newbie to the pgsql world, so pls bear with a possibly stupid
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
strk <[EMAIL PROTECTED]> writes:
> Does with(isStrict) still work ?
regression=# create function foo(int) returns int as
regression-# 'select $1' language sql with(isStrict);
CREATE FUNCTION
regression=# select version();
version
-
56 matches
Mail list logo
