On Fri, 10 Sep 2004, Ennio-Sr wrote:
I slightly modified your queries and the result gets nearer my goals,
but ...
Here is what I tried:
SELECT DISTINCT
/* despite the DISTINCT, it shows twice each matching record: once
with the memo fieldd and then without it!. Leaving out the DISTINCT,
postgres 7.4.2 on a RedHat Enterprise Server
using libpq on SCO Open Server
Seems that if a command takes too long I get ERROR:Canceling query due
to user request.
I have ulimit=unlimited
postgresql.conf has statement_timeout = 0
Any ideas on what could be causing this?
Thanks,
Bart
On Thu, Sep 09, 2004 at 12:53:57PM -0500, Edwin Grubbs wrote:
I have experienced problems with postgres hanging when two inserts
reference the same foreign key. It appears that the second insert is
waiting for the first insert to release a lock.
You can also create a deadlock situation:
* Stephan Szabo [EMAIL PROTECTED] [100904, 07:10]:
On Fri, 10 Sep 2004, Ennio-Sr wrote:
I slightly modified your queries and the result gets nearer my goals,
but ...
Here is what I tried:
[ ... ]
As an explanation of the duplicate rows:
FROM bib_lt t0, bibbt t1 with no WHERE
On Fri, 10 Sep 2004, Ennio-Sr wrote:
* Stephan Szabo [EMAIL PROTECTED] [100904, 07:10]:
On Fri, 10 Sep 2004, Ennio-Sr wrote:
I slightly modified your queries and the result gets nearer my goals,
but ...
Here is what I tried:
[ ... ]
As an explanation of the duplicate rows:
* Stephan Szabo [EMAIL PROTECTED] [100904, 09:05]:
On Fri, 10 Sep 2004, Ennio-Sr wrote:
* Stephan Szabo [EMAIL PROTECTED] [100904, 07:10]:
On Fri, 10 Sep 2004, Ennio-Sr wrote:
[ big cut ]
Note however, that this may very well perform poorly compared to other
solutions because as
On Fri, 10 Sep 2004, Ennio-Sr wrote:
* Stephan Szabo [EMAIL PROTECTED] [100904, 09:05]:
On Fri, 10 Sep 2004, Ennio-Sr wrote:
* Stephan Szabo [EMAIL PROTECTED] [100904, 07:10]:
On Fri, 10 Sep 2004, Ennio-Sr wrote:
[ big cut ]
Note however, that this may very well perform
* Stephan Szabo [EMAIL PROTECTED] [100904, 10:39]:
On Fri, 10 Sep 2004, Ennio-Sr wrote:
* Stephan Szabo [EMAIL PROTECTED] [100904, 07:10]:
On Fri, 10 Sep 2004, Ennio-Sr wrote:
[ big cut ]
Well, I'd expect that for large tables the outer join type solution would
tend to be
On 8 beta1 I get 'SMgrRelation hashtable corrupted' *sometimes* when
executing the following, but only when there are other clients connecting to
the same database.
ALTER TABLE declines
ALTER COLUMN comp_name TYPE varchar(128),
ALTER COLUMN f_name1 TYPE varchar(48),
ALTER COLUMN
Title: unsubscribe
unsubscribe
This message, including any attachments, contains confidential information intended for a specific
individual and purpose and is protected by law. If you are not the intended recipient, please contact
sender immediately by reply e-mail and destroy all
Is there any good way to speed up SQL that uses like and has placeholders?
Here's the scoop. I've got a system that uses a lot of pre-generated
SQL with placeholders in it. At runtime these SQL statements are
fired off (through the C PQexecParams function, if that matters) for
execution. No
Chris Ochs [EMAIL PROTECTED] writes:
On 8 beta1 I get 'SMgrRelation hashtable corrupted' *sometimes* when
executing the following, but only when there are other clients connecting to
the same database.
Hmm. The SMgrRelation hashtable is local in each backend, so I'm not
sure I believe the
Dan Sugalski [EMAIL PROTECTED] writes:
I'd figure, though, that since the parameters are being passed
into PQexecParams basically to get them out of band so I don't have
to deal with escaping, quoting, and suchlike things, that the
optimizer would look at things *after* the substitution was
At 5:19 PM -0400 9/10/04, Tom Lane wrote:
Dan Sugalski [EMAIL PROTECTED] writes:
I'd figure, though, that since the parameters are being passed
into PQexecParams basically to get them out of band so I don't have
to deal with escaping, quoting, and suchlike things, that the
optimizer would look
This is probably a stupid question, but ...
I'd like to be able to take an existing query and modify it to return a
single row if that's what the base query returns, and 0 rows if the
base query returns multiple rows. Similarly, I'd like to also modify
it to return multiple rows if that's what
Ed L. wrote:
Is this pthreads warning of any concern?
gcc -O2 -fno-strict-aliasing -Wall -Wmissing-prototypes
-Wmissing-declarations -pthread -pthreads -D_REENTRANT -D_THREAD_SAFE
-D_POSIX_PTHREAD_SEMANTICS -fpic -shared -Wl,-soname,libecpg.so.4 execute.o
typename.o descriptor.o data.o
Dan Sugalski [EMAIL PROTECTED] writes:
Would I regret it if I asked where in the source this lies so I could
go fix it?
If it were easy to fix it would have been fixed before now ...
I have toyed with the notion of converting var LIKE pattern to
var LIKE pattern AND var = lowbound(pattern)
Nick wrote:
I have a table with columns
(product_id,related_product_id,related_counter)
If product A is related to product B then a record should be created,
if the record already exists then the related_counter should be
incremented.
This is very easy to do with MySQL using INSERT... ON DUPLICATE
Georgi Chorbadzhiyski wrote:
I just experienced the same problem [1] with 8.0.0beta2.
[1] http://archives.postgresql.org/pgsql-bugs/2004-08/msg00086.php
Right. It is still on the open items list.
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED]
Would someone answer this report?. Looks strange to me.
---
Ben Trewern wrote:
All,
There seems to be a bug in pg_dumpall:
For one of my dbs I've done:
ALTER DATABASE dbname SET search_path = mw, public;
If I
Bruce Momjian [EMAIL PROTECTED] writes:
No. The problem is that the test script just tries all options and if
it doesn't error out, it uses it. Ideally we could test from configure
and ingnore meaningless options but we don't know how yet.
Drop any options that cause the compiler to write
At 5:55 PM -0400 9/10/04, Tom Lane wrote:
Dan Sugalski [EMAIL PROTECTED] writes:
Would I regret it if I asked where in the source this lies so I could
go fix it?
If it were easy to fix it would have been fixed before now ...
Oh, I wasn't expecting it to be an *easy* fix... :) The question is
UPDATE related_products SET related_counter = related_counter
WHERE .
only updates if the record exists
INSERT (x,y,z) SELECT ?,?,1 WHERE NOT EXISTS (SELECT 1 FROM
related_products WHERE .)
Inserts if the key does not exist.
On Sat, 11 Sep 2004 00:02:26 +0200, Gaetano Mendola [EMAIL
Dan Sugalski [EMAIL PROTECTED] writes:
Since the only difference in this case is that the parameters are
pulled out for transport rather than being in band (a
properly-escaped string substitution could turn this case from a
PQexecParams call into a PQexec call) I was thinking the thing to
At 6:33 PM -0400 9/10/04, Tom Lane wrote:
Dan Sugalski [EMAIL PROTECTED] writes:
Since the only difference in this case is that the parameters are
pulled out for transport rather than being in band (a
properly-escaped string substitution could turn this case from a
PQexecParams call into a
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
No. The problem is that the test script just tries all options and if
it doesn't error out, it uses it. Ideally we could test from configure
and ingnore meaningless options but we don't know how yet.
Drop any options that cause
On Thu, Sep 09, 2004 at 16:32:18 -0500,
Karl O. Pinc [EMAIL PROTECTED] wrote:
Unfortunately modulo (%) does not operate on dates so I still need
to convert to Julian day. :-( I need to know where I am within a
regular repeating interval. Mostly, in my case, modulo 2.
(We arbitrarly
Forgive me if this is a basic and trivial (i.e., stupid) question. I haven't
been using postgres very long, and I'm not an experienced database system
developer.
I noticed that there is a very powerful group-based security feature in
postgres. Very nice - I like it alot. So one way to implement
Has anyone successfully done this? I've got cygwin and the
very first step crashes -
bash-2.05$ pwd
pwd
/cygdrive/e
bash-2.05$ cd postgresql-7.4.5
cd postgresql-7.4.5
bash-2.05$ ./configure
./configure
bash: ./configure: bad interpreter: No such file or directory
bash-2.05$
--
% Randy Yates
$ /usr/sbin/cygserver -S
Segmentation fault (core dumped)
[EMAIL PROTECTED] ~
$
--
% Randy Yates % ...the answer lies within your soul
%% Fuquay-Varina, NC% 'cause no one knows which side
%%% 919-577-9882% the coin will fall.
Can't get the postgres server started under Win2000/cygwin. Here's
what happens:
$ initdb -D /Gauss/rr/data -W
The files belonging to this database system will be owned by user yates.
This user must also own the server process.
The database cluster will be initialized with locale C.
fixing
It might be a good idea to place a reference to table 8-1 in
the various subsections of the Datatypes section in the
online postgresql documentation. Otherwise, when hyperjumping
from the table of contents to a specific section, table 8-1 may
not be in sight (as it is not for integer datatypes)
Is opening up port 5432 (R/W both directions) all that is required
of a firewall in order to access a postgres database outside the
firewall?
--
% Randy Yates % My Shangri-la has gone away, fading like
%% Fuquay-Varina, NC% the Beatles on 'Hey Jude'
%%%
Hi all,
I have a problem when inserting into a varchar field via jdbc.
Using to bytes makes the varchar fields shorten.
Example: with 7.4.5. on Linux
create table test(charfield varchar(5));
insert into test(charfield) values('abcde');
insert into test(charfield) values('üö');
select
I have a table with columns
(product_id,related_product_id,related_counter)
If product A is related to product B then a record should be created,
if the record already exists then the related_counter should be
incremented.
This is very easy to do with MySQL using INSERT... ON DUPLICATE KEY.
Greg Stark wrote:
Gaetano Mendola [EMAIL PROTECTED] writes:
Well, when SHA-0 was ready NSA suggested to apply some changes in order to
correct some flaw discovered and SHA-1 comes out, interesting NSA never wrote
which flaw was corrected!
May be SHA-1 is trasparent water to NSA eyes :-)
This is
I have searched the Internet... but haven't found much relating to this.
I am wondering on what the best practices are for migrating a
developmemnt database to a release database. Here is the simplest
example of my situation (real world would be more complex).
Say you have two versions of your
I'm a complete newbie to postgres so please look the
other way if these questions are really stupid.
Is it legitimate to have one database per data file? For
organizational and backup purposes, I'd like to keep the
database files for each of several projects separate.
This means, e.g., that
I guess it would be great if Pgsql had a way to find a database
definition via a system stored procedure like other database platforms
have.
There are two ways I've found so far:
SELECT
attname as name, typname as type, atttypmod - 4 as size,
relhaspkey as is_primary_key, *
FROM
pg_class
Christopher Browne wrote:
Quoth John [EMAIL PROTECTED]:
As per subject, i'm considering migrating a database (still in
development) from MaxDB to postgresql. The main reason for this is
that the stored procedures (functions) in MaxDB are unreliable and
hard to debug, and that the JDBC driver is
Tom Lane [EMAIL PROTECTED] writes:
it's unlikely that the same situation holds today.
Why would you think that? The US government may not have too many
clues, but they certainly understand the importance of crypto. I cannot
think of any reason to suppose that NSA et al would have stopped
Is it possible to have a sequence across two columns. For example
table1
+---+---+
| a | b |
+---+---+
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 1 |
| 2 | 2 |
| 2 | 3 |
| 3 | 1 |
| 3 | 2 |
| 3 | 3 |
+---+---+
Would I have to create a new sequence for every unique 'a' column?
That seems pretty
Hi All,
I'm developing some scripts to create my schema to be run by other
folks and I'd like to have them not spit out those NOTICE messages
when you create a table regarding the implicit indexes that are made
since it just makes it harder to see when there is a real error.
I've tried running
I am trying to create a function that creates a user
and adds a row to a table. It produces no warnings or
errors when I create the function but when I attempt
to execute it I get a syntax error. I do not
understand why this is happening. Any help would be
greatly appreciated.
SELECT
Greg Stark [EMAIL PROTECTED] writes:
This means it's quite possible the NSA had differential cryptanalysis
30 years before anyone else.
s/quite possible/known fact/
Quite a remarkable achievement. However
it's unlikely that the same situation holds today.
Why would you think that? The US
I have a problem with postgresql runnung on smp kernel.
setup:
master:
---
- Pentium 4 (hyperthreading)
- 2 GB Memory
- os: fedora core 1
- kernel: 2.4.22-1.2188.nptlsmp
- postgresql: 7.4.3-1PGDG
slave 1:
- Pentium 4 (hyperthreading)
- 2 GB Memory
- os: fedora core 1
- kernel:
As per subject, i'm considering migrating a database (still in
development) from MaxDB to postgresql. The main reason for this is that
the stored procedures (functions) in MaxDB are unreliable and hard to
debug, and that the JDBC driver is still experimental.
I thought I'd post here to find
Google Mike wrote:
How do I list the schema for a table or procedure? Is there a command
I can do in psql to list this, or do I have to join a series of tables
to see that?
You can do a pg_dump -s DBNAME to see the full schema of the
database. To see just a table of the database issue the
One other option, which I had forgotten for a long time, was:
\d object name
...which can describe many things, although this doesn't give you the
CREATE syntax like a pg_dump can do. Please also note that a pg_dump
can dump output to the screen if you don't specify a file, so if
you're only
Is there a tool that allows the tables and relationships
of an Access database to be moved into postgresql (7.4.5)?
Sorry if this has been asked before. There also may be
new tools that have recently come out.
--
% Randy Yates % Watching all the days go by...
%%
Hi all;
Comments inline.
Lincoln Yeoh wrote:
I doubt it's a good idea to make your postgres server internet
accessible. You'll be using postgresql in what I'd consider to be a
less tested scenario. Most people don't expose their database servers
to the Internet.
You could use the following
I am declaring a variaable of type void in a plpgsql function which serves to
receive the value(?) returned by another function which has been declared to
return a void type. This worked in 7.4 but in testing 8, we receive an error -
'ERROR: variable dbg has pseudo-type void'. Is there a change
Hi!
I have a problem with stringToNode() function. I'm trying to convert a
Plan into its ASCII representation. This seems to succeed. The problem
is that when I try to convert it back with stringToNode() the following
error is reported:
ERROR: badly formatted node string SEQSCAN :startup_cost
Dino Vliet wrote:
MUCH better nowI did manage to get an insert into
the table lessons with these adjustments...BUT now it
seems the FOR LOOP didn't work because I only get 1
record and expected that I would get 8 records due to
the i variabele.
What could be wrong?
My code is now:
WOW, that is the most comprehensive, 'nearing to commercial capability' update of
Postgres (and any OTHER OSS project) that I've seen in all my readings about and
dealings with Postgres. I would be VERY surprised if Postgres doesn't win some major
awards (and accounts) now that this has
Christopher Browne [EMAIL PROTECTED] writes:
Oops! Randy Yates [EMAIL PROTECTED] was seen spray-painting on a wall:
I'm a complete newbie to postgres so please look the other way if
these questions are really stupid.
Is it legitimate to have one database per data file? For
organizational
Hello list,
has postgresql the functionality for clustering, load balancing
and failover. I have to setup two redundant web-servers with and
want run a dbms cluster on this machines.
My webapps should only see one dbms, but there should be two
redundant dbms. I know that mysql 4.1 supports this
Not even close. PostgreSQL uses one or more files per
table/index/sequence/etc. Each database has its own directory. I think
with tablespaces you can even spread a database over multiple
directories.
Secondly, every connection gets its very own postmaster, they can can
each access any file they
58 matches
Mail list logo