hi everybody
first, it is not that i'm migrating from postgresql to oracle, it's just
that we have a payroll system (we are a software development company)
that currently runs on postgresql, but the goal is that it runs on other
databases too (for our internal needs it runs on postgresql, and tw
On Sat, 26 Feb 2005 16:47:38 +0200, Vitaly Belman <[EMAIL PROTECTED]> wrote:
> I am allowing my users to delete data from certain tables. However, to
> be able to do a rollback of user changes, I decided to create another
> "backup" schema that most data tables will copy data to, upon delete.
>
>
From: "Tom Lane" <[EMAIL PROTECTED]>
There are some speed improvements in 8.0 too, though that wasn't the
main focus of the release cycle. For instance, Lonni Friedman's nearby
thread reports on a case where 8.0 consistently finds a much better
query plan for a complex query than prior releases di
Yes, that certainly ought to work.
If what you're meaning is that you make a replica that sits in
/opt/VERSION8, and then, once the upgrade is complete, rename that to
/opt/MYDATABASE which was where your version 7.4 DB used to be.
We have copied databases from one server to another by copying th
I've finally got around to writing the two nagios plugins which I am
using to check our slony cluster (on our linux servers). I'm posting
them in case anyone else wants them or to use them as a basis for
something else. These are based on Christopher Browne's scripts that
ship with slony.
The
on 2/25/05 4:09 PM, [EMAIL PROTECTED] purportedly said:
> I have two related tables, ³item² and ³book². I have defined
> a view, ³bookview² that contains fields from item and book.
> My goal was to have all inserts, updates, and deletes performed
> on bookview rather than on the tables directly.
On Fri, 2005-02-25 at 16:48 -0800, Ron Mayer wrote:
> Getting closer?
For me, yes.
I agree with Bruce's comment on the use of the word "needed", and I
think your change reads better now.
The not-warnings seem a little wordy for me, but they happen when and
how I would hope for.
So, for me, it
I have just installed Postgresql and tried it for the first time.
One very serious problem I ran into was when actually trying to use
created tables.
Creating a simple table without any foreign keys works OK, but after
creating the
table it is not possible to do a select on it! I tried the follow
> > is there a way return a column with the row number automatically
> > generated according the way the rows were processed by the query.
>
> No, but you can easily keep a counter in the client.
How, then, do I do it if I "need" the "row number" in a view ?
Karsten
--
GPG key ID E4071346 @ wwwk
On Sun, 27 Feb 2005 15:27:48 -0800, Mohsen Pahlevanzadeh wrote:
> Dears,I need to read 1 field with select command from mysql.Then Write it
> to pgsql.
Which programming environment? Java/php/perl/c/...?
--
Greetings from Troels Arvin, Copenhagen, Denmark
---(end of b
Tommy Svensson <[EMAIL PROTECTED]> writes:
> I have just installed Postgresql and tried it for the first time.
>
> One very serious problem I ran into was when actually trying to use
> created tables.
> Creating a simple table without any foreign keys works OK, but after
> creating the
> table it
On Sun, 2005-02-27 at 18:50 -0500, Tommy Svensson wrote:
>I have just installed Postgresql and tried it for the first time.
>
>One very serious problem I ran into was when actually trying to use
>created tables.
>Creating a simple table without any foreign keys works OK, but after
>creating the
>
Bruce Momjian wrote:
Syntax error reporting has been improved in our code so 8.1 might be
better and catching such errors.
Yes, current sources catches this at definition-time:
% psql -f test.sql
psql:test.sql:21: ERROR: syntax error at or near "EXCEPTIONRATIO_OUT"
at character 1
QUERY: EXCEPTIO
13 matches
Mail list logo
