Can we have Auto Backup facility to schedule backup of
PostgreSQL Database
I am using version 8.2.0
With Regads
Ashish Karalkar
Want to start your own business?
Learn how on Yahoo! Small Business.
http://smal
Can we have Auto Backup facility to schedule backup of
PostgreSQL Database
I am using version 8.2.0
With Regads
Ashish Karalkar
Have a burning question?
Go to www.Answers.yahoo.com and get answers from re
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 backup script?
Ciao,
Thomas
--
Thomas Pundt <[EMAIL PROTECTED]> http://rp-online.de/
-
Yes, setup a cron job using pg_dump utility and in case you need incremental
backups PITR can serve the purpose
Thanks,
Shoaib
On 12/8/06, Thomas Pundt <[EMAIL PROTECTED]> wrote:
On Friday 08 December 2006 09:16, Ashish Karalkar wrote:
| Can we have Auto Backup facility to schedule backup
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 t1 without using an alias for the second
instance of t1.
I think you meant:
upda
[please include a meaningful subject]
On Dec 8, 2006, at 17:10 , Ashish Karalkar wrote:
Can we have Auto Backup facility to schedule backup of
PostgreSQL Database
I am using version 8.2.0
cron pg_dump or pg_dumpall on unix works great. I'm not sure on
Windows, but I bet there's something.
You can use a view for that join query and then create a rule over it to
insert in the referenced tables for the inserts in view.
Thanks,
Shoaib
On 12/8/06, Alban Hertroys <[EMAIL PROTECTED]> wrote:
Andrus wrote:
> In my current DBMS I can use
>
> create table t1 ( f1 int, f2 int );
> create t
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.
I then tried pg_dump -U postgres MYDB -n "_MYDB" and then got "pg_dump:
No matc
On Thu, Dec 07, 2006 at 06:01:13PM +0100, Zoltan Boszormenyi wrote:
> >I have just one more question:
> >How can I get an Oid out of a Datum, i.e.
> >how do I know what type I get in a given Datum?
> >DatumGetObjectId() seems to give me an Oid that
> >was specifically stored as a Datum.
>
> I have
On fös, 2006-12-08 at 10:09 +0100, Alban Hertroys wrote:
> 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 t1 witho
On fös, 2006-12-08 at 10:17 +, Ragnar wrote:
> On fös, 2006-12-08 at 10:09 +0100, Alban Hertroys wrote:
> > 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
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 indexes
> > first (as I do now) could slow down the clustering - perhaps the row
> > locations in
Hello List,
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".
This src.rpm contains :
-rw-r--r-- 1 postgres postgres 12459207 Dec 2 20:25
postgresql-8.2.0.tar.bz2
-rw-r--r-- 1 po
Hi!
error with Subquery alias...
help...
SELECT *,(SELECT COUNT(id)
FROM articles a WHERE a.lft < articles.lft AND a.rgt > articles.rgt) AS depth
FROM articles
where (depth < 3)
ORDER BY lft
Max mailto:[EMAIL PROTECTED]
---(end of broadcast)-
TSearch does change from version to version.
- Create your database with template=template0
- Load tsearch2.sql
- Truncate pg_ts_* tables
- Try to restore
Ignore the already exists errors and examine the rest carefully.
On 08.12.2006 00:11, Rick Schumeyer wrote:
It was my understanding that ru
Sorry, not only load tsearch2.sql. Load your dictionaries as well.
(The SQL-Files generated after Gendict and make in contrib/dict_xx)
On 08.12.2006 12:08, Hannes Dorbath wrote:
TSearch does change from version to version.
- Create your database with template=template0
- Load tsearch2.sql
- Tr
I have two similar datasets, on two diffrent m/cs.
One m/c has PG 8.0.0 installed the other has PG 8.1.5 installed
i vaccum analyzed both and i see that the delete performance in PG 8.1.5 is one
third and sometimes one fifth of PG 8.0.0
please see that the number of rows etc is similar and bo
On Thu, Dec 07, 2006 at 04:44:35PM -0700, [EMAIL PROTECTED] wrote:
> fields. The WHERE clause that I use in SQL Server is:
> getdate() + ((2100 + 5 + (9*Points)) / 86400) >= DueTime
>
> Where the numbers are actually parameters passed in to the function.
> Other than changine getdate() to now(),
On fös, 2006-12-08 at 13:58 +0300, Max Bondaruk wrote:
> Hi!
>
> error with Subquery alias...
> SELECT *,(SELECT COUNT(id)
> FROM articles a WHERE a.lft < articles.lft AND a.rgt > articles.rgt) AS depth
> FROM articles
> where (depth < 3)
> ORDER BY lft
you cannot refer to depth in the where bec
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
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 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
> >
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
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.
>
>
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
-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
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
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
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,
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
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
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
-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
>
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
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
> -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
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:
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
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
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
> > > 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
> > 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
> 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)---
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
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
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
--
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
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
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
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 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
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
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
"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
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
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'
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
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
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
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).
-
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
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
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
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
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
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
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
-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
-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 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
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
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
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
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, 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
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 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,
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 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
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 -
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 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
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
> > 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, "
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
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
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
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-
>
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
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
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
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
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, 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
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
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
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,
-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 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
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
1 - 100 of 119 matches
Mail list logo
