On Sat, Oct 4, 2008 at 8:49 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Gurjeet Singh" <[EMAIL PROTECTED]> writes:
> > Shouldn't PG make all efforts to not execute something when the result is
> > already known?
>
> Not if said effort would cost more than is saved, which would be by far
> the most
"Gurjeet Singh" <[EMAIL PROTECTED]> writes:
> Shouldn't PG make all efforts to not execute something when the result is
> already known?
Not if said effort would cost more than is saved, which would be by far
the most likely result if we tried to cache all function results.
What are the differes between ST_Intersects and ST_Touches?
The 1st query return something, but the 2nd return 0.
select road.link_id from road where
Intersects (
Buffer(GeometryFromText('POINT(-88.02083 41.956982)',4326), .001),
the_geom
)
select road.link_id from road where
Touches (
Bu
Jörn
a Microsoft Windows Installer is supposed to do:
a)configure any/all server binaries to work as a Windows Service (take a look
at Admin/CPanel/Services) ..
b)retain these configurations in the windows registry as identified by CLSID (a
unique ID which tracks
the binaries characteristics su
On Sat, Oct 4, 2008 at 1:36 AM, Tom Lane <[EMAIL PROTECTED]> wrote:
> Joseph S <[EMAIL PROTECTED]> writes:
> > Aren't static functions supposed to executed only once per transaction?
>
> There's no promise of that.
>
Can this be changed? Or does it work only in simpler queries, based on some
resu
On Sat, Oct 4, 2008 at 2:42 AM, Dave Page <[EMAIL PROTECTED]> wrote:
> On Fri, Oct 3, 2008 at 9:31 PM, Joshua Drake <[EMAIL PROTECTED]> wrote:
> > On Fri, 3 Oct 2008 15:18:26 -0500
> > "Eduardo Arévalo" <[EMAIL PROTECTED]> wrote:
> >
> >> Hi I am trying to install the portgres of 64btis in centos
On Oct 3, 2008, at 6:05 AM, Joey K. wrote:
Hello,
I'd like to get the path configured for archive_command in a shell
script
I've used a file with following content as an example
(postgresql.conf),
# archive_command = cp %p /backup/%r
# archive_command = cp %p /backup/%r
# ar
Artacus <[EMAIL PROTECTED]> writes:
>> This will not work, or at least it will stop working after your
>> installation passes 4 billion transactions.
> * So what exactly happens at the 4 billion mark?
txid keeps going (that's why it's a bigint). xid will wrap around.
> * Why can't I cas
On Sat, 4 Oct 2008 00:00:03 +0100
"Dave Page" <[EMAIL PROTECTED]> wrote:
> On Fri, Oct 3, 2008 at 10:46 PM, Joshua Drake <[EMAIL PROTECTED]>
> wrote:
> >> http://www.postgresql.org/download/linux
> >
> >
> > No that is a link to another vendors open source software. That is
> > not a .Org file.
>
On Fri, Oct 3, 2008 at 10:39 PM, Eduardo Arévalo <[EMAIL PROTECTED]> wrote:
> Now I am in the language I get the following screen:
>
...
> [620] zh_HK
> [621] zh_HK.utf8
> [622] zh_SG
> [623] zh_SG.utf8
> [624] zh_TW
> [625] zh_TW.euctw
> [626] zh_TW.utf8
> [627] zu_ZA
> [628] zu_ZA.iso88591
> [629
On Fri, Oct 3, 2008 at 10:46 PM, Joshua Drake <[EMAIL PROTECTED]> wrote:
>> http://www.postgresql.org/download/linux
>
>
> No that is a link to another vendors open source software. That is not
> a .Org file.
By the same token, neither is anything on the Yum repository (as
sponsored by Command Pro
On Fri, Oct 3, 2008 at 2:31 PM, Joshua Drake <[EMAIL PROTECTED]> wrote:
> On Fri, 3 Oct 2008 15:18:26 -0500
> "Eduardo Arévalo" <[EMAIL PROTECTED]> wrote:
>
>> Hi I am trying to install the portgres of 64btis in centos 5.6 but at
>> the next command ./postgresql-8.3.4-1-linux-x64.bin
>> the results
On Fri, 03 Oct 2008, Joseph S <[EMAIL PROTECTED]> writes:
> Aren't static functions supposed to executed only once per transaction?
There is no such promise, that depends on the PL you prefer. For
instance, in PL/scheme[1] non-volatile (immutable) and non-SRF functions
are cached per (top) transac
On Fri, 3 Oct 2008 22:14:22 +0100
"Dave Page" <[EMAIL PROTECTED]> wrote:
> >> Yes we do - and simply switching to the RPM distro is unlikely to
> >> solve the problem as the OP is obviously not aware of the what the
> >> problem is and will probably grab the latest version available.
> >
> > Where
On Fri, Oct 3, 2008 at 10:13 PM, Joshua Drake <[EMAIL PROTECTED]> wrote:
> On Fri, 3 Oct 2008 22:12:08 +0100
> "Dave Page" <[EMAIL PROTECTED]> wrote:
>
>> On Fri, Oct 3, 2008 at 9:31 PM, Joshua Drake <[EMAIL PROTECTED]>
>> wrote:
>> > On Fri, 3 Oct 2008 15:18:26 -0500
>> > "Eduardo Arévalo" <[EMAIL
On Fri, 3 Oct 2008 22:12:08 +0100
"Dave Page" <[EMAIL PROTECTED]> wrote:
> On Fri, Oct 3, 2008 at 9:31 PM, Joshua Drake <[EMAIL PROTECTED]>
> wrote:
> > On Fri, 3 Oct 2008 15:18:26 -0500
> > "Eduardo Arévalo" <[EMAIL PROTECTED]> wrote:
> >
> >> Hi I am trying to install the portgres of 64btis in c
On Fri, Oct 3, 2008 at 9:31 PM, Joshua Drake <[EMAIL PROTECTED]> wrote:
> On Fri, 3 Oct 2008 15:18:26 -0500
> "Eduardo Arévalo" <[EMAIL PROTECTED]> wrote:
>
>> Hi I am trying to install the portgres of 64btis in centos 5.6 but at
>> the next command ./postgresql-8.3.4-1-linux-x64.bin
>> the results
On Fri, Oct 3, 2008 at 1:48 PM, Rob Richardson
<[EMAIL PROTECTED]> wrote:
> I didn't see anything in the documentation about deferred constraints.
> Can you point to someplace where I can read about them?
http://www.postgresql.org/docs/8.3/static/sql-createtable.html
--
Sent via pgsql-general ma
On Fri, 3 Oct 2008 15:18:26 -0500
"Eduardo Arévalo" <[EMAIL PROTECTED]> wrote:
> Hi I am trying to install the portgres of 64btis in centos 5.6 but at
> the next command ./postgresql-8.3.4-1-linux-x64.bin
> the results are as follows:
We don't distribute .bin files I would strongly suggest us
Hi I am trying to install the portgres of 64btis in centos 5.6 but at the
next command ./postgresql-8.3.4-1-linux-x64.bin
the results are as follows:
[EMAIL PROTECTED] programas]# ./postgresql-8.3.4-1-linux-x64.bin
Welcom
Joseph S <[EMAIL PROTECTED]> writes:
> Aren't static functions supposed to executed only once per transaction?
There's no promise of that.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http:/
I didn't see anything in the documentation about deferred constraints.
Can you point to someplace where I can read about them?
Thank you!
RobR
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent: Friday, October 03, 2008 2:59 PM
To: Rob Richardson
Cc: pgsql-general@p
Thanks for your answer but here's the longer question as asked in the
posts before:
How can I use the official "Postgres without installer" distribution
without compiling the sources for myself and without having to install
the redistribution application of the VC dlls so that I can distribute
On Fri, 03 Oct 2008 21:02:27 +0200
Jörn Heid <[EMAIL PROTECTED]> wrote:
> So, nobody knows how to make the official "Postgres without
> Installer" to work with a normal Windows installation?
http://www.postgresql.org/docs/faqs.FAQ_MINGW.html
Have fun.
Joshua D. Drake
--
The PostgreSQL Compa
Umm r/static/stable
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Aren't static functions supposed to executed only once per transaction?
I have a query plan that looks like this:
Unique (cost=441872.58..441875.39 rows=562 width=4)
-> Sort (cost=441872.58..441873.98 rows=562 width=4)
Sort Key: elog.uid
-> Nested Loop (cost=89.52..441
So, nobody knows how to make the official "Postgres without Installer"
to work with a normal Windows installation?
Jörn
Jörn Heid schrieb:
Okay, that's a misunderstanding.
I don't want to build it from the sources. I want to take the official
pre-built "postgres without installer" package and
On Fri, Oct 3, 2008 at 8:56 AM, Rob Richardson
<[EMAIL PROTECTED]> wrote:
> No, because the application first saves the coils and then saves the
> charge. Setting up the foreign key constraint would prevent any coils
> from being saved because the charge record would never exist at the time
> the
My thanks to all who contributed thoughts about my question. I have put
a two-part solution into place. The trigger function that fires when
charges are inserted raises the exception, but leaves the possibility of
dangling coils (coils with the numbers of charges that do not exist in
the database
SELECT *
FROM strand_scores
WHERE xmin::text = txid_current()::text
This will not work, or at least it will stop working after your
installation passes 4 billion transactions.
The traditional way to find out your own XID is to insert a dummy row
somewhere (perhaps in a temp table) and se
Maybe try pltclu - you may use socket (TCP/IP) or to write data to OS
filesystem. I was doing in pltclu very similar things.
Write what you concrete watnts (in points), then I will try to write
you scripts.
Regards
Blazej
2008/10/3 Rob Richardson <[EMAIL PROTECTED]>:
> That's how it should have
Tom Lane wrote:
> The traditional way to find out your own XID is to insert a dummy row
> somewhere (perhaps in a temp table) and see what its xmin is. I'm not
> sure why we don't expose a more convenient way --- maybe just that
> there's not been any demand for it.
I think we've suggested the t
No, because the application first saves the coils and then saves the
charge. Setting up the foreign key constraint would prevent any coils
from being saved because the charge record would never exist at the time
the coil record was created.
RobR, who would love to hear some of the music in Galway
On 03/10/2008 14:52, Rob Richardson wrote:
> That's how it should have been done, but it wasn't. It's too late to
> change it now. If I make any change to the C++ code, I run into a
But setting up a foreign key constrain is something you do in the
database, not in the app - can't you do that?
R
That's how it should have been done, but it wasn't. It's too late to
change it now. If I make any change to the C++ code, I run into a
horrible case of DLL Hell. I told my bosses that if we change any C++
code at that site, we have to change all of it. So I need a pure
database solution. Or ma
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Hello,
I'd like to get the path configured for archive_command in a shell script
I've used a file with following content as an example (postgresql.conf),
# archive_command = cp %p /backup/%r
# archive_command = cp %p /backup/%r
# archive_command = cp %p /backup/%r
#archive_command = c
Hi Friends!!
I install the postgre 8.3 by command line :
msiexec /i postgresql-8.3-int.msi /qr ADDLOCAL=server,psql,pgadmin
INTERNALLAUNCH=1 DOSERVICE=1 DOINITDB=1 ENCODING=UTF8
SERVICEDOMAIN="%COMPUTERNAME%" SERVICEACCOUNT="postgre_service"
SERVICEPASSWORD="passWorD" CREATESERVICEUSER=1
SERVICEN
"Rob Richardson" <[EMAIL PROTECTED]> writes:
> I think I just came up with a thoroughly ugly idea. The database
> supports an annealing shop, in which coils are assigned to charges.
> After the check fails, I end up with coils assigned to a charge that
> does not exist. I could set up a job that
Devrim GÜNDÜZ wrote:
>
> Hi Peter,
>
> On Tue, 2008-09-23 at 23:09 +0300, Peter Eisentraut wrote:
>> SLES builds have been broken for a while. I have not analyzed that
>> yet.
>> Bugs and patches welcome.
>
> https://projects.commandprompt.com/public/pgcore/repo/rpm/suse/8.3/SLES-10/postg
RAISE NOTICE won't help (I don't think) because the notice isn't visible from
inside the C++ application, so the user won't know that a problem occured.
I think I just came up with a thoroughly ugly idea. The database supports an
annealing shop, in which coils are assigned to charges. After
Hi Roshni-san.
First, thank you for the report of a good result. However, I don't know well about
libpqxx Therefore, pushes on GENERAL-ML. Someone may be able to support.?
Regards,
Hiroshi Saito
- Original Message -
From: "Roshni Mani" <[EMAIL PROTECTED]>
To: "Hiroshi Saito" <[E
Artacus <[EMAIL PROTECTED]> writes:
> Ok, so it took a lot of googling to figure this one out, but you can do
> it with something like so.
> SELECT *
> FROM strand_scores
> WHERE xmin::text = txid_current()::text
This will not work, or at least it will stop working after your
installation passes
On Thursday 2. October 2008, Tim Semmelhaack wrote:
>Hello,
>
>I have to import a huge number of data sets of data sets with "Copy
> from".
>
>The numbers are formatted with decimal comma ',' (as usual in Germany)
>instead of the decimal point '.'
>
>When I try to import this data Postgres crashes,
44 matches
Mail list logo
