queries?
Message-ID: <[EMAIL PROTECTED]>
Reply-To:
Froa: Marc Weber <[EMAIL PROTECTED]>
Hi,
I'd like to implement some query checking at compile time for haskell
using template haskell.
Is there any query method such as
explain input and output types of query "SELECT (1,'string')"
or "INSERT IN
On May 28, 2008, at 9:27 PM, edfialk wrote:
example rows from huge table (almost 900,000 rows):
fips, pollutant, value
That's not really huge in comparison with other pgsql databases.
There are terabyte installations out there ;)
SELECT small.fips, small.geom, small.name, SUM(huge.value)
On May 29, 5:17 am, hobbes <[EMAIL PROTECTED]> wrote:
> Hi Guys,
>
> I have been trying to get my local (windows) machine's PgAdmin II to
> connect directly to a remote Linux (Debian) Server where Postgresql
> 8.3 is installed.
>
> I have set in my postgresql.conf (remote):
>
> listen_addresses = '
edfialk wrote:
So, what I need is all kinds of things, but to start (pseudo-query):
SELECT small.fips, small.geom, small.name, SUM(huge.value) from small
JOIN huge on huge.fips = small.fips WHERE (SUM(huge.value)) > 500 AND
huge.pollutant='co';
wonder if that makes sense. Obviously, can't have
"edfialk" <[EMAIL PROTECTED]> writes:
> So, what I need is all kinds of things, but to start (pseudo-query):
>
> SELECT small.fips, small.geom, small.name, SUM(huge.value) from small
> JOIN huge on huge.fips = small.fips WHERE (SUM(huge.value)) > 500 AND
> huge.pollutant='co';
>
> wonder if that m
edfialk wrote:
> SELECT small.fips, small.geom, small.name, SUM(huge.value) from small
> JOIN huge on huge.fips = small.fips WHERE (SUM(huge.value)) > 500 AND
> huge.pollutant='co';
>
> wonder if that makes sense. Obviously, can't have an aggregate in
> where clause, so I've tried a couple WHERE
Hey everybody, I'm having an issue executing the query I want. I've
let a couple queries run a good 20 minutes and it still hasn't
finished. For my app, this is way too long to be useful, and I'm not
real sure what else I can do, let alone if my query is even what I
want.
So I'm really hoping th
I wrote:
> "Francisco Reyes" <[EMAIL PROTECTED]> writes:
>> On 3:09 pm 05/28/08 Gregory Stark <[EMAIL PROTECTED]> wrote:
> Does it really have a COPY command at the beginning? Are you really doing >\i
> data/usb_t_60M.sql or were you trying to do a copy from this file?
>> Argh..That's it.
>> When
hobbes <[EMAIL PROTECTED]> writes:
> I have been trying to get my local (windows) machine's PgAdmin II to
> connect directly to a remote Linux (Debian) Server where Postgresql
> 8.3 is installed.
What exactly happens when you try?
A reasonable guess is that you need to poke a hole in your firewal
Hi Guys,
I have been trying to get my local (windows) machine's PgAdmin II to
connect directly to a remote Linux (Debian) Server where Postgresql
8.3 is installed.
I have set in my postgresql.conf (remote):
listen_addresses = '*' # what IP address(es) to listen on;
"Francisco Reyes" <[EMAIL PROTECTED]> writes:
> On 3:09 pm 05/28/08 Gregory Stark <[EMAIL PROTECTED]> wrote:
>> Does it really have a COPY command at the beginning? Are you really doing
>> >\i data/usb_t_60M.sql or were you trying to do a copy from this file?
> Argh..That's it.
> When I re-organi
2008/5/27 Webb Sprague <[EMAIL PROTECTED]>:
> I am trying to return a 2-d array with filled in values, but I can't
> find a way to initialize the array programmatically (ie, in a
> function, with the array size being determined by parameter values.
>
> here is one approach
>
>> Well, the point is t
On Wed, May 28, 2008 at 03:42:47PM -0400, Francisco Reyes wrote:
> Is there a slowdown by keeping the debug RPM?
> Or should I only have it when trying to troubleshoot a problem?
Debug info costs nothing if its not being used.
Have a nice day,
--
Martijn van Oosterhout <[EMAIL PROTECTED]> ht
On 3:09 pm 05/28/08 Gregory Stark <[EMAIL PROTECTED]> wrote:
>Does it really have a COPY command at the beginning? Are you really doing >\i
>data/usb_t_60M.sql or were you trying to do a copy from this file?
Argh..That's it.
When I re-organized the scripts I must have taken the copy command from
"Bob Pawley" <[EMAIL PROTECTED]> writes:
> The concept of most lists should be "the free exchange of ideas in the most
> efficient manner possible".
What is this in response to?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA servic
"Francisco Reyes" <[EMAIL PROTECTED]> writes:
> #1 0x002a955820ae in pqPutMsgBytes (buf=0x2a9860a010, len=2147483647,
So it's trying to execute an sql query that's MAXINT bytes long which is
pretty off-course.
> #5 0x00406e95 in SendQuery (
> query=0x2a9860a010
> "yjbjK8WKLRH
Malcolm Standring came up with the following tip which might be of use
to other XP Home users.
--- Malcolm's message below ---
Sorry to trouble you like this (not yet subscribed to Postgres lists,
but didn't want to loose this snippet) concerning a thread in March -
I stumbled on a way to ma
"Alban Hertroys" <[EMAIL PROTECTED]> writes:
> THE 'active' query (not AN) is the query that's currently being executed on a
> connection. There can be multiple connections with an active query each. You
> can't execute multiple queries in parallel on the same connection. You can
> execute them
"Chris Browne" <[EMAIL PROTECTED]> writes:
> RT has a very different purpose; it was designed to track work (e.g. -
> "work tickets"), as opposed to managing web site content.
>
> It *might* be used as a bug tracker, though with a considerably
> different flavour from (say) Bugzilla; as a CRM, it
"Tom Lane" <[EMAIL PROTECTED]> writes:
> Bottom line: have some respect for your readers. Make it easy to
> distinguish what you wrote from the preceding material, and remember
> that the only reason you are quoting anything at all is to provide some
> context for what you are saying. We don't
On 11:09 am 05/28/08 Tom Lane <[EMAIL PROTECTED]> wrote:
Re-send. Didn't do reply-all before.
> Well, it would be if it were right; but PQsendQuery doesn't call
> PQunescapeBytea, so there's something wrong with the debug info.
..
> > compat-postgresql-libs-debuginfo-3-2PGDG.rhel4.x86_64.rpm
Th
On Tue, May 27, 2008 at 4:18 AM, Mark Neely <[EMAIL PROTECTED]> wrote:
> I've already shortlisted potential CMS systems (including several open-
> source options, such as Drupal and Joomla).
[snip...]
> I am looking for examples of open-source CRM (or similar platforms)
> used for this kind of pr
On Wed, 2008-05-28 at 09:20 -0700, Steve Atkins wrote:
> On May 28, 2008, at 8:52 AM, David Wall wrote:
>
> > What about SugarCRM?
>
Drupal works fine with PostgreSQL :)
Joshua D. Drake
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscript
[EMAIL PROTECTED] (Kaloyan Iliev) writes:
> And what about RT (Request Tracker - http://bestpractical.com/rt/)
> .
> AFAIK it is free and open-source, uses Postgres and is easy to setup.
RT has a very different purpose; it was designed to track work (e.g. -
"work tickets"), as opposed to managing
If I'm not totally off-base, here's one way to enable clustering on systems
that run 24/7:
1 cluster current rows
1.1 note current last committed transaction
1.2 copy all visible rows to new table in cluster order
1.3 build indexes on new table
2 add changes
2.1 note current last c
On May 28, 2008, at 8:52 AM, David Wall wrote:
What about SugarCRM?
It's nice, but it's MySQL only, with a few desiccated corpses of ports
to PostgreSQL done by third parties littered in it's wake.
vTiger is a fork / knock-off of Sugar which has sorta-kinda support
for PostgreSQL in old
What about SugarCRM?
David
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On 11:09 am 05/28/08 Tom Lane <[EMAIL PROTECTED]> wrote:
> > I installed
> > compat-postgresql-libs-debuginfo-3-2PGDG.rhel4.x86_64.rpm
> > postgresql-debuginfo-8.2.7-1PGDG.rhel4.x86_64.rpm
>
> Do those *exactly* match the versions of the Postgres RPMs you're
> using?
I got them from the same di
"Francisco Reyes" <[EMAIL PROTECTED]> writes:
> (gdb) bt
> #0 0x003cc31723e6 in memcpy () from /lib64/tls/libc.so.6
> #1 0x00364bf0e0ae in PQunescapeBytea () from /usr/lib64/libpq.so.5
> #2 0x00364bf0e230 in PQunescapeBytea () from /usr/lib64/libpq.so.5
> #3 0x00364bf0c09e in PQ
On 6:28 pm 05/27/08 Tom Lane <[EMAIL PROTECTED]> wrote:
> Can you get us a stack trace from the crash?
Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 182894175648 (LWP 4487)]
0x003cc31723e6 in memcpy () from /lib64/tls/libc.so.6
(gdb) bt
#0 0x003cc31723e6 in mem
On Wed, May 28, 2008 at 04:59:33PM +0800, laser wrote:
> >Yes, use a TRIGGER instead a RULE for such tasks.
>
> thanks, good to know it's a bug and we'll try TRIGGER approach.
It's not a bug, just your misunderstanding of how rules work. Rules
rewrite queries. What happen in your case is because
Mark Neely wrote:
Hi,
I am working with a client (a media company) that is re-developing its
web publishing system.
I've already shortlisted potential CMS systems (including several open-
source options, such as Drupal and Joomla).
The brief requires a site that has sophisticated profiling ca
A. Kretschmer wrote:
am Wed, dem 28.05.2008, um 15:56:22 +0800 mailte laser folgendes:
hi all,
see query below:
create table ruleTest(id integer, name text);
create or replace rule ruleTest_insert_rule AS on insert to ruleTest
where exists(select 1 from ruleTest where ruleTest.name = NEW.
am Wed, dem 28.05.2008, um 15:56:22 +0800 mailte laser folgendes:
> hi all,
>
> see query below:
>
> create table ruleTest(id integer, name text);
>
> create or replace rule ruleTest_insert_rule AS on insert to ruleTest
> where exists(select 1 from ruleTest where ruleTest.name = NEW.name)
> do
hi all,
see query below:
create table ruleTest(id integer, name text);
create or replace rule ruleTest_insert_rule AS on insert to ruleTest
where exists(select 1 from ruleTest where ruleTest.name = NEW.name)
do instead (update ruleTest set id = id+1 where ruleTest.name = NEW.name);
create uniq
35 matches
Mail list logo
