On 21/05/2010 9:43 PM, christophe.an...@elsys-design.com wrote:
Hi,
How I know whether Postgres is already installed or not on a machine(on
Linux and Windows)?
I found that pg_ctl --version could be used
Only if PostgreSQL's binary directory is on the PATH, which it may not
be especially on
On 2010-05-21, Kevin Kempter kev...@consistentstate.com wrote:
Can I copy from one db (via COPY) and pipe the results to a psql/COPY stmt so
I can load the data into a table in the second db 'inline' without writing to
reading from a flat file?
Yes.
COPY ... TO stdout;
at the source and
Dear All,
Can some one help me understand st_azimuth() available in postgis.
Regards,
Deepa.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I'm curious, is there any latest word on this?
(Note that I've read fully the link
http://wiki.postgresql.org/wiki/Alter_column_position as well as all links
stemming from it).
I could go digging through the latest source code, or the mailing list
Archives, but I get the feeling I'll really
On Sat, May 22, 2010 at 09:34:50AM -0400, Patrick Rutkowski wrote:
I'm curious, is there any latest word on this?
(Note that I've read fully the link
http://wiki.postgresql.org/wiki/Alter_column_position as well as all
links stemming from it).
No one's working on it, to my knowledge. While
Hmm, interesting.
Though I do see how the performance bumps could be useful, I would still bet
that the huge majority of users who utters the words damn, I wish I could
re-order columns are just talking about the visual order in psql(1) or
PgAdminIII.
On May 22, 2010, at 10:49 AM, David
On Sat, May 22, 2010 at 8:02 AM, Deepa Thulasidasan
deepatulsida...@yahoo.co.in wrote:
Dear All,
Can some one help me understand st_azimuth() available in postgis.
did you read the documentation?
(http://postgis.refractions.net/documentation/manual-svn/ST_Azimuth.html).
the function
On Fri, May 21, 2010 at 1:48 PM, Francisco Reyes li...@stringsutils.com wrote:
Tom Lane writes:
Francisco Reyes li...@stringsutils.com writes:
I am trying to do
select max(primary_key) from some_table;
Are there a whole lot of nulls in that column?
Zero nulls. It is a primary key.
do a
On 05/21/2010 11:18 AM, Tom Lane wrote:
Yeah, this is known to happen in some cases where there was a broken
(incompletely enforced) foreign key constraint in your old database.
The odds are good that what you should do is nothing at all, because
you probably didn't even realize you still had
On 22/05/2010 17:03, erobles wrote:
ERROR: there is no unique constraint matching given keys for referenced
table table_name'
there is a way to solve this?? what can i do ??
It means you need to have a primary key, or at least a unique
constraint, on the target table which uses the
On Sat, May 22, 2010 at 11:01 AM, Patrick Rutkowski rutsk...@gmail.com wrote:
Though I do see how the performance bumps could be useful, I would still bet
that the huge majority of users who utters the words damn, I wish I could
re-order columns are just talking about the visual order in
Merlin Moncure writes:
do a big delete recently? any other open transactions?
Some inserts were taking place. Roughly 2 to 5 million rows inside
transactions. We were doing some ETL and each batch represented a file we
were loading. We need to have the entire file or roll back so each file
Hi,
Well, i'm moving some databases from Mysql to Pgsql, but i'm having some admin
doubts, i wondering 3 things:
1. whar are equivalent for these commands:
in mysql: mysqldump mydata_base_name
mysql mydata_base_name script.sql
2. any link to read about how to admin pgsql with mysql
Hello,
I have a schema which tracks various pieces of information which would
need to be globally searchable. One approach I came up with to make all
of the data searchable is to create a view made of UNION ALL queries
that would integrate different tables into a common structure which
could be
* Luis Daniel Lucio Quiroz (luis.daniel.lu...@gmail.com) wrote:
1. whar are equivalent for these commands:
in mysql: mysqldump mydata_base_name
pg_dump (pg_restore to restore from the dump, if you use a non-SQL
format for it, which can give you the ability to do a parallel-restore)
mysql
On 23/05/10 10:40, Ivan Voras wrote:
Hello,
I have a schema which tracks various pieces of information which would
need to be globally searchable.
If systems that exist outside the database its self are acceptable,
check out Apache Lucerne, and tools that use it like Hibernate Search.
--
16 matches
Mail list logo