"Hiroshi Inoue" <[EMAIL PROTECTED]> writes:
> How about starting new transaction automatically after committing
> "create user ..." at backend side if "create user" is the first command
> of the transaction ?
So then
begin;
create user ...;
rollback;
would do the wrong th
carl garland wrote:
> > Don't even think about 10 separate tables in a database :-(.It's
> >not so much that PG's own datastructures wouldn't cope,as thatvery
> >few Unix filesystems can cope with 10 filesin a directory.You'd
> >be killed on directory search times.
>
On Wed, May 31, 2000 at 09:23:27PM -0400, Bruce Momjian wrote:
> > 3. Mailing Lists. We use software that allows us to use remote sites for
> >'mail relaying'. Basically, instead of our central server having to
> >service *all* remote addresses, it offloads email onto remote servers
> >
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Thomas Lockhart
>
> > I have to create users via an ODBC connection, but I get this error:
> > CREATE USER: may not be called in a transaction block
> > With psql I have no problems. Any body knows w
> I have to create users via an ODBC connection, but I get this error:
> CREATE USER: may not be called in a transaction block
> With psql I have no problems. Any body knows what is happening?
Yeah. There are too many transaction block wrappers (BEGIN/COMMIT
statements) in the ODBC driver. I'm
>We support servers on NT, but not on Win95/98. Cygwin supports both,
What's the performance like?
NT doesn't do forks well and Postgres uses forks right?
Cheerio,
Link.
Not sure this belongs in the FAQ. Seems more of a web page thing.
>
> Due to a recent thread started on pgsql-hackers, I'm posting this to the
> lists. Vince is planning on putting in appropriate links for some of
> this, and, Bruce, can we maybe put it into the FAQ?
>
> I'm not an English m
Jerry Lynde wrote:
>
> Hello out there,
>
> I'm having a problem with a production server. Actually, there are two
> problems. The semi-trivial problem is that Postgres won't die using the
> service mechanism. As root, I "service postgres stop" and then "service
> postgres start" after a
mikeo wrote:
>
> hi,
> in oracle you would use these two cursors to determine who was connected and
> what they were doing.
>
> select distinct s.sid sid, s.serial# serial, s.status status, osuser, spid ,
> count(o.sid) counter, s.username username, s.program program, sql_address
> from v$sessio
Jerry Lynde wrote:
>
> I'm having a problem with a production server. Actually, there are two
> problems. The semi-trivial problem is that Postgres won't die using the
> service mechanism. As root, I "service postgres stop" and then "service
> postgres start" after a reasonable wait. The
In version 7.0 postgres waits for all clients to close their connections
before exiting. Before it just quit.
Jerry Lynde wrote:
>
> Hello out there,
>
> I'm having a problem with a production server. Actually, there are two
> problems. The semi-trivial problem is that Postgres won't d
Hello out there,
I'm having a problem with a production server. Actually, there are two
problems. The semi-trivial problem is that Postgres won't die using the
service mechanism. As root, I "service postgres stop" and then "service
postgres start" after a reasonable wait. The restart w
Hi!
I have to create users via an ODBC connection, but I get this error:
CREATE USER: may not be called in a transaction block
With psql I have no problems. Any body knows what is happening?
Thanks
Diego Schvartzman
Email: [EMAIL PROTECTED]
ICQ# 1779434
Charles Tassell wrote:
>
> No, that's now what he said. You can backup the database while it's still
> being used (the pg_dmp runs in a transaction) but you still can't vacuum a
> database while it's in use. Vacuuming is more along the lines of a defrag,
> it updates the indexes and maintains s
There is an article about open source database on the LinuxWorld web
site:
http://www.linuxworld.com/linuxworld/lw-2000-05/lw-05-database.html
It mentions PostgreSQL. I was interviewed for the article.
--
Bruce Momjian| http://www.op.net/~candle
[EMAIL PROT
No, that's now what he said. You can backup the database while it's still
being used (the pg_dmp runs in a transaction) but you still can't vacuum a
database while it's in use. Vacuuming is more along the lines of a defrag,
it updates the indexes and maintains stats.
At 12:16 PM 5/31/00, Ed
hi,
in oracle you would use these two cursors to determine who was connected and
what they were doing.
select distinct s.sid sid, s.serial# serial, s.status status, osuser, spid ,
count(o.sid) counter, s.username username, s.program program, sql_address
from v$session s, v$open_cursor o, v$proc
On Wed, 31 May 2000, Ed Loehr wrote:
# Hmmm. My backup procedure, based on earlier discussions in this group,
# involves blocking all write-access during a pg_dump. That is
# effectively shutting down the database from my perspective. Is there a
# quicker way to take a consistent snapshot whil
> Philip Hallstrom <[EMAIL PROTECTED]> writes:
> > I took a look around and was unable to find a Perl DBI driver for
> > PostgreSQL... does one exist that I'm missing?
>
> DBD-Pg, at rev 0.93 last I looked at the CPAN archives. For some
> bizarre reason it's not listed on the index page abou
I have sent off the first draft of my book to the publisher for review.
Since last week, I have doubled the size of the Administration chapter(20),
and updated all the SQL output to match the 7.0 format.
The books is accessible at:
http://www.postgresql.org/docs/awbook.html
Comments we
Bruce Momjian wrote:
>
> > Alex Pilosov wrote:
> > >
> > > > http://networkdna.com/database/index.html mentions that PostgreSQL is
> > > > capable of "Online backup". What does that exactly mean?
> > >
> > > It means Postgres can do a reliable backup (a consistent snapshot) of a
> > > database wi
> Alex Pilosov wrote:
> >
> > > http://networkdna.com/database/index.html mentions that PostgreSQL is
> > > capable of "Online backup". What does that exactly mean?
> >
> > It means Postgres can do a reliable backup (a consistent snapshot) of a
> > database without shutting down the database.
>
Alex Pilosov wrote:
>
> > http://networkdna.com/database/index.html mentions that PostgreSQL is
> > capable of "Online backup". What does that exactly mean?
>
> It means Postgres can do a reliable backup (a consistent snapshot) of a
> database without shutting down the database.
Hmmm. My backu
Thanks a lot.
Now, what is WAL?
When is it scheduled for implementation?
>It means Postgres can do a reliable backup (a consistent snapshot) of a
>database without shutting down the database.
>
>What you are asking for is replication, which is not easy to implement,
>and almost damn impossible t
See archives of this mailing list.
WAL is write-ahead logging, more conventional way of assuring atomicity.
(I.E. before a transaction is written to database, it is written to
transaction log, which can be replayed). Replication can be achieved by
streaming transaction log toyour replicated compu
I have now a program that works aginst a Postgresql. I have a wrapper
class that gets the query.
The sequence is like this in Postgresql
res=PQexec(conn, query);
value = PQgetvalue(res, tuple, col);
The problem is col because you don't know what kind of colunm the
program send into this clas
I am starting to use inheritance between tables and when performing a
pg_dump -c (ie: clean drop schema) the DROP TABLE statements are not
optimally ordered: the "DROP TABLE mother_table" comes before "DROP TABLE
child_table" and a "psql -f dump.sql" fails to clear the tables because
you can't DRO
It means Postgres can do a reliable backup (a consistent snapshot) of a
database without shutting down the database.
What you are asking for is replication, which is not easy to implement,
and almost damn impossible to get it RIGHT. (*curse at both Sybase and
Oracle replication servers*). (i.e.
On Tue, 30 May 2000, Dana Eckart wrote:
> Things work fine with the authorization type in pg_hba.conf set to "trust".
> However, when I try to use either "crypt" or "password" psql fails to
> authenticate either the postgresql super-user (mylocal in my case) or any
> other non-privelegded user.
Hello pgsql-general,
I have a problem. I want to make the company I work to go from Informix Online
and SCO to PostgreSQL + Linux and I want this transition to be made, if
it possible, very smooth.
Anybody from this list make this transition and found or made some tools to
make import from Inform
Hi all,
I made an update (pg_dump) from 6.5 to 7.0 (i686-pc-linux-gnu, compiled
by gcc egcs-2.91.66),
I created an index on column gmkg_tl by doing:
create index ix_flurst_gmkg_tl_ix on flurstueck using btree (gmkg_tl
bpchar_ops);
gmkg_tl is char(16).
When I do a
select * from flurstueck where
31 matches
Mail list logo
