hi
all,
has anybody
experience using psql with emacs (M-x sql-postgres) on windows. if
i execute 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 mess
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 multipl
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 one
complaining about it.
On 9/6/06, Jean-Christophe Praud <[EMAIL PROTECTED]> wrote:
Hi all,
I'm planning to convert an application to postgresql 8.1 (from mysql).
Currently we have some recursive procedures done on the application side
we would want to rewrite as stored pl/pgsql procedures called by triggers...
Is it
On 9/6/06, Arturo Perez <[EMAIL PROTECTED]> wrote:
On Sep 6, 2006, at 8:48 PM, Merlin Moncure wrote:
> 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
On Wed, 6 Sep 2006, Joshua D. Drake wrote:
If we were playing DNS body part size wars then who has the bigger 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 servic
On Thu, 7 Sep 2006, Tim Allen wrote:
Andrew was apparently suggesting that the configuration issue he
mentioned is not irrelevant, and may be the actual cause of the
problems. Since he works for a domain registrar, I'm prepared to assume,
at least as a working hypothesis, that he knows what he
DNS issue was fixed this aft, and I'm currently working on reviving the
vServer right now ... CVS itself should be working now ...
Sorry for the delay ...
On Wed, 6 Sep 2006, Andrew Sullivan wrote:
Hi,
I just checked, and gborg is still dead. In fact, the hostname is no
longer valid (ther
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 one
complaining about it.
Based on this thread, an
On Sep 6, 2006, at 6:41 PM, Joshua D. Drake wrote:
Irrelevant details of the server configuration that do not
directly affect those services aren't really something to gossip
about on a public mailing list, though.
The two are quite different things.
Andrew was apparently suggesting th
If we were playing DNS body part size wars then who has the bigger 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 imp
On Sep 6, 2006, at 8:48 PM, Merlin Moncure wrote:
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 tabl
* Steve Atkins ([EMAIL PROTECTED]) wrote:
> If we were playing DNS body part size wars then who has the bigger
> 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
When you commit to providing services to this community, it is
absolutely the business of that community on how the infrastructure is
managed.
It is the business of the community that the services provided are
adequate and stable, certainly. That's become rather obvious recently.
Irrelevan
Irrelevant details of the server configuration that do not directly
affect those services aren't really something to gossip about on a
public mailing list, though.
The two are quite different things.
Andrew was apparently suggesting that the configuration issue he
mentioned is not irrele
On Sep 6, 2006, at 5:58 PM, Tim Allen wrote:
Steve Atkins wrote:
On Sep 6, 2006, at 5:29 PM, Joshua D. Drake wrote:
When you commit to providing services to this community, it is
absolutely the business of that community on how the
infrastructure is managed.
It is the business of the com
Steve Atkins wrote:
On Sep 6, 2006, at 5:29 PM, Joshua D. Drake wrote:
When you commit to providing services to this community, it is
absolutely the business of that community on how the infrastructure
is managed.
It is the business of the community that the services provided are
adequa
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 Sep 6, 2006, at 5:29 PM, Joshua D. Drake wrote:
Also the servers are volunteer provided, so
it's not really anyones business other than the server owners.
Given that the entire postgresql.org infrastructure just went off the
air because of what sure looked to me like an error in
administrat
Also the servers are volunteer provided, so
it's not really anyones business other than the server owners.
Given that the entire postgresql.org infrastructure just went off the
air because of what sure looked to me like an error in
administration, I submit that it _is_ others' business how the
[EMAIL PROTECTED] (Steve Atkins) writes:
> On Sep 6, 2006, at 9:50 AM, Andrew Sullivan wrote:
>> Now that the DNS is back (thanks!), I thought I'd ask why the ra bit
>> is set on the responses. Are those servers providing recursion to
>> the whole Net? (They seem to be.) If so, that's a Bad Thin
In article <[EMAIL PROTECTED]>,
[EMAIL PROTECTED] (Scott Marlowe) wrote:
> On Wed, 2006-09-06 at 16:56, Arturo Perez wrote:
> > Hi all,
> >
> > My environment is Tomcat5.0, Cayenne 1.2 and PostgreSQL 8.1.4 on a
> > RedHat ES3 machine.
> >
> > My webapplication is reusing sequence numbers and ge
On Wed, 2006-09-06 at 16:56, Arturo Perez wrote:
> Hi all,
>
> My environment is Tomcat5.0, Cayenne 1.2 and PostgreSQL 8.1.4 on a
> RedHat ES3 machine.
>
> My webapplication is reusing sequence numbers and getting duplicate
> primary key
> failures because of it (error is "duplicate key violates
I work with a system designed as lots of little cooperating worker
programs, with boss programs that... well, boss the worker programs
around.
Boss and workers all use the same database.
Sometimes it would be convenient to have a boss start a transaction
and then have the workers do their work in
Hi all,
My environment is Tomcat5.0, Cayenne 1.2 and PostgreSQL 8.1.4 on a
RedHat ES3 machine.
My webapplication is reusing sequence numbers and getting duplicate
primary key
failures because of it (error is "duplicate key violates unique
constraint"). The
columns are not defined as SERIAL for
On Wed, 2006-09-06 at 23:29 +0200, Jean-Christophe Praud wrote:
> Hi all,
>
> I'm planning to convert an application to postgresql 8.1 (from mysql).
> Currently we have some recursive procedures done on the application side
> we would want to rewrite as stored pl/pgsql procedures called by trigge
Hi all,
I'm planning to convert an application to postgresql 8.1 (from mysql).
Currently we have some recursive procedures done on the application side
we would want to rewrite as stored pl/pgsql procedures called by triggers...
Is it possible for these triggers to be asynchronous, in order no
Hi
I am trying to create table. With in it one column will be stored ip
address or hostnames. I found out that I should use cidr type (or inet)
or am I wrong?
I have postgresql ver. 7.4.7 and I am useing pgaccess tool and with
in there is not that types. How can I add these types to p
On Tue, 5 Sep 2006 22:53:14 +0200
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> wrote:
> Hi,
>
> The most general problem that may be a design problem (and I'm not
> asking to do my homework even if well, you may still help ) is
> I've a "temporary relation" and a permanent relation. A typical
> situ
On Wed, Sep 06, 2006 at 07:09:14AM -0700, Joshua D. Drake wrote:
> The exact same person physically responsible for the health of Gborg is
> also responisble for PostgreSQL.Org.
>
> This has nothing to do with a modular component argument.
Well, it does at the moment, because gborg has been down
On Wed, Sep 06, 2006 at 09:59:29AM -0700, Steve Atkins wrote:
>
> There's not anything like universal agreement on whether that's
> a bad thing, or not.
Uh, well, there sure is right now among TLD operators. Wide-open
recursion is being used in a denial of service attack that causes
orders-of-m
hi all,
has anybody
experience using psql with emacs (M-x sql-postgres) on windows. if
i execute 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
Andrew Sullivan wrote:
> Hi,
>
> Now that the DNS is back (thanks!), I thought I'd ask why the ra bit
> is set on the responses. Are those servers providing recursion to
> the whole Net? (They seem to be.) If so, that's a Bad Thing.
>
> A
>
Yes, they do seem to be and yes it probably is a Ba
On Wed, Sep 06, 2006 at 02:42:36PM +0200, Magnus Hagander wrote:
> Unable to get at Marc right now, but I believe these issues are much
> related. Hosts are dropping out of the hub.org nameservers one by one as
> well, probably as TTL expires. It just happens that the full zone has
> expired from
On Sep 6, 2006, at 9:50 AM, Andrew Sullivan wrote:
Hi,
Now that the DNS is back (thanks!), I thought I'd ask why the ra bit
is set on the responses. Are those servers providing recursion to
the whole Net? (They seem to be.) If so, that's a Bad Thing.
There's not anything like universal ag
Hi,
Now that the DNS is back (thanks!), I thought I'd ask why the ra bit
is set on the responses. Are those servers providing recursion to
the whole Net? (They seem to be.) If so, that's a Bad Thing.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
If they don't do anything, we don't need their acr
> I have been trying to open the link and seems that
> postgresql archive site is down.
> http://archives.postgresql.org/pgsql-novice/2006-06/msg00092.php
Sorry, the link didn't work. It worked yesterday when I found it.
I will also forward this to the general list maybe someone there could tak
On Sep 3, 2006, at 8:46 PM, Tom Lane wrote:
(b) I believe there's a "null cipher" mode for SSL if you truly don't
need encryption.
Nothing such is obviously documented for SSHv2, which is unfortunate
for some uses.
smime.p7s
Description: S/MIME cryptographic signature
Andrew Sullivan wrote:
Hi,
I just checked, and gborg is still dead. In fact, the hostname is no
longer valid (there's no A record). Do we have even an estimate for
when it will be back? Can the estimator please publish that
somewhere in big flashing letters or something?
I can totally apprec
"Johannes Weberhofer, Weberhofer GmbH" <[EMAIL PROTECTED]> writes:
> while the regression tests, there is one that fails:
Repeatably, or did you only see this once? There's a known timing issue
that explains this, but it's only been seen once or twice that I know of.
2006-08-06 00:35 tgl
On Wed, Sep 06, 2006 at 12:04:18AM -0700, George Pavlov wrote:
> I have two columns, both individually nullable, but a row needs to have
> a value in one or the other. What is the best way to implement the
> constraints?
check (a is null != b is null);
---(end of broadcast
> Hi,
>
> I just checked, and gborg is still dead. In fact, the hostname is
> no longer valid (there's no A record). Do we have even an estimate
> for when it will be back? Can the estimator please publish that
> somewhere in big flashing letters or something?
Yes, Marc posted to -www earlier
Hi,
I just checked, and gborg is still dead. In fact, the hostname is no
longer valid (there's no A record). Do we have even an estimate for
when it will be back? Can the estimator please publish that
somewhere in big flashing letters or something?
I can totally appreciate that this is a volun
Hi Folks,
I have a strange Problem (to be honest there are more than one, but this
is one of it) after Upgrading to Postgres 8.1.3. The following SQL seems
to produce a deadlock while doing an endless reading of a temp table:
SELECT s.sid FROM stud s, stud_vera v WHERE s.sid = v.sid AND v.veraid
Sim Zacks wrote:
>
> I have a very strange problem that I cannot figure out and was hoping
> that someone else may have at least seen this problem because it makes
> no sense at all to me.
>
> I have a PostGreSQL 8.0.1-r1 server on gentoo.
> The data is accessed by MSAccess clients using linked t
I have a very strange problem that I cannot figure out and was hoping
that someone else may have at least seen this problem because it makes
no sense at all to me.
I have a PostGreSQL 8.0.1-r1 server on gentoo.
The data is accessed by MSAccess clients using linked tables. After a
good amount o
On Wed, Sep 06, 2006 at 09:59:03AM +0200, Ivan Sergio Borgonovo wrote:
> You can write a xor function. At least in 7.4, that I'm currently using,
> there is no xor operator.
Ah, but there's is, but it's in disguise:
test=# select true <> true, true <> false, false <> true, false <> false;
?colu
Fabi Avilés wrote:
Hi people. I'm trying to understand the DB model of an application, and
I´ve found that the sava dates using Int8 type. I need to know how can I
convert it to a date format or something taht I can understand as a
date. Thanks.
Check the running thread "Converting double to
Hi people. I'm trying to understand the DB model of an application, and I´ve found that the sava dates using Int8 type. I need to know how can I convert it to a date format or something taht I can understand as a date. Thanks.
I see why it would now. But it would be nice if the message mentioned
the root cause of the problem - that the tsquery value does not contain
any lexemes and thus is not valid for doing a search.
... doing a index search :(. GIN core doesn't know anything about
tsvector/tsquery/tsearch - so,
Thanks for the clarification Teodor - it makes much more sense now.
I'd agree the error message is confusing, particularly since this works:
set enable_seqscan to on;
set enable_indexscan to off;
set enable_bitmapscan to off;
select *
from test.features
where to_tsquery('') @@ features.vector;
On Wed, 6 Sep 2006 09:29:23 +0200
"Dawid Kuroczko" <[EMAIL PROTECTED]> wrote:
> On 9/6/06, George Pavlov <[EMAIL PROTECTED]> wrote:
> > I have two columns, both individually nullable, but a row needs
> > to have a value in one or the other. What is the best way to
> > implement the constraints? I
Tom Lane wrote:
> zeljko <[EMAIL PROTECTED]> writes:
>> Is there any plans (or somebody already working on) to see compressed
>> protocol in 8.2 ?
>
> Why bother? Run your session through an ssh tunnel and ask it to
> compress.
I saw it on TODO list, not marked for 8.2 but it's there.
explain analyze
select *
from test.features
where to_tsquery('') @@ features.vector
ERROR: Gin doesn't support full scan due to it's awful inefficiency
Look:
contrib_regression=# select '{1,2,3}'::int4[] @ '{}'; --contains
?column?
--
t
(1 row)
contrib_regression=# select '{1,2,3}'
On 9/6/06, George Pavlov <[EMAIL PROTECTED]> wrote:
I have two columns, both individually nullable, but a row needs to have
a value in one or the other. What is the best way to implement the
constraints? I currently have:
create table f (
a int,
b int,
check (a + b is null),
check (coale
I have two columns, both individually nullable, but a row needs to have
a value in one or the other. What is the best way to implement the
constraints? I currently have:
create table f (
a int,
b int,
check (a + b is null),
check (coalesce(a,b) is not null)
);
Is there a better way to do
Hello,
while the regression tests, there is one that fails:
*** ./expected/sanity_check.out Thu Sep 8 20:07:42 2005
--- ./results/sanity_check.out Tue Sep 5 10:27:53 2006
***
*** 17,22
--- 17,24
circle_tbl | t
fast_emp4000| t
func_index_heap |
57 matches
Mail list logo