Re: [GENERAL] Finding the number of rows affected by UPDATE or INSERT?

> I am writing a bunch of stuff in pl/pgsql, and some of these functions > do UPDATEs or INSERTs on various tables. How could I find out, from > within the pl/pgsql function, how many rows were affected? This way, > if the update or insert fails for some reason, I can return a "failed" > message

[GENERAL] Finding the number of rows affected by UPDATE or INSERT?

I am writing a bunch of stuff in pl/pgsql, and some of these functions do UPDATEs or INSERTs on various tables. How could I find out, from within the pl/pgsql function, how many rows were affected? This way, if the update or insert fails for some reason, I can return a "failed" message from the

Re: [GENERAL] Re: Referential Integrity problem...

On Thu, 30 Aug 2001, Joel Burton wrote: > On Thu, 30 Aug 2001, Justin wrote: > > (cc'd to PG list in hopes that someone else might find this useful, > or that someone else might have a better solution.) > > > Have you ever come across the problem of having multiple fields in a > > table referrin

Re: [GENERAL] Compaq iPAQ and Postgresql

> But on an ipaq data isn't stored on disk, it is all stored in memory. Hmmm... sorry, didn't get that point. So you'll get a real problem. AFAIK PostgreSQL will use diskspace if more space is needed for sorts and other things, than RAM is available (better if neded space exceeds the given value

Re: [GENERAL] Re: Run scripts

Lee Harr wrote: > > On 24 Aug 2001 05:43:37 -0700, Christoph <[EMAIL PROTECTED]> wrote: > > Working with oracle I used the command > > @/home/lange/textfile.sql > > to run scripts. Does anyone happen to know how this works with postgres? > > > > In psql, you could use: > > \i /home/lange/textfi

Re: [GENERAL] PostgreSQL Log Analyzer 1.0 is out

Gilles DAROLD wrote: > > Hi all, > > The first release of the PostgreSQL Log Analyzer is out, you can take a look > of a screenshot at: > > http://www.samse.fr/GPL/pg_analyzer/sample/ > > Documentation and download have a link here: > > http://www.samse.fr/GPL/ > > This is the first

[GENERAL] pg_dump error

Hi, I get an error when the following command executed; /usr/local/pgsql/bin/pg_dump trollandtoad > trollandtoad.out   SET TRANSACTION command failed. Explanation from backend: 'ERROR:  Bad TRANSACTION ISOLATION LEVEL (serializable)   Where should I look at for a solution.   Thanks in adva

[GENERAL]

---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Re: [GENERAL] How do I pack a class into a string? Is serialize available?

"Gurunandan R. Bhat" <[EMAIL PROTECTED]> writes: > On 28 Aug 2001, Doug McNaught wrote: > > > What problem are you trying to solve? > > I wanted to write a small utility to keep two databases synchronised. > Whenever I add a row to a table in the local database, I intend to put a > trigger that

[GENERAL] Default encoding in database

Hi List I'm using PostgreSQL version PostgreSQL 7.1.2 When I create a new database it's made with SQL_ASCII by default. What do I have to do to make LATIN1 the default encoding? This is how I configured Postgres ./configure --with-java --enable-odbc --enable-multibyte=LATIN1 --enable-locale --ena

Re: [GENERAL] RFC: PostgreSQL and MySQL comparison.

On Wed, 29 Aug 2001, Justin Clift wrote: > Hi guys, > > I'm willing to put this on techdocs.postgresql.org, as long as I feel > it's been written for the right reasons. > > i.e. I'm all for a document(s) which helps people needing a good, solid, > Open Source database needing transactions, ACID f

Re: [GENERAL] RFC: PostgreSQL and MySQL comparison.

Hi guys, I'm willing to put this on techdocs.postgresql.org, as long as I feel it's been written for the right reasons. i.e. I'm all for a document(s) which helps people needing a good, solid, Open Source database needing transactions, ACID features, etc. But, I'm definitely not for a document

[GENERAL] Compaq iPAQ and Postgresql

Hello folks! We are using a Compaq iPAQ with 32 MB of RaM. Now we thinking about the size of the postmaster, because we wanna use Postgres on it. If we are performing big Querys, the used size of the postmaster could be more than 32 MB. It would be a good idea, if the postmaster would

[GENERAL] Select from different database

Hi All Is it possible to fetch data from another database than the current? E.g. like in Oracle I can select data from 2 different DB's like this: select * from db1.table1 as tbl1, db2.table2 as tbl2 where tbl1.id1 = tbl2.id2; Jacob ---(end of broadcast)---

[GENERAL] Question about plan

Basically, I have one table A with a set of start times and duration and another table B with just a set of times. What I want is a result that for each time in table B count the number of intervals in table A that it is in. The query is not so difficult but it's a large set. The plan looks like