I two Unix/ process related questions:
Is there a documented way to pass around an (opened) PGconn * structure
between two processes on Unix?
When a process forks() and both the parent and child process continue to
use a previously opened PGconn * structure, is that behaviour defined?
Thanks,
Ma
On Thu, Jul 22, 2010 at 1:02 PM, Scott Marlowe wrote:
>>
>> Why on Earth would I want to store this sort of stuff in a bit string?!
>
> Because you are manipulating bits and not integers? I guess there are
> 10 kinds of people, those who like think in binary and those who
> don't.
>
>> I don't
Hi All
Thanks for your suggestions . But the problem here seems to be with the way
slony applies triggers .
The result of below queries in the database gives the following results :
SELECT tgrelid,tgname,tgfoid from pg_trigger;
tgrelid|tgname | tgfoid
- +
On Wed, Jul 21, 2010 at 9:02 PM, Scott Marlowe wrote:
> If the fifth bit means one thing, and the 7th bit means something
> else, quick which of the following have the fifth bit set and the 7th
> bit off:
That should be fifth bit off and 7th bit on up there ^^^
>
> 01001101 (base2)
> or
> 77 (ba
On Wed, Jul 21, 2010 at 4:41 AM, Howard Rogers wrote:
> On Wed, Jul 21, 2010 at 6:08 PM, Scott Marlowe
> wrote:
>> On Tue, Jul 20, 2010 at 9:59 PM, Howard Rogers wrote:
>>> Suppose 1=Red, 2=Yellow, 4=Green and 8=Orange.
>>>
>>> Now suppose the following data structures and rows exist:
>>>
>>> c
On 21/07/10 20:21, paladine wrote:
>
> I have a linux daemon that parses some datas and writes to db continuously
> but my db is growing unexpectedly so I must reduce disk space once a week.
I assume you're also deleting from the database, given that its growth
is a problem.
It sounds like you n
On Wed, Jul 21, 2010 at 9:17 PM, Mathieu De Zutter wrote:
> On Wed, Jul 21, 2010 at 5:59 AM, Howard Rogers wrote:
>> It's also easy to find records which have either some yellow or some
>> orange (or both) in them:
>>
>> select * from coloursample where colour & 10>0;
>>
>> But how do I find reco
Hum right... Better follow Paul instructions. We are in geographic coordinates
here... Sorry. This would work in a limited projected space.
>-Original Message-
>From: pgsql-general-ow...@postgresql.org
>[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of
>Pierre Racine
>Sent: 21 jui
create table cities (
geog geography,
name varchar,
id integer primary key
);
insert into cities
select
Geography(ST_SetSRID(ST_MakePoint(lon, lat),4326)) as geog,
name, id
from mytable;
create index cities_gix on cities using gist ( geog );
select st_distance(a.geog, b.geog),
yasinma...@gmail.com (paladine) writes:
> Hi all
> I prefer doing pg_dump - psql restore to vacuum full and
> is there anyone know whether postgresql can insert data concurrently while
> restoring a table for not losing any data.
>
> thanks in advance...
The problem scenario that I'd expect is w
Once PostGIS is installed you can do it with a single SQL query looking like
this:
SELECT dest.id, ST_Distance(ST_MakePoint(orig.longitude, orig.latitude),
ST_MakePoint(dest.longitude, dest.latitude))
FROM yourcitytable orig, yourcitytable dest
WHERE ST_DWithin(ST_MakePoint(orig.longitude, orig.
On Jul 21, 2010, at 9:05 AM, Thom Brown wrote:
> On 21 July 2010 16:58, Ben Chobot wrote:
>> Is there any difference between "text" and "varchar" data types? (Not
>> varchar(n), just varchar.) I can't see a different from the manual page, but
>> I'm wondering about index usage or something simi
On 21 July 2010 16:58, Ben Chobot wrote:
> Is there any difference between "text" and "varchar" data types? (Not
> varchar(n), just varchar.) I can't see a different from the manual page, but
> I'm wondering about index usage or something similarly subtle.
> --
Here's what Tom Lane had to say o
varchar allows you to define an explicit length of the field, text does not.
varchar with a length specified (varchar(n)) is sql92 compliant while
varchar() and text are pgsql extensions.
On 2010-07-21 08:58:54AM -0700, Ben Chobot wrote:
> Is there any difference between "text" and "varchar" data
On Wed, 2010-07-21 at 08:58 -0700, Ben Chobot wrote:
> Is there any difference between "text" and "varchar" data types? (Not
> varchar(n), just varchar.) I can't see a different from the manual page, but
> I'm wondering about index usage or something similarly subtle.
They are the same thing. So
Is there any difference between "text" and "varchar" data types? (Not
varchar(n), just varchar.) I can't see a different from the manual page, but
I'm wondering about index usage or something similarly subtle.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes
On 07/21/2010 06:01 AM, Geoffrey wrote:
> We need to locate all cities within a certain distance of a single city.
> We have longitude and latitude data for all cities. I was thinking
> postGIS was a viable solution, but I don't see a way to use our existing
> data via postGIS.
>
> Is postGIS a
On 21 July 2010 10:43, Robot Tom wrote:
> Hi,
>
> Has there been any progress on nested transactions in the last 10 years?
>
PostgreSQL has had subtransactions since version 8.0, if that's what
you mean. If you're experiencing OOM a lot, a high work_mem setting is
often the culprit. This can be s
On 7/21/2010 8:01 AM, Geoffrey wrote:
We need to locate all cities within a certain distance of a single city.
We have longitude and latitude data for all cities. I was thinking
postGIS was a viable solution, but I don't see a way to use our existing
data via postGIS.
Is postGIS a viable solutio
Hi,
Has there been any progress on nested transactions in the last 10 years?
I am in a situation where I have a script that executes a number of
functions that build and populate a database including a rather large
lookup table (80GB) along with a number of large indexes (10GB).
I am trying
take Oracle Spatial SDO_FILTER Functio
Uses the spatial index to identify either the set of spatial objects that are
likely to interact spatially with a given object
Format: SDO_FILTER(geometry1, geometry2, params);
http://download.oracle.com/docs/html/A85337_01/sdo_oper.htm#76214
example
On Mon, Jul 19, 2010 at 8:14 PM, vinicius_bra wrote:
>
> Hi All,
>
> I'm developing a system in C and I have a unsigned char pointer that
> represents a struct and I like to store it in a bytea column in postgreSQL.
> How can I do it?
> Example:
you have several options:
*) encode the memory for
We need to locate all cities within a certain distance of a single city.
We have longitude and latitude data for all cities. I was thinking
postGIS was a viable solution, but I don't see a way to use our existing
data via postGIS.
Is postGIS a viable solution, or should I be looking at a dif
I have a linux daemon that parses some datas and writes to db continuously
but my db is growing unexpectedly so I must reduce disk space once a week.
vacuum full is one solution but pg_dump-restore gives back more space to OS.
I wrote a script like this
# pg_dump db > asd.sql (1)
# dropdb db
On 21/07/10 19:26, paladine wrote:
>
> Hi all
> I prefer doing pg_dump - psql restore to vacuum full and
> is there anyone know whether postgresql can insert data concurrently while
> restoring a table for not losing any data.
There's no particular reason why you can't just feed a data-only dum
Hi all
I prefer doing pg_dump - psql restore to vacuum full and
is there anyone know whether postgresql can insert data concurrently while
restoring a table for not losing any data.
thanks in advance...
--
View this message in context:
http://old.nabble.com/pg_dump-restore-concurrency-tp29224
Hi,
when I have an Oracle spatial database, I can easily convert it to
PostgreSQL database, using handwritten tool, or just dumping it to a shape
file and loading to the PostGis database. Do you know any simple way for
(semi)automatical conversion of the spatial queries from Oracle to PostGis?
I ha
On 21 Jul 2010, at 11:35, pdov...@tiscali.it wrote:
>> Yes, Jan's right. You're effectively overriding the return values
>> with NULL.
>>
>> Although I think I know why you're doing it, because you want to
>> redirect the value to the child table so that it doesn't get inserted
>> into the pare
Hi Tom
Messaggio originale
Da: thombr...@gmail.com
Data: 21/07/2010 10.38
A: "Jan Otto"
Cc: "pdov...@tiscali.it", "pgsql-
gene...@postgresql.org"
Ogg: Re: [GENERAL] INSERT RETURNING and partitioning
On 21 July 2010 09:17, Jan Otto wrote:
> hi,
>
> On Jul 21, 2010, at 10:02, "pdov...@tisc
Hi Jan,
Messaggio originale
Da: as...@me.com
Data: 21/07/2010 10.17
A: "pdov...@tiscali.it"
Cc: "pgsql-general@postgresql.org"
Ogg: Re: [GENERAL] INSERT RETURNING and partitioning
hi,
On Jul 21, 2010, at 10:02, "pdov...@tiscali.it"
wrote:
> Hi,
> I'm testing the system with these two
On 7/20/2010 11:59 PM, Howard Rogers wrote:
But how do I find records which are ONLY yellow and orange, and
exclude records which have some other colour mixed in, in one simple
query without a lot of 'not this, not that' additions, and without
using multiple separate AND tests to nail it down?
..
On 21 July 2010 09:17, Jan Otto wrote:
> hi,
>
> On Jul 21, 2010, at 10:02, "pdov...@tiscali.it" wrote:
>
>> Hi,
>> I'm testing the system with these two insert commands:
>>
>> 1) this command returns an empty result set:
>> insert into support.master (a) VALUES (2) RETURNING seq;
>>
>> 2) this c
Howard Rogers wrote:
insert into coloursample values (2,10,'Yellow and Orange');
But how do I find records which are ONLY yellow and orange
what about
select * from coloursample where colour = 10;
regards,
Yeb Havinga
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To
hi,
On Jul 21, 2010, at 10:02, "pdov...@tiscali.it"
wrote:
Hi,
I'm testing the system with these two insert commands:
1) this command returns an empty result set:
insert into support.master (a) VALUES (2) RETURNING seq;
2) this command returns correctly the seq (serial) value into result
On Tue, Jul 20, 2010 at 9:59 PM, Howard Rogers wrote:
> Suppose 1=Red, 2=Yellow, 4=Green and 8=Orange.
>
> Now suppose the following data structures and rows exist:
>
> create table coloursample (recid integer, colour integer, descript varchar);
> insert into coloursample values (1,2,'Yellow only'
Hi,
I'm testing the system with these two insert commands:
1) this command returns an empty result set:
insert into support.master (a) VALUES (2) RETURNING seq;
2) this command returns correctly the seq (serial) value into result
set:
insert into support.partitionB (a) VALUES (2) RETURNING seq;
Suppose 1=Red, 2=Yellow, 4=Green and 8=Orange.
Now suppose the following data structures and rows exist:
create table coloursample (recid integer, colour integer, descript varchar);
insert into coloursample values (1,2,'Yellow only');
insert into coloursample values (2,10,'Yellow and Orange');
in
On 21/07/10 15:08, Prometheus Prometheus wrote:
> head -> wall
That's about how I feel about SQL NULLs in general.
They seem like a great idea. A way of representing "unknown" or
"undefined" in a generic, consistent manner.
Or is that "a definite value that means empty or absent" ? Depends on
w
> Date: Wed, 21 Jul 2010 12:38:55 +0800
> From: cr...@postnewspapers.com.au
> To: prometheus...@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] what do i need to know about array index?
>
> On 20/07/10 18:27, Prometheus Prometheus wrote:
>
> What's with the pseudonym?
not
39 matches
Mail list logo
