U ... PostgreSQL, inc (http://www.pgsql.com) was around before GB, and
is still around now ...
On Fri, 7 Sep 2001, Micah Yoder wrote:
> On Friday 07 September 2001 08:57, you wrote:
> > This kind of sad news is coming all too frequently
> > now.
>
> Yep. I really thought Great Bridge was o
On Sat, 8 Sep 2001, Vince Vielhaber wrote:
> We can talk to Marc, but we can set it up as 1) someone looking for
> work gets a free listing, 2) a company looking for someone gets a free
> listing, but 3) a headhunter pays $10/listing - or "donates" it to
> postgresql.org or
On Thu, 18 Oct 2001, David Pirotte wrote:
> Allan Engelhardt wrote:
> >
> > Sorry for the offtopic nature, but:
> >
> > 1. Am I the only one who are having problems with the listerver not honouring the
>NOMAIL option?
> > I prefer to read the list on news and am a little annoyed with the vol
The PostgreSQL Core would like to publicly welcome welcome Josh Berkus as
our newest member.
Josh is being included especially as a "liason" between the
source-programmer and non-source-programmer contributors to PostgreSQL, in
an effort to expand PostgreSQL volunteer documentation, advocacy, and
I've just moved some anti-virus/anti-spam checks a bit closer to the
source, and am now rejecting the following before it even gets to the
anti-virus checking, and/or majordomo:
/^Subject: Thank you!/ REJECT
/^Subject: Re: Thank you!/ REJECT
/^Subject: Re: Wicked screensaver/
On Thu, 28 Aug 2003, Alvaro Herrera wrote:
> Fortunately, Cristoph Dalitz's repeated complaints have finally caused
> Marc to reconfigure MHonArc so it won't publish the addresses.
Actually, someone finally providing me with a means to 'mangle' the
addresses c
see http://techdocs.postgresql.org/hosting.php
On Tue, 3 Sep 2003, Aaron wrote:
> Hi,
> Can anyone out there point me to an inexpensive web hosting solution
> that offers postgres database support???
> Thanks
> Aaron
>
>
> ---(end of broadcast)---
I spent this aft enabling debugging on the postmaster side, and determined
that there was a critical index missing on one of the tables ... there was
no index on the url.rec_id field, so a query that looks like:
SELECT rec_id, site_id, pop_rank FROM url WHERE rec_id IN
('31356','31364','32786','3
yes it is/was ...I've just removed it from the list of stop words, but am
not going to force a re-index of 250k URLs ;( So, any new index'ng will
pull in index as a valid search word, and when the current URLs
expire/re-index,they will get pulled in then also ...
On Thu, 4 Sep 2003, Sean Chitt
On Thu, 4 Sep 2003, Sean Chittenden wrote:
> > yes it is/was ...I've just removed it from the list of stop words,
> > but am not going to force a re-index of 250k URLs ;( So, any new
> > index'ng will pull in index as a valid search word, and when the
> > current URLs expire/re-index,they will g
Done ... am regenerating all the archives right now:
# To: jm ( at ) poure ( dot ) com
On Mon, 25 Aug 2003, Christoph Dalitz wrote:
> Hello Marc,
>
> On Wed, 18 Jun 2003 17:30:52 -0300 (ADT)
> The Hermit Hacker <[EMAIL PROTECTED]> wrote:
> >
> > as I've
mid to end October ...
On Wed, 10 Sep 2003, Nigel J. Andrews wrote:
>
> Just wondering what the feeling is regarding when the end of beta might be.
>
>
> --
> Nigel Andrews
>
>
>
> ---(end of broadcast)---
> TIP 7: don't forget to increase your fre
> I haven't had a chance to sit down and do any exhaustive testing yet and
> don't think I will for a while. That said, once 7.4 goes gold, I'm
> going to provide databases/postgresql-devel with a tunable that will
> allow people to choose what block size they would like (4k, 8K, 16K,
> 32K, or 6
On Fri, 12 Sep 2003, Ron Johnson wrote:
> On Fri, 2003-09-12 at 17:48, Joshua D. Drake wrote:
> > Hello,
> >
> > The initdb is not always a bad thing. In reality the idea of just
> > being able to "upgrade" is not a good thing. Just think about the
> > differences between 7.2.3 and 7.3.x... The
On Sat, 13 Sep 2003, Ron Johnson wrote:
> So instead of 1TB of 15K fiber channel disks (and the requisite
> controllers, shelves, RAID overhead, etc), we'd need *two* TB of 15K
> fiber channel disks (and the requisite controllers, shelves, RAID
> overhead, etc) just for the 1 time per year when
> > And that has nothing to do with user need as a whole, since the care
> > level I mentioned is predicated by the developer interest level.
> > While I know, Marc, how the whole project got started (I have read the
> > first posts), and I appreciate that you,
On Tue, 16 Sep 2003, scott.marlowe wrote:
> Not so sure on whether the foot gun is a good idea. We already have .22
> calibre foot gun (fsync) that makes for pretty big improvements in load
> speed, and we see people all the time on General and Performance running
> production servers with it t
that works too ... basically, adding 'security' for a "load nly" mode
shouldn't be to difficult
On Tue, 16 Sep 2003, scott.marlowe wrote:
> On Tue, 16 Sep 2003, Marc G. Fournier wrote:
>
> >
> >
> > On Tue, 16 Sep 2003, scott.marlowe wrote:
&
On Thu, 18 Sep 2003, Lamar Owen wrote:
> > Huh? I have no disagreement that upgrading is a key feature that we are
> > lacking ... but, if there are any *on disk* changes between releases, how
> > do you propose 'in place upgrades'?
>
> RTA. It's been hashed, rehashed, and hashed again. I've a
On Fri, 19 Sep 2003, Tom Lane wrote:
> I think we could definitely adopt a policy of "on-disk changes not
> oftener than every X releases" if we had a working pg_upgrade, even
> without doing any extra work to allow updates. People who didn't want
> to wait for the next incompatible release cou
On Sat, 20 Sep 2003, Ron Johnson wrote:
> On Sat, 2003-09-20 at 11:17, Tom Lane wrote:
> > "Marc G. Fournier" <[EMAIL PROTECTED]> writes:
> > > No, I'm not suggesting no catalog changes ... wait, I might be wording
> > > this wrong ... there are
On Sat, 27 Sep 2003, Ron Johnson wrote:
> Isn't Perl pretty ubiquitous on "Unix" now, though? Except maybe
> Unixware
I know that Solaris now has it included by default ...
---(end of broadcast)---
TIP 8: explain analyze is your friend
On Sat, 27 Sep 2003, Larry Rosenman wrote:
> perl ships on UnixWare (5.005, but that will change in UP3).
In what way? :) It won't ship anymore ... or upgraded?
>
> LER
>
>
> --On Saturday, September 27, 2003 22:42:02 -0300 "Marc G. Fournier"
> <[EMAIL
On Fri, 3 Oct 2003, Relaxin wrote:
> Does this have native Win32 support?
As has been mentioned *several* times already, v7.4 will *not* have Win32
support in it.
>
> ""Marc G. Fournier"" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
>
Well folks, we are now coming into the home stretch of another long
development cycle, and its time for more vigorous and extensive testing
...
Last night, we bundled up Beta4, which is the first one that we've
officially announced "publicly", with the other 3 having been only
announced on -hacke
On Sun, 5 Oct 2003, Tom Lane wrote:
> Peter Eisentraut <[EMAIL PROTECTED]> writes:
> > Jillian Carroll writes:
> >> As your new PostgreSQL "Master of Ceremonies",
>
> > What?
>
> The advocacy group recently put her in charge of lining up Postgres
> speakers and presenters for conventions, local
On Thu, 9 Oct 2003 [EMAIL PROTECTED] wrote:
> Andrew Sullivan <[EMAIL PROTECTED]> writes:
>
> > On Thu, Oct 09, 2003 at 08:52:36AM -0600, scott.marlowe wrote:
> >> Fact: If you write your application to work with ODBC -> MySQL
> >> connectivity, you can write a closed source app and sell it for
Name:svr3.postgresql.org
Address: 200.46.204.161
Aliases: gborg.postgresql.org
On Mon, 13 Oct 2003, Patrick Welche wrote:
> Is something up with gborg cvs, or have the settings changed?
>
> % cvs update
> cvs [update aborted]: connect to gborg.postgresql.org:2401 failed: Connection timed
On Oct 3rd, we released beta4 in the hopes that it would be the final beta
before going into the "Release" phase of development ... due to several
bug fixes over the past 3 weeks, we've decided to release a Beta5 in order
to flesh out any bugs that may have been introduced ...
Beta5 contains seve
I'd say yes based on the SSL and pg_dump fixes that were back patched ...
On Wed, 29 Oct 2003, Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> Yeah, I think we have accumulated enough changes in the 7.3 branch to
> >> justify a 7.3.5, but I'm not sure when we'll
On Fri, 31 Oct 2003, Ryan Mack wrote:
> First, I want to confirm my understanding that the "without fee" clause in
> the PostgreSQL license means that a party may not sell PostgreSQL or works
> derived from the PostgreSQL source code.
Nope, you are free to do with PostgreSQL (or any derived wor
On Tue, 4 Nov 2003, Dennis Gearon wrote:
> do I have to be a major guru or coder to be on the dev list?
Nope, anyone's welcome to join
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Wed, 5 Nov 2003, Chris M. Gamble wrote:
> My company has just finished a simple replication system in java. We are
> now interested in sharing our work under the GPL license so that we can
> hopefully work with others in improving this product.
>
> Would such a thing be useful, or simply over
.did-it.com | Money lost, little lost. |
> | [EMAIL PROTECTED] | Honor lost, much lost.|
> | 516-255-0500 | Courage lost, all lost... |
> +---+---+
>
>
>
> Marc G. Fournier wrote:
>
> >We have just packa
We have just packaged up our second Release Candidate for v7.4, with the
hopes of producing a full release next week.
A full ChangeLog is available at:
ftp://ftp.postgresql.org/pub/sources/v7.4/ChangeLog.RC1.to.RC2
But, one of the highlights is that support for tcl8.0.x has been
re-int
On Mon, 17 Nov 2003, Peter Eisentraut wrote:
> Marc G. Fournier writes:
>
> > After almost 12 months of intense development, and testing, we are proud
> > to announce the availability of PostgreSQL v7.4.
>
> And when will the coordinator learn that it is called &q
egistered thing, but the registration form is quite short ...
---
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---(end of broadcast)---
years, we've finally given in and are
offering both .gz and .bz versions, both through FTP and BitTorrent.
Any questions/problems with release, please report them, as always, to
[EMAIL PROTECTED]
Marc G. Fournier
Coordinator
PostgreSQL Global Development Group
---(e
On Mon, 17 Nov 2003 [EMAIL PROTECTED] wrote:
> Interesting, I see the difference between "PostgreSQL v7.4 Released" and
> "PostgreSQL 7.4 Released".
And, until Peter pointed it out to you, did you notice the difference?
---(end of broadcast)---
T
On Tue, 18 Nov 2003, Peter Eisentraut wrote:
> Marc G. Fournier writes:
>
> > > And when will the coordinator learn that it is called "PostgreSQL 7.4" and
> > > not "PostgreSQL v7.4"?
> >
> > Habit :)
>
> I would appreciate it if you
On Mon, 17 Nov 2003, Joshua D. Drake wrote:
> Here it's just the release announcements that make us look like some kind
>
> >of weirdos. But when you're making tarballs like erserver_v1.2.tar.gz
> >then you're not only making a fool of yourself, you're creating actual
> >technical problems. I ta
On Tue, 18 Nov 2003, Peter Eisentraut wrote:
> Joshua D. Drake writes:
>
> > Somebody please explain to me what the hell a difference it makes if
> > we have a v in front of the version number?
>
> Packaging tools, packaging standards, convention, consistency of public
> presentation.
Packaging h
within a secure, reliable,
> high-performance network ... a Novell NetWare network.
>
>
> ---(end of broadcast)---
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEma
I think that defining forn_id as "serial" is what you are looking for.
This will handle the assignment of unique numbers to the id for you (it creates
a sequence table).
The locking stategy is fraught with danger... and unnecessary.
Marc A. Leith
redboxdata inc.
E-mail:[EMAIL
through Usenet, please send an appropriate
> subscribe-nomail command to [EMAIL PROTECTED] so that your
> message can get through to the mailing list cleanly
>
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: [EMAIL PROTECTED]
IL PROTECTED] so that your
> > message can get through to the mailing list cleanly
> >
> > ---(end of broadcast)---
> > TIP 2: you can get off all lists at once with the unregister command
> > (send "u
e a dump/reload
to put into place.
As always, this release is available on all our mirrors, viable at:
http://www.postgresql.org/mirrors-www.html
And, thanks to David Fetter, is also available via BitTorrent at:
http://bt.postgresql.org
Marc G. Fournier Hub
here are gated to .general, but
if you check out the other newsgroups, you'll find alot more
traffic :)
--
Marc G. Fournier [EMAIL PROTECTED]
Systems Administrator @ hub.org
scrappy@{postgresql|isc}.org ICQ#7615664
On Tue, 10 Oct 2000, Sergio A. Kessler wrote:
> Bruce Momjian <[EMAIL PROTECTED]> el día Tue, 10 Oct 2000 01:06:42
> -0400 (EDT), escribió:
>
> [...]
> >After careful consideration, I have decided to accept a job with Great
> >Bridge. There will be a press announcement tomorrow (Tuesday) with
uge number of data.
>
> przemol
>
>
What version of postgresql are you running? I can't recall whether
it was in 6.2 or 6.1 (I think 6.2), but one of those versions
contained a pg_dump that would seg fault on
PROTECTED]
> Isle of Wight http://www.lfix.co.uk/oliver
>PGP key from public servers; key ID 32B8FAA1
> ====
> "Set your affection on things above, not on things on
> the earth."
remain. Then, when finished, do a ... damn, haven't used this one
yet, so don't remember what the 'command' is...but there is one to do a
RENAME of a table...rename the old to something different, and rename the
new to the old...
Marc G. Fournier
; Ok, now the question is: where?
>
> I add it in Makefile.global, but nothig.
ave you patched in all the v6.3.2 related patches before all this?
I thought we had fixed it post-release...
Marc G. Fournier [EMAIL PROTECTED]
Systems Administrator @ hub.org
scrappy@{postgresql|isc}.org ICQ#7615664
em... IS THERE A WAY AROUND THIS?
Thank you very much because rebuilding several programs with many hundreds of line
code is crazy!!! (I have my finger crossed!)
--
Marc André Paquin, adjoint au chef T. I.
~~~
Centre Canadien d'Architecture | C C A
http://cca.qc.ca
~~~
On Sat, 25 Dec 1999, Clark C. Evans wrote:
>
>
> On Sat, 25 Dec 1999, Bruce Momjian wrote:
> > My big question is, what new challenges will we face as
> > we become more popular?
>
> Plug-in Oracle 7 compatibility.
I know we have (and have for awhile) a good deal of Oracle
compatibility...
On Sun, 26 Dec 1999, Ed Loehr wrote:
> Bruce Momjian wrote:
>
> > We don't have roll-forward logging until 7.1, and require vacuum
> > regularly. Other than that, I don't know of any major issues.
> > Reliability has always been of primary importance. We wouldn't be where
> > we are today wit
> I don't think the *BSD's have intentionally tried any such thing. You
> could possibly have picked up these vibes from certain members of the Open
> BSD camp, but I wouldn't extend them to encompass the *BSD community at
> large. (And I wonder if I should comment about how Linux people are
uld like to remove all databases in postgresql and create everything
again from scratch. Unfortunatlly i can't see the list of databases,
althought i am able to create databse
can you suggest what to do? is it a good idea to reinstall postgresql?
Pau Marc Muñoz Torres
skype: pau_m
was indexing
the database. the problem came when i tried to cancel a \di command
as far as i know nothing changed since the last time i was working last
week.
p
Pau Marc Muñoz Torres
skype: pau_marc
http://www.linkedin.com/in/paumarc
http://www.researchgate.net/profile/Pau_Marc_Torres3/info
index" command
p
Pau Marc Muñoz Torres
skype: pau_marc
http://www.linkedin.com/in/paumarc
http://www.researchgate.net/profile/Pau_Marc_Torres3/info/
2016-06-27 16:21 GMT+02:00 Sterpu Victor :
> You probably have a HDD problem.
> Try a "cat /proc/mounts" and see if part
Hi
I'm moving from mysql to postgresql just now i I'm a bit lost, could anyone
tell me some place with a comparative between postdresql and mysql commands,
i think than mostly is the same think but, any way, do anything change ?
pau
--
Pau Marc Muñoz Torres
Laboratori d
Thanks every body, today i've created my first table with postgresql, what a
mass with \d and sequancial vs auto_increment data type in create...
anyway, i will become an expert soon
;-)
thanks again
pau
2007/11/16, Merlin Moncure <[EMAIL PROTECTED]>:
>
> On Nov 15, 2007 1
Hi
I've written a sql function in a text file, and now, i would like to upload
into postgresql an execute, is there any command to do it? as far as I know
in mysql exist source command, is there something similar in postgresql?
Thanks
--
Pau Marc Muñoz Torres
Laboratori de Bio
something like
Select * from precalc where h2iab>2
but obviously h2iab is not a column...
some of you knows what i should do?
thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E
,p9,'H-2*IAb'));
ERROR: functions in index expression must be marked IMMUTABLE
mhc2db=>
in this indexation p1,p4,p6,p7,p9 are variables that depends on the field.
could anyone help me?
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Bi
something like
Select * from precalc where h2iab>2
but obviously h2iab is not a column...
some of you knows what i should do?
thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E
p6, p7, p9, 'HLA-DRB1*1302'::character
varying))
"hladrb11501" btree (idr(p1, p4, p6, p7, p9, 'HLA-DRB1*1501'::character
varying))
"hladrb40101" btree (idr(p1, p4, p6, p7, p9, 'HLA-DRB4*0101'::character
varying))
"hladrb50101" btree (idr(p1
t if i can't
use idr as an index it eill be to slow
pau
2007/11/29, Richard Huxton < [EMAIL PROTECTED]>:
>
> Pau Marc Munoz Torres wrote:
> > Hi everybody
> >
> > I'm doing a two table query as follow
> >
> > mhc2db=> select t1.sp, t1.pos,t2.p1,
')>2;
or
select * from local where ce='ACIAD';
works perfectely
is it clear enough? i don't now if i make myself understand, any way, if it
not, please, ask me!!
thanks
pau
2007/11/29, Richard Huxton <[EMAIL PROTECTED]>:
>
> Pau Marc Munoz Torres wrote:
>
Hi every body
it is possible to force to postgresql to use a certain index? I know that
in mysql exits Force index (index_name) option for select queries
SELECT * FROM precalc FORCE INDEX (hladrb50101) ;
any of you have used this?
thanks
pau
--
Pau Marc Muñoz Torres
Laboratori de Biologia
Hi every body
it is possible to force to postgresql to use a certain index? I know that
in mysql exits Force index (index_name) option for select queries
SELECT * FROM precalc FORCE INDEX (hladrb50101) ;
any of you have used this?
thanks
pau
--
Pau Marc Muñoz Torres
Laboratori de Biologia
could i use a sentence similar to the mysql sentence
insert if not exist into SP values ('cesp','sp');
in postgresql?
pau
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
Universitat Autonoma
Thanks, i'll test it tomorrow
pau
2007/12/11, Richard Broersma Jr <[EMAIL PROTECTED]>:
>
> --- On Tue, 12/11/07, Pau Marc Munoz Torres <[EMAIL PROTECTED]> wrote:
> > could i use a sentence similar to the mysql sentence
> >
> > insert if not exist int
Hi
I'm an ex-mysql user, i know there was a sentence in mysql that was
load data local infile "somefile.txt" into table "sometable;
I'm trying to do something similar in postgresql, can someone help me?
Thanks
Pau
--
Pau Marc Muñoz Torres
Laboratori
ot; character?
Thanks
Pau
2008/2/4, Dimitri Fontaine <[EMAIL PROTECTED]>:
>
> Hi,
>
> Le lundi 04 février 2008, Pau Marc Munoz Torres a écrit :
> > I'm an ex-mysql user, i know there was a sentence in mysql that was
> >
> > load data local inf
some directory
form default configuration
thanks
pau
--
Pau Marc Muñoz Torrespostgresql.conf
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)postgresql.conf
telèfon: 93 5812807
Email : [
some directory
form default configuration
thanks
pau
--
Pau Marc Muñoz Torrespostgresql.conf
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent
Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)postgresql.conf
telèfon: 93 5812807
Email : [
Ok
it's works !!
thanks
2008/3/10, Craig Ringer <[EMAIL PROTECTED]>:
>
> Pau Marc Munoz Torres wrote:
>
> > Thanks Craig
> >
> > just one more question, most of the variables at
> > /home/postgresql/data/postgresql.conf file are commented (the di
e into the database.
and then when I try to create the language, i get
geldb=# CREATE LANGUAGE plpgsql;
ERROR: language "plpgsql" already exists
anybody knows what's wrong?
Thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i
e into the database.
and then when I try to create the language, i get
geldb=# CREATE LANGUAGE plpgsql;
ERROR: language "plpgsql" already exists
anybody knows what's wrong?
Thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i
ot; btree (idr(p1, p4, p6, p7, p9, 'HLA-DRB1*1301'::character
varying))
"hladrb11302" btree (idr(p1, p4, p6, p7, p9, 'HLA-DRB1*1302'::character
varying))
"hladrb11501" btree (idr(p1, p4, p6, p7, p9, 'HLA-DRB1*1501'::character
varying))
"hladrb40101" btree (idr(p1, p4, p6, p7, p9, 'HLA-DRB4*0101'::character
varying))
"hladrb50101" btree (idr(p1, p4, p6, p7, p9, 'HLA-DRB5*0101'::character
varying))
"iid" btree (id)
"ip1" btree (p1)
"ip4" btree (p4)
"ip6" btree (p6)
"ip7" btree (p7)
"ip9" btree (p9)
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)
telèfon: 93 5812807
Email : [EMAIL PROTECTED]
select into output P1+P4+P6+P7+P9;
return output;
END;
' LANGUAGE plpgsql IMMUTABLE;
and crash at (*), some of you know why?
thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universit
what
configuration file and variables do i have to modify?
Thanks
pau
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)
telèfon: 93 5812807
Email : [EMAIL PROTECTED]
what
configuration file and variables do i have to modify?
Thanks
pau
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
Universitat Autonoma de Barcelona
E-08193 Bellaterra (Barcelona)
telèfon: 93 5812807
Email : [EMAIL PROTECTED]
--
Aggregate (cost=66188.88..66188.89 rows=1 width=0)
-> Bitmap Heap Scan on precalc (cost=17615.20..63522.21 rows=107
width=0)
Recheck Cond: (idr(p1, p4, p6, p7, p9, 'HLA-DRB1*0101'::character
varying) > -2::d
ITER '\ '; DROP...
the problem is thet this script was done by anothey guy, so i cant change
this. by the way it is possible to change somthing at postgresql.conf that
allows use \ as scape?
i found this variable
standard_conforming_strings
but i didn't find it at postgresql.conf
Hi follk
i trying to performe a conditional insert into a table, indeed, what i'm
trying to do is not insert a record into the table if that record exist
googleling i found something like
insert into XX values (1,2,3) where not exist (select );
but i'm having and error near where...
an
' ?
thanks
2011/9/5 Thomas Kellerer
> Pau Marc Muñoz Torres, 05.09.2011 11:38:
>
> Hi follk
>>
>> i trying to performe a conditional insert into a table, indeed, what
>> i'm trying to do is not insert a record into the table if that record exist
>>
Ok , thanks Sim, now i see it
P
2011/9/5 Sim Zacks
> **
> On 09/05/2011 01:37 PM, Pau Marc Muñoz Torres wrote:
>
> i don't see it clear, let me put an example
>
> i got the following table
>
> molec varchar(30)
> seq varchar(100)
>
> where I insert m
index
what can I do?
2008/9/16 Richard Huxton <[EMAIL PROTECTED]>
> Pau Marc Munoz Torres wrote:
> > Hi everybody
> >
> > I have a problem with index, i droped a table before drop their indexs,
> so,
> > now i can't remove the index
>
> That shoul
Hi every body
there is some way to delete or rename an index only if this index exists?
something like
"alter index index rename to pepe if exists"
thanks
--
Pau Marc Muñoz Torres
Laboratori de Biologia Computacional
Institut de Biotecnologia i Biomedicina Vicent Villar
U
thanks
2009/12/22 Filip Rembiałkowski
>
>
> 2009/12/22 Pau Marc Munoz Torres
>
> Hi every body
>>
>
>
>>
>> there is some way to delete or rename an index only if this index exists?
>>
>> something like
>>
>> "alter index ind
[EMAIL PROTECTED] ("Marc G. Fournier") writes:
to usenet works, how about back to mail?
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
[EMAIL PROTECTED] (Jim Seymour) writes:
>Here's another factoid for you. When a new big-8 newsgroup is
>approved, an "official" newsgroup creation control message is sent.
>Well, somebody *forged* just such a control message for one-or-more
>comp.databases.postgresql.* newsgroups.
That was *not*
[EMAIL PROTECTED] ("Gary L. Burnore") writes:
>At 05:28 PM 11/23/2004, Joshua D. Drake wrote:
>>Jim Seymour wrote:
>>>"Gary L. Burnore" <[EMAIL PROTECTED]> wrote:
>>>[snip]
>>>
It's ok. Mysql's better anyway.
>>>
>>>Was that absolutely necessary?
>Of course not.
>>Yes. It shows his lack of
ions, and
>>postgresql, even without pgadmin
>>iii, is far superior in MANY ways to mysql.
>Many, maybe. Not all and certainly not more. Of course, ihat's my OPINION
>and I am quite well informed about databases, thankyouverymuch.
>I'm also well informed about running an NSP a
[EMAIL PROTECTED] ("Gary L. Burnore") writes:
>It appears that his aliiasing hasn't actually taken effect yet. Once it
>does, apparently things will be slightly better because he's then sending
>posts to pgsql.* not comp.databases.postgres.* .As of a short while
>ago, we were still receivin
701 - 797 of 797 matches
Mail list logo
