I believe contrib/dblink may be what you're after...
On Sat, 4 Nov 2006, stig erikson wrote:
Hi.
a handy thing in mysql is FEDERATED tables that allows one to open a channel
from one MySQL-server to another MySQL-server.
it helps a lot when writing stored procedures that transfer data to other
Russell Smith <[EMAIL PROTECTED]> writes:
> I got this error the other day, I was under the impression that vacuum could
> get a concurrently updated tuple. I could be wrong. It is possible for
> somebody to quickly explain this situation? Message follows;
> vacuumdb: vacuuming of table "scho
Hello,
I got this error the other day, I was under the impression that vacuum could
get a concurrently updated tuple. I could be wrong. It is possible for
somebody to quickly explain this situation? Message follows;
vacuumdb: vacuuming of table "school.person" in database "sqlfilter" failed
On Mon, Oct 30, 2006 at 11:46:01AM -0800, [EMAIL PROTECTED] wrote:
> 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 disconne
On Nov 4, 2006, at 5:44 , Anonymous wrote:
Please note that natural joins may be dangerous in production code.
See
the following thread for more detailed information...
http://forums.oracle.com/forums/thread.jspa?threadID=440287
All that thread shows is that people are using natural join w
I am looking at PostgreSql native geometry.
I am wondering if it can be used in conjunction with a basic drawing
package.
If so, is there a recommended drawing package to use? Are there any examples
of this type of use?
Bob
- Original Message -
From: "Michael Fuhr" <[EMAIL PROTE
On Sat, Nov 04, 2006 at 10:12:00PM +0100, stig erikson wrote:
> a handy thing in mysql is FEDERATED tables that allows one to open a
> channel from one MySQL-server to another MySQL-server.
> it helps a lot when writing stored procedures that transfer data to other
> servers. you can do the trans
On Sat, Nov 04, 2006 at 05:01:12PM -0800, Bob Pawley wrote:
> What is an example of how geometric datatypes are being used?
They could be used for simple GIS applications (e.g., storing
latitude/longitude as points), although PostGIS would be more
suitable for non-trivial needs. Are you asking ab
Hi all!
This is most certainly a lame question but perhaps
someone is gracious enough to lend me a hand… ;-)
I have the following setup in a table:
The first record which is to be found (ok easy enough
:D) with a timestamp meets a certain condition (ignition off)
The following
Thanks again everyone.
I thought pgSQL might be case sensitive so I tried all variations (mentioned
all of this in prev msgs)
Oh...I just figured out what it was. I did created the proc successfully.
The pgAdmin III interface saved it, moved it from the procedures hive to the
functions hive. Eac
Hi.
a handy thing in mysql is FEDERATED tables that allows one to open a channel
from one MySQL-server to another MySQL-server.
it helps a lot when writing stored procedures that transfer data to other
servers. you can do the transfer without
any extarnal temporary files or external applications
Raymond O'Donnell wrote:
> On 4 Nov 2006 at 18:24, Alain Roger wrote:
>
>> However, i've read that before i must restore the image by exporting
>> them to local (on server) file.
>
> You can use bytea type to store binary data directly in the database -
> if it's any use to you, I can send you
Thanks Richard! All is working fine now...
> -Original Message-
> From: Richard Broersma Jr [mailto:[EMAIL PROTECTED]
> Sent: Friday, November 03, 2006 10:50 AM
> To: robert.balzli
> Cc: General PostgreSQL List
> Subject: RE: [GENERAL] I can not add up columns when using a left
outer
> joi
Alexander Staubo wrote:
> 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
Please note that natural joins may be dangerous in production code. See
the following thread for more detailed information...
http://forums.oracle.com/forums/thread.jspa?threadID=440287
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
Dear Martijn,
Wow, didn't know about arrays. Did lots of sql, but, as I think about it,
that was 7 years ago, and we didn't know about arrays then
Are their performance problems with arrays? We will not likely be working
with more than 50,000 - 100,000 records.
Ben
In message <[EMAIL PROTE
The ADDLOCAL parameter that allows to only install certain modules for the PostgreSQL via the silent installer for win32 does not. It ends up installing everything. Does anyone have a workaround or fix for this? Here is my command:msiexec /i "postgresql-8.1-int.msi" /qr /log install.log INTERNAL
What is an example of how geometric datatypes are being
used?
Bob Pawley
On Nov 4, 2006, at 11:34 , Martijn van Oosterhout wrote:
On Sat, Nov 04, 2006 at 04:23:02PM +0100, Alain Roger wrote:
however, when i do this, my encoding is in UTF-8 via phpAdmin.
UTF8 is a part of UNICODE, but as i'm not sure on how many bits is
UNICODE,
how can i setup my local DB to UNI
2006/11/4, Alain Roger <[EMAIL PROTECTED]>:
Hi,
Sorry to cross post this mail but i'm not able to know from where comes my
issue.
I have a postgreSQL database in UNICODE (UTF-8 in v8.1.4 and UNICODE in
v8.0.1).
Via my web application i type a sentence in Slovak language and it is stored
into DB
Hi,Sorry to cross post this mail but i'm not able to know from where comes my issue.I have a postgreSQL database in UNICODE (UTF-8 in v8.1.4 and UNICODE in v8.0.1).Via my web application i type a sentence in Slovak language and it is stored into DB without any slovak characters. Instead of that, al
Hugh, that's a long way to do that.
Thanks for the help.
SWK
Ketema wrote:
> It would be easier if we could see the context in which you are doing
> the select into. However I think this may help. Try putting the
> select into in a loop:
>
> declare
> _result record;
> _rows integer;
>
> Hi,
>
> I create a table with some large object (ref: OID) to store some images.
> When my PHP will display some data, it will also display the images
> stored as OID.
>
> However, i've read that before i must restore the image by exporting
> them to local (on server) file.
I'm not sure what y
On 4 Nov 2006 at 18:24, Alain Roger wrote:
> However, i've read that before i must restore the image by exporting
> them to local (on server) file.
You can use bytea type to store binary data directly in the database -
if it's any use to you, I can send you some ASP code that does this.
There
> That second query may not be the best, as it will probably seqscan and
> grab all the pins before only returning the first one ...
A partial index where USED_BY is null would eliminate the need for the
seqscan on the table...
--
Scott Ribe
[EMAIL PROTECTED]
http://www.killerbytes.com/
(303) 72
On Sat, 4 Nov 2006, novnov wrote:
>
> Thanks to both of you for responding. I should have included the code for my
> own attempt, at #1 which is just as you suggest:
>
> update item set itemname = 'fox';
>
> I've tried single, and double quoting the table and field names; call caps
> to the UPDATE
Hi,I create a table with some large object (ref: OID) to store some images.When my PHP will display some data, it will also display the images stored as OID.However, i've read that before i must restore the image by exporting them to local (on server) file.
isn't it easier in this case, to simply s
Yes, my provider has v8.0.1 and i have installed v8.1.4.thanks for your confirmation.Al.On 11/4/06, Martijn van Oosterhout <
kleptog@svana.org> wrote:On Sat, Nov 04, 2006 at 04:23:02PM +0100, Alain Roger wrote:
> however, when i do this, my encoding is in UTF-8 via phpAdmin.> UTF8 is a part of UNIC
On Sat, Nov 04, 2006 at 04:23:02PM +0100, Alain Roger wrote:
> however, when i do this, my encoding is in UTF-8 via phpAdmin.
> UTF8 is a part of UNICODE, but as i'm not sure on how many bits is UNICODE,
> how can i setup my local DB to UNICODE value as my provider has ?
As far a postgres is conce
> novnov wrote:
Thanks to both of you for responding. I should have included the code for
my own attempt, at #1 which is just as you suggest:
update item set itemname = 'fox';
I've tried single, and double quoting the table and field names; call caps
to the UPDATE etc, exactly matching the cap
novnov wrote:
And here is what shows in the SQL window for that proceedure
CREATE FUNCTION "proc_UpdateItemName"(IN "strItemName" "varchar") RETURNS
void AS
$BODY$update item set itemname = 'fox';$BODY$
LANGUAGE 'sql' VOLATILE;
The error is always "ERROR relation "item" does not exist". Not us
And here is what shows in the SQL window for that proceedure
CREATE FUNCTION "proc_UpdateItemName"(IN "strItemName" "varchar") RETURNS
void AS
$BODY$update item set itemname = 'fox';$BODY$
LANGUAGE 'sql' VOLATILE;
The error is always "ERROR relation "item" does not exist". Not using the
param,
Thanks to both of you for responding. I should have included the code for my
own attempt, at #1 which is just as you suggest:
update item set itemname = 'fox';
I've tried single, and double quoting the table and field names; call caps
to the UPDATE etc, exactly matching the capitalization of the
Hi,I tried to reproduce the same DB on my local server as my web provider gave me access.On this DB (from provider) i can see via phpAdmin pages that encoding is setup to UNICODE.after reading some documentation, i've seen that i had to create my DB on my local server like that :
create database my
On Fri, 3 Nov 2006, novnov wrote:
> 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
Hello,
On Sat, 2006-11-04 at 13:21 +0530, Sandeep Kumar Jakkaraju wrote:
> 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 ??
I am assuming that you want RPMs for RHEL, not RHL.
h
You can use the following:>>#1 updating ItemName for all rows to 'fox'update tablename set itemname = 'fox';>>#2 updating ItemName for row where ItemID = 2 to 'fox'update tablename set itemname = 'fox' where itemid = 2;
>>#3 updating ItemName for row where ItemID = 3 to a param value passed in\set
37 matches
Mail list logo
