I am looking for feedback from anyone that has moved their data from
Mysql to Postgres using the tools in contrib/mysql or any other data
porting tools on the net. Did any data get lost in the transfer?
Recommendations? Amount of time for transfers? Any feedback would be
greatly appreciated. Thank
On Fri, 31 Aug 2001, Andrew Snow wrote:
> Hrmm... I have 26 rows in mine at the moment, and after vacuum
> analyzing, it uses a seq. scan. How come yours used the index? I
> thought mine wasn't using an index because postgres won't use an index
> until the table is "big enough".
>
> But if a
HELP WANTED: Open Source Consultant Programmer wanted for quick project
We are in need of someone to quickly develop a new web project. You will
need to be an expert on setting up Apache Web Server on a Linux system and
in designing an online data base using Postgresql or MySQL. HTML require
I install PostgreSQL 7.1.3 first time and have problem.
I create table Klient with PGAccess and
- from it when I do "table open" a see every data
- when I tried filter ID=32 I see error no column 'id'
in psql I can't do any select on table Klient
error : no Relation
command \dt show this table
Working with oracle I used the command
@/home/lange/textfile.sql
to run scripts. Does anyone happen to know how this works with postgres?
Thanks for any help in advance,
Chris
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, ple
Hi all expert,
I am a newbie on pgsql. It is so many thing that I don't know.
Is that pgsql supports the database partitioning just like oracle do?
For the current project, I need to store data into the same database. Can I
split the data into different storage device by using database p
accept A903-35A9-76AF
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Sorry if I insulted the wrong people.
Like I said in the message, "The odd comparison is OK" was poorly
stated, I was tired of having to go through all the posts from people
who appear to be close to anti PostgreSQL. I was trying to indicate that
suggesting feature enhancements that are SQL92 and
Hi
I had to "rpm --rebuild postgresql-7.1.3-1PGDG.src.rpm" on a RedHat 6.2
machine.
After I rebuilt the software I attempted to install all the compiled
packages but got the error message :
error: failed dependencies:
mx is needed by postgresql-python-7.1.3-1PGDG
This "/root/.cpan/buil
Its been much much too long since I've upgraded Majordomo2 on the server,
so this is the last email I'm sending out prior to upgrading her today ...
if anyone notices the lists go suddenly quiet, or the way it works
changing, please let me know ...
My main worry is that in the past 6+ months, so
> I tried with the command you gave. But, if I try to delete the table 'test1'
> it comes with the following error:
> ERROR: mdopen: couldn't open test1: Permission denied
>
> How to solve it?Any help.
Make sure the file is owned and writable by the user that the database
runs as.
--
Looking for some hints on how to speed up deletes Thanks in advance
Using PostgreSQL 7.1.2 on hppa2.0-hp-hpux10.20, compiled by GCC 2.95.3
(2 processors)
Have a "file" record wx_grib_file, with data stored as large object.
The rule "wx_grib_file_delete" does the lo_unlink on grib_file_id.
On Thu, 30 Aug 2001, Daniel Lundqvist wrote:
> I have a pgsql database containing DHCP lease informtation,one table for
> each month.
> As we get more and more customers there will be more rows in the tables. The
> table for august
> now contains about 2.7 million rows. There is about 5 inserts p
On Wed, 29 Aug 2001, Guy Fraser wrote:
> I would appreciate it if the MySQL zealots with troglodytical
> mentalities would confine themselves to there own mailing list.
Er? Man, everybody just has to chime in with their $0.02. Let the
moderators handle it, oh flaming sword o' justice.
> The o
On Wed, 29 Aug 2001, Robert J. Sanford, Jr. wrote:
> http://www.phpbuilder.com/columns/tim20001112.php3
Now *that* was very informative, thank you.
The best benefit to this, is that the optimization engine is supposedly
vastly improved in the 7.2 tree, so that'll just increase the lead. If
the
Hi,
I'm having a strange problem with syslog and Solaris 7, and I've run
out of ideas about what might be wrong.
I configure postgres with --enable-syslog, and everything works fine.
Configure finds syslog, so that's not a problem. In postgres.conf, I
have the following:
#
# Syslog
#
#i
On Thu, 30 Aug 2001, Ben-Nes Michael wrote:
> Can I:
>
> select *, sum_rows as ( select count(*) from table2; ) from table1;
I think you need to say:
select *, (select count(*) from table2) as sum_rows from table1;
But this won't be a very interesting query because the sum_rows column
will be
> So far I haven't seen any real flames or insults thrown about
> yet - no MYsql will kill your puppy threads at all. There
> can be rigourous discussion without insults being thrown and
> so far that's all I've seen.
No, but it WILL kill your data, if the DB is big enough and has been in
us
Hello all,
when i use the "\dp" to view the permission
of "mytable":
mytable |
{"=","28=arw","34=arw","36=arw","40=arw","42=arw","cgi=arw"}
i guess those numeric thingy is kinda
object id of a user, and i've deleted
the user b4 i revoke the permission of
Can I:
select *, sum_rows as ( select count(*) from table2; ) from table1;
--
Canaan Surfing Ltd.
Internet Service Providers
Ben-Nes Michael - Manager
Tel: 972-4-6991122
http://sites.canaan.co.il
--
---(end of broadcast)-
sorry, i forgot some version number :)
[mat@biniac ~]$ psql --version
psql (PostgreSQL) 7.1.2
contains readline, history support
Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
Portions Copyright (c) 1996 Regents of the University of California
Read the file COPYRIGHT or
hi,
i'm notice a weird behaviour while running a query on the same table,
the query take a long time to be executed when this table is empty ,
and when this table isn't empty, it take about 1/2 second
the two tables are freshly vacuumed ...
here the same tables, one is empty, not the other
Shanmugasundaram Doraisamy wrote:
> - Original Message -
> From: Peter Eisentraut <[EMAIL PROTECTED]>
> To: Shanmugasundaram <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Wednesday, August 29, 2001 5:11 PM
> Subject: Re: [JDBC] Regarding vacuumdb
>
> > Shanmugasundaram writes:
> >
Hi,
Sorry for my last empty message.
I have a pgsql database containing DHCP lease informtation,one table for
each month.
As we get more and more customers there will be more rows in the tables. The
table for august
now contains about 2.7 million rows. There is about 5 inserts per second.
Table
On Thu, Aug 30, 2001 at 11:04:39AM +0200, Jacob Vennervald Madsen wrote:
> If I do rebuild it with initdb will I still have all my data?
No of course, initdb create everything again... but if you have
only templates DB you probably haven't some data, else you must
dump all your DB and backup it
On Thu, Aug 30, 2001 at 05:28:16PM +0900, Tatsuo Ishii wrote:
> > > How does the output from "psql -l" look like?
> > List of databases
> > Database | Owner | Encoding
> > +--+---
> > template0 | postgres | SQL_ASCII
> > template1 | postgres | SQL_ASC
Guy Fraser wrote:
>
> Hi
>
> I would appreciate it if the MySQL zealots with troglodytical
> mentalities would confine themselves to there own mailing list.
>
I've yet to see any MYsql zealots on this list.
> The odd comparison is OK but the flame wars are a waste of storage.
>
> MySQL and Po
On Wed, Aug 29, 2001 at 11:15:08AM +0200, Markus Wagner wrote:
> Hi,
>
> we need to control database changes within BEFORE triggers.
> There is no problem with triggers called by update, but there is
> a problem with triggers called by insert.
>
> We strongly need to know the oid of a newly inse
If I do rebuild it with initdb will I still have all my data?
Jacob
-Original Message-
From: Karel Zak [mailto:[EMAIL PROTECTED]]
Sent: 30. august 2001 11:03
To: Tatsuo Ishii
Cc: Jacob Vennervald Madsen; [EMAIL PROTECTED]
Subject: Re: Default encoding in database
On Thu, Aug 30, 2001 a
> > How does the output from "psql -l" look like?
> List of databases
> Database | Owner | Encoding
> +--+---
> template0 | postgres | SQL_ASCII
> template1 | postgres | SQL_ASCII
> Jacob
I don't know why your template1 DB's encoding is SQL_ASCII, bu
Greetings, pgsql-general!
While researching material for a certain upcoming article, I found
out that online docs still claim "2001-??-??" as a release date
for PostgreSQL 7.1
--
Yours, Alexey V. Borzov, Webmaster of RDW.ru
---(end of broadcast)---
* Matthew Kennedy <[EMAIL PROTECTED]> wrote:
|
| There was a brief mention in the "RFC: PostgreSQL and MySQL comparison"
| thread about "free text search" in postgresql. Is there any information
| avaliable on this? Nothing came up when I searched the interactive
Check the openfts addon for postg
I found out how to do it:
In pl/pgsql:
INT nr;
UPDATE
GET DIAGNOSTICS SELECT PROCESSED INTO nr;
will put the number of rows into nr. It's a very useful feature to
have this in PG7.1.
---(end of broadcast)---
TIP 2: you can get off all lis
Greetings, Peter!
At 29.08.2001, 23:32, you wrote:
>> But I do think that
>> the statements in
>> http://www.mysql.com/doc/M/y/MySQL-PostgreSQL_features.html
>> should NOT go unanswered.
PE> Okay, I answered them:
PE> http://webmail.postgresql.org/~petere/comparison.html
Looks good, but i
34 matches
Mail list logo
