> 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 respect to Latin-1 names and words.
I thi
Title: Signature
Hi,
sorry, i am a PostgesSQL beginner:
I started the pgadmin tool as superuser.
Created the database OfficeTalk
Created the schema OfficeTalk with same permissions as the template
pg_template_1
If i create the table OfficeTalk.absent >>>
sche
Title: Signature
Hi,
i want to migrate a MS-SQL database to postgres. I have a SQL-script for
the tables (definitions, indices a.s.o.), created by the MS-Enterprise-Manager.
How can i create a postgres database with this script. Does a tool exist
for reading such a script ?
--
B
It seems like the conclusion should be that PGSQL 8 works very well under
Windows but
maybe for Windows NT something else should be used; it seems like too much
hazzle to
get it to work
BTJ
Frank Rittinger wrote:
> Hello Bjørn,
>
> we are running a handfull of PostgreSQL installations on
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 binary-hash back.
Does anyone know how to get the regular 40-character string b
Josef Springer wrote:
Hi,
i want to migrate a MS-SQL database to postgres. I have a SQL-script for the
tables (definitions, indices a.s.o.), created by the MS-Enterprise-Manager. How
can i create a postgres database with this script. Does a tool exist for reading
such a script ?
You proba
Title: Signature
I think it's because of uppercase letters: if you don't quote ...
create table "OfficeTalk.absent" , postgresql will lowercase
everything
regards
Josef Springer wrote:
Hi,
sorry, i am a PostgesSQL beginner:
I started the pgadmin tool as superuser.
Create
pgsql-general, 您好！
postgreSQL version is Redhat 9.0 + postgresql 8.0.3
下面是转发邮件
原邮件发件人名字: Bj�rn_T_Johansen
[EMAIL PROTECTED]
原邮件收件人名字：Frank Rittinger
[EMAIL PROTECTED]
[EMAIL PROTECTED]
[EMAIL PROTECTED]
>It seems like the conclusion should be that PGSQL 8 work
On 7/13/05, Tom Lane <[EMAIL PROTECTED]> wrote:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Personally I would settle for a fuller set of small fixed size datatypes.
> > The
> > "char" datatype is pretty much exactly what's needed except that it provides
> > such a quirky interface.
>
> I'm not
On 7/12/05, Joe <[EMAIL PROTECTED]> wrote:
> Dawid Kuroczko wrote:
> > smallint takes two bytes. Numeric(1) will take around 10 bytes and char(1)
> > will
> > take 5 bytes (4 bytes for length of data).
> I never would've imagined *that* amount of overhead for CHAR(1)! I would've
> imagined that
Josef Springer wrote:
Hi,
sorry, i am a PostgesSQL beginner:
* I started the pgadmin tool as superuser.
* Created the database /OfficeTalk/
* Created the schema /OfficeTalk/ with same permissions as the template
/pg_template_1/
Are you sure pg_template_1 isn't a database?
> I insalled Postgres 8 in Windows XP with default settings I
> xreated database with encoding unicode.
Unicode is not currently supported when the server runs on Win32, see
http://www.postgresql.org/docs/faqs.FAQ_windows.html#2.6. You'll need to
pick a different encoding if you need locale-aware
Dear hackers
I want to embed postgres into a software installation. I will use silent install, how do I detect which partition is NTFS so I can tell the installer to use that partition?
Many thanks
-Evandro-- Evandro M Leite JrPhD Student & Software developer
University of Southampton, UKPerso
On Wed, Jul 13, 2005 at 10:48:56AM +0200, Dawid Kuroczko wrote:
> As for the char/varchar type -- I was wondering. Worst case
> scenario for UTF-8 (correct me on this) is when 1 character
> takes 4 bytes. And biggest problem with char/varchar is that
> length indicator takes 4 bytes... How much
> I want to embed postgres into a software installation. I will
> use silent install, how do I detect which partition is NTFS
> so I can tell the installer to use that partition?
You can't do that inside the installer, you'll have to do it in your own
script/program that wraps it.
//Magnus
--
> Unicode is not currently supported when the server runs on Win32, see
> http://www.postgresql.org/docs/faqs.FAQ_windows.html#2.6. You'll need to
> pick a different encoding if you need locale-aware sorting.
I need to upsize tables from other dbms. This dbms does not support unicode.
I have tabl
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.
7.4.7 on i686-redhat-linux-gnu, compiled by GCC gcc (GCC) 3.4.3 20041212 (Red
Hat 3.4.3-9.EL4)
callrec32=# explain select fd.base from fix.dups fd join f
Hi,
[i am using Postgresql version 8.0.3]
yesterday i posted a mail regarding a function which calculates a ranking with
a plperl SHARED variable.
Today i ve got some problems with it:
FEHLER: duplizierter Schlüssel verletzt Unique-Constraint
»pg_type_typname_nsp_index«
CONTEXT: SQL-Anweis
How does one pass an array as a parameter to a plpgsql function? I
have tried this the following. I can't seem to get a select statement
to work without syntax problems and no examples in Postgres book to
help with this :( This is just a test so please ignore the fact it is
a simple function.
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
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,
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
# 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 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
> -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
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);
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
+-
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
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
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
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
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*)
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
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
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
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
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
# 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) |
> >
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
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
# [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
> > >++-
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
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
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
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
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
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)
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
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
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
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
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
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
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
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
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
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
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
>
> 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
[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
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
"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
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
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
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).
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 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
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
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
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
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
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.
> -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
"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
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
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
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
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
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 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 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
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 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
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
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
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
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
[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
> -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
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
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
"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 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
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 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
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
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
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
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, 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
1 - 100 of 119 matches
Mail list logo
