In a thread on advocacy there was talk about the challenges on some
rather strict borders.
There are reasons, why it may be advised to hide or "store away" data.
Customer Information on Laptops. i.E.
and ... PostgreSQL data is open accessable as soon as somebody has
physical access to the hard dr
On Wed, Apr 23, 2008 at 05:51:48PM -0400, Robert Treat wrote:
> > Add
> >
> > hermaphrodite
> > transgender with female phenotype
> > transgender with male phenotype
> >
> > and you should be set from current medical science's point
> > of view ;-)
> >
>
> The standard is unknown, male, female
On Wed, Apr 23, 2008 at 05:18:12PM -0600, Scott Marlowe wrote:
> > hermaphrodite
> > transgender with female phenotype
> > transgender with male phenotype
> the most common and easiest is intersex.
The political correctness of any one term changes over time.
The above list should close the
On Wed, Apr 23, 2008 at 07:46:07PM -0400, brian wrote:
>> I would put it that gender is not so easily defined, which makes it a
>> poor choice for enum.
>
> Absolutely true. Which is odd, because this example is trotted out
> whenever there's a thread about ENUMs.
So it's good we got it in the
On Thu, Apr 24, 2008 at 10:25:44AM +0200, Andreas 'ads' Scherbaum wrote:
> If you define a medical database, you have to extend the ENUM values a
> bit, but even then you know the possible values in advance
Considering scary genetic experiments I wouldn't even be
sure about that.
> It all depend
Richard Huxton napsal(a):
I think someone is looking at per-database locales for 8.4 - the issue
is more tricky than you might think because you need to worry about
system catalogue sort-order.
There is Google Soc project for implementing collation per database level. I
hope it will appear
On 24/apr/08, at 22:15, Matthew T. O'Connor wrote:
Bruce Momjian wrote:
Matthew T. O'Connor wrote:
D. Dante Lorenso wrote:
Or, here's another way to look at it ... make it easier to
modify ENUM datatypes because we all know that you will
eventually need that feature whether you males, fema
D. Dante Lorenso wrote:
Alvaro Herrera wrote:
D. Dante Lorenso wrote:
Or, here's another way to look at it ... make it easier to modify
ENUM datatypes because we all know that you will eventually need
that feature whether you males, females, and unknowns think so or not.
Agreed. Let's keep
Hi all,
I'm in the process of writing a backup script which only dumps those tables which were changed in the last 24 hours. We
have hundreds of tables (one per user), but most of them don't get changed very often, so there's no point in dumping
them every night.
Is there a way to get the tim
I had a problem with a database yesterday on a Windows server. The
service was described as executing "C:\Program
Files\PostgreSQL\8.3\bin\pg_ctl.exe" runservice -w -N "pgsql-8.3" -D
"E:\PostgreSQL\data\". I also had an old backup of the data directory
from 8.2. It was located on E:\PostgreSQL\d
On Fri, Apr 25, 2008 at 02:14:17PM +0200, Aleksander Kmetec - INTERA wrote:
> Is there a way to get the time of the last insert, update or delete
> statement for a specific table?
Only if you put a trigger on each table to collect that information.
A
--
Sent via pgsql-general mailing list (pg
Aleksander Kmetec - INTERA wrote:
Hi all,
I'm in the process of writing a backup script which only dumps those
tables which were changed in the last 24 hours. We have hundreds of
tables (one per user), but most of them don't get changed very often, so
there's no point in dumping them every ni
2008/4/25 Aleksander Kmetec - INTERA <[EMAIL PROTECTED]>:
> Is there a way to get the time of the last insert, update or delete
> statement for a specific table?
You can check the time stamp of the file corresponding the table
after checkpoint. The relationship between the table name and
the file
On Apr 25, 2008, at 4:49 AM, Giorgio Valoti wrote:
And reorder them, too.
Why would you want to reorder an enum? It seems to me the point of
them is to hold a small list of valid values. The order the list is
described in surely should be irrelevant?
--
Sent via pgsql-general mailing l
Hi All,
I've some question about the new full text search capability. Is it a way to
have wildcard (or smth like) in the query ?
Or do we have to add dictionaries ? If yes what kind (for english for
example) ?
TY
Best.
andy
On Apr 25, 2008, at 8:19 AM, Ben Chobot wrote:
On Apr 25, 2008, at 4:49 AM, Giorgio Valoti wrote:
And reorder them, too.
Why would you want to reorder an enum? It seems to me the point of
them is to hold a small list of valid values. The order the list is
described in surely should be
Hello,
A simple query is executing much slower than expected. When looking at
the query plan, I see a bitmap index scan on a partial index that does
not have any associated index condition. How could that happen?
The query is:
select id from test_run_results where test_run_id = 12902 and status
"Jimmy Choi" <[EMAIL PROTECTED]> writes:
> A simple query is executing much slower than expected. When looking at
> the query plan, I see a bitmap index scan on a partial index that does
> not have any associated index condition. How could that happen?
Easily --- it thinks that the partial index p
Thanks. I'm not really in a position to upgrade at the moment. I guess
in the short-term I'll tweak the query to work around this (e.g.
removing "status = 3" or adding more refining conditions both seem to
work).
Please let me know if there are configuration settings I should try.
Thanks,
Jimmy
On Fri, Apr 25, 2008 at 12:29:48PM -0400, Jimmy Choi wrote:
> Thanks. I'm not really in a position to upgrade at the moment.
You know that an upgrade of 8.1 to the latest is not a dump and restore, and
that running an older stability-and-security release of the software is
probably more dangerous
"Jimmy Choi" <[EMAIL PROTECTED]> writes:
> Thanks. I'm not really in a position to upgrade at the moment.
Why not? A minor version update doesn't take much more than stop the
server, install new binaries, start the server.
regards, tom lane
--
Sent via pgsql-general mai
On Fri, 25 Apr 2008, andy petrella wrote:
Hi All,
I've some question about the new full text search capability. Is it a way to
have wildcard (or smth like) in the query ?
in 8.4 text search will support prefix search and operation
LIKE '%asd%' will have index support.
Or do we have to add d
Indeed, I will endeavour to limit the length of my replies, although my
extemporaneous nature, while ranting, will invariably result in prolonged
discourse on my part . I am also grateful for your willingness to assist and
saddened that you are ill. I do hope you recovery quickly.
The example I pr
On Fri, Apr 25, 2008 at 6:56 PM, Oleg Bartunov <[EMAIL PROTECTED]> wrote:
> On Fri, 25 Apr 2008, andy petrella wrote:
>
> Hi All,
> >
> > I've some question about the new full text search capability. Is it a
> > way to
> > have wildcard (or smth like) in the query ?
> >
>
> in 8.4 text search wil
Rhys Stewart wrote:
The example I provided earlier was a very simplified model of the table
I'm working with after a self join. The table in question contains
geographic data (linestrings)
PostGIS LINESTRINGs?
> and I have written a function to return a
textual representation
Like ST_AsEWK
Tino Wildenhain wrote:
D. Dante Lorenso wrote:
Alvaro Herrera wrote:
D. Dante Lorenso wrote:
Or, here's another way to look at it ... make it easier to modify
ENUM datatypes because we all know that you will eventually need
that feature whether you males, females, and unknowns think so or n
Yes, PostGIS LINESTRINGS, no not ST_AsEWKT(). By similar configuration I
mean shape. So I can identify two lines if they have a similar shape. No not
ST_Distance()and don't call me Shirley.
I also neglected to include the query in my previous post.
SELECT a.id,b.id FROM subsumed_secondary a
I
On Thu, Apr 24, 2008 at 3:01 PM, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> Merlin Moncure wrote:
> > I think you're being a little too hard on enums here. I was actually
> > in the anti-enum camp until it was demonstrated to me (and in my own
> > testing) that using enum for natural ordering vs
28 matches
Mail list logo
