Tonko Racic <[EMAIL PROTECTED]> writes:
> I have a problem with local host resolving.
> LOG: could not resolve "localhost": host nor service provided, or
> not known
> I am running HP-UX 11.23 and have installed postgresql 8.1.3
Googling suggests that that's HPUX's spelling of EAI_NONAME, imply
"Angva" <[EMAIL PROTECTED]> wrote:
>
> > clustering also removes the dead tuples.
>
> I have a followup question. What if the set of dead tuples is too big
> and I need to VACUUM FULL, as opposed to VACUUM. (The update size
> varies greatly from day to day.) Will the clustering effectively do a
>
Luca Ferrari <[EMAIL PROTECTED]> writes:
> excuse me for this trivial question, but here's my doubt:
> create table person(varchar id, varchar surname, varchar name)
> with id primary key. Now, the query:
> select * from person order by surname,name
> provide me an explaination that is sequential s
Luca Ferrari <[EMAIL PROTECTED]> wrote:
>
> Hi all,
> excuse me for this trivial question, but here's my doubt:
> create table person(varchar id, varchar surname, varchar name)
> with id primary key. Now, the query:
> select * from person order by surname,name
> provide me an explaination that is s
[EMAIL PROTECTED] writes:
> I really like TOAD for building Oracle queries. Is there a TOAD-like,
> FOSS query builder for PostgreSQL?
A little googling suggests that TOAD works fine with Postgres ...
why don't you just use it, if that's what you're used to?
regards, tom l
Hi there,
I have a problem with local host resolving.
LOG: could not resolve "localhost": host nor service provided, or
not known
LOG: disabling statistics collector for lack of working socket
LOG: database system was shut down at 2006-12-08 14:15:00 MET
LOG: checkpoint record is at 1/43D7
I really like TOAD for building Oracle queries. Is there a TOAD-like,
FOSS query builder for PostgreSQL?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
In article <[EMAIL PROTECTED]>,
wheel <[EMAIL PROTECTED]> wrote:
% I copied all of the database 'parts' to the new 'base' directory. I am
% not sure how carefully anyone has read what I wrote. But it's so simple
% what I'm asking about, or so it would seem to me.
As several people have pointed
Thank you very much, Alan and Martijn, for the advice!
Mark
Martijn van Oosterhout wrote:
> On Thu, Dec 07, 2006 at 02:52:11PM -0800, Alan Hodgson wrote:
> > On Thursday 07 December 2006 08:38, "Angva" <[EMAIL PROTECTED]> wrote:
> > > three commands. For instance I have a hunch that creating the
> clustering also removes the dead tuples.
I have a followup question. What if the set of dead tuples is too big
and I need to VACUUM FULL, as opposed to VACUUM. (The update size
varies greatly from day to day.) Will the clustering effectively do a
VACUUM FULL, or just a VACUUM?
Thanks again for
Hi all,
excuse me for this trivial question, but here's my doubt:
create table person(varchar id, varchar surname, varchar name)
with id primary key. Now, the query:
select * from person order by surname,name
provide me an explaination that is sequential scan + sort, as I expected.
After that I bu
Martijn van Oosterhout writes:
> One issue would be that even disabled indexes would need to be updated
> when there are new rows. If you don't update the index when it's
> disabled, then re-enabling will essentially need to rebuild the index.
I assume that's what he wants. However, it's not imm
On Fri, 2006-12-08 at 16:23 -0600, Scott Marlowe wrote:
> > To be fair, he was running the cluster on a 100Mbps network. Depending
> > on his setup, that may have been his bottleneck. However, there's a good
> > chance that's not his only problem. Especially if he's so sold on MySQL
> > Cluster tha
Are there any negatives to not specifying the length variable of a
character varying data type?
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
IMHO you need at least five values:
Male
Female
Unknown (aka NULL)
Not Available
Not Applicable
BTW, my wife's grandfather's given name was "Pearl".
A few years ago I taught a lesson to a group of about 30 third grade
students. There were 6 students in that class with a first name pronounced
l
Madison Kelly <[EMAIL PROTECTED]> writes:
> Some people argue that gender is a spectrum. If you want to be very
> inclusive. Maybe you could use a 'float' and stick with 0 = woman, 1 = man
> (self documenting after all) with the option of '0.1 - 0.9' for people who
> feel "in between". How efficie
While this thread is tangentially interesting, due to the magic of
relational relationships, the point is really moot. If you are really
worried about various gender states in the future, just create a
table called "gender" and reference it and update it as necessary- done.
-M
On Fri, Dec 08, 2006 at 04:15:10PM -0600, Ron Johnson wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> On 12/08/06 14:40, Richard Troy wrote:
> >
> >
> >
> [snip]
> > 0 = unknown
> > 1 = male
> > 2 = female
> > 3 =
> > 4 = female to male transgender
> > 5 = male to female transgende
On Fri, 2006-12-08 at 16:08, Erik Jones wrote:
> Scott Marlowe wrote:
> > On Fri, 2006-12-08 at 15:44, Erik Jones wrote:
> >
> >> Scott Marlowe wrote:
> >>
SNIP
> >>> Guess he's never heard of pgpool, slony, mammoth replicator, cjdbc, or a
> >>> half dozen other ways to get high reliabili
Jeff Davis wrote:
On Fri, 2006-12-08 at 22:04 +0100, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free "database" in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
On Fri, 2006-12-08 at 16:13, Jeff Davis wrote:
> On Fri, 2006-12-08 at 22:04 +0100, Mikael Carneholm wrote:
> > This link adds to the joy...
> >
> > http://forums.mysql.com/read.php?25,93181,93181
> >
> > So the most popular free "database" in the world is a lousy performing
> > product that acce
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 14:40, Richard Troy wrote:
>
>
>
[snip]
> 0 = unknown
> 1 = male
> 2 = female
> 3 =
> 4 = female to male transgender
> 5 = male to female transgender
> 6 =
> 7 = hermaphrodite
> 8 = declined to state
> 9 = Neuter - Not applicable
>
> Hm
On Fri, 2006-12-08 at 22:04 +0100, Mikael Carneholm wrote:
> This link adds to the joy...
>
> http://forums.mysql.com/read.php?25,93181,93181
>
> So the most popular free "database" in the world is a lousy performing
> product that accepts 'gabba gabba hey' as a valid timestamp. Someone
> please,
Martijn van Oosterhout wrote:
On Fri, Dec 08, 2006 at 12:49:30PM -0800, Glen Parker wrote:
I'd like to see a general way to take indexes off line without actually
losing their definitions. For example, something like "ALTER TABLE [EN
| DIS] ABLE INDEXES", "ALTER INDEX [EN | DIS] ABLE", etc. T
Scott Marlowe wrote:
On Fri, 2006-12-08 at 15:44, Erik Jones wrote:
Scott Marlowe wrote:
On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free "database" in the world is a l
On Fri, Dec 08, 2006 at 12:49:30PM -0800, Glen Parker wrote:
> I'd like to see a general way to take indexes off line without actually
> losing their definitions. For example, something like "ALTER TABLE [EN
> | DIS] ABLE INDEXES", "ALTER INDEX [EN | DIS] ABLE", etc. This could
> also be used
Steve Crawford wrote:
Richard Troy wrote:
On Fri, 8 Dec 2006, Raymond O'Donnell wrote:
Yes, the table is used only for humans; it's part of some
administrative software I'm writing for an educational institution,
and the primary purpose of the gender column is to help the users
cope wit
On Fri, 2006-12-08 at 15:44, Erik Jones wrote:
> Scott Marlowe wrote:
> > On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
> >
> >> This link adds to the joy...
> >>
> >> http://forums.mysql.com/read.php?25,93181,93181
> >>
> >> So the most popular free "database" in the world is a lousy per
Scott Marlowe wrote:
On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free "database" in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
Richard Troy wrote:
>
>
> On Fri, 8 Dec 2006, Raymond O'Donnell wrote:
>> Yes, the table is used only for humans; it's part of some
>> administrative software I'm writing for an educational institution,
>> and the primary purpose of the gender column is to help the users
>> cope with a problem ne
On Fri, 2006-12-08 at 15:04, Mikael Carneholm wrote:
> This link adds to the joy...
>
> http://forums.mysql.com/read.php?25,93181,93181
>
> So the most popular free "database" in the world is a lousy performing
> product that accepts 'gabba gabba hey' as a valid timestamp. Someone
> please, give
This link adds to the joy...
http://forums.mysql.com/read.php?25,93181,93181
So the most popular free "database" in the world is a lousy performing
product that accepts 'gabba gabba hey' as a valid timestamp. Someone
please, give me a reason not to get cynical...
> -Original Message-
>
Hi all,
Since PITR works well, my use of pg_dump has shifted. Rather than using
it as a backup tool, I now use it as a snapshotting tool. At the end of
each month we do an ASCII dump to keep around, so if we ever need to,
we can see the data as it was any number of months or years ago. Not
Angva wrote:
Looking for a small bit of advice...
I have a script that updates several tables with large amounts of data.
Before running the updates, it drops all indexes for optimal
performance. When the updates have finished, I run the following
procedure:
recreate the indexes
cluster the tab
Steve Crawford wrote:
Of course this breaks apart when dealing with that very rare syndrome
(name escapes me) where the child appears female at birth but is
actually a male whose male sex-organs descend and appear at puberty
so I
guess we need to add apparent_sex_at_birth.
It turns out ther
> > Male
> > Female
> > Hermaphrodite
>
> This read, "Intersexed"
>
> > Trans (MTF)
> > Trans (FTM)
> > Neuter
> >
> > and... I can't think of a seventh possibility.
>
> "Decline to state"
ISO 5218 takes 22 pages to give us four oddly placed values for male,
female, and two versions of null, "
On 12/8/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote:
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
> > COPY gender (gender_pk, gender) FROM stdin;
> > 0(unknown)
> > 1Male
> > 2Female
> > 3Trans
> > \.
>
>
> Not to take this completely off track, but isn't transgendered n
On 8 Dec 2006 at 12:17, Richard Troy wrote:
> Ray, darest I point out that that's never been possible in English
> anyway? There are dozens if not hundreds of androgenous names - Pat and
> Tracy come immediately to mind, and there are countless others!
You're correct, of course - but this is the
NULL concatenated to anything is NULL. Try this:
UPDATE test SET myint = COALESCE(myint || ARRAY[123], ARRAY[123]) WHERE
id = 1;
Or:
UPDATE test SET myint =
CASE WHEN myint IS NULL THEN ARRAY[123]
ELSE myint || ARRAY[123]
END
WHERE id = 1;
An empty array can be displayed as ARRAY[NUL
On Fri, 8 Dec 2006, Raymond O'Donnell wrote:
>
> Yes, the table is used only for humans; it's part of some
> administrative software I'm writing for an educational institution,
> and the primary purpose of the gender column is to help the users
> cope with a problem new to the west of Ireland -
On 8 Dec 2006 at 11:13, Scott Marlowe wrote:
> Male
> Female
> Hermaphrodite
> Trans (MTF)
> Trans (FTM)
> Neuter
>
> and... I can't think of a seventh possibility.
How about just plain confused??
--Ray.
--
Raymond O'Donnell
Tom Lane wrote:
Edoardo Panfili <[EMAIL PROTECTED]> writes:
I spend many time to explain the bahaviour of the system:
I some occasions the system use another connection to retrieve some
information during the main connection. This explain the hangs but...
why sometimes the system works.
I
On 8 Dec 2006 at 15:12, Jorge Godoy wrote:
> I haven't read the beginning of the thread, but will this table be
> used only for humans? There are animals that are hermafrodites (I hope
Many thanks to all who responded - I had no idea of the monster I was
creating in starting this thread!
Yes,
Isn't that why we have null?
On Fri, 8 Dec 2006, Steve Wampler wrote:
Andreas Kretschmer wrote:
What about with Hermaphroditism?
More seriously - is the gender something you always know? There
are situations in the US where you cannot force someone to divulge
their gender. So you may need
On Fri, Dec 08, 2006 at 11:13:03AM -0600, Scott Marlowe wrote:
> On Fri, 2006-12-08 at 10:44, John Meyer wrote:
> > David Fetter wrote:
> > > On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
> > >> Just wondering.how do list member represent gender when storing
> > >> details
Scott Marlowe wrote:
On Fri, 2006-12-08 at 09:16, Edoardo Panfili wrote:
I have a question regarding a strange behaviour (for me, maybe that this
is desidered feature) of LOCK on tables. I am using postgres 8.2
I have a servlet that uses connection pools.
The servlet do "LOCK table,table2,tabl
On Fri, 2006-12-08 at 09:16, Edoardo Panfili wrote:
> I have a question regarding a strange behaviour (for me, maybe that this
> is desidered feature) of LOCK on tables. I am using postgres 8.2
>
> I have a servlet that uses connection pools.
> The servlet do "LOCK table,table2,table3,table4"
> t
Edoardo Panfili <[EMAIL PROTECTED]> writes:
> I spend many time to explain the bahaviour of the system:
> I some occasions the system use another connection to retrieve some
> information during the main connection. This explain the hangs but...
> why sometimes the system works.
> I do more tes
Tom Lane wrote:
Edoardo Panfili <[EMAIL PROTECTED]> writes:
It seems that if I put some delay between calls to the servlet all goes
well. I can change lock level but ther is something wrong.
Obviously I am doiung something wrong. To unlock the tables is not
sufficient close the Statement and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 12:38, Matthew O'Connor wrote:
> Csaba Nagy wrote:
>> On Fri, 2006-12-08 at 17:39, Bernhard Weisshuhn wrote:
>>> On Fri, Dec 08, 2006 at 05:26:22PM +0100, Harald Armin Massa
>>> <[EMAIL PROTECTED]> wrote:
[snip]
> You know, here in the US n
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 09:40, Leif B. Kristensen wrote:
> On Friday 8. December 2006 16:23, Raymond O'Donnell wrote:
>> Just wondering.how do list member represent gender when storing
>> details of people in a database?
>>
>> I've done it two ways:
>>
>> * A
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 09:31, John Meyer wrote:
> Second method might be better.
Too much heat from declaring "Males are True, Females are False"?
> Of course, you could also do a one chracter gender "M/F" if you want to
> save space.
>
> Raymond O'Donnell wro
Scott Marlowe wrote:
> On Fri, 2006-12-08 at 10:44, John Meyer wrote:
>> David Fetter wrote:
>>> On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
>>> I usually use a tabl
Quick follow up on this, the guy who ran this test retested with a much
newer version of MySQL and sent this message to the DBMail mailing list
today.
Ok, I just did the test on mysql 5.0.27. It took 73 seconds
to deliver the 1000 messages. So, it's a good bit faster
than 4.1.20's 95 seconds, b
Edoardo Panfili <[EMAIL PROTECTED]> writes:
> It seems that if I put some delay between calls to the servlet all goes
> well. I can change lock level but ther is something wrong.
> Obviously I am doiung something wrong. To unlock the tables is not
> sufficient close the Statement and the Connect
Tom Lane wrote:
Edoardo Panfili <[EMAIL PROTECTED]> writes:
I have a servlet that uses connection pools.
The servlet do "LOCK table,table2,table3,table4"
then do some select (I am testing the code, I will put the update in the
future) an then I close instruction and connection.
The first 4 exe
Csaba Nagy wrote:
On Fri, 2006-12-08 at 17:39, Bernhard Weisshuhn wrote:
On Fri, Dec 08, 2006 at 05:26:22PM +0100, Harald Armin Massa <[EMAIL
PROTECTED]> wrote:
Now we just need fast, stable and native replication for " The Girl
That Every Man Secretly Wishes He Was Married To!"
I want repli
Jorge Godoy wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
Yes, but further I don't know of any country that recognizes anything
but Male or Female.
I haven't read the beginning of the thread, but will this table be used only
for humans? There are animals that are hermafrodites (I hope
That not including Genetics,
where and individual could have
multiple X Chromomes individuals
Or be XY - female times those other
6 (or 7).
- Original Message -
From: "brian" <[EMAIL PROTECTED]>
To:
Sent: Friday, December 08, 2006 9:19 AM
Subject: Re: [GENERAL] Male/female
> Scott Marl
I guess in the end it really depends on what the client wants to track
and what they don't. But this does actually have a serious implication,
and that is how do you code for something that is mutable vs. something
that supposedly is or very nearly immutable (i.e. the alphabet).
-
Scott Marlowe wrote:
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use a table called gend
Scott Marlowe wrote:
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
David Fetter wrote:
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I usually use
Joshua D. Drake wrote:
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
COPY gender (gender_pk, gender) FROM stdin;
0(unknown)
1Male
2Female
3Trans
\.
Not to take this completely off track, but isn't transgendered not so
much a gender as it is a process of moving f
On Fri, 2006-12-08 at 11:05, Joshua D. Drake wrote:
> On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
> > > COPY gender (gender_pk, gender) FROM stdin;
> > > 0(unknown)
> > > 1Male
> > > 2Female
> > > 3Trans
> > > \.
> >
> >
> > Not to take this completely off track, but isn'
On Fri, 2006-12-08 at 10:44, John Meyer wrote:
> David Fetter wrote:
> > On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
> >> Just wondering.how do list member represent gender when storing
> >> details of people in a database?
> >
> > I usually use a table called gender whi
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
> Yes, but further I don't know of any country that recognizes anything
> but Male or Female.
I haven't read the beginning of the thread, but will this table be used only
for humans? There are animals that are hermafrodites (I hope I got the
English
Hi
I am trying to restore a pgdump.sql file. i am very much in need of help.
i first went to pgAdmin III and created two database ( postgres and
anuradha)...
properties of anuradha ::
1) owner = ofbiz
2) encoding = 'UTF8'
3)connected ? yes
4) allow connections? yes
Keary Suska wrote:
Thanks to Erik, Jeff, & Richard for their help.
I have a further inheritance question: do child tables inherit the indexes
created on parent columns, or do they need to be specified separately for
each child table? I.e., created via CREATE INDEX.
I assume at least that the im
On Fri, 2006-12-08 at 09:31 -0700, John Meyer wrote:
> > COPY gender (gender_pk, gender) FROM stdin;
> > 0(unknown)
> > 1Male
> > 2Female
> > 3Trans
> > \.
>
>
> Not to take this completely off track, but isn't transgendered not so
> much a gender as it is a process of moving from
Edoardo Panfili <[EMAIL PROTECTED]> writes:
> I have a servlet that uses connection pools.
> The servlet do "LOCK table,table2,table3,table4"
> then do some select (I am testing the code, I will put the update in the
> future) an then I close instruction and connection.
> The first 4 executions of
On Fri, 2006-12-08 at 17:39, Bernhard Weisshuhn wrote:
> On Fri, Dec 08, 2006 at 05:26:22PM +0100, Harald Armin Massa <[EMAIL
> PROTECTED]> wrote:
>
> > Now we just need fast, stable and native replication for " The Girl
> > That Every Man Secretly Wishes He Was Married To!"
>
> I want replicati
Seven genders? Even San Fransisco thinks that's over the top.
David Fetter wrote:
> On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
>> Just wondering.how do list member represent gender when storing
>> details of people in a database?
>
> I usually use a table called gender
Andreas Kretschmer wrote:
> What about with Hermaphroditism?
More seriously - is the gender something you always know? There
are situations in the US where you cannot force someone to divulge
their gender. So you may need an 'unreported' value of some sort.
--
Steve Wampler -- [EMAIL PROTECTE
On Fri, Dec 08, 2006 at 05:26:22PM +0100, Harald Armin Massa <[EMAIL
PROTECTED]> wrote:
> Now we just need fast, stable and native replication for " The Girl
> That Every Man Secretly Wishes He Was Married To!"
I want replication WITH that girl!
Any chance for 8.3?
bkw
--
On Fri, Dec 08, 2006 at 03:23:11PM -, Raymond O'Donnell wrote:
> Just wondering.how do list member represent gender when storing
> details of people in a database?
I usually use a table called gender which has one TEXT column, that
being its primary key. For one client I had, there were s
Marc Evans <[EMAIL PROTECTED]> writes:
> I am trying to make use of table partitions. In doing so I would like to
> use a rule to call a functioning which inserts the data into the proper
> partition.
Basically, you're guaranteeing yourself large amounts of pain by
insisting on using a rule for
> COPY gender (gender_pk, gender) FROM stdin;
> 0(unknown)
> 1Male
> 2Female
> 3Trans
> \.
Not to take this completely off track, but isn't transgendered not so
much a gender as it is a process of moving from one gender to another?
---(end of broadcast)---
> > 0 = woman
> > 1 = man
This gave me my first good laugh of the day... I will never accuse DBAs of not
having a sense of> humor albeit unique!
Richard,
gmail extended my laugh with the sponsored links:
How To Be A woman
How To Be The Girl That Every Man Secretly Wishes He Was Married To!
Re
> > > Just wondering.how do list members represent gender when storing
> > > details of people in a database?
> > >
> > > I've done it two ways:
> > >
> > > * A bool column, with the understanding that true/false represents
> > > one gender or the other.
[snip]
> > We have done it with a in
H.J. Sanders wrote:
>> We have done it with a integer whereby
>>
>> 0 = woman
>> 1 = man
>>
>> also self-documenting :-)
Why not use unicode symbols 0x2640 and 0x2642?
--
Alban Hertroys
[EMAIL PROTECTED]
magproductions b.v.
T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
I have a question regarding a strange behaviour (for me, maybe that this
is desidered feature) of LOCK on tables. I am using postgres 8.2
I have a servlet that uses connection pools.
The servlet do "LOCK table,table2,table3,table4"
then do some select (I am testing the code, I will put the updat
On Friday 8. December 2006 16:23, Raymond O'Donnell wrote:
>Just wondering.how do list member represent gender when storing
>details of people in a database?
>
>I've done it two ways:
>
>* A bool column, with the understanding that true/false represents
>one gender or the other.
>
>* Create a d
Ragnar <[EMAIL PROTECTED]> writes:
> On fös, 2006-12-08 at 10:09 +0100, Alban Hertroys wrote:
>> Andrus wrote:
>>> update t1 set f1=t2.f3 from t1 left join t2 on t1.f2=t2.f4
>>
>> That looks like a self-join on t1 without using an alias for the second
>> instance of t1.
>>
>> I think you meant:
> -Oorspronkelijk bericht-
> Van: H.J. Sanders [mailto:[EMAIL PROTECTED]
> Verzonden: vrijdag 8 december 2006 16:33
> Aan: Raymond O'Donnell
> Onderwerp: RE: [GENERAL] Male/female
>
>
> Hi ray.
>
> We have done it with a integer whereby
>
> 0 = woman
> 1 = man
>
> also self-document
Raymond O'Donnell wrote:
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the understanding that true/false represents
one gender or the other.
* Create a domain, something like:
CREATE DOMAIN g
Raymond O'Donnell <[EMAIL PROTECTED]> schrieb:
> Just wondering.how do list member represent gender when storing
> details of people in a database?
>
> I've done it two ways:
>
> * A bool column, with the understanding that true/false represents
> one gender or the other.
>
> * Create a d
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 09:23, Raymond O'Donnell wrote:
> Just wondering.how do list member represent gender when storing
> details of people in a database?
>
> I've done it two ways:
>
> * A bool column, with the understanding that true/false represents
>
Second method might be better.
Of course, you could also do a one chracter gender "M/F" if you want to
save space.
Raymond O'Donnell wrote:
> Just wondering.how do list member represent gender when storing
> details of people in a database?
>
> I've done it two ways:
>
> * A bool column, w
Just wondering.how do list member represent gender when storing
details of people in a database?
I've done it two ways:
* A bool column, with the understanding that true/false represents
one gender or the other.
* Create a domain, something like:
CREATE DOMAIN gender_domain
AS character
Bill Moran <[EMAIL PROTECTED]> writes:
> In response to "Stéphane Schildknecht" <[EMAIL PROTECTED]>:
>> pg_dump -U postgres MYDB -N "_MYDB" gives me a dump including that schema.
>>
>> I then tried pg_dump -U postgres MYDB -n "_MYDB" and then got "pg_dump:
>> No matching schemas were found"
> My
Hi -
I am trying to make use of table partitions. In doing so I would like to
use a rule to call a functioning which inserts the data into the proper
partition. To do so, I believe that I need to find a way to opaquely pass
NEW from the rule to a function which then passes it to INSERT. (Well,
On Fri, Dec 08, 2006 at 03:38:49PM +0100, Hannes Dorbath wrote:
> Is there a way I can have notifications to be streamed to the listener,
> so I don't need to poll with LISTEN?
>
> LISTEN foo;
> LISTEN
> NOTIFY foo;
> NOTIFY
> Asynchronous notification "foo" received from server process with PID
Is there a way I can have notifications to be streamed to the listener,
so I don't need to poll with LISTEN?
LISTEN foo;
LISTEN
NOTIFY foo;
NOTIFY
Asynchronous notification "foo" received from server process with PID 3593.
This does work for the same backend, but not for notifications issued
f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 12/08/06 02:36, Thomas Pundt wrote:
> On Friday 08 December 2006 09:16, Ashish Karalkar wrote:
> | Can we have Auto Backup facility to schedule backup of
> | PostgreSQL Database
> | I am using version 8.2.0
>
> why don't you use cron to set up a ba
First, I think the table design is probably not the best way to do this.
In the relational database world, Table 2 probably should look like this:
NODE1 NODE2
NODE1 NODE3
NODE2 NODE4
NODE2 NODE3
Then you could do:
INSERT INTO table1 SELECT DISTINCT column2 FROM table2 WHERE column2 NO
In response to "Stéphane Schildknecht" <[EMAIL PROTECTED]>:
> Hi all,
>
> I tried the knewly introduced feature allowing one to exclude a schema
> from a backup with pg_dump, but I got a
> really strange error :
>
> pg_dump -U postgres MYDB -N "_MYDB" gives me a dump including that schema.
>
>
In article <[EMAIL PROTECTED]>,
Alban Hertroys <[EMAIL PROTECTED]> writes:
> Andrus wrote:
>> In my current DBMS I can use
>>
>> create table t1 ( f1 int, f2 int );
>> create table t2 ( f3 int, f4 int );
>> update t1 set f1=t2.f3 from t1 left join t2 on t1.f2=t2.f4
> That looks like a self-join
On Dec 7, 11:42 pm, [EMAIL PROTECTED] (Tony Caduto)
wrote:
> BigSmoke wrote:
> > On Dec 7, 11:07 pm, [EMAIL PROTECTED] ("Merlin Moncure") wrote:
>
> >> On 7 Dec 2006 14:02:53 -0800, BigSmoke <[EMAIL PROTECTED]> wrote:
>
> >>> I'm facing a particular task for which I need any procedural language
> >
Hello,
On Fri, 2006-12-08 at 11:59 +0100, DANTE Alexandra wrote:
> I am still trying to generate RPM for an IA-64 server with Red Hat
> Enterprise Linux 4 AS and today, I got a question about the
> "postgresql-8.2.0-2PGDG.src.rpm".
We are working off-list with Alexandra and will inform the lis
On 8 Dec 2006 at 18:10, Michael Glaesemann wrote:
> cron pg_dump or pg_dumpall on unix works great. I'm not sure on
> Windows, but I bet there's something.
pgAdmin comes with pgAgent - I haven't used it, but it's a job
scheduler for postgreSQL. Alternatively, use the Windows scheduler
with pg
1 - 100 of 119 matches
Mail list logo
