Tony Caduto wrote:
> I am having trouble getting dblink_tds compiled on my system.
>
> i downloaded the source and followed the directions but keep getting
> this error:
>
> [EMAIL PROTECTED] dblink_tds]# make
> /postgresql-8.1.4/src/Makefile.global.in:309:
> /postgresql-8.1.4/src/Makefile.port
I am using PostgreSQL 8.0.0.
i have noted the following
lines in the script to start or shut down postmaster.
Can you please let me know why they are
needed
if [ "`uname`" = "Linux" ]; then
INITD=/etc/rc.d/init.d .
$INITD/functions # Get config. .
/etc/sysconfig/networkfi
and
i
Gregory,
All you described you do with fti is possible with tsearch2. Just need
some think, of course. If you don't need stemming, just don't use it,
if you need something like %txt%, just write simple dictionary, which
produce any substrings from input word.
Oleg
On Tue, 31 Oct 2006, Gregory
2. No. In fact I can replicate the problem on the same computer using
PgAdmin (connecting as two different users)
3. I can isolate the part but it does not help much. I'm even doing
RAISE NOTICE and printing out the actual SQL statement that is being
executed... and it's IDENTICAL f
On Fri, Nov 03, 2006 at 01:40:35PM +0530, surabhi.ahuja wrote:
> I am using PostgreSQL 8.0.0.
>
> i have noted the following lines in the script to start or shut down
> postmaster.
> Can you please let me know why they are needed
Where did you get these fragments from? They appear to be for a
Magnus Hagander wrote:
Is there any way to count how many hits I got in a cursor in PL/pgsql?
I have a function that will "window" through the result of a (large)
query based on two parameters, but I also want to return the number of
hits to the client. Right now I'm looping through the entire
On Thu, Nov 02, 2006 at 10:43:58PM +0100, Magnus Hagander wrote:
> Is there any way to count how many hits I got in a cursor in PL/pgsql?
>
> I have a function that will "window" through the result of a (large)
> query based on two parameters, but I also want to return the number of
> hits to the
surabhi.ahuja wrote:
I am using PostgreSQL 8.0.0.
i have noted the following lines in the script to start or shut down
postmaster.
Can you please let me know why they are needed
if [ "`uname`" = "Linux" ]; then
INITD=/etc/rc.d/init.d
. $INITD/functions
# Get config.
. /etc/sy
Egil Möller wrote:
It seems like you can not use the magical relations new and old in
sub-selects in rules. Why is this, or is there something I haven't
understood correctly about rules and new and old?
create table "user" (
username varchar,
created timestamp default now(),
detstroyed times
> > Is there any way to count how many hits I got in a cursor
> in PL/pgsql?
> >
> > I have a function that will "window" through the result of
> a (large)
> > query based on two parameters, but I also want to return
> the number of
> > hits to the client. Right now I'm looping through the e
> select count(*) from new ??? - new refers to a record not a table name
In the description in the manual, new and old are described as
relations... Also, isn't the point that the query is rewritten into the
new query with rules, thus if you update more than one row, new should
be all the updated
Hi!
I'm trying to fix a bug (?) in my design but I'd like to understand my mistake
first, so that I don't do that again.
I'm inserting rows into a table that are results from an external physical
process and I have some operations that I was automating inside the database
with triggers:
-
On 11/3/06, Magnus Hagander <[EMAIL PROTECTED]> wrote:
> > Is there any way to count how many hits I got in a cursor
> in PL/pgsql?
> >
> > I have a function that will "window" through the result of
> a (large)
> > query based on two parameters, but I also want to return
> the number of
> > hits
On Fri, Nov 03, 2006 at 09:49:17AM -0300, Jorge Godoy wrote:
> I'm trying to fix a bug (?) in my design but I'd like to understand my mistake
> first, so that I don't do that again.
> But when I converted those to (before) triggers I started having a problem
> where it tries reading data from th
Martijn van Oosterhout writes:
> "Before" triggers can't see the data changes yet, they are, by
> definition, before the commit.
That's what I thought... But then, I was in doubt with the serialization
level and the fact that all was being done inside the very same transaction.
I thought all da
Mike G wrote:
Hi,
I had someone pull the plug on my database about a week ago. When it was
restarted
postgres would not start because of the postmaster.pid file existed already. I
deleted
the pid file and attempt to restart the postmaster but it again failed. The
error this
time was that L
On Fri, Nov 03, 2006 at 10:24:21AM -0300, Jorge Godoy wrote:
> But then, the answer to my question is that even inside the same transaction
> or receiving the NEW row those functions called by the trigger shouldn't see
> the information. Did I get it right?
Correct. Before triggers happen prior t
Martijn van Oosterhout writes:
> On Fri, Nov 03, 2006 at 10:24:21AM -0300, Jorge Godoy wrote:
>> But then, the answer to my question is that even inside the same transaction
>> or receiving the NEW row those functions called by the trigger shouldn't see
>> the information. Did I get it right?
>
On Fri, 3 Nov 2006, Merlin Moncure wrote:
> >
> > I can deal with materializing the resultset, but I want to get away from
> > the loop-a-thousand-times-doing-plus-one...
>
> i dont think its possible. note that you can make a refcursor inside
> your plpgsql function and pass it to an sql function
I confess to having once written code that prints something like
"Items # 1 to 10 of 45"
by using select count(*) from t where condition; and select * from t
where condition limit 10 offset x;
I now know this is "bad", I guess because of the count() and the offset.
So what is the preferred way
On 11/3/06, Richard Troy <[EMAIL PROTECTED]> wrote:
On Fri, 3 Nov 2006, Merlin Moncure wrote:
> >
> > I can deal with materializing the resultset, but I want to get away from
> > the loop-a-thousand-times-doing-plus-one...
>
> i dont think its possible. note that you can make a refcursor inside
> > > I can deal with materializing the resultset, but I want
> to get away
> > > from the loop-a-thousand-times-doing-plus-one...
> >
> > i dont think its possible. note that you can make a
> refcursor inside
> > your plpgsql function and pass it to an sql function which
> can do sql
> > cu
Rick Schumeyer wrote:
I confess to having once written code that prints something like
"Items # 1 to 10 of 45"
by using select count(*) from t where condition; and select * from t
where condition limit 10 offset x;
I now know this is "bad", I guess because of the count() and the offset.
Well
Hi all,
I've got a database on a server that can be accessed thru the user wwwrun with
no password. Now I'd like to copy it on my laptop, so I created the wwwrun
(with no password) and thru pg_dump and pg_restore I copied the database on
the laptop. The problem is that on the latter I'm unable t
> Nope, the query is way too expensive to run it twice. (GIN scan over
> well over half a million rows. It's faster to do the
> get-as-cursor-then-loop-and-increment, I've measured that)
Can't you select into a temporary table and then do select count(*)
over that table, aswell as run your cursor
> > Nope, the query is way too expensive to run it twice. (GIN
> scan over
> > well over half a million rows. It's faster to do the
> > get-as-cursor-then-loop-and-increment, I've measured that)
>
> Can't you select into a temporary table and then do select
> count(*) over that table, aswell a
am Fri, dem 03.11.2006, um 15:36:04 +0100 mailte Luca Ferrari folgendes:
> Hi all,
> I've got a database on a server that can be accessed thru the user wwwrun
> with
> no password. Now I'd like to copy it on my laptop, so I created the wwwrun
> (with no password) and thru pg_dump and pg_restore
Richard Huxton writes:
> surabhi.ahuja wrote:
>> i have noted the following lines in the script to start or shut down
>> postmaster.
>> ...
> Yes - this looks like a Red Hat script. It's certainly not the one that
> ships with the source distribution.
It's not the one that ships with Red Hat,
On Friday 03 November 2006 15:44 A. Kretschmer's cat, walking on the keyboard,
wrote:
> The settings in your pg_hba.conf.
> This file contains comments, read this to understand the proper content.
> I guess, you want change the method to trust.
But I've already configured pg_hba.conf (maybe in a
Thanks for the link.
However, I was thinking in terms of how and where the geometric datatypes
are used and why they were developed.
Bob Pawley
- Original Message -
From: "A. Kretschmer" <[EMAIL PROTECTED]>
To:
Sent: Thursday, November 02, 2006 10:17 PM
Subject: Re: [GENERAL]
am Fri, dem 03.11.2006, um 15:58:51 +0100 mailte Luca Ferrari folgendes:
> On Friday 03 November 2006 15:44 A. Kretschmer's cat, walking on the
> keyboard,
> wrote:
> > The settings in your pg_hba.conf.
> > This file contains comments, read this to understand the proper content.
> > I guess, you
On Friday 03 November 2006 16:17 A. Kretschmer's cat, walking on the keyboard,
wrote:
> Yes, this is okay. Do you have an other line with host all all ... below
> this line? Have you restart/reload the database after editing?
Of course I've a similar line for the ipv6 connections and the followi
Luca Ferrari <[EMAIL PROTECTED]> schrieb:
> On Friday 03 November 2006 16:17 A. Kretschmer's cat, walking on the
> keyboard,
> wrote:
> > Yes, this is okay. Do you have an other line with host all all ... below
> > this line? Have you restart/reload the database after editing?
>
>
> Of course
Is it possible to invoke a computer language other than postgres sql as
the result of a trigger firing, eg something like Java.
Dave.
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nom
On Fri, Nov 03, 2006 at 03:22:40PM -, David Potts wrote:
> Is it possible to invoke a computer language other than postgres sql as
> the result of a trigger firing, eg something like Java.
Sure, many languages are supported, C, perl, tcl, python and yes, even Java.
Have a nice day,
--
Martij
On Friday 03 November 2006 16:40 Andreas Kretschmer's cat, walking on the
keyboard, wrote:
>
> try psql -h localhost ...
That worked!
Thanks,
Luca
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
am Fri, dem 03.11.2006, um 17:06:01 +0100 mailte Luca Ferrari folgendes:
> On Friday 03 November 2006 16:40 Andreas Kretschmer's cat, walking on the
> keyboard, wrote:
> >
> > try psql -h localhost ...
>
>
> That worked!
> Thanks,
Great, okay.
The reason is, without -h, psql connect to the d
redhog wrote:
select count(*) from new ??? - new refers to a record not a table name
In the description in the manual, new and old are described as
relations... Also, isn't the point that the query is rewritten into the
new query with rules, thus if you update more than one row, new should
be a
On 11/2/06, louis gonzales <[EMAIL PROTECTED]> wrote:
Hey Brian,
Yeah I had considered this, using cron, I just feel like that is too dirty.
Actually I didn't see Andreas' post, can someone forward that?
I'm running this application on Solaris 9. Ultimately what I want to
know is, is there som
Dear PostGreSQL experts,
I am working with text objects. A text object will have lots of fields that
are potentially multiple. There may be more than one author, more than one
modern editor, more than one edition number, etc.
These potentially multiple fields are, in my schema, nothing more th
Hi,
We are in the process of porting an application from SQL Server to
PostgresQL.
We have a table which contains a bunch of prepaid PINs. What is the
best way to fetch the next available unique pin from the table in a
high-traffic environment with lots of concurrent requests?
For example, our
PL/Java might help you hereThank you,---Shoaib MirEnterpriseDB (www.enterprisedb.com)On 11/3/06,
David Potts <[EMAIL PROTECTED]> wrote:
Is it possible to invoke a computer language other than postgres sql asthe result of a trigger firing, eg something like Java.Dave.---
I'm trying to produce a decimal fraction by dividing integer fields
like this fragment of the query:
...((cntoh0.count + cntoh1.count)/ttl_deptcat.ttlcount) as "Ratio"...
I get this output
dept_cat | cnt_oh_0 | cnt_oh_1 | sum_oh_0+1 | ttl_count | Ratio
+--+--+-
I think we've figured out a way to implement the equivalent of a
READPAST hint in a function.
The basic idea is to loop until we find the next available unlocked
row, using the lock_not_available exception to determine if the record
is locked or not. Our early testing seems to indicate that this
Any issues with running PostgreSQL on a Windows 2003 server that
already has Microsoft SQL Server Desktop Engine? What about with MS
SQL Server?
---(end of broadcast)---
TIP 6: explain analyze is your friend
Hi, I'm trying to create a dumpfile for a client. The data is gathered
from about 7 tables, and I need to output all the columns as the client
wishes.
I figure the best way to this is to collect data from multiple tables
and putting them into a view, and using the client's desired names to
be the
Hi All,
I want to add x and y. John and Joe do not have a “y”
value, so the LEFT JOIN returns NULL. Likewise Jane does not have a value for “x”
so the LEFT JOIN returns null for her. The “x” and “y” columns
are correct, but I would expect the “total” column to have 24, 232,
and 4. myvi
I'm new to Postgres, but have been impressed so far.
We're using a remote Postgres server to view video data. It works
well, but we're having a hard time making our app robust when the
network fails. For example, PQexec does not return consistently when
the cable is disconnected. Is there a time
[EMAIL PROTECTED] wrote:
> Any issues with running PostgreSQL on a Windows 2003 server that
> already has Microsoft SQL Server Desktop Engine? What about with MS
> SQL Server?
It would be generally considered insane, but sure it will work ;)
Sincerely,
Joshua D. Drake
>
>
>
[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
> Any issues with running PostgreSQL on a Windows 2003 server that
> already has Microsoft SQL Server Desktop Engine? What about with MS
> SQL Server?
You can do this without problems.
Andreas
--
Really, I'm not out to destroy Microsoft. That wil
On Nov 2, 2006, at 23:54 , [EMAIL PROTECTED] wrote:
I'm trying to produce a decimal fraction by dividing integer fields
like this fragment of the query:
...((cntoh0.count + cntoh1.count)/ttl_deptcat.ttlcount) as "Ratio"...
...
How do I get fractions when dividing integers? Cast as something?
Oleg Bartunov wrote:
> Gregory,
>
> All you described you do with fti is possible with tsearch2. Just need
> some think, of course. If you don't need stemming, just don't use it,
> if you need something like %txt%, just write simple dictionary, which
> produce any substrings from input word.
Is t
[EMAIL PROTECTED] <[EMAIL PROTECTED]> schrieb:
> Hi, I'm trying to create a dumpfile for a client. The data is gathered
> from about 7 tables, and I need to output all the columns as the client
> wishes.
>
> I figure the best way to this is to collect data from multiple tables
> and putting them
On Sun, Oct 29, 2006 at 08:32:12AM -0800, Bobus wrote:
> 10 users request a pin at the same time. What is the easiest/best way
> to ensure that the 10 users will get 10 unique pins, while eliminating
> any waiting?
What are you doing that holds locks for so long? If you do a select for
update, ta
> We are in the process of porting an application from SQL Server to
> PostgresQL.
>
> We have a table which contains a bunch of prepaid PINs. What is the
> best way to fetch the next available unique pin from the table in a
> high-traffic environment with lots of concurrent requests?
>
> For ex
On Thu, Nov 02, 2006 at 04:36:49PM +, Benjamin Weaver wrote:
> Dear PostGreSQL experts,
>
>
> I am working with text objects. A text object will have lots of fields that
> are potentially multiple. There may be more than one author, more than one
> modern editor, more than one edition numbe
> I want to add x and y. John and Joe do not have a "y" value, so the LEFT
> JOIN returns NULL. Likewise Jane does not have a value for "x" so the
> LEFT JOIN returns null for her. The "x" and "y" columns are correct, but
> I would expect the "total" column to have 24, 232, and 4. myview is a
> vi
In response to "Bobus" <[EMAIL PROTECTED]>:
> Hi,
>
> We are in the process of porting an application from SQL Server to
> PostgresQL.
>
> We have a table which contains a bunch of prepaid PINs. What is the
> best way to fetch the next available unique pin from the table in a
> high-traffic env
[EMAIL PROTECTED] wrote:
Any issues with running PostgreSQL on a Windows 2003 server that
already has Microsoft SQL Server Desktop Engine? What about with MS
SQL Server?
No issues on Windows XP, 2003 Server should be similar.
--
P. J. "Josh" Rovero Sonalysts,
We're taking some politically expensive downtime to drop an index
on a very large, heavily used table because to do it while live
blocks too many users for too long, requiring tens of seconds or
more on a system doing 200 transactions/second. That's due to
the fact that nearly every user inter
> COALESCE works great! Is there a way to default the LEFT JOIN to return
> zero and not NULL? Then we could use COALESCE on strings only. Most of
> our columns are integers not strings. This would make our queries
> simpler for 99% of the columns.
> Thanks,
> Robert Balzli
>
> PS: I will join the
On Fri, 3 Nov 2006, Joshua D. Drake wrote:
Oleg Bartunov wrote:
Gregory,
All you described you do with fti is possible with tsearch2. Just need
some think, of course. If you don't need stemming, just don't use it,
if you need something like %txt%, just write simple dictionary, which
produce an
Hi All,
I am using postgres 8.0 on a windows server and I create and delete
database frequently. However I have noticed that the number of
subdirectories in the base directory does not reflect the number of
databases.
Can I delete the directories that do not correspond to the OIDs in:
selec
Regarding this question,
I'm wondering that the ways of executing stored procedure, triggers and user-defined function are all the same in view of a query planning.
Thanks,
jungmin
On 11/3/06, Shoaib Mir <[EMAIL PROTECTED]> wrote:
PL/Java might help you hereThank you,---Shoaib MirEnterp
On Fri, 2006-11-03 at 09:06 -0500, Rick Schumeyer wrote:
> I confess to having once written code that prints something like
> "Items # 1 to 10 of 45"
> by using select count(*) from t where condition; and select * from t
> where condition limit 10 offset x;
>
> I now know this is "bad", I guess b
David Potts wrote:
Is it possible to invoke a computer language other than postgres sql as
the result of a trigger firing, eg something like Java.
Dave.
http://wiki.tada.se/wiki/display/pljava/Home
Regards,
Thomas Hallgren
---(end of broadcast)---
I have Postgresql DB on a local machine that is updated periodically.
I could have a script that would run pg_dump and then ftp it up to the
host machine each 15 minutes say.
Would I then be able to run pg_restore each time autonomously on the
host machine to load the updated database?
-
On 3 Nov 2006 at 13:40, numb3rs wrote:
> Would I then be able to run pg_restore each time autonomously on the
> host machine to load the updated database?
I don't see why not.but you might be better off using replication
- have a look at Slony.
http://gborg.postgresql.org/project/slony1/pro
numb3rs <[EMAIL PROTECTED]> schrieb:
> I have Postgresql DB on a local machine that is updated periodically.
> I could have a script that would run pg_dump and then ftp it up to the
> host machine each 15 minutes say.
>
> Would I then be able to run pg_restore each time autonomously on the
> host
I am designing an application which requires fine-grained role-based
security, where every logical object in the system has an ACL which
expresses the permissions allowed by roles.
Implementing this on a high level is trivial, but it must scale, and
scale extremely well. I have some fairly
On Thu, Nov 02, 2006 at 09:11:58PM +0530, Sandeep Kumar Jakkaraju wrote:
> Like We have used the Haversine formula ...given on most of the websites ...
> to calculate the distance between to lat/lon points ..
You can examine the PostGIS source code to see how distance_sphere()
works; the underlyin
Josh Rovero wrote:
[EMAIL PROTECTED] wrote:
Any issues with running PostgreSQL on a Windows 2003 server that
already has Microsoft SQL Server Desktop Engine? What about with MS
SQL Server?
No issues on Windows XP, 2003 Server should be similar.
Technically it could be done - the real quest
I'm completely new to pgsql, using 8.1 and pgAdmin III. I'm not finding a lot
of bare bones simple example stored procs that I can learn from. It would be
very helpful if someone could show me some simple code.
In the pgAdmin interface I've been picking SQL as the language, that's the
default it
[EMAIL PROTECTED] wrote:
Any issues with running PostgreSQL on a Windows 2003 server that
already has Microsoft SQL Server Desktop Engine? What about with MS
SQL Server?
No issues on Windows XP, 2003 Server should be similar.
no issues on 2003 server either. just make sure you have enough ra
Hi All
I am unable to find PostGIS Binary RPM for Red Hat Linux ...on the postgis.org website ...
Can somebody point me to the url from where i can download ...this ??
Thanks in advance
Sandeep
75 matches
Mail list logo
