Tom Lane wrote:
Antonios Christofides [EMAIL PROTECTED] writes:
Why 25 seconds for appending an element?
Would you give us a specific test case, rather than a vague description
of what you're doing?
OK, sorry, here it is (on another machine, thus times are different.
8.0.1 on a PIV
hi,
I'm trying to backup a server and restore it on a different machine
with newer versions of postgresql and postgis. Dumps have been created
for the following versions from the old database server:
Postgresql 7.4.6
Postgis 0.8.2
Now since both the packages have released newer versions
Shridhar Daithankar wrote:
Perhaps you could attempt to store a fix small number of records per row, say
4-6? Or may be a smaller fixed size array, That should make the row overhead
less intrusive...
Thanks, I didn't like your idea, but it helped me come up with another
idea:
On Wed, 16 Feb 2005, Pritesh Shah wrote:
I understand that this is due to the following:
libpostgis.so.8.0 is now liblwgeom.so.1.0 and also
histogram2d_in is now lwhistogram2d_in
histogram2d_out is now lwhistogram2d_out and so on.
Now my problem is there are a lot of databases that use the
Title: insert data from an microsoft excel
Is there is way to load data from as Microsoft excel into database tables in postgresql7.4.x
Thx
Rao
Hi,
I create this table:create table teste (campo1 varchar(20));
And this view:create view vteste as select * from teste;
When I try change the type of the column raise thir error:db=# alter table teste alter column campo1 type varchar(30);ERROR: cannot alter type of a column used by a view or
On Wed, 16 Feb 2005, Andrew Hall wrote:
fsync is on for all these boxes. Our customers run their own hardware with
many different specification of hardware in use. Many of our customers don't
have UPS, although their power is probably pretty reliable (normal city based
utilities), but of course
On Feb 16, 2005, at 6:16 AM, Nageshwar Rao wrote:
Is there is way to load data from as Microsoft excel into database
tables in postgresql7.4.x
Sure. Export the data into a CSV file. Then import it using psql and
the \COPY command.
http://www.postgresql.org/docs/8.0/interactive/app-psql.html
Marco Colombo wrote:
On Wed, 16 Feb 2005, Andrew Hall wrote:
fsync is on for all these boxes. Our customers run their own hardware
with many different specification of hardware in use. Many of our
customers don't have UPS, although their power is probably pretty
reliable (normal city based
On Wed, 16 Feb 2005, Daniel Naschenweng wrote:
I create this table:
create table teste (campo1 varchar(20));
And this view:
create view vteste as select * from teste;
When I try change the type of the column raise thir error:
db=# alter table teste alter column campo1 type varchar(30);
John DeSoi wrote:
On Feb 16, 2005, at 6:16 AM, Nageshwar Rao wrote:
Is there is way to load data from as Microsoft excel into database
tables in postgresql7.4.x
Sure. Export the data into a CSV file. Then import it using psql and
the \COPY command.
Or if it's something that needs automating,
OK!
Thanks.Stephan Szabo [EMAIL PROTECTED] wrote:
On Wed, 16 Feb 2005, Daniel Naschenweng wrote: I create this table: create table teste (campo1 varchar(20)); And this view: create view vteste as select * from teste; When I try change the type of the column raise thir error: db=# alter table
I get a dump of some data in a CSV file and am able to import it
manually using psql and \COPY without a problem. However I now need to
automate this as it will need to be done every 2 hours 24/7. I've tried
looking through the archives and nothing seems to touch upon this
completely and the
The short answer is that you leave out all the postgis function calls in
your dump, create a new database and load the postgis functions using the
new scripts. Then you just load the data.
I didn't find an easy way to selectively load tables and views using the
.sql format (and I actually
On Wed, 2005-02-16 at 07:14, Alban Hertroys wrote:
Marco Colombo wrote:
On Wed, 16 Feb 2005, Andrew Hall wrote:
fsync is on for all these boxes. Our customers run their own hardware
with many different specification of hardware in use. Many of our
customers don't have UPS, although
Have you tried creating a script to do the import operation, and then
scheduling it to run periodically using cron (on unix) or at (on windows)?
Seems like that is all you need to do...
John Sidney-Woollett
walker1145 wrote:
I get a dump of some data in a CSV file and am able to import it
On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:
Is there is way to load data from as Microsoft excel into database
tables in postgresql7.4.x
Once you've upgraded to 8.0x--a good idea anyhow--you can use DBI-Link
with the DBD::Excel driver.
http://pgfoundry.org/projects/dbi-link/
On Wednesday February 16 2005 7:48, David Fetter wrote:
On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:
Is there is way to load data from as Microsoft excel into
database tables in postgresql7.4.x
Once you've upgraded to 8.0x--a good idea anyhow--you can use
DBI-Link with
Antonios Christofides [EMAIL PROTECTED] writes:
CREATE TABLE test(id integer not null primary key, records text[]);
UPDATE test SET records[207] = 'hello, world!';
[11 seconds]
UPDATE test SET records[100] = 'hello, world!';
[15 seconds (but the difference may be because of system
On Wed, Feb 16, 2005 at 08:05:55AM -0700, Ed L. wrote:
On Wednesday February 16 2005 7:48, David Fetter wrote:
On Wed, Feb 16, 2005 at 04:46:09PM +0530, Nageshwar Rao wrote:
Is there is way to load data from as Microsoft excel into
database tables in postgresql7.4.x
Once you've
Ed L. [EMAIL PROTECTED] writes:
Postmaster is totally
unresponsive to SIGTERM, SIGINT, and SIGQUIT (sigkill is the
only thing that shuts it down).
gdb backtrace definitely sounds like a good idea. Also it might be
interesting to see the results of strace of the postmaster while hitting
it
On Wed, 16 Feb 2005, Scott Marlowe wrote:
I know there are write modes in ext3 that will allow corruption on power
loss (I think it's writeback). I know little of XFS in a production
environment, as I run ext3, warts and all.
Yeah, but even in writeback mode, ext3 doesn't lie on fsync. No FS
Peter Eisentraut wrote:
Am Freitag, 11. Februar 2005 13:37 schrieb Marques Johansson:
A recent Slashdot thread on MySQL performance
(http://developers.slashdot.org/article.pl?sid=05/02/11/038232from=rss)
contains a comment mentioning the following Fermilab report from May 2003:
They were
On Wed, 2005-02-16 at 11:13, Ron Mayer wrote:
Peter Eisentraut wrote:
Am Freitag, 11. Februar 2005 13:37 schrieb Marques Johansson:
A recent Slashdot thread on MySQL performance
(http://developers.slashdot.org/article.pl?sid=05/02/11/038232from=rss)
contains a comment mentioning the
Peter Eisentraut wrote:
Am Samstag, 12. Februar 2005 23:32 schrieb Preston Landers:
If the postgresql encoding WIN is intended to be Cyrillic 1251,
then
it should be labeled as such in the docs to avoid confusion.
Well, isn't it? You pointed to the place in the documentation
yourself.
I am trying to write a query on the pg_depend table and it is confusing the
hell out of me. Hopefully someone could help.
I would like to know which views depend on another view.
When I try to drop a view it gives me a list of all the views that need to
be dropped in order for my view to be
You can't simply restore a dump to upgrade postgis
for two reasons:
1) postgis library name might have changed (this is the case).
2) postgis procedural language function might be changed
and you'd get the old ones.
You can find an utility script in the utils/
- Original Message -
From: Tom Lane [EMAIL PROTECTED]
To: Andrew Hall [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Tuesday, February 15, 2005 3:25 PM
Subject: Re: [GENERAL] Lost rows/data corruption?
Andrew Hall [EMAIL PROTECTED] writes:
Here is the data you requested. It
Hi, I wrote a few days ago with an error in a
PostgreSQL 8.01 SP in pgplsql, I've done a lot of stuff and i still can't
execute the sp, I will pass you all the messages...
-- My SP ---
CREATE OR REPLACE FUNCTION
sp_insert_users_2(varchar, varchar, varchar, varchar, smallint, date,
Scott Marlowe [EMAIL PROTECTED] writes:
On Wed, 2005-02-16 at 11:13, Ron Mayer wrote:
Fermilab did have contact information (mail comments to:) at the
bottom of the page. Fermilab's a quite highly respected organization,
so I think this page is probably trusted by many.
Wandering about that
Martijn van Oosterhout wrote:
On Fri, Feb 11, 2005 at 08:12:50PM -0500, Milla Erdee wrote:
Also, has PostgreSQL considered adding some CLOB and BLOB types?
Has had these for ages.
You have BYTEA and TEXT which fill this need. But you could add CLOB and
BLOB types as synonyms for BYTEA and TEXT
On Wednesday February 16 2005 8:54, Tom Lane wrote:
Ed L. [EMAIL PROTECTED] writes:
Postmaster is totally
unresponsive to SIGTERM, SIGINT, and SIGQUIT (sigkill is
the only thing that shuts it down).
gdb backtrace definitely sounds like a good idea. Also it
might be interesting to see
On Mon, Feb 14, 2005 at 15:25:15 -0500,
Milla Erdee [EMAIL PROTECTED] wrote:
The updating view syntax in many cases might be preferred in certian
cases and other types of syntax in other cases, and it should be up to
the programmer to decide which is best for a certian application.. A
Hi
Can anyone help me with the oledb driver.
I have RC1 of Postgres 8 installed on the default(5432) port. I have the
full release version installed on port 5433. I am trying to get the OLEDB
connection to look at port 5433. Below is my connection string. It works for
the RC1 installation (on
Sim Zacks [EMAIL PROTECTED] writes:
I am trying to write a query on the pg_depend table and it is confusing the
hell out of me. Hopefully someone could help.
I would like to know which views depend on another view.
The dependencies are actually from the view's _RETURN rule to the
other view.
Craig Bryden wrote:
Hi
Can anyone help me with the oledb driver.
I have RC1 of Postgres 8 installed on the default(5432) port. I have the
full release version installed on port 5433. I am trying to get the OLEDB
connection to look at port 5433. Below is my connection string. It works for
the RC1
On Feb 14, 2005, at 10:35 AM, Cristian Prieto wrote:
What is happening here? I just passed the right parameters but that
stuff doesn't work handling my parameters? what am I doing wrong??? I
have a week with that trouble, somebody please help me!
Look at this part of the parameter list:
...
On Tue, 2005-02-15 at 15:01 +, Jeff Amiel wrote:
I'm looking specifically for a tool to help compare 2 database schemas
(nominally, production and development) and generate the appropriate SQL
(that can be later executed) to bring the to schema's into sync.
[snip]
What does the rest of
I keep scripts for drop/creation or replacement of each type of object,
and a shell script to run them in order. I only make changes in the
scripts. They can be run one at a time if only one type of object has
changed or been created. I keep backups of data only, and have an
intermediate step
On Wed, Feb 16, 2005 at 11:41:35AM -0700, Ed L. wrote:
Question: Am I doing all I can to avoid corruption with the
following procedure to shutdown a 7.4.6 cluster with a hung
postmaster? Suggestions?
What is the state of the processes in ps? D, S, R, ?? That should at
least give a hint as
On Wed, 16 Feb 2005, Ian Harding wrote:
I keep scripts for drop/creation or replacement of each type of object,
Jeff Amiel [EMAIL PROTECTED] 02/15/05 7:01 AM
I'm looking specifically for a tool to help compare 2 database schemas
(nominally, production and development) and generate the
Tom Lane wrote:
Scott Marlowe [EMAIL PROTECTED] writes:
On Wed, 2005-02-16 at 11:13, Ron Mayer wrote:
Fermilab did have contact information (mail comments to:) at the
...
Right. The question is whether we can get them to update it.
I think so... as mentioned earlier in the thread, they did
hi,
I would like to thank everybody for their responses to my question. I
tried a couple of things and the best thing for me was to use
utils/postgis_restore.pl script.
I ran this script on some sample databases and they all seemed to
work, but partially, as there are still some errors.
These
43 matches
Mail list logo