Hi there,is there a simple way to replace NULL values in multiple columns within the SQL statement? I changed the underlaying country template of your database; so now there are a couple of NULL values when I join the stats-table with the country table. Unfortunately, my queries have always
hi
all,
hasanybody
experience using psql with emacs (M-x sql-postgres) on windows. if
iexecute this command emacs prompts for user, database and host, but not
for the password, so i think there is no response from psql. but if am looking
at the emacs messages there is no error message
Shane Ambler wrote:
On 2/9/2006 4:11, Scott Marlowe [EMAIL PROTECTED] wrote:
I think that with either the GPL or BSD, code is returned under a type
of coercion. Not necessarily a bad thing, understand.
The coercion of the GPL is legalistic. If you distribute GPL stuff,
you've got to give
Hello Oleg,
Am 2006-09-04 20:52:02, schrieb Oleg Bartunov:
You need to provide more details.
Oleg
- END OF REPLIED MESSAGE -
One of my two programmers had coded last year stuff in php5 (UNICODE
is now working) to search à la Google in my
Arturo Perez wrote:
What happens is that if I do a select nextval('seq') I get a number
that's lower than the
max primary key id. This is inspite of my doing
SELECT setval('seq', ((SELECT MAX(seq_ID) FROM table)+1))
ALTER SEQUENCE seq RESTART WITH max + 1;
select pg_catalog.setval(seq,
On Thu, Sep 07, 2006 at 07:45:19AM +0200, Stefan Schwarzer wrote:
Hi there,
is there a simple way to replace NULL values in multiple columns
within the SQL statement? I changed the underlaying country template
of your database; so now there are a couple of NULL values when I
join the
On Thu, Sep 07, 2006 at 07:45:19AM +0200, Stefan Schwarzer wrote:
Hi there,
is there a simple way to replace NULL values in multiple columns
within the SQL statement? I changed the underlaying country template
of your database; so now there are a couple of NULL values when I
join the
On Thu, Sep 07, 2006 at 11:54:43AM +0200, Stefan Schwarzer wrote:
As I said, I couldn't figure out how COALESCE would work on multiple
columns (without naming them explicitly).
So, say I have a table with columns for each year between 1970 and
2005. For specific countries the values
Aside from your database structure being problematic, what are you
trying to accomplish?
In other words, what do you want to replace the nulls with and in what
circumstance?
I imagine your table looks like this
ID,country,1950,1951,1952,1953,
1 usa50 null 70 10
2 canada 10 45
You want to use the Notify/Listen framework.
1) You need a rule on a table that says on Update (or insert or delete)
do also notify {key}
2) You need a daemon running against the server that calls listen {key}
3) when the table is updated (or inserted or deleted) then your
application will be
I have an internet map server connected to my database. Until now,
no data fields within the table were filled with a -, i.e.
- equalled no data available.
Now, for displaying a map with different classes (red for values from
0-100, green for values from 100-200) I need to
On Thu, Sep 07, 2006 at 12:58:17PM +0200, Stefan Schwarzer wrote:
Unfortunately the mapserver can't deal with NULL values. So, I can't
build a class saying
if values = NULL do something
but instead it only works with fake NULL values as -
if values = - do something
Hello,
I have a question regarding user rights.
I have one user in postgres8.01. which connects from a webserver and inserts
some data into a table. It only has INSERT access on that table.
ON the other hand, on the same table a have an after-insert trigger which
executes a function owned by a
On Sep 7, 2006, at 5:35 AM, Alban Hertroys wrote:
Arturo Perez wrote:
What happens is that if I do a select nextval('seq') I get a number
that's lower than the
max primary key id. This is inspite of my doing
SELECT setval('seq', ((SELECT MAX(seq_ID) FROM table)+1))
ALTER SEQUENCE seq
Once again Martijn is correct, and you have to use is null not =null
One thing you might want to consider is adding - as a default value
in the table so that when new data is entered it with a null it
automatically gets the correct value.
Using coalesce with the value will probably be the
Thanks for your suggestions.
You're right with the is versus = for NULL values. Unfortunately
the coding for the mapserver does not allow an IS statement.
Concerning the coalesce(datafield,-) it seems rather unusable for
me, if I have to explicitly stated each column, as a) for many
Joshua D. Drake wrote:
Marc G. Fournier wrote:
On Wed, 23 Aug 2006, Alvaro Herrera wrote:
In any case I don't see any reason to let the broken software continue
to be broken. Surely there must be an updated version which corrects
this bug? A patch at least? I mean, I can't be the only
On Thu, Sep 07, 2006 at 02:12:57PM +0300, Valentin Militaru wrote:
I have one user in postgres8.01. which connects from a webserver and inserts
some data into a table. It only has INSERT access on that table.
ON the other hand, on the same table a have an after-insert trigger which
executes a
fixed now:
* From: kynn ( at ) panix ( dot ) com
* To: pgsql-novice ( at ) postgresql ( dot ) org
* Subject: SQL for removing duplicates?
* Date: Tue, 13 Jun 2006 12:11:41 -0400 (EDT)
Hi. I'm stumped. I have a large table (about 8.5M records), let's
call it t, whose columns
On Thu, Sep 07, 2006 at 07:15:43AM -0400, Arturo Perez wrote:
Note that all of the above was in an attempt to reset the sequence to
the proper value. I'm beginning to think that it's a library problem
as this morning I get:
iht= select max(article_id) from article;
max
--
4992
On 9/7/06, Arturo Perez [EMAIL PROTECTED] wrote:
I tried statement logging but I am not sure it reported anything
useful. When I get into work I'll send in those logs.
More than likely they are large and should not be sent through the
mailing list. contact me off list and I'll arrange it.
On Wed, Sep 06, 2006 at 06:23:06PM -0700, Steve Atkins wrote:
DNS clue might be relevant. We're not, though. Rather I'm saying that
publicly criticizing people who volunteer services to a project,
about things that are not related to the services they're providing
is at best a little
Alvaro Herrera wrote:
Joshua D. Drake wrote:
Marc G. Fournier wrote:
On Wed, 23 Aug 2006, Alvaro Herrera wrote:
In any case I don't see any reason to let the broken software continue
to be broken. Surely there must be an updated version which corrects
this bug? A patch at least? I mean,
It seems like the mapserver is quite inflexible. Maybe there are options
to loosen it up a little? (I've found that pouring beer into the
keyboard after a long week does not help.)
I would venture that your best option is to write a quick pgpsql
function that goes over all the fields in the
On Thu, Sep 07, 2006 at 01:39:06PM +0200, Stefan Schwarzer wrote:
You're right with the is versus = for NULL values. Unfortunately
the coding for the mapserver does not allow an IS statement.
There's a hack for this; you need to turn it on in the config file.
I think it's called
From: Alban Hertroys [mailto:[EMAIL PROTECTED]
Martijn van Oosterhout wrote:
On Thu, Sep 07, 2006 at 07:15:43AM -0400, Arturo Perez wrote:
iht= select max(article_id) from article;
max
--
4992
(1 row)
iht= select nextval('pk_article');
nextval
-
4986
(1 row)
Assuming
Joshua D. Drake wrote:
Alvaro Herrera wrote:
Joshua D. Drake wrote:
Marc G. Fournier wrote:
On Wed, 23 Aug 2006, Alvaro Herrera wrote:
In any case I don't see any reason to let the broken software continue
to be broken. Surely there must be an updated version which corrects
this bug?
ever noticed/commented about it ... ya, you are the only one
complaining about it :)
Honestly, it may be time we start looking at mailman.
Please don't, unless Majordomo is really broken and unfixed (i.e.
there isn't a newer version with the bug fixed). What version
are we running?
Mailman is a supported, large, active, FOSS community project that is
battle tested in the current field much more so then Majordomo. Holding
on with a dying breaths to old software is silly.
Can Mailman do moderation over email? If it can do that, then I'm all
for it. If it can't, which
Martijn van Oosterhout wrote:
On Thu, Sep 07, 2006 at 07:15:43AM -0400, Arturo Perez wrote:
iht= select max(article_id) from article;
max
--
4992
(1 row)
iht= select nextval('pk_article');
nextval
-
4986
(1 row)
Assuming the sequence number is being used correctly why would
Seriously, I think that's the first time anybody said anything good
about the mailman interfaces Just the stuff I have to do for the
pgFoundry lists (of which I have only *two*) is just so much pain. (who
came up with such a brilliant thing as
different-password-for-everything-you-do? It's
Arturo Perez wrote:
In any case, at this point in time it's looking like Cayenne doesn't honor
the rules of the sequence. It appears to (and is documented as) internally
incrementing rather than fetching the sequence for each insert.
I have no experience with Cayenne, but reading
Seriously, I think that's the first time anybody said anything
good
about the mailman interfaces Just the stuff I have to do for
the
pgFoundry lists (of which I have only *two*) is just so much
pain.
(who came up with such a brilliant thing as
Joshua D. Drake wrote:
Mailman is a supported, large, active, FOSS community project that is
battle tested in the current field much more so then Majordomo. Holding
on with a dying breaths to old software is silly.
Can Mailman do moderation over email? If it can do that, then I'm all
Same goes as a user of mailman lists.
What I want is to log in to lists.postgresql.org, and get an interface
that wil show me everything about the lists i'm subscribed to
(capability to change my flags etc) and everything about the ones I'm
admin for (which I'm not for any on pgsql.org, but in
I don't see how the web stuff can be any simpler.
I view a single page, select the items I wish to keep, hit a single
button, I am done and I don't have to clutter my inbox.
This discussion is all about how people work. Most people *DO NOT* work
from email the way Alvaro and and some of
From: Alban Hertroys [mailto:[EMAIL PROTECTED]
Arturo Perez wrote:
In any case, at this point in time it's looking like Cayenne doesn't honor
the rules of the sequence. It appears to (and is documented as) internally
incrementing rather than fetching the sequence for each insert.
I have no
-Original Message-
From: Joshua D. Drake [EMAIL PROTECTED]
To: Joshua D. Drake [EMAIL PROTECTED]; Marc G. Fournier [EMAIL
PROTECTED]; Tom Lane [EMAIL PROTECTED]; General
pgsql-general@postgresql.org
Sent: 07/09/06 14:27
Subject: Re: [GENERAL] Majordomo drops multi-line Subject:
O.k.
Working again now!
Regards,
Ben
Ben Trewern [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I'm currently getting:
PgFoundry Could Not Connect to Database
when I try to visit http://pgfoundry.org
Regards,
Ben
---(end of
In Windows XP Pro (SP2) I tried to upgrade PostgreSQL server from 8.1.2 to
8.1.4., by using upgrade.bat.
Everything goes nice until end of installation when the following error
apears: Service 'PostgreSQL Database Server 8.1' (pgsql-8.1) could not be
installed. Verify that you have sufficient
Hi everybody. Hope I'm posting in the correct group.
My question is part design and part implementation.
Since we are creating an inventory system we need to have the clients
pull up current inventory. Also, we need to have the past transactions
stored for reference and billing. In our previous
Hello,
I have a question regarding user rights.
I have one user in postgres8.01. which connects from a webserver and inserts
some data into a table. It only has INSERT access on that table.
ON the other hand, on the same table a have an after-insert trigger which
executes a function owned by
Hi,
I discorver yesterday pgllogger and try to use it.
OS: OpenBSD 3.8
DB: postgreSQL 8.1
I have a database with UNICODE encondings.
Sometimes in the log of PostgreSQL I got the error:
LOG: statement: PREPARE unnamed AS INSERT INTO apache.log
hola...Cómo estas? ..Sabes cómo hacer en postgres plpgsql hacer varios
join?..además,necesito hacer un select dentro de otro select y asignarle el
resultado a una variable de tipo record, pero no me deja, y necesito tomar
en el record una variable fecha y hora pero el datetime pareciera que es
On Wed, Aug 30, 2006 at 02:11:11PM -0400, Tom Lane wrote:
Actually, what I'd like to see done is to get majordomo to bounce list
messages containing unsubscribe in the subject, with an explanatory
message about the right way to unsubscribe. There's no reason the rest
of us should be
Nick Bower wrote:
We're considering using Postgresql for storing gridded metadata - each point
of our grids has a variety of metadata attached to it (including lat/lon,
measurements, etc) and would constitute a record in Postgresql+Postgis.
Size-wise, grids are about 4000x700 and are
Does this device allow connection to other phones besides Skype, like
Xten Xlite?
http://www.voipvoice.com/UConnect-2.html.
Compatibility with standard voip is not mentioned on their website?
---(end of broadcast)---
TIP 1: if posting/reading
Hi Mike,
I have been using Visual FoxPro with
Postgresql for two years. Currently my front end is Visual Foxpro 9. I
do not have the Postgresql on a Windows server, I am on a Linux server
that is running RedHat 9. I upgraded my Postgresql two months ago and I
am on version 8.1.4. My clients
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
As someone who does a lot of moderation using both mailman and
majordomo every single day, I can assure everyone that both
of them suck in their own way. Majordomo is nice in that I can
view a whole bunch of lists at once, and accept/reject en
On Thu, 2006-09-07 at 10:38, Frank Church wrote:
Does this device allow connection to other phones besides Skype, like
Xten Xlite?
http://www.voipvoice.com/UConnect-2.html.
Compatibility with standard voip is not mentioned on their website?
I think you sent this to the wrong list... :)
On Thursday 07 September 2006 11:38, Frank Church wrote:
Does this device allow connection to other phones besides Skype, like
Xten Xlite?
http://www.voipvoice.com/UConnect-2.html.
Compatibility with standard voip is not mentioned on their website?
wrong list.
On 9/6/06, Arturo Perez [EMAIL PROTECTED] wrote:
What happens is that if I do a select nextval('seq') I get a number
that's lower than the
max primary key id. This is inspite of my doing
SELECT setval('seq', ((SELECT MAX(seq_ID) FROM table)+1))
ALTER SEQUENCE seq RESTART WITH max + 1;
María Soledad Ibarra Díaz wrote:
hola...Cómo estas? ..Sabes cómo hacer en postgres plpgsql hacer varios
join?..además,necesito hacer un select dentro de otro select y asignarle el
resultado a una variable de tipo record, pero no me deja, y necesito tomar
en el record una variable fecha y
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]
Sent: Thursday, September 07, 2006 2:46 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgres and emacs on windows os
hi all,
has anybody experience using psql with emacs (M-x sql-postgres) on
Sorry, I realized that.
On 9/7/06, Jan de Visser [EMAIL PROTECTED] wrote:
On Thursday 07 September 2006 11:38, Frank Church wrote:
Does this device allow connection to other phones besides Skype, like
Xten Xlite?
http://www.voipvoice.com/UConnect-2.html.
Compatibility with standard voip
It's not clear to me how your data is organized or exactly what you're
counting. If I understand you correctly, yes, you could use triggers to
maintain a table in this manner. However, why can't you simply use a
SELECT query using the SUM() or COUNT() aggregate functions? If the
queries are
I have not had problems with integers
but I am using a VFP class for SQL server backends that was written by
someone else. Best thing is to try it yourself. If you need support sign
up for the psql-general list. They're a good resource and have subscribers
from all platforms.
*** *** *** *** ***
I'm running postgres 8.1.3 on a 2-CPU dual-core Opteron server with
8-Gigs of RAM. The server's operating system is FreeBSD 6.0. We migrated
our client applications from Informix and went through all of the
standard steps to resolve differences between the two databases
packages. However,
Hi all
I wonderring what could be differences beetwen languages with and
without u for example:
pltcl - pltclu
plperl - plperlu
Is anybodu know and could point me suitable link or something?
Kindly regards
Sebastian
---(end of broadcast)---
TIP
On 9/7/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
I have not had problems with integers but I am using a VFP class for SQL server
backends that was written by someone else. Best thing is to try it yourself. If
you need support sign up for the psql-general list. They're a good resource
Tom Lane wrote:
Jeff Davis [EMAIL PROTECTED] writes:
From what you described, I would not expect many locking problems. Are
there any other types of queries you run that may cause a lock?
Row locks (SELECT FOR UPDATE/SHARE) are a possible problem, particularly
if this is a pre-8.1 Postgres
I think the ODBC pass through engine has
been enchaned in newer versions of foxpro because many companies are moving
to SQLserver backends. At recent VFP conferences there are sessions devoted
entirely to this subject.
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** ***
SebaM wrote:
Hi all
I wonderring what could be differences beetwen languages with and
without u for example:
pltcl - pltclu
plperl - plperlu
Is anybodu know and could point me suitable link or something?
It's trusted versus untrusted languages.
Trusted languages only work within the
On Thu, 2006-09-07 at 22:56 +0200, SebaM wrote:
Hi all
I wonderring what could be differences beetwen languages with and
without u for example:
pltcl - pltclu
plperl - plperlu
Languages with a u should be untrusted by PostgreSQL, because they
are free to do anything the language can do.
Roman --
You can certainly use a trigger to track changes (as well as creating an audit
trail and enforcing rules); performance on inserts,updates and deletes will
suffer accordingly since there's extra operations involved, but it definitely
be a winner on the other end in generating reports
65 matches
Mail list logo