On Tue, Jan 13, 2009 at 9:36 AM, m zyzy myz...@gmail.com wrote:
I successfully install the .bin installer in linux redhat-centos-fedora.
After a few days using pgadmin and postgresql in the one-click ,I decided
to go back to old plain postgresql and postGIS (Am I right ? the one click
I successfully install the .bin installer in linux redhat-centos-fedora.
After a few days using pgadmin and postgresql in the one-click ,I decided
to go back to old plain postgresql and postGIS (Am I right ? the one click
installer not include the PostGIS extension. ) .
Is there an option to
Is the planner/optimiser smart enough to join just after the LIMIT
in a similar situation:
select [columns from A, B and C] from A
join B on A.Aid=B.Bid
join C on A.Aid=C.Cid
where (conditions on A and B columns)
order by [columns from A and B]
limit 10;
What about a similar situation with
2009/1/13 Aleksander Kmetec aleksander.kme...@intera.si:
Hi, everyone.
I'm trying to upgrade a database which is used by several hundred
installations of an app; with each installation possibly running some custom
code and 3rd party extensions. I was hoping that it would be possible to
Scott Marlowe escribió:
In this thread getting a bounce from advocacy won't bother me too
much. Having hundreds ot bounce messages in a busy thread, would be
much much worse.
Yup.
I wonder, if all the mailing lists are run by the same software,
wouldn't it be easy enough to have a kind of
Hi list,
I have written a function that returns a setof record. The function has
a table name as a parameter and the resulting records have the same
structure as this table. Is there any easy way to specify this when I
call the function? If the table has many columns then it's annoying to
2009/1/13 Christian Schröder c...@deriva.de:
Hi list,
I have written a function that returns a setof record. The function has a
table name as a parameter and the resulting records have the same structure
as this table. Is there any easy way to specify this when I call the
function? If the
I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have
found that the cast text-integer and integer-text are missing. Is
there a reason why they are not there and how can I get them back. I
have many stored procedures that rely on those casts
On Tue, Jan 13, 2009 at 02:50:49PM +0100, Christian Schrrrder wrote:
I have written a function that returns a setof record. The function has
a table name as a parameter and the resulting records have the same
structure as this table. Is there any easy way to specify this when I
call the
2009/1/13 Nykolyn, Andrew andrew.nyko...@ngc.com:
I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found
that the cast text-integer and integer-text are missing. Is there a
reason why they are not there and how can I get them back. I have many
stored procedures that
Emanuel Calvo Franco wrote:
You add the cast's but not the operator.
The cast is in other way (try to compare with a text '13')
for example.
Thanks. I added both ||(double precision, text) and ||(text, double
precision) operators and it works now.
But I'm wondering: do I need to do anything
Nykolyn, Andrew wrote:
I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have
found that the cast text-integer and integer-text are missing. Is
there a reason why they are not there and how can I get them back. I
have many stored procedures that rely on those casts
I'm
On Tue, Jan 13, 2009 at 05:43:52PM +0100, Aleksander Kmetec wrote:
I added both ||(double precision, text) and ||(text, double
precision) operators and it works now.
But I'm wondering: do I need to do anything else besides creating implicit
casts and adding missing operators? And will this
On Tue, 2009-01-13 at 16:58 +, Sam Mason wrote:
In the end, any type system is just a tool. It's main job is to find
bugs in code by spotting a common class of error
The purpose of the database as a whole is to preserve the integrity of
your data. The type system is a key component of
2009/1/13 Aleksander Kmetec aleksander.kme...@intera.si:
Nykolyn, Andrew wrote:
I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have
found that the cast text-integer and integer-text are missing. Is there a
reason why they are not there and how can I get them back. I have
On Tue, Jan 13, 2009 at 8:23 AM, Nykolyn, Andrew andrew.nyko...@ngc.com wrote:
I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found
that the cast text-integer and integer-text are missing. Is there a
reason why they are not there and how can I get them back. I have
On Tue, Jan 13, 2009 at 09:14:15AM -0800, Joshua D. Drake wrote:
On Tue, 2009-01-13 at 16:58 +, Sam Mason wrote:
In the end, any type system is just a tool. It's main job is to find
bugs in code by spotting a common class of error
The purpose of the database as a whole is to preserve
Scott Marlowe scott.marl...@gmail.com writes:
On Tue, Jan 13, 2009 at 8:23 AM, Nykolyn, Andrew andrew.nyko...@ngc.com
wrote:
I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and have found
that the cast text-integer and integer-text are missing. Is there a
reason why they are
2009/1/13 Aleksander Kmetec aleksander.kme...@intera.si:
Nykolyn, Andrew wrote:
I am trying to upgrade my Postgres server from 8.2.3 to 8.3.5 and
have found that the cast text-integer and integer-text are missing.
Is there a reason why they are not there and how can I get them back.
I
I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
to store 100 GB of images in PostgreSQL.
Once they are in there I can deal with them. My main purpose is to use
rsync to get the files into the database.
Is there a better way to load 20,000 plus files reliably into Postgres?
--
On Tuesday 13 January 2009, Jason Long mailing.l...@supernovasoftware.com
wrote:
I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
to store 100 GB of images in PostgreSQL.
Once they are in there I can deal with them. My main purpose is to use
rsync to get the files into the
bytea was what I was going for.
*Does anyone have a script they would share for this purpose?
*
If not I will probably use Java because this is what I am familiar with.
The web app I will write for managing my photos will be written in
Java. I want to be able to categorize, label, search,
With XML similar to:
a
b
c 1 / c
c 2 / c
c 3 / c
/ b
I'm trying to create an xpath expression (for a postgresql query) that will
return if is a particular value and not that is all three values.
What I currently have (which does not work) is:
select * from someTable
On Jan 13, 2009, at 10:34 AM, Jason Long wrote:
I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
to store 100 GB of images in PostgreSQL.
Once they are in there I can deal with them. My main purpose is to
use rsync to get the files into the database.
Is there a better way to
Hi. How would I return the number of matches found by a query, but when I
only want to return 30 of them ?
In MySQL there is a way of calling SQL_CALC_FOUND_ROWS to do this?
Is there something similiar that can be done in PostgreSQL ? Do I have to
rerun my query?
Thanks / Moe
On Tuesday 13 January 2009 21:56:56 Mohamed wrote:
Hi. How would I return the number of matches found by a query, but when I
only want to return 30 of them ?
In MySQL there is a way of calling SQL_CALC_FOUND_ROWS to do this?
Is there something similiar that can be done in PostgreSQL ? Do I
Nykolyn, Andrew andrew.nyko...@ngc.com writes:
The above has all worked great to get me past the two issues described
so far. Now I am having a problem with: function quote_literal is not
unique.
And you're going to have a few other problems after you get past that.
You can't just insert
Steve Atkins wrote:
On Jan 13, 2009, at 10:34 AM, Jason Long wrote:
I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
to store 100 GB of images in PostgreSQL.
Once they are in there I can deal with them. My main purpose is to
use rsync to get the files into the database.
Is
On Tue, Jan 13, 2009 at 03:28:18PM -0600, Jason Long wrote:
Steve Atkins wrote:
On Jan 13, 2009, at 10:34 AM, Jason Long wrote:
I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
to store 100 GB of images in PostgreSQL.
Is there a better way to load 20,000 plus files reliably
Sam Mason wrote:
On Tue, Jan 13, 2009 at 03:28:18PM -0600, Jason Long wrote:
Steve Atkins wrote:
On Jan 13, 2009, at 10:34 AM, Jason Long wrote:
I would like to use PSQLFS(http://www.edlsystems.com/psqlfs/)
to store 100 GB of images in PostgreSQL.
Is there a better way to load
On Tue, Jan 13, 2009 at 06:22:34PM -0600, Jason Long wrote:
Sam Mason wrote:
You'd need to generate the SQL somehow; if you know python it's probably
a pretty easy 20 or 30 lines of code to get this working.
*Never used Python or Perl. I use primarily Java. I was thinking of
doing
Sam Mason wrote:
On Tue, Jan 13, 2009 at 06:22:34PM -0600, Jason Long wrote:
Sam Mason wrote:
You'd need to generate the SQL somehow; if you know python it's probably
a pretty easy 20 or 30 lines of code to get this working.
*Never used Python or Perl. I use primarily
On Tue, Jan 13, 2009 at 06:43:06PM -0600, Jason Long wrote:
Sam Mason wrote:
If you're OK with using large objects, instead of byteas, you can use
the lo_import function.
*They are on the server. I would rather use bytea. Is it possible to
import them as large objects and then use SQL to
On Wed, Jan 14, 2009 at 12:56:42AM +, Sam Mason wrote:
If you Java you'd probably be better off using it
Hum, it's getting late. That should be If you *know* Java! Bed time
for me I think!
Sam
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to
Sam Mason wrote:
On Wed, Jan 14, 2009 at 12:56:42AM +, Sam Mason wrote:
If you Java you'd probably be better off using it
Hum, it's getting late. That should be If you *know* Java! Bed time
for me I think!
Sam
Thanks for the advice. I will probably go with Java. In the
35 matches
Mail list logo