I'm trying to figure out the best way to cope with creating a PITR base
backup on a 8.1 server that is essentially idle during that time (and for
hours afterwards). Because there's no activity when the backup is going
on, I get the same segment file for FIRST WAL and LAST WAL.
Unfortunately, t
Tom Allison wrote:
alter TABLE user_history ALTER COLUMN seen_as set not null;
turns it on...
I want to turn it off
DROP NOT NULL;
On May 30, 2007, at 9:05 PM, Joshua D. Drake wrote:
Tom Allison wrote:
I have a column that was created with a 'not null' restriction.
How do I remove i
alter TABLE user_history ALTER COLUMN seen_as set not null;
turns it on...
I want to turn it off
On May 30, 2007, at 9:05 PM, Joshua D. Drake wrote:
Tom Allison wrote:
I have a column that was created with a 'not null' restriction.
How do I remove it?
alter table set
-
> Hi List;
>
> It seems that in a replication scenario pgpool becomes the single point of
> failure, i.e. if we loose the pgpool box were dead. Any thoughts,
> suggestions, best practices, etc per creating redundancy in the pgpool layer?
>
> I've posted to the pgpool list as well but I wanted t
Tom Allison wrote:
I have a column that was created with a 'not null' restriction.
How do I remove it?
alter table set
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
--
I have a column that was created with a 'not null' restriction.
How do I remove it?
---(end of broadcast)---
TIP 4: Have you searched our list archives?
http://archives.postgresql.org/
On May 30, 2007, at 13:59 , Gabriel Laet wrote:
I'm developing an application where basically I need to store cars.
Every car has a Make and Model association. Right now, I have three
tables: MAKE, MODEL (make_id) and CAR (model_id).
1) I'm not sure if I need or not to include "make_id" to the
On Wed, May 30, 2007 at 06:28:17PM -0400, ABHANG RANE wrote:
> client. Please may I know what other parameters need to be tweaked. I
To begin with, please show us exactly what you're doing. I don't
know what it is yet.
A
--
Andrew Sullivan | [EMAIL PROTECTED]
This work was visionary and imag
Hi,
I have installed postgre 8.2.4. I tried to modify the pg_hba.conf and
.conf file for allowing remote connection but it did not work. The
server is a linux machine. I am trying to connect with my laptop by ssh
client. Please may I know what other parameters need to be tweaked. I
get an erro
If it's been fsync'd to a DRDB device, it's been fsync'd to both systems.
I think that answers your question...
On Wed, 30 May 2007, Kevin Kempter wrote:
Hi List ;
per considering DRDB as a replication solution in a failed master node
scenario, is there a risk of loosing not only in-flight tr
"Andrus" <[EMAIL PROTECTED]> writes:
>>> Why numeric(2) is not casted to integer automatically ?
>>
>> Because it would lose data, eg '4.4' being rounded to 4.
> I tought that numeric(2) can store only integer data, without decimal
> points.
Oh, I see your confusion: you're supposing that we mig
[EMAIL PROTECTED] writes:
> Other than the fact that no space may need to be reclaimed is anyone
> aware of any circumstance - e.g. use of numeric data types - where a
> full vacuum will simply not reclaim space?
There are several corner cases where the code will abandon shrinking.
What are you co
On 5/29/07, Zhan Deng <[EMAIL PROTECTED]> wrote:
After the installation, I was trying to run createdb.exe and createuser.exe
utilities in a silent mode. But they always ask me to enter the password.
Is there is a way that I can run them by passing the username/password from
the command line wit
nuno escribió:
> hello.
>
> i deleted and recreated a db with the same name.
> is it possible to recover the database back to where it was before i
> deleted it?
No.
--
Alvaro Herrerahttp://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
---
Hi List ;
per considering DRDB as a replication solution in a failed master node
scenario, is there a risk of loosing not only in-flight transactions but alos
un-sync'd buffer-pool dirty pages?
If so, how might I minimize this risk ?
Thanks in advance...
---(end of bro
Vang wrote:
Hello,
I'm using PostgreSQL 8.0 and Java in NetBeans IDE. In java I have a
method that does a "insert into" and it throws a "duplicate key
violates unique constraint." I call that method once and then call
another method which does a "select." However, when the select
method gets
Hi,
I have a question regarding the PostgreSQL installation.
I installed PostgreSQL in silent mode successfully. I passed the
following parameters into the postgresql:
Msiexec postgresql-8.2-int.msi" /l*v C:\\log4.txt /qb INTERNALLAUNCH=1
ADDLOCAL=server,psql,pgadmin,jdbc,npgsql SERVICE
Other than the fact that no space may need to be reclaimed is anyone
aware of any circumstance - e.g. use of numeric data types - where a
full vacuum will simply not reclaim space?
---(end of broadcast)---
TIP 5: don't forget to increase your free s
Why numeric(2) is not casted to integer automatically ?
Because it would lose data, eg '4.4' being rounded to 4.
create temp table test ( test numeric(2));
insert into test values (0.5);
select * from test
returns
1
I'm really confused now.
I tought that numeric(2) can store only integer
Hi,
I'm developing an application where basically I need to store cars.
Every car has a Make and Model association. Right now, I have three
tables: MAKE, MODEL (make_id) and CAR (model_id).
1) I'm not sure if I need or not to include "make_id" to the CAR
table. To me, it's clear to associate just
Joshua wrote:
Thank you all for your assistance. I did end up finding NULL in the
'onorder' column which should have been zero's this was in a test
table that happened to have some NULL in it for one reason or another
but I should not find this in the production version of the table.
I al
Hello,
I'm using PostgreSQL 8.0 and Java in NetBeans IDE. In java I have a method
that does a "insert into" and it throws a "duplicate key violates unique
constraint." I call that method once and then call another method which does a
"select." However, when the select method gets called post
Hi List;
It seems that in a replication scenario pgpool becomes the single point of
failure, i.e. if we loose the pgpool box were dead. Any thoughts,
suggestions, best practices, etc per creating redundancy in the pgpool layer?
I've posted to the pgpool list as well but I wanted to get some tho
Alvaro Herrera wrote:
> André Volpato wrote:
>
>> The ammount of space saved seems pretty clear to me.
>
> Yeah, zero most of the time due to alignment.
So trading off more I/O for less CPU?
I wonder if for any I/O bound database servers
it might be worth packing tightly rather than
aligning in
Tom Lane wrote:
>
> Exactly. VACUUM sucks (ahem) in all ways but one: it pushes the
> maintenance costs associated with MVCC out of the foreground query code
> paths and into an asynchronous cleanup task. AFAIK we are the only DBMS
> that does it that way. Personally I believe it's a fundamenta
Google. And, yes, Google use a modified MySQL for its pigeons.
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Joshua D. Drake
Sent: Wednesday, May 30, 2007 2:41 PM
To: Jeff Davis
Cc: Scott Ribe; PostgreSQL general
Yes, thanks, you're all very helpful and I completely appreciate it.
For future reference, here is the adapted procedure. I wonder if the way I'm
dealing with the boolean param (using the if then to set a stand in
variable) is as clean as it could be...but it does work.
CREATE or REPLACE FUNCTIO
Tom Lane wrote:
> Dave Page <[EMAIL PROTECTED]> writes:
>> I can't imagine Flickr or Slashdot ...
>
> I'm pretty sure I remember reading that Slashdot had to put enormous
> amounts of cacheing in front of their DB to keep it from falling over
> on a regular basis.
Yes, slashdot and flickr both us
On Wed, 2007-05-30 at 11:41 -0700, Joshua D. Drake wrote:
> > I agree that /. not a great example of stability or correctness.
>
> Interesting statement. Question: What would be a great example of
> stability of correctness?
>
Admittedly, I'm comparing against an ideal. If I get ungraceful erro
novnov escribió:
>
> While a hard coded order by clause works; passing the order by as a param is
> ignored as I've implemented below. The order by value is being passed as
> expected (tested by outputing the value in a column).
It doesn't because the value is expanded as a constant, therefore a
On Wed, May 30, 2007 at 11:40:15AM -0700, novnov wrote:
>
> While a hard coded order by clause works; passing the order by as a param is
> ignored as I've implemented below. The order by value is being passed as
> expected (tested by outputing the value in a column). I've called like so:
What yo
Jeff Davis wrote:
On Wed, 2007-05-30 at 12:18 -0600, Scott Ribe wrote:
I thought it had to do with letting a form sit around too long and
then /. timing out the state.
That's probably not good anyway: it should at least give you a real
error message. However, they might not consider that a bug.
While a hard coded order by clause works; passing the order by as a param is
ignored as I've implemented below. The order by value is being passed as
expected (tested by outputing the value in a column). I've called like so:
ups=# begin;
BEGIN
ups=# select proc_item_list(1,true,'item_id');
pr
On Wed, 2007-05-30 at 12:18 -0600, Scott Ribe wrote:
> > I thought it had to do with letting a form sit around too long and
> > then /. timing out the state.
> >
> > That's probably not good anyway: it should at least give you a real
> > error message. However, they might not consider that a bug.
> I thought it had to do with letting a form sit around too long and
> then /. timing out the state.
>
> That's probably not good anyway: it should at least give you a real
> error message. However, they might not consider that a bug.
I didn't let the form sit around at all--didn't think to menti
Richard Huxton <[EMAIL PROTECTED]> writes:
> With a libpq call you could set "sslmode", but I'm not sure if you can
> do that from the command-line.
I think you can set it via a PGSSLMODE environment variable.
regards, tom lane
---(end of broadcas
On Wed, 2007-05-30 at 19:38 +0200, Martijn van Oosterhout wrote:
> On Wed, May 30, 2007 at 05:58:24PM +0100, Oliver Elphick wrote:
> > While experimenting just now, I seem to have found a weird problem with
> > passwords, in that _anything_ I type in is accepted as a valid password.
>
> > # TYPE
Right...I see I'd left BEGIN; off after the first couple of trys.
Thanks
Alvaro Herrera-7 wrote:
>
> novnov escribió:
>>
>> I have been able to run a test like you have in a query (if that's the
>> right
>> term), and ORDER BY does work. When trying to run via psql, it fails, I
>> can't see w
On 05/30/07 11:01, John D. Burger wrote:
Even ISO country codes are not guaranteed to be stable
I'm not sure where the idea that primary keys must be stable comes
from. There's nothing necessarily wrong with updating a primary key.
All a primary key does is uniquely identify a row in a table.
[EMAIL PROTECTED] wrote:
The following is an extract of the output from the DB monitoring tool
that was delivered with the Progress DB. Sorry for the formatting but
I am hopeful you get an idea of what I am talking about. Counters
would be updated every x seconds. Is there something - commercial,
On Wed, May 30, 2007 at 05:58:24PM +0100, Oliver Elphick wrote:
> While experimenting just now, I seem to have found a weird problem with
> passwords, in that _anything_ I type in is accepted as a valid password.
> # TYPE DATABASEUSERCIDR-ADDRESS METHOD
> # IPv4 local connect
Oliver Elphick wrote:
While experimenting just now, I seem to have found a weird problem with
passwords, in that _anything_ I type in is accepted as a valid password.
Here are the relevant bits of pg_hba.conf
# TYPE DATABASEUSERCIDR-ADDRESS METHOD
hostnossljunk
On 5/30/07, Ron Johnson <[EMAIL PROTECTED]> wrote:
On 05/30/07 01:38, Albe Laurenz wrote:
> Ron Johnson wrote:
>> Does PG set up buffers at the postmaster level or the database level?
>>
>> If at the database level, then you'll be allocating memory to
>> databases that might not be in use at any
Oliver Elphick <[EMAIL PROTECTED]> writes:
> His original message (which I snipped) said he had:
> # IPv4-style local connections:
> hostall all 127.0.0.1 255.255.255.255 trust
> hosttesting123 brakesh 127.0.0.1 255.255.255.255 trust
> So it seems
Did you ever "createuser brakesh" ???
Apologies about the he,she ;)... he + s = she, see you're greater of a
person than a 'he.' Heehee.
On Wed, 30 May 2007, Bhavana.Rakesh wrote:
Yes, I have been restarting the postgres every time I make changes to the
pg_hba.conf file.
-Bhavana
On a li
Yes, I have been restarting the postgres every time I make changes to
the pg_hba.conf file.
-Bhavana
On a lighter note, it's a 'she' not 'he'. :) No offense taken. :))
[EMAIL PROTECTED] wrote:
As super-user (postgres) you have to create the user in Postgres, then
Grant access. In other word
Did you grant access to your user?
On Wed, 30 May 2007, Oliver Elphick wrote:
On Wed, 2007-05-30 at 18:35 +0200, Martijn van Oosterhout wrote:
On Wed, May 30, 2007 at 12:30:38PM -0400, Bhavana.Rakesh wrote:
Oliver,
When I do a :
psql -p 5000 testing123
I can make a connec
I'm using version 7.4. The "hostnossl" is not helping either. My error is
[EMAIL PROTECTED] ~]$ psql -U brakesh -h 127.0.0.1 -d testing123
psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "brakesh",
database "testing123", SSL off
The current pg_hba.conf file is as follows:
# TY
As super-user (postgres) you have to create the user in Postgres, then
Grant access. In other words, if the pg_hba.conf file specifies a user
who does not exist, "user brakesh does not exist" will cause a failure to
connect as well.
Every connection to a database, has to have a user associate
On Wed, 2007-05-30 at 13:00 -0400, [EMAIL PROTECTED] wrote:
> Did you grant access to your user?
If you mean grant access by an SQL GRANT, he hasn't got far enough to
check that. The error specifically says "no pg_hba.conf entry". As far
as I can see, his pg_hba.conf is OK.
>
> On Wed, 30 May
In short, you have to update every instance of the key, not only in the
database, but in every application and even in every other
representation in
the real world. That could include changing people's bookmarks, notes in
PDAs,
even paper reports sitting on people's desks -- a tall order fo
While experimenting just now, I seem to have found a weird problem with
passwords, in that _anything_ I type in is accepted as a valid password.
Here are the relevant bits of pg_hba.conf
# Database administrative login by UNIX sockets
local all postgres ident sa
Hello,
I'm trying to write a trigger on insert which should insert the row
in another
table. The table on which to insert the row should be selected at
runtime and
it is not know in advance. For example, let's say we have a table with
two columns, a date and an integer. a row is inserted int
novnov escribió:
>
> I have been able to run a test like you have in a query (if that's the right
> term), and ORDER BY does work. When trying to run via psql, it fails, I
> can't see what I'm doing wrong. (windows xp, postgres 8.2.0-1)
>
> ups=# select proc_item_list(1,true);
>proc_item_list
>>> I'm not sure where the idea that primary keys must be stable comes from.
>>> There's nothing necessarily wrong with updating a primary key. All a
>>> primary key does is uniquely identify a row in a table. If that id changes
>>> over time, that's fine, as long as the primary key columns con
On Wed, 2007-05-30 at 18:35 +0200, Martijn van Oosterhout wrote:
> On Wed, May 30, 2007 at 12:30:38PM -0400, Bhavana.Rakesh wrote:
> > Oliver,
> >
> > When I do a :
> >psql -p 5000 testing123
> > I can make a connection. However, when I do a
> >
> > psql -U brakesh -h 127
On Wed, 2007-05-30 at 12:30 -0400, Bhavana.Rakesh wrote:
> Oliver,
>
> When I do a :
> psql -p 5000 testing123
> I can make a connection.
Since you aren't specifying a host (with -h), that command uses a Unix
socket connection and only looks at lines in pg_hba.conf that begin
On Wed, May 30, 2007 at 12:30:38PM -0400, Bhavana.Rakesh wrote:
> Oliver,
>
> When I do a :
>psql -p 5000 testing123
> I can make a connection. However, when I do a
>
> psql -U brakesh -h 127.0.0.1 -d testing123
>
> I get the followign error:
>
> psql: FATAL: no pg_h
Oliver,
When I do a :
psql -p 5000 testing123
I can make a connection. However, when I do a
psql -U brakesh -h 127.0.0.1 -d testing123
I get the followign error:
psql: FATAL: no pg_hba.conf entry for host "127.0.0.1", user "brakesh", database
"testing123", SSL off
I used the example in the following URL
http://www.postgresql.org/docs/7.3/static/client-authentication.html
Thanks for the catch on "host" instead of "local". I made that change,
and reloaded pgsql.. But I still get the same error. I can connect to
the database using psql client, but my j
We are using a three-tier application with J2EE, JBoss, Hibernate and
a Postgres database.
It would be a nice thing to monitor or trace the actual SQL statements
processed by the DB. I do not really need the result set as I can get
this - if required - using SQL against the DB through the Pgsql
Even ISO country codes are not guaranteed to be stable
I'm not sure where the idea that primary keys must be stable comes
from. There's nothing necessarily wrong with updating a primary
key. All a primary key does is uniquely identify a row in a table.
If that id changes over time, that's
On Wed, 2007-05-30 at 11:47 -0400, Bhavana.Rakesh wrote:
> Hello,
> I'm still getting the error
...
> Here is my updated version of pg_hba.conf file
> __
> #
> # TYPE DATABASEUSERIP-ADDRESSIP-MASK
On 05/30/07 10:23, Tom Lane wrote:
Paul Tilles <[EMAIL PROTECTED]> writes:
I am wondering if one of the previous executions of psql is doing some
"back room" work in the database while allowing the script to continue.
It takes finite time for the backend to quit, and psql doesn't wait
around
I have been able to run a test like you have in a query (if that's the right
term), and ORDER BY does work. When trying to run via psql, it fails, I
can't see what I'm doing wrong. (windows xp, postgres 8.2.0-1)
ups=# select proc_item_list(1,true);
proc_item_list
(1 row)
On Wed, May 30, 2007 at 08:04:19AM -0700, Joshua D. Drake wrote:
> I would like to submit that, that is likely not true at all.
Possibly. I was just pointing out that the last estimate any
developer gave was "beta in Sept."
A
--
Andrew Sullivan | [EMAIL PROTECTED]
The whole tendency of moder
In response to [EMAIL PROTECTED]:
> We are using a three-tier application with J2EE, JBoss, Hibernate and
> a Postgres database.
>
> It would be a nice thing to monitor or trace the actual SQL statements
> processed by the DB. I do not really need the result set as I can get
> this - if required
Hello,
I'm still getting the error
[EMAIL PROTECTED] ~/db_connect]$ java db_connect_pgsql.class
Checking if Driver is registered with DriverManager
Registered the driver ok, making DB connection now
Couldn't connect: print out a stack trace and exit.
org.postgresql.util.PSQLException: A connect
The following is an extract of the output from the DB monitoring tool
that was delivered with the Progress DB. Sorry for the formatting but
I am hopeful you get an idea of what I am talking about. Counters
would be updated every x seconds. Is there something - commercial, non-
commercial, does not
We are using a three-tier application with J2EE, JBoss, Hibernate and
a Postgres database.
It would be a nice thing to monitor or trace the actual SQL statements
processed by the DB. I do not really need the result set as I can get
this - if required - using SQL against the DB through the Pgsql
in
Paul Tilles <[EMAIL PROTECTED]> writes:
> I am wondering if one of the previous executions of psql is doing some
> "back room" work in the database while allowing the script to continue.
It takes finite time for the backend to quit, and psql doesn't wait
around for that to happen. I've noticed
Andrew Sullivan wrote:
On Wed, May 30, 2007 at 12:05:18AM +0100, Raymond O'Donnell wrote:
I realise that (i) this is something of a FAQ, and (ii) the definitive
answer is "When it's ready", but when (roughly) is 8.3 planned to be
released?
According to a recent post on -hackers by Bruce, at t
I am executing a script which contains multiple executions of psql.
The last execution of psql renames the database. It looks something
like the following
psql -f create_tables.sql db_name1
psql -f modify_tables.sql db_name1
psql -f add_indexes.sql db_name1
psql templat
On Wed, May 30, 2007 at 12:05:18AM +0100, Raymond O'Donnell wrote:
> I realise that (i) this is something of a FAQ, and (ii) the definitive
> answer is "When it's ready", but when (roughly) is 8.3 planned to be
> released?
According to a recent post on -hackers by Bruce, at the current rate
of p
On Thu, May 24, 2007 at 04:44:53PM -0700, Raymond C. Rodgers wrote:
> The question, and point, is this: Is there an alternate way of
> accomplishing read and write functionality similar to what inheritance
> offers but allowing me to map the columns as I desire? The read only
It isn't clear fro
On Thu, May 24, 2007 at 07:02:15AM -0700, bruce wrote:
>
> (If i leave out the md5, and use the "trust" then I can access the db
> without a passwd, but that's not what I need.)
By doing it that way, though, you could access the database and ALTER
USER to set the password correctly. It must not
On 30.05.2007 14:28, [EMAIL PROTECTED] wrote:
Other than the fact that no space may need to be reclaimed is anyone
aware of any circumstance - e.g. use of numeric data types - where a
full vacuum will simply not reclaim space?
- Idle transactions
- It doesn't heal index bloat, which might eat q
Paolo Bizzarri wrote:
my name is Paolo Bizzarri and I am a developer of PAFlow, an document
tracking and management system for public administrations.
We use postgres as a backend, and we are experimenting some corruption
problems on openoffice files.
As our application is rather complex (it in
On 5/30/07, Matthew T. O'Connor <[EMAIL PROTECTED]> wrote:
Paolo Bizzarri wrote:
> my name is Paolo Bizzarri and I am a developer of PAFlow, an document
> tracking and management system for public administrations.
>
> We use postgres as a backend, and we are experimenting some corruption
> proble
1. Please don't forget to cc: the list
2. Please don't top-quote
Bhavana.Rakesh wrote:
Does this mean the pg_hba.conf file has to be edited everytime a new
database/schema is created?
No, only when you want to change network access permissions for the
installation as a whole. See the manuals
Hello,
On Wed, 2007-05-30 at 07:36 -0400, Bhavana.Rakesh wrote:
> Here is my pg_.conf file
Uncomment this line:
#hostall all 127.0.0.1 255.255.255.255
trust
and reload PostgreSQL. And make sure that you read this part of the
manual:
http://www.postgresql.org/docs/c
Bhavana.Rakesh wrote:
Hi,
I'm a newbee to postgreSQL. Does anyone know what this error means.
Couldn't connect: print out a stack trace and exit.
org.postgresql.util.PSQLException: A connection error has occurred:
org.postgres ql.util.PSQLException:
FATA
Hi,
I'm a newbee to postgreSQL. Does anyone know what this error means.
I'm trying to run the following java program. I have also included the
java program and the pg_hba.conf file.
java db_connect_pgsql.class
Checking if Driver is registered with DriverManager
Registered the driver ok,
Hi everyone,
my name is Paolo Bizzarri and I am a developer of PAFlow, an document
tracking and management system for public administrations.
We use postgres as a backend, and we are experimenting some corruption
problems on openoffice files.
As our application is rather complex (it includes Zo
De : mailto:[EMAIL PROTECTED]
> Cyril VELTER wrote:
> > OK, I've the results of my tests :
> >
> > With the previous code, then message "SOCKERROR" is printed 5 times
> > during
the
> > whole process (100 Gb dump import with psql). There one group of three and
one
> > group of two, b
Paolo Bizzarri,
I am also using postgresql in my application and also facing file object
corruption problem.
I already discussed several times with Richard Huxton, and ended without any
clue.
Here I am briefing my problem, see if u find any clue about it.
I am storing/retrieving my file in post
Paolo Bizzarri wrote:
On 5/30/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
Paolo Bizzarri wrote:
> We use postgres as a backend, and we are experimenting some corruption
> problems on openoffice files.
1. How are you storing these files?
Files are stored as large objects. They are written wi
On 5/30/07, Richard Huxton <[EMAIL PROTECTED]> wrote:
Paolo Bizzarri wrote:
> We use postgres as a backend, and we are experimenting some corruption
> problems on openoffice files.
1. How are you storing these files?
Files are stored as large objects. They are written with an lo_write
and its
Paolo Bizzarri wrote:
We use postgres as a backend, and we are experimenting some corruption
problems on openoffice files.
1. How are you storing these files?
2. What is the nature of the corruption?
As our application is rather complex (it includes Zope as an
application server, OpenOffice a
Hi everyone,
my name is Paolo Bizzarri and I am a developer of PAFlow, an document
tracking and management system for public administrations.
We use postgres as a backend, and we are experimenting some corruption
problems on openoffice files.
As our application is rather complex (it includes Zo
ERROR: data type real[] has no default operator class for access method
"gist"
HINT: You must specify an operator class for the index or define a
default operator class for the data type.
There is operator class for GIN for real[].
http://www.postgresql.org/docs/8.2/static/xindex.html#XINDEX-G
On 05/29/07 17:46, Michael Glaesemann wrote:
On May 29, 2007, at 15:28 , John D. Burger wrote:
Even ISO country codes are not guaranteed to be stable
I'm not sure where the idea that primary keys must be stable comes from.
There's nothing necessarily wrong with updating a primary key. All a
On 05/30/07 01:38, Albe Laurenz wrote:
Ron Johnson wrote:
Does PG set up buffers at the postmaster level or the database level?
If at the database level, then you'll be allocating memory to
databases that might not be in use at any one time, thus wasting it.
One database buffer pool would m
93 matches
Mail list logo
