Hello,
In this query:
UPDATE foo
SET allocated_to=?
WHERE id=(SELECT MIN(id) FROM foo WHERE allocated_to IS NULL)
AND allocated_to IS NULL
RETURNING id
Is it guaranteed in any way that there will only be one id allocated and
returned even if multiple clients are executing this query co
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.
--
Cr
* 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 m
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 un
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 backgraoun
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
On Sat, May 22, 2010 at 11:01 AM, Patrick Rutkowski 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 psql(1) or
> PgAd
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 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 Fri, May 21, 2010 at 1:48 PM, Francisco Reyes wrote:
> Tom Lane writes:
>
>> Francisco Reyes 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 big delete recently? an
On Sat, May 22, 2010 at 8:02 AM, Deepa Thulasidasan
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 calculates the angle between two p
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 Fett
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. W
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
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
On 2010-05-21, Kevin Kempter 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
COPY ... FROM stdi
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 W
17 matches
Mail list logo