# [EMAIL PROTECTED] / 2005-07-14 00:57:57 -0400:
> On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote:
> > Vivek Khera wrote:
> > >The first sentence rules out MySQL, so the second sentence should read
> > >"So that leaves Postgres". Your problem is solved ;-)
> > >
> > >(If you are acc
> Harry Mantheakis wrote:
> >>Correct. The lesson is, never use locale support for Asian languages
> >>and multibyte encodings including UTF-8.
> >
> >
> > Thank you for your reply - much appreciated.
> >
> > I'm now concerned if and how this will affect ORDER BY query results (and
> > other fun
On Thu, Jul 14, 2005 at 02:46:01PM +1000, Neil Conway wrote:
> Vivek Khera wrote:
> >The first sentence rules out MySQL, so the second sentence should read
> >"So that leaves Postgres". Your problem is solved ;-)
> >
> >(If you are accustomed to Oracle, you are probably expecting an ACID
> >da
Vivek Khera wrote:
The first sentence rules out MySQL, so the second sentence should read
"So that leaves Postgres". Your problem is solved ;-)
(If you are accustomed to Oracle, you are probably expecting an ACID
database, which rules out MySQL too).
Does MySQL with InnoDB not qualify as
Alvaro Herrera wrote:
I don't think you can use just plpgsql's parser. The problem is that it
relies on the main backend parser to figure out anything it doesn't
understand.
I think it depends on what kind of information you want to extract from
a PL/PgSQL function definition. The PL/PgSQL pa
Thanks for the tips. It kind of worked. I got passed that point, but
then got to another set of errors.
I'm going to change my approach. I'm trying to locate some older
Linux ISOs that I can install in a vmware virtual environment and try
to build in there. Since all I want is to dump my da
Harry Mantheakis wrote:
>>Correct. The lesson is, never use locale support for Asian languages
>>and multibyte encodings including UTF-8.
>
>
> Thank you for your reply - much appreciated.
>
> I'm now concerned if and how this will affect ORDER BY query results (and
> other functions) with respe
Here is the link in case your fingers are broken and it hurts to type;)
http://www.postgresql.org/docs/8.0/interactive/encryption-options.html
On 7/13/05, Matt McNeil <[EMAIL PROTECTED]> wrote:
Greetings,
I need to securely store lots of sensitive contact
information andnotes in a freely av
On Wed, Jul 13, 2005 at 04:29:41PM -0700, Gregory Youngblood wrote:
> It gets through most of the make process, but then at the point where
> it starts creating files like GNUmakefile, it returns:
> sed: file conftest.sl line 35: unterminated `s' command
The problem is that GCC now gives a mult
I'm developing a habit of being the most frequent replier to my own posts, but anyway: I discovered the meaning of 1663, which is the default tablespace oid.But I still need help with diagnosis and treatment... -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC Strategic Open S
Joshua D. Drake wrote:
If you are using savepoints you can rollback to a specific point of
a parent transaction.
Although you can't use savepoints (explicitly) in functions. PL/PgSQL
exceptions (which are actually implemented internally via savepoints)
can be used to achieve a similar effect.
Karsten Hilbert wrote:
My main concern, however, was whether the *approach* is
sound, eg using a separate database name per release or IOW
version. One way would be to use the database name "gnumed"
regardless of release, another way would be to use
"gnumedX_Y" for release X.Y. I wonder whether
On Wed, Jul 13, 2005 at 01:28:45PM -0500, Jason Tesser wrote:
> I have the following store dproc but when I run it I am getting the
> error
>
> ERROR: invalid input syntax for integer: "(1)"
> CONTEXT: PL/pgSQL function "irispermissionget" line 9 at return next
>
> What am I doing wrong?
The
I have a production database where we just encountered the following error:ERROR: could not open relation 1663/32019395/94144936: No such file or directory Here's the output of SELECT version():PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC 2.95.4Here's uname -a:Linux 2.6.11.8 #8 SMP Tue
Tom Lane wrote:
> Bob <[EMAIL PROTECTED]> writes:
> > Doesn't that really only save you from having someone come in at the OS
> > level and copying your data files and than moutning them on a differet
> > server/database. A person could still come in to psql as a dba or anyone
> > for
> > that
What is the best way to quickly and reliably stop postgres? We've found
that pg_ctl doesn't work for us very well, frequently failing to
actually stop the postmaster (it times out and reports that it has
failed to stop). This is the same even if we use -m immediate.
We don't want to kill -9, o
Ron Mayer wrote:
> Martijn van Oosterhout wrote:
> >
> > Well, you get another issue, alignment. If you squeeze your string
> > down, the next field, if it is an int or string, will get padded to a
> > multiple of 4 negating most of the gains. Like in C structures, there
> > is padding to optimise
On Wed, Jul 13, 2005 at 05:23:06PM -0500, Jeffrey Melloy wrote:
> I'm currently looking at implementing a system almost exactly like this,
> and I was wondering if there is anything around that does this.
Attached find how GNUmed does it based on recent discussion
here on the list.
Karsten
--
I've been going through some old backups, and found databases from
pgsql versions as old as 7.0 (7.0, 7.1, 7.3, and 7.4 to be precise).
I'm trying to build these older versions specifically so I can dump
the data and see what I want to keep and what I can erase.
7.3 and 7.4 appear to have b
On Wed, Jul 13, 2005 at 03:53:26PM -0500, [EMAIL PROTECTED] wrote:
> I think a better approach is to handle configuration management with a
> table in each schema. Update the schema, update the table.
We already do that anyways. Our schema scripts have their
CVS version tag embedded in an INSERT
Tom Lane wrote:
>
> According to the SQL spec it's "implementation defined", which means
> different DBs could do it differently but they have to tell you what
> they will do. "Implementation dependent" effectively means "the
> behavior is not specified at all".
One problem is that even if the
On Wed, 2005-07-13 at 17:04 -0400, Alvaro Herrera wrote:
> > a simple standalone PL/pgSQL parser
>
> it relies on the main backend parser ... you'd have to mix
> both parsers somehow. ... The main parser depends (at least)
> on the List handling and memory handling
Okay, you scared me off.
It lo
I think a better approach is to handle configuration management with a
table in each schema. Update the schema, update the table. This works
well with automating database upgrades as well, where upgrades are written
as scripts, and applied in a given order to upgrade a database from release
A
Scott Marlowe wrote:
>
> On Wed, 2005-07-13 at 12:41, Tom Lane wrote:
> > [EMAIL PROTECTED] writes:
> > > Where does PostgreSQL rank nulls when sorting a column of timestamps,
> > > is this behaviour deterministic, and can I rely on it not changing in
> > > the future?
> >
> > Nulls sort high (in
On Wed, Jul 13, 2005 at 05:39:33PM -0400, Tom Lane wrote:
> (Memo to hackers: this is a fairly interesting case for autovacuum
> I think. The overall update rate on the table is not high enough to
> trigger frequent vacuums, unless autovacuum is somehow made aware that
> particular index key rang
Bob <[EMAIL PROTECTED]> writes:
> Doesn't that really only save you from having someone come in at the OS
> level and copying your data files and than moutning them on a differet
> server/database. A person could still come in to psql as a dba or anyone for
> that matter with the proper select g
On 7/13/05, Matt McNeil <[EMAIL PROTECTED]> wrote:
> Greetings,
> I need to securely store lots of sensitive contact information and
> notes in a freely available database (eg PostgreSQL or MySQL) that will be
> stored on a database server which I do not have direct access to.
> This database will
"David Esposito" <[EMAIL PROTECTED]> writes:
> ... and the way new keys are
> inserted into the index is to always add them to a new page (where the 'new'
> page is either a truly new page, or a page that is completely empty), rather
> than using up some of the fragmented space within existing page
On Wed, Jul 13, 2005 at 04:24:53PM -0400, Vivek Khera wrote:
>
> On Jul 12, 2005, at 1:16 PM, Ted Slate wrote:
>
> >If I stick with a true RDBMS then Codebase is out. So that leaves
> >Postgres and MySQL.
>
> The first sentence rules out MySQL, so the second sentence should
> read "So that
On Wed, Jul 13, 2005 at 08:33:59PM +, Matt Miller wrote:
> I'd like (to find or make) a utility that inputs the code of a Pl/pgSQL
> function (e.g. from a text file or from STDIN, and then parses the
> function definition, building a complete symbol table. I would then
> write C code that walk
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 13, 2005 3:45 PM
>
> Hmm, this is preferentially touching stuff near the right end of the
> index, ie, it's going to bloat the pages associated with higher keys.
> As I understand your usage of these
[EMAIL PROTECTED] wrote on 07/13/2005 02:59:02 PM:
> On Wed, Jul 13, 2005 at 12:53:15PM -0400, Alvaro Herrera wrote:
>
> > > we are developing GNUmed, a medical practice management
> > > application running on PostgreSQL (you want your medical
> > > data to be hosted by something reliable, don't
Even though PostgreSQL is more like an Oracle which is a good thing.
It's like Oracle in function not in cost and adminstration. PostgreSQL
not only fits into the enterprice really well it also fits in the mom
and pop shops(dentist office,corner store, you name it that may not
have any IT folks. S
On Wed, Jul 13, 2005 at 01:21:01PM -0700, Philip Hallstrom wrote:
> >My main concern, however, was whether the *approach* is
> >sound, eg using a separate database name per release or IOW
> >version. One way would be to use the database name "gnumed"
> >regardless of release, another way would be
Doesn't that really only save you from having someone come in at the OS
level and copying your data files and than moutning them on a differet
server/database. A person could still come in to psql as a dba or
anyone for that matter with the proper select grants and query off that
data and see it i
I'd like (to find or make) a utility that inputs the code of a Pl/pgSQL
function (e.g. from a text file or from STDIN, and then parses the
function definition, building a complete symbol table. I would then
write C code that walks that symbol table and does stuff. As a starting
point I'd be happy
On Tue, Jul 12, 2005 at 05:16:44PM +, Ted Slate wrote:
> Hello Everyone,
>
> I considering moving a product to Solaris/Linux and trying to find a
> good DB. Oracle is out due to cost so as far as i know the only
> reasonable alternatives are Postgres or Codebase or MySQL. Does
> anyone here
we are developing GNUmed, a medical practice management
application running on PostgreSQL (you want your medical
data to be hosted by something reliable, don't you ;-) We
are putting out our first release sometime in the next two
weeks.
The idea is to name the production database "gnumed0.1" for
On Jul 12, 2005, at 1:16 PM, Ted Slate wrote:
If I stick with a true RDBMS then Codebase is out. So that leaves
Postgres and MySQL.
The first sentence rules out MySQL, so the second sentence should
read "So that leaves Postgres". Your problem is solved ;-)
(If you are accustomed to Ora
On Jul 13, 2005, at 1:18 PM, Berend Tober wrote:
Or why bother including either? Just use sequential integers, maybe
left-padded with zeros to make the name the same length for the
first thousand or so releases?
I concur with this advice. Just use a sequence number which happens
to c
On Wed, Jul 13, 2005 at 01:18:09PM -0400, Berend Tober wrote:
> Or why bother including either? Just use sequential integers, maybe
> left-padded with zeros to make the name the same length for the first
> thousand or so releases?
A good tip, too, thanks. Would solve the ambiguity dilemma, too.
On Wed, Jul 13, 2005 at 12:53:15PM -0400, Alvaro Herrera wrote:
> > we are developing GNUmed, a medical practice management
> > application running on PostgreSQL (you want your medical
> > data to be hosted by something reliable, don't you ;-) We
> > are putting out our first release sometime in
Greetings,
I need to securely store lots of sensitive contact
information andnotes in a freely available database (eg PostgreSQL or MySQL) that
will bestored on a database server which I do not have direct access to.
This database will be accessed by a PHP application that I
amdeveloping. H
Using PHP and PostgreSQL only, what do you feel are the most popular
CMS and RAD tools out there?
I'm looking for free options.
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
My sense is that this is a difficult problem. However, I made the
mistake of promising this functionality,
Well it isn't that difficult except that you need some level of two way
encryption and it is going to be a performance nightmare.
I would suggest instead just mounting postgresql on a
"David Esposito" <[EMAIL PROTECTED]> writes:
> Hmm, if I keep running the following query while the test program is going
> (giving it a few iterations to rest between executions), the steady-state
> usage of the indexes seems to go up ... it doesn't happen every time you run
> the query, but if yo
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 13, 2005 2:10 PM
> To: David Esposito
>
> Plain VACUUM doesn't try very hard to shorten the table physically, so
> that's not surprising either. But the internal free space should get
> picked up at t
Greetings,
I need to securely store lots of sensitive contact
information andnotes in a freely available database (eg PostgreSQL or MySQL) that
will bestored on a database server which I do not have direct access to.
This database will be accessed by a PHP application that I
amdeveloping.
I've been using MySql for a long time, and have just recently moved to
PostgreSql (currently I have a few projects already running on postgresql)..
I have to say I prefer PostgreSql over MySql. One major factor in this is
the price (as mysql isn't free for commercial projects).
I can't really tell
I have the following store dproc but when I run it I am
getting the error
ERROR: invalid input syntax for integer: "(1)"
CONTEXT: PL/pgSQL function "irispermissionget"
line 9 at return next
What am I doing wrong?
CREATE OR REPLACE FUNCTION
"public"."irispermissionget" (usern
Doug Hall <[EMAIL PROTECTED]> writes:
>> If the EXPLAIN output doesn't say
>> anything about a "hashed subplan", then either you've got an old
>> version or there's some sort of estimation problem.
> No, the EXPLAIN doesn't mention "hashed subplan". I suspect it was a
> bug in the beta.
You mig
Oleg Bartunov wrote:
On Wed, 13 Jul 2005, marcelo Cortez wrote:
hi folks
the follow script fail
select to_tsquery('hello world ');
-> ERROR: syntax error
how to catch this error, any clue?
Also there is a handy article over here:
http://www.devx.com/opensource/Article/21674/0
by de
On Jul 13, 2005, at 12:46 PM, Tom Lane wrote:
Doug Hall <[EMAIL PROTECTED]> writes:
delete from citizen where id not in (select citizenid from
citizen_stage);
The explain select tells me that there is a sequential select of
citizen_stage records. (??) There are 75009 citizen records and 1477
Scott Marlowe <[EMAIL PROTECTED]> writes:
> On Wed, 2005-07-13 at 12:41, Tom Lane wrote:
>> Nulls sort high (in any datatype, not only timestamps). It's possible
>> that we'd offer an option to make them sort low in the future, but I
>> can't imagine that we'd change the default behavior.
> Isn't
On Wed, 2005-07-13 at 12:41, Tom Lane wrote:
> [EMAIL PROTECTED] writes:
> > Where does PostgreSQL rank nulls when sorting a column of timestamps, is
> > this
> > behaviour deterministic, and can I rely on it not changing in the future?
>
> Nulls sort high (in any datatype, not only timestamps).
On Wed, 13 Jul 2005, marcelo Cortez wrote:
hi folks
the follow script fail
select to_tsquery('hello world ');
-> ERROR: syntax error
how to catch this error, any clue?
by definition :)
read http://www.sai.msu.su/~megera/oddmuse/index.cgi/tsearch-v2-intro
Lets attempt to use the function
Many thanks Tom. Inconvenient from the point of view of the application but
still useful information.
The situation is that I've got a query with numerous subselects, each of which
has to return exactly one row so I was doing a union with a nulled record then
selecting the most recent: obviously I
"David Esposito" <[EMAIL PROTECTED]> writes:
> You're right that the index behavior is well-behaved with the cycle of
> INSERT / DELETE / VACUUM ... But while it was running, I started a second
> session to the database after the 60th iteration and did
> BEGIN;
> SELECT COUNT(*) FROM bigboy;
> RO
Doug Hall <[EMAIL PROTECTED]> writes:
> delete from citizen where id not in (select citizenid from
> citizen_stage);
> The explain select tells me that there is a sequential select of
> citizen_stage records. (??) There are 75009 citizen records and 14778
> records, and it's taking more than ha
[EMAIL PROTECTED] writes:
> Where does PostgreSQL rank nulls when sorting a column of timestamps, is this
> behaviour deterministic, and can I rely on it not changing in the future?
Nulls sort high (in any datatype, not only timestamps). It's possible
that we'd offer an option to make them sort l
>
> It sounds like you need to link gnova.so against the other shared
> objects so the runtime linker can find them. For examples, see the
> Makefiles used by contributed modules like dblink, xml2, and a few
> others that link against external libraries.
>
That approach is working, but only after
Alvaro Herrera wrote:
On Wed, Jul 13, 2005 at 05:56:03PM +0200, Karsten Hilbert wrote:
we are developing GNUmed, a medical practice management
application running on PostgreSQL (you want your medical
data to be hosted by something reliable, don't you ;-) We
are putting out our first releas
Where does PostgreSQL rank nulls when sorting a column of timestamps, is this
behaviour deterministic, and can I rely on it not changing in the future?
Apologies if this shows up as a repost, I've had gateway problems at this end.
--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk
[Opinion
Bizzarly its now working after I added the
server ip address in addition to the client ip address in the listen addresses
config line !!!
John Tulodziecki
Senior Software Engineer
Squire Technologies Ltd
Phone +44(0)1305 757315
Web www.squire-technologies.com
Email
On Wed, Jul 13, 2005 at 05:56:03PM +0200, Karsten Hilbert wrote:
> we are developing GNUmed, a medical practice management
> application running on PostgreSQL (you want your medical
> data to be hosted by something reliable, don't you ;-) We
> are putting out our first release sometime in the nex
Sorry. I realize this is a rather newbie question, but I've got a slow
delete going on here, and I could use some help figuring out why. This
is the classic "get rid of orphans" select.
delete from citizen where id not in (select citizenid from
citizen_stage);
citizen.id and citizen_stage.ci
Have you checked your pg_hba.conf file and add the correct entry to
allow the remote client ip address? Sorry don't have my file so I can't
show you an example. But I think the docs and/or a google will show
some examples.
Also you have to alter the postgresql.conf to allow tcp/ip connections.
I t
There are a number of good, objective, and informative comparisons
available on the Internet, such as http://www.databasejournal.com/sqletc/article.php/3486596.
You can Google something like "Postgresql mysql firebird comparison" to access
these. I am migrating an application from Paradox a
I solved it. The statment worked as is, I just had to use dynamic SQL (put
the statement in a string and the EXECUTE the string). Here is what I did:
CREATE FUNCTION test(varchar) RETURNS int2 AS'
DECLARE
id_list ALIAS FOR $1;
query varchar;
BEGIN
query := '' INSERT INTO history (media_id
Hi there
I am trying to run a simple client application on one linux
box (running redhat 9) whilst the server (i.e postmaster) is running on another
box.
I have successfully run the client program locally on the
server machine.
I am getting connection refused when I try a remote
Hi all,
we are developing GNUmed, a medical practice management
application running on PostgreSQL (you want your medical
data to be hosted by something reliable, don't you ;-) We
are putting out our first release sometime in the next two
weeks.
The idea is to name the production database "gnumed
I am "TOP POSTING" intentionally --
Thanks Mike... Very informative -- I never realized that child (INHERITED)
tables do NOT inherit the indexes from their parent... that might be part of
the solution I duplicated the parents index on the child table -- the
function still takes 4672 ms to
Einar Indridason <[EMAIL PROTECTED]> writes:
> I'm experiencing a memory leak, when I run this program.
Yup, it's a leak. See patches just committed at
http://developer.postgresql.org/cvsweb.cgi/pgsql/src/interfaces/libpq/fe-connect.c
(note patch varies depending on branch)
argh!!! It was telling me I had an error in select statement. Thanks
Tom!
Regards
David
On Wednesday, July 13, 2005, at 11:08 AM, Tom Lane wrote:
David Pratt <[EMAIL PROTECTED]> writes:
CREATE FUNCTION create_record_test(text[][]) RETURNS int4 AS '
DECLARE
test_array ALIAS F
hi folks
the follow script fail
select to_tsquery('hello world ');
-> ERROR: syntax error
how to catch this error, any clue?
best regards
mdc
__
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
¡Abrí tu
Roman Neuhauser wrote:
# dev@archonet.com / 2005-07-13 14:09:34 +0100:
Roman Neuhauser wrote:
callrec32=# \d fix.files
Table "fix.files"
Column | Type | Modifiers
++---
dir| character varying(255) |
bas
On Wed, Jul 13, 2005 at 07:23:29AM -0600, Michael Fuhr wrote:
> On Wed, Jul 13, 2005 at 12:09:37PM +, Einar Indridason wrote:
> >
> > Hi folks. One of my co-workers came to me with a problem. I took a
> > look, and it does seem to be a problem. (But where? That is why I'm
> > turning to you
Richard Huxton writes:
> What happens to the plan if you SET enable_seqscan=false; first? It's
> presumably getting the row-estimate right, so unless there's terrible
> correlation on "base" in the files table I can only assume it's getting
> the cost estimates horribly wrong.
I think you'll f
# [EMAIL PROTECTED] / 2005-07-13 15:58:09 +0200:
> # dev@archonet.com / 2005-07-13 14:09:34 +0100:
> > Roman Neuhauser wrote:
> > >callrec32=# \d fix.files
> > > Table "fix.files"
> > > Column | Type | Modifiers
> > >++-
David Pratt <[EMAIL PROTECTED]> writes:
> CREATE FUNCTION create_record_test(text[][]) RETURNS int4 AS '
> DECLARE
> test_array ALIAS FOR $1; -- alias for input array
> BEGIN
> return array_upper(test_array,1)
> END;
> ' LANGUAGE 'plpgsql';
> SELECT
Janning Vygen <[EMAIL PROTECTED]> writes:
> I was just testing some configuration settings, especially increasing
> shared_buffers and setting fsync to false. And suddenly it happens 3 times
> out of ten that i get this error.
Could you put together a complete example --- that is a script someon
# dev@archonet.com / 2005-07-13 14:09:34 +0100:
> Roman Neuhauser wrote:
> >callrec32=# \d fix.files
> > Table "fix.files"
> > Column | Type | Modifiers
> >++---
> > dir| character varying(255) |
> >
Am Dienstag, den 12.07.2005, 12:47 -0300 schrieb Adam O'Toole:
> I am trying to INSERT multiple rows to a table using a stored procedure
> something like this:
>
> CREATE FUNCTION test(varchar) RETURNS int2 AS '
> DECLARE
> id_list ALIAS FOR $1;
> BEGIN
> INSERT INTO history (media_id, media_type
Am Dienstag, den 12.07.2005, 17:16 + schrieb Ted Slate:
> Hello Everyone,
>
> I considering moving a product to Solaris/Linux and trying to find a good
> DB. Oracle is out due to cost so as far as i know the only reasonable
> alternatives are Postgres or Codebase or MySQL. Does anyone here
First, thank you for spending so much time on this issue
Second, I think I might have found a good lead ... I replicated the test you
described below (minus the updating of 10% of the records) ... I've attached
the PHP script (I'm more proficient at writing PHP than a shell script; you
should be a
Martijn van Oosterhout wrote:
Well, you get another issue, alignment. If you squeeze your string
down, the next field, if it is an int or string, will get padded to a
multiple of 4 negating most of the gains. Like in C structures, there
is padding to optimise access.
Anecdotally I hear at leas
Here the media_id will be checked with ('24,25') and not with (24,25).
You might change the datatype from varchar to int array in test function and use "any" in the place of "IN" clause like this,
CREATE FUNCTION test(int[]) RETURNS int2 AS '
DECLARE
id_list ALIAS FOR $1;
BEGIN
INSERT INTO h
Janning Vygen <[EMAIL PROTECTED]> writes:
> this way it works:
> CREATE TEMP TABLE ranking AS *Q*;
> EXECUTE 'UPDATE temp_gc SET gc_rank = ranking.rank
> FROM ranking WHERE temp_gc.mg_name = ranking.mg_name;';
> and this way it doesn't:
> UPDATE temp_gc
> SET gc_rank = ranking.rank
> FROM (*Q*)
On Wed, Jul 13, 2005 at 12:09:37PM +, Einar Indridason wrote:
>
> Hi folks. One of my co-workers came to me with a problem. I took a
> look, and it does seem to be a problem. (But where? That is why I'm
> turning to you...)
Your message doesn't say anything about what the problem is -- wha
Hello Everyone,
I considering moving a product to Solaris/Linux and trying to find a good
DB. Oracle is out due to cost so as far as i know the only reasonable
alternatives are Postgres or Codebase or MySQL. Does anyone here have any
experience using Codebase or MySql? If I stick with a tru
Hi all,
I've dropped a schema in my database with this command :
delete from pg_namespace where nspname = "toto";
I know ... I 've done a big mistake :( . I will prefer "drop schema
toto" the next time.
Now I can't do a pg_dump because some objects of the removed schema are
still referenced
Hi,
Am Mittwoch, 13. Juli 2005 00:03 schrieb Tom Lane:
> Janning Vygen <[EMAIL PROTECTED]> writes:
> > I have a guess, what happens here: The order of the subselect statement
> > is dropped by the optimizer because the optimizer doesn't see the
> > "side-effect" of the ranking function.
>
> That
Roman Neuhauser wrote:
Because you don't have an index on "base" for the files table.
I added one, ran vacuum full analyze fix.files, and:
callrec32=# \d fix.files
Table "fix.files"
Column | Type | Modifiers
+-
I am trying to INSERT multiple rows to a table using a stored procedure
something like this:
CREATE FUNCTION test(varchar) RETURNS int2 AS '
DECLARE
id_list ALIAS FOR $1;
BEGIN
INSERT INTO history (media_id, media_type) SELECT media.media_id,
media.media_type WHERE media.media_id IN (id_list);
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, July 12, 2005 12:26 PM
>
> "David Esposito" <[EMAIL PROTECTED]> writes:
> > As promised, here are two runs of VACUUM VERBOSE on the
> problem table ...
>
> BTW, the tail of the VACUUM VERBOSE output ought t
On Wed, Jul 13, 2005 at 12:45:19AM -0700, Miles Keaton wrote:
> I have the contrib/pgcrypto installed.
> I want to get the 40-character hash from SHA1
>
> Example: SELECT digest('blue', 'sha1') would be:
> 4c9a82ce72ca2519f38d0af0abbb4cecb9fceca9
>
> I was surprised and disappointed to get a bina
# dev@archonet.com / 2005-07-13 12:57:31 +0100:
> Roman Neuhauser wrote:
> >Why does the planner want to crawl the table that has 5M rows instead of
> >the one
> >with 176k rows? Both tables are freshly vacuum-full-analyzed.
>
> Because you don't have an index on "base" for the files table.
On Wed, Jul 13, 2005 at 01:55:39PM +0800, Nee.mem() wrote:
>
> i see you wrote on this page
> http://archives.postgresql.org/pgsql-general/2005-07/msg00319.php
>
> test exsample:
> create or replace function test()
> returns void as
> '
> begin
> del
Hi folks. One of my co-workers came to me with a problem. I took a
look, and it does seem to be a problem. (But where? That is why I'm
turning to you...)
The C code below serves as an example. He is basically trying to
re-connect again to a "bad" database server. The "server" at
192.168.0.1,
Roman Neuhauser wrote:
Why does the planner want to crawl the table that has 5M rows instead of the one
with 176k rows? Both tables are freshly vacuum-full-analyzed.
Because you don't have an index on "base" for the files table.
callrec32=# \d fix.files
Table "fix.files"
Column
1 - 100 of 119 matches
Mail list logo
