Buckets: 1024 Batches: 1 Memory Usage: 12kB
-> Seq Scan on customers o (cost=0.00..20285.94 rows=184
width=8) (actual time=16.901..126.606 rows=430 loops=1)
Filter: (group_id = 45)
Rows Removed by Filter: 476221
Total runtime: 142.089 ms
(9 rows)
duction=> select count(*) from customers;
count
476645
(1 row)
Is it possible for explain analyze to somehow produce bad stats? I can't
figure out where that 212699113 number is coming from at all.
Sean
On Mon, Oct 12, 2015 at 5:43 PM, David Rowley
wrote:
> On 10 Octobe
s
(7 rows)
Sean
On Fri, Oct 9, 2015 at 1:09 PM, Igor Neyman wrote:
> Hello,
>
>
>
> I'm seeing some inexplicable (to me) behavior in PostgreSQL 9.2. I checked
>
> the archives, but I still can't explain it. Apologies if I missed
> something.
>
>
bout the same
performance in either case, but one query takes only a few hundred
milliseconds while the other takes hundreds of seconds. Ouch!
Can anyone help me explain this behavior?
Some details are below. Let me know if it would be helpful to gather others.
Sean
pr
run in to this before and in some scripts I run a CHECKPOINT before
sending a SIGINT, which reduces the size of the CHECKPOINT, but doesn't
necessarily eliminate it all of the time. In fact, I'm not sure it happens 100%
of the time either, but today I was bit by this shutdown/startup dela
fully
(supposedly).
START WAL LOCATION: 9F/3620 (file 0001009F0036)
CHECKPOINT LOCATION: 9F/37E9D6D8
BACKUP METHOD: pg_start_backup
BACKUP FROM: master
START TIME: 2012-10-06 17:48:10 UTC
LABEL: repmgr_standby_clone_1349545601
--
Sean Chittenden
s...@chittenden.org
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
ites safe, but that slaves are
still making assumptions about full page WAL entries being the MTU during some
corner cases. My observations lead me to believe that replication works fine
with full_page_writes disabled until the master cleans up a zero-filled or
damaged page.
For the arch
arios that come from a system running
out of FDs (though seek(2)'ing consuming an FD seems odd), it's more that it's
still possible for a master DB's VACUUM to clean up a bogus or partial page
write, and have the slave crash when the WAL entry is shipped over.
Are there any
alid pages
Oct 6 17:26:44 db02 postgres[19614]: [14-2] @ 19614 0: CONTEXT: xlog redo
vacuum: rel 1663/16387/20196; blk 2944, lastBlockVacuumed 2403
Oct 6 17:26:44 db02 postgres[19608]: [12-1] @ 19608 0: LOG: startup process
(PID 19614) was terminated by signal 6: Abort trap
Oct 6 17:26:4
Konstantin,
Just back from some time off and read this reply.
This was exactly the issue. The superuser "postgres" did not have this
role since this was a dump/restore/upgrade from postgres 8.4. I just
created a new Role and user, and it all worked!
Thanks!
--Sean
On 11/06/
On 11/04/2011 11:31 AM, Simon Riggs wrote:
On Fri, Nov 4, 2011 at 2:56 PM, Raghavendra
wrote:
# The standby server must have superuser access privileges.
host replication postgres 192.168.0.20/22 trust
I strongly recommend you don't use those settings, since they result
in no security at
On 11/04/2011 11:25 AM, Thom Brown wrote:
On 4 November 2011 17:19, Sean Patronis wrote:
On 11/04/2011 10:59 AM, Thom Brown wrote:
On 4 November 2011 16:50, Sean Patroniswrote:
I am running Postgres 9.1
I have followed the howto here:
http://wiki.postgresql.org/wiki
On 11/04/2011 10:59 AM, Thom Brown wrote:
On 4 November 2011 16:50, Sean Patronis wrote:
I am running Postgres 9.1
I have followed the howto here:
http://wiki.postgresql.org/wiki/Streaming_Replication
I am attempting to replicate an existing database.
On the Master, I get the following
I am running Postgres 9.1
I have followed the howto here:
http://wiki.postgresql.org/wiki/Streaming_Replication
I am attempting to replicate an existing database.
On the Master, I get the following error in the postgres log file:
FATAL: must be replication role to start walsender
On the sla
On Tue, Oct 11, 2011 at 8:50 PM, Scott Marlowe wrote:
> On Tue, Oct 11, 2011 at 5:00 PM, Sean Laurent wrote:
>> As much as I would like Postgres to withstand a 2 second outage, I
>> don't honestly care. I'd just like to figure out whether I'm looking
>> at so
tem - it's under load, but not a
tremendously high load. During our busier times we average something
in the neighborhood of 300-400 transactions per second, which just
doesn't seem like that much.
As much as I would like Postgres to withstand a 2 second outage, I
don't honestly ca
On Fri, Oct 7, 2011 at 12:36 AM, Tom Lane wrote:
>
> Sean Laurent writes:
> > We've been running into a particularly strange problem that I'm trying to
> > better understand. The super short version is that our application servers
> > lose their connection t
On Mon, Oct 10, 2011 at 8:09 AM, Craig Ringer wrote:
> On 10/07/2011 01:21 AM, Sean Laurent wrote:
>> Within a few seconds of the backup, our application servers start
>> throwing exceptions that indicate the database connection was closed.
>> Meanwhile, Postgres still show
time. The
backups were running every hour, but we have only seen the app servers crash
5-10 times over the course of a month.
Has anyone encountered anything like this? Do any of these steps have
ramifications that I'm not considering? Especially something that might
explain the app server failure?
Thanks.
Sean Laurent
Director of Operations
StudyBlue, Inc.
for the reply. I turned out to be a simple path issue. The
installer didn't put the correct path in. Now on to other problems
with psycopg :/
Sean
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
found. Did find:
/usr/lib/libpq.5.dylib: no matching architecture in universal wrapper
/usr/lib/libpq.5.dylib: no matching architecture in universal wrapper
Trace/BPT trap: 5
Does anyone know how to fix this?
Thanks in advance for the help!
Sean
--
Sent via pgsql-general mailing list
Magnus, congratulations! In my short two years around PostgreSQL your name has
been synonymous with super intelligence and a great attitude.
All the best
Sean
On Apr 27, 2011, at 1:48 PM, Dave Page wrote:
> I'm pleased to announce that effective immediately, Magnus Hagander
&
On 10 March 2011 14:21, Sean Hsien wrote:
> Hi,
>
> I've setup 2 nodes for streaming replication and it was working
> perfectly. I the tested multiple failovers, switching master/slave,
> and now the streaming replication doesn't work anymore.
>
> I had a look at
: user=postgres ...". From ps, the sender and
receiver processes have been started. However there is something
strange with the sender process, ps says:
postgres: wal sender process postgres xxx.xxx.xxx.xxx (48159) startup
And the streaming never starts. What are the possible problems?
Than
On Sun, Feb 27, 2011 at 1:04 PM, Jens Wilke wrote:
> On Sonntag, 27. Februar 2011, Sean Laurent wrote:
>
> > Unfortunately, most queries against the hot standby fail. Worse
> > yet, pg_dump fails:
> ...
> > I'm not entirely certain I understand why I'm seeing
ain I understand why I'm seeing this. Nor do I
understand how to fix or work around this. Any advice or suggestions would
be greatly appreciated.
-Sean
c is loaded with
#ifdef USE_PGSQL connection functions. Some of the PGSQL specific functions in
ndo2db.c are commented out, but are at least there.
Sean
in >postgres, which is
something else.
Daniel,
Buried in the ./ndoutils-1.4b9/db/README is wording that suggests it
may just be a matter of modifying the .sql file. What happens if you
just try it?
Best,
Sean
PostgreSQL system imposes, but it does exceed my server's
storage. Can anyone give a hint?
Thanks,Sean
_
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
. I think it is obvious because in below code there is no information
> where to connect to. Could you please help me out.
Hi, Dipti.
Have a look at the DBI documentation. As you suspect, you will need
to specify the host.
Sean
> use DBI;
> $DB_name = 'mydb';
> $
gards,
Sean
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Thanks Tom. That is what I suspected. I will install the branch tip on
Monday and see if the problem goes away.
Sean
Tom Lane wrote:
Sean Foreman writes:
We recently upgraded postgres from 8.1 to 8.4.
One of our queries stopped working and after some digging I've narrowed
the pr
a bug.
On Thu, Aug 27, 2009 at 2:13 PM, Sean
Foreman wrote:
We recently upgraded postgres from 8.1 to 8.4.
One of our queries stopped working and after some digging I've narrowed the
problem down to this:
table structure of interest:
merchant_set
merchant_set_id
merchant
m
There is no error message. Posgres "likes" the query. In this case, the
query returns a count of 1 instead of 3562.
Scott Marlowe wrote:
On Thu, Aug 27, 2009 at 2:13 PM, Sean
Foreman wrote:
We recently upgraded postgres from 8.1 to 8.4.
So, is there an error message you ge
We recently upgraded postgres from 8.1 to 8.4.
One of our queries stopped working and after some digging I've narrowed
the problem down to this:
table structure of interest:
merchant_set
merchant_set_id
merchant
merchant_id
merchant_set_id
customer
customer_id
merchant_set_id
-- failure (c
On Fri, Jan 30, 2009 at 7:43 AM, Reg Me Please wrote:
> I already have a JS interpreter (spidermonkey) but there is no PGSQL
> interfacing API!
> This'd be why I'm asking.
>
Ah. Sorry again. No idea if this will be useful, but you might take a look
at:
http://ww
is Rhino for java.
Sean
>
> On Friday 30 January 2009 12:53:05 Allan Kamau wrote:
> > May be Javascript + JDBC not sure.
> >
> > But the question is why would you want to do so?
> > Javascript can be read easily by the user having the javascript
> > running on
No. I'm not sure how that could be done given the security concerns.
Sean
On Fri, Jan 30, 2009 at 6:40 AM, Reg Me Please wrote:
> Hello all.
>
> Is there a way to directly access PGSQL from a Javascript application?
> With no application server intervention, I mean.
> J
r hints on using postgres in a data warehousing/mining
environment. Any suggestions on how DDL, loading, backup, indexing,
or (to a certain extent) hardware?
Thanks,
Sean
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
On Tue, Sep 30, 2008 at 1:18 PM, Merlin Moncure <[EMAIL PROTECTED]> wrote:
> On Tue, Sep 30, 2008 at 12:48 PM, Sean Davis <[EMAIL PROTECTED]> wrote:
>> On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote:
>>> There are a number of mysql to
On Tue, Sep 30, 2008 at 10:08 AM, Sean Davis <[EMAIL PROTECTED]> wrote:
> There are a number of mysql to postgresql converters available, but
> many of them have significant shortcomings. Has anyone found a tool
> that works well? I am trying to convert a couple of relatively
There are a number of mysql to postgresql converters available, but
many of them have significant shortcomings. Has anyone found a tool
that works well? I am trying to convert a couple of relatively large,
public schema to postgresql.
Thanks,
Sean
--
Sent via pgsql-general mailing list (pgsql
writing and somewhat faster for reading, but the "blocking" is
problematic, as the machine is serving multiple purposes.
I know this is off-topic, but I know lots of folks here deal with very large
disk arrays; it is hard to get real-world input on machines such as these.
Thanks,
Sean
Sorry I am not familiar with hyperic. Do you mean I can use hyperic to do the
job, or do you mean I can take the same approach as hyperic?
- Original Message
From: Scott Marlowe <[EMAIL PROTECTED]>
To: Sean Z. <[EMAIL PROTECTED]>
Cc: pgsql-general@postgresql.org
Sen
BTW, what's the best way to determine the installation folder, port number used
by an existing postgres server? From registry
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations ?
- Original Message
From: Scott Marlowe <[EMAIL PROTECTED]>
To: Sean Z. <[EMAIL PROTECT
any version existing on the same windows
box?
- Original Message
From: Scott Marlowe <[EMAIL PROTECTED]>
To: Sean Z. <[EMAIL PROTECTED]>
Cc: pgsql-general@postgresql.org
Sent: Wednesday, December 19, 2007 1:04:19 PM
Subject: Re: [GENERAL] Deploy postgres - upgrade strategy
VICEDOMAIN="%COMPUTERNAME%"
SERVICEPASSWORD="SecretWindowsPassword123" CREATESERVICEUSER=1
SUPERPASSWORD="postgres" BASEDIR="C:\Program Files\PostgreSQL"
DATADIR="e:\PostgreSQL.DATA"
Thanks a lot!
Sean
_
Hi,
I need to write a maintenance function to delete oldest records of a table,
leaving only a certain number of records, say 50. The task should run once per
day. How can I write it?
The oldest record carries the smallest ID.
Thanks a lot!
Sean
On Nov 19, 2007 9:08 PM, Jorge Godoy <[EMAIL PROTECTED]> wrote:
> Em Monday 19 November 2007 19:29:51 Sean Davis escreveu:
> > Just a simple question--does plpythonu (8.3beta) have support for
> > arrays? I don't see a specific mention of it in the docs, so I
> >
Just a simple question--does plpythonu (8.3beta) have support for
arrays? I don't see a specific mention of it in the docs, so I
suppose not.
Thanks,
Sean
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
3beta2) implies that errors generated in functions are
genuine python errors that I should be able to catch.
Thanks,
Sean
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Nov 16, 2007 2:14 PM, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Sean Davis wrote:
> > I meant a schema that
> > represents a general mapping between XML and a relational schema. In
> > other words, I am looking for tools that use postgresql as the storage
On Nov 15, 2007 6:20 PM, Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> Sean Davis wrote:
> > Is the current XML datatype (in 8.3) the direction of the
> > future, or is something more akin to a dedicated XML schema (I think
> > this is the route that Oracle has gone) go
dedicated XML schema (I think
this is the route that Oracle has gone) going to be important?
Thanks,
Sean
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTE
.
Thanks,
Sean
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
s=1)"
" Filter: (event_time > '2007-10-25
20:00:00-04'::timestamp with time zone)"
Every partition table is "Seq Scan"ned, I think unrelated tables are not
excluded in the query. Only table events_day_25 should be included in scan I
believe.
Do I miss anything?
Best,
Sean
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
from day to day. No data has been deleted from the table
> yet, just added.
>
> Here is some config info:
>
> PostgreSQL 8.1.8 on Fedora 3
Have you vacuumed recently?
Sean
---(end of broadcast)---
TIP 6: explain analyze is your friend
using the grant wizard.
Sean
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
"real" 3NF tables. If you do all of this within a
transaction, if anything breaks, you can rollback and have no problems
with data integrity.
Sean
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your
estions on what is up?
Thanks,
Sean
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Maybe this is a well duh kind of question, or maybe there's no
straightforward way to do it, but is there any way that I could have a
pg function initiate a process on the host system?
Specifically I'd like to script an email to send off on an insert
trigger, but the ability to initiate system pro
e that can check the
constraints.
http://www.postgresql.org/docs/8.2/static/triggers.html
However, I wonder whether it might not make more sense to go with an
account system, with an account balance and credits and debits to the
account. Is the system you are proposing really the best data model
million rows in them initially if we
> convert old data.
I would give backup/restore a try. A million rows isn't very big in
postgres terms. On relatively low-end hardware, I am routinely able to
backup about 300Gb in about 35 databases in under 3 hours.
Sean
Scott Marlowe wrote:
> On Tue, 2007-05-08 at 15:59, Sean Murphy wrote:
>> Scott Marlowe wrote:
>>> On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
>>>> Tom Lane wrote:
>>>>> Sean Murphy <[EMAIL PROTECTED]> writes:
>>>>&
Scott Marlowe wrote:
> On Tue, 2007-05-08 at 12:19, Sean Murphy wrote:
>> Tom Lane wrote:
>>> Sean Murphy <[EMAIL PROTECTED]> writes:
>>>> I'm WAY out of my depth here, but my impression, based on the
>>>> circumstances, is that there is some
Tom Lane wrote:
> Sean Murphy <[EMAIL PROTECTED]> writes:
>> I'm WAY out of my depth here, but my impression, based on the
>> circumstances, is that there is some sort of an idle session timeout
>> kicking in (most likely on the client side) and dropping the
I've got a bunch of users on VB applications connecting to PG 8.2.3 via
psqlodbc with SSL. For a variety of reasons, some good, some probably
bad, I have the app open a connection and leave it open, using it as
needed to run queries back and forth.
If I look in my logs, I see loans of little clust
adow table with "old" versions of a row
4) Maintain a shadow table with only diffs from the original and metadata on
when the changes took place
5) Other?
Has anyone suggestions on what might work "best"? The "rows" here are going
to be simple text fiel
all flags
3) You can expand to an arbitrary number of flags
4) Your schema remains normalized
Sean
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Hi all,I have a question about how a certain function would look. Basically, what I want to do is having something that would take in a 'from' date (day, month, year) and a 'to' date (also day, month and year) and then spit back a series of records whose timestamps fall between those two dates. How
ent is quite trivial (we learn that from
> pg_dump), but can someone hint on how to use it from perl scrypt? With
> "use DBI" module?
>
See the DBD::Pg documentation, under "copy support".
Sean
---(end of broadcast)---
I seem to have a problem accessing a temp table from a trigger when I
use cascading deletes.
I have 2 tables: a main table and a child table. The child table has a
foreign key reference to the main table that has DELETE CASCADE on.
I have delete triggers on both tables that are run BEFORE DELETE.
On 6/1/06 12:29 PM, "Tomi NA" <[EMAIL PROTECTED]> wrote:
> On 6/1/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>> You might look into Eclipse (the java-based IDE). It has at least one ERD
>> design plugin that allows graphical layout, editing of schema, and
&
You might look into Eclipse (the java-based IDE). It has at least one ERD
design plugin that allows graphical layout, editing of schema, and
generation of DDL directly from the schema. It works with many DB platforms
and is FREE!!!
Sean
On 6/1/06 5:44 AM, "[EMAIL PROTECTED]" <[EM
Tony Wasson wrote:
On 5/16/06, Tom Lane <[EMAIL PROTECTED]> wrote:
"Tony Wasson" <[EMAIL PROTECTED]> writes:
> When I saw the same error as you, the stats collector process was
> missing.
The collector, or the buffer process? The reported message would be
emitted by the buffer process, after
Jim C. Nasby wrote:
On Tue, May 16, 2006 at 03:41:07PM -0400, Sean Davis wrote:
I had cranked things up a bit from the standard install.
shared_buffers = 15000 # min 16 or max_connections*2, 8KB
each
#temp_buffers = 1000# min 100, 8KB each
On 5/16/06 3:08 PM, "Tony Wasson" <[EMAIL PROTECTED]> wrote:
> On 5/16/06, Sean Davis <[EMAIL PROTECTED]> wrote:
>> I am using postgresql 8.1.0 on an Xserver running MacOS 10.3.9. I am
>> getting the following in the log every minute for the past couple
conclusion was reached. Tom suggested that an EAGAIN signal was being
received from the system, but I'm not sure what this means exactly or why it
is happening now, as we have had the server running for months.
Any insight?
Thanks,
Sean
---(end of broa
I have to log each time a user selects data from a table by inserting
record in another table.
For example
I have table xzy
user test selects id, name from table xyz.
I want to insert into table xyz_log
user, action, fields, timestamp
test, select, id name, 12/1/05 02:00:21
How can i do this u
will probably need to ask that on another list. There are many other
reasons to choose one language over another besides speed (in fact, I think
speed is probably not the first thing to think about when choosing a
language).
Sean
---(end of broadcast)---
Does Postgres support granting priviliges at the column level?
ex. grant update on tableA (id, description) to user
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMA
k? (don't tell me to cut the
> database :))
I assume that by "psql" you mean postgresql?
You'll probably have to be more specific about what you are doing, what your
database is like and how it is used, what you want to change, and what kinds
of time you are talking about.
S
rt the server? Did you fix the pg_hba.conf file? Does your
postgresql.conf file allow tcp connections? Those are the places I would
look.
Sean
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On 1/19/06 7:14 AM, "Martijn van Oosterhout" wrote:
> On Thu, Jan 19, 2006 at 07:03:47AM -0500, Sean Davis wrote:
>> I have a table that stores data like so:
>
>
>
>> And I would like to design a query that gives:
>>
>> Clone_idx e
data, just reshaping.
Thanks,
Sean
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
les, but I find it easier to load the whole thing and then
just do selects to grab the data and put it into normalized form.
Hope that helps,
Sean
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
all that you need. Have you tried
simulating your application under expected loads so that you are sure that
you are making the right choice?
Sean
---(end of broadcast)---
TIP 6: explain analyze is your friend
could have
changed recently, but I'm not aware of it.
So, choose whichever is easiest for you for the job. If performance is the
ONLY issue, then testing under real conditions is probably the only way to
be sure that what you are doing is the right way.
Sean
-
On 12/2/05 10:21 AM, "Guy Rouillier" <[EMAIL PROTECTED]> wrote:
> Sean Davis wrote:
>> This might be a bit off-topic, but I'm curious what folks would do
>> with this
>> situation:
>>
>> I have about 6 different tab-delimited file types,
ast choice.
Thanks for any insight.
(For replies, please try to reply to me directly as well as the list as I
just get digests right now).
Thanks,
Sean
---(end of broadcast)---
TIP 4: Have you searched our list archives?
he
records in the form of a tab-delimited file is to COPY or \copy (in psql)
them into a separate loader table and then use SQL to manipulate the records
(check for duplicates, etc) for final insertion into the table.
Sean
---(end of broadcast)---
TIP 6: explain analyze is your friend
On 10/26/05 8:52 AM, "Zlatko Matić" <[EMAIL PROTECTED]> wrote:
> Hello.
>
> Is there any way to check the version of PostgreSQL by a query? Maybe by
> querying catalog tables?
Select version();
---(end of broadcast)---
TIP 6: explain analyze is y
estored
with database dumps, unless you are dumping and restoring only data. Is
that the case?
Sean
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
currval of sequence "field_seq" is not yet defined in this session.
>
> I think currval will work only after an insert. I don't want to use nextval as
> this increases the lastvalue value.
That is correct. You can't call currval until you have called ne
Title: [GENERAL] newbie question: reading sql commands from script files
In psql, look at \i.
Sean
- Original Message -
From:
basel
novo
To: pgsql-general@postgresql.org
Sent: Monday, October 24, 2005 8:28
PM
Subject: [GENERAL] newbie question:
reading
single column that contains the same id.
See any of MANY online tutorials on SQL for an introduction or get a book on
SQL. I found that I had to sit and type verbatim from multiple sources
before I really understood what was going on, so you may want to try that.
Google for SQL tu
sum(sales) != 0
Can you use case?
http://www.postgresql.org/docs/8.0/interactive/functions-conditional.html
Or you could create a simple function to do the logic to avoid the division
by zero.
Sean
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
.gmod.org/schema/index.shtml) project can comment on computing
the transitive closure using stored procedures, but I think they do that for
their project.
Sean
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
r as file manipulation.
http://www.postgresql.org/docs/8.0/static/server-programming.html
Sean
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ator. However, MANY, MANY features from postgres 8.0
will not be available on mysql 3 (really?). So, I think you may have to do
a bit of editing to make it work correctly, in any case. If this is a
one-time thing, do it by hand. If doing on a regular basis, you might need
to script thin
1 - 100 of 279 matches
Mail list logo
