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 an
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 languag
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 p
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.
*** *** *** *** *** *** *** *** ***
*** *** *** *** *** *** *** *** *** *** **
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
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 a
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)---
TI
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, there
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.
*** *** *** *** ***
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 slo
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
> 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) o
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
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 ;
select
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 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...
-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 masse,
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 conn
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 thro
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 collected
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 b
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
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 AS INSERT INTO apache.log
(clientaddress,rfc1413,username,"localtime",httprequest,s
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
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 s
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 p
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 broadcast)--
-Original Message-
From: "Joshua D. Drake" <[EMAIL PROTECTED]>
To: "Joshua D. Drake" <[EMAIL PROTECTED]>; "Marc G. Fournier" <[EMAIL
PROTECTED]>; "Tom Lane" <[EMAIL PROTECTED]>; "General"
Sent: 07/09/06 14:27
Subject: Re: [GENERAL] Majordomo drops multi-line Subject:
> O.k. this is a
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 ha
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 the
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 i
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,
> > 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-ev
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
http://cwiki
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 ju
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 t
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 wa
> >>> 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
>
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
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
>>>
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 al
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 ta
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, I
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
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.
m
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
> --
>
fixed now:
* From:
* 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 include x and y. I want to rem
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
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
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 ma
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 t
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 RE
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 m
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
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
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 a
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
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
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 stats-table
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
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 ;
select pg_catalog.setval(seq, , true)
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 Data
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
63 matches
Mail list logo
