On Tue, Mar 11, 2008 at 3:31 PM, Dann Corbit [EMAIL PROTECTED] wrote:
-Original Message-
From: [EMAIL PROTECTED] [mailto:pgsql-general-
[EMAIL PROTECTED] On Behalf Of rrahul
Sent: Tuesday, March 11, 2008 6:48 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] postgre
in ~/.bash_profile for postgres
Alex
On Sat, Mar 8, 2008 at 11:01 AM, Douglas McNaught [EMAIL PROTECTED] wrote:
On 3/8/08, Alex Turner [EMAIL PROTECTED] wrote:
Well - I know that my stored proc is segfaulting based on a strace of
postgresql. Don't know how that affects trac which isn't using
On Sat, Mar 8, 2008 at 1:05 PM, Douglas McNaught [EMAIL PROTECTED] wrote:
On 3/8/08, Alex Turner [EMAIL PROTECTED] wrote:
No I'm not. Where would a core file be if there was going to be one?
They should appear in the data directory (e.g. /var/lib/pgsql/data).
Yeah - thats where I
Ah... no I didn't know that - that would explain all the other
behaviour then!! Good to know.
Alex
On Sat, Mar 8, 2008 at 3:03 PM, Tom Lane [EMAIL PROTECTED] wrote:
Alex Turner [EMAIL PROTECTED] writes:
... I found what was going on in that bit and fixed it so
it's not crashing anymore
difference :(
Alex
On Fri, Mar 7, 2008 at 3:00 AM, Richard Huxton [EMAIL PROTECTED] wrote:
Alex Turner wrote:
I had stored procs in C on 8.2 for months, and I moved them over to
8.3 when we upgraded.
And re-compiled them, yes?
The thing is that it's happening on a database
Nothin worth mentioning in /var/log/messages
The wierd thing I do see is there are a number of sockets in
CLOSE_WAIT when doing a netstat -an | grep 5432
I think maybe I'll just reboot and see if that fixes it.
Alex
On Fri, Mar 7, 2008 at 11:47 AM, Richard Huxton [EMAIL PROTECTED] wrote:
Alex
I didn't. And after the reboot, I still see 8 new sockets stuck in
CLOSE_WAIT - I'm wondering if this is a hardware/kernel problem...
Alex
On Fri, Mar 7, 2008 at 11:50 AM, Alex Turner [EMAIL PROTECTED] wrote:
Nothin worth mentioning in /var/log/messages
The wierd thing I do see
should set the
system default up.
Alex
On Fri, Mar 7, 2008 at 2:28 PM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Fri, Mar 7, 2008 at 11:17 AM, Alex Turner [EMAIL PROTECTED] wrote:
I didn't. And after the reboot, I still see 8 new sockets stuck in
CLOSE_WAIT - I'm wondering
at 11:42 PM, Alex Turner [EMAIL PROTECTED] wrote:
Well - I think it might be that some of my servlets weren't closing
their database connections properly.
I do have some new evidence though:
I did an strace of the tomcat processes, and I noticed something that
might be odd, but I'm
I'm getting the back end closing connections early for some reason.
Here is an exception report from my servlet. This first started
happening with my instance of Trac, but now it's happening to my Java
apps too. I hope someone can shed some light on what is going on
here.
Alex
HTTP Status 500
need a core file. I'm guessing I just restart
postgresql from a user whos core file size limit is set to non zero?
Alex
On Thu, Mar 6, 2008 at 3:49 PM, Alex Turner [EMAIL PROTECTED] wrote:
I'm getting the back end closing connections early for some reason.
Here is an exception report from my
Ok - the connection closed thing is happening a lot, but not much is
going into pg_log...
Alex
On Thu, Mar 6, 2008 at 4:03 PM, Douglas McNaught [EMAIL PROTECTED] wrote:
On 3/6/08, Alex Turner [EMAIL PROTECTED] wrote:
Ok - lookint at the pg log, it appears that the server process is seg
Sometimes I'm getting LOG: unexptected EOF on client connection
Alex
On Thu, Mar 6, 2008 at 4:06 PM, Alex Turner [EMAIL PROTECTED] wrote:
Ok - the connection closed thing is happening a lot, but not much is
going into pg_log...
Alex
On Thu, Mar 6, 2008 at 4:03 PM, Douglas McNaught
=trend host=localhost port=51586
but when it fails, I get nothing in the log at all...
ALex
On Thu, Mar 6, 2008 at 4:09 PM, Alex Turner [EMAIL PROTECTED] wrote:
Sometimes I'm getting LOG: unexptected EOF on client connection
Alex
On Thu, Mar 6, 2008 at 4:06 PM, Alex Turner [EMAIL PROTECTED
I did a pg_ctl start from the postgres user... is that gonna work, or
does pg_ctl do an su?
Alex
On Thu, Mar 6, 2008 at 4:34 PM, Tom Lane [EMAIL PROTECTED] wrote:
Alex Turner [EMAIL PROTECTED] writes:
I'm thinking I need a core file.
Yeah.
I'm guessing I just restart
postgresql
Upgrading to Postgres 8.3 broke virtually every site we host, and I
finally figured out why. In 8.2 you could do this:
create table foo (
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
SIGNED MESSAGE-
Hash: SHA1
On Thu, 21 Feb 2008 17:53:35 -0500
Alex Turner [EMAIL PROTECTED] wrote:
Upgrading to Postgres 8.3 broke virtually every site we host, and I
finally figured out why. In 8.2 you could do this:
create table foo (
No that would fail.
Did you
-0500
Alex Turner [EMAIL PROTECTED] wrote:
Yeah - I pressed tab to indent my code, and of course it tabbed to the
next element on the page, which was the send button, then I hit a key,
and it sent the message before I was ready. I tested my hypothesis,
but it was wrong. I haven't quite
PROTECTED] wrote:
On Feb 3, 2008 10:14 PM, Alex Turner [EMAIL PROTECTED] wrote:
Im not a database expert, but wouldn't
create table attribute (
attribute_id int
attribute text
)
create table value (
value_id int
value text
)
create table attribute_value
That is a very awesome system. I am constantly impressed at the
awesomeness of Postgresql.
Alex
On Feb 4, 2008 1:06 PM, Tom Lane [EMAIL PROTECTED] wrote:
Jorge Godoy [EMAIL PROTECTED] writes:
Em Monday 04 February 2008 07:03:47 Dawid Kuroczko escreveu:
Well, but PostgreSQL's NULLs occupy
of keeping products as DB neutral as possible)?
Alex
On Feb 4, 2008 7:09 AM, Scott Marlowe [EMAIL PROTECTED] wrote:
On Feb 3, 2008 10:14 PM, Alex Turner [EMAIL PROTECTED] wrote:
Im not a database expert, but wouldn't
create table attribute (
attribute_id int
attribute text
)
create
Im not a database expert, but wouldn't
create table attribute (
attribute_id int
attribute text
)
create table value (
value_id int
value text
)
create table attribute_value (
entity_id int
attribute_id int
value_id int
)
give you a lot less pages to load than building a table
Frameworks are over-rated. PHP makes most common tasks simple (not that I'm
really a big PHP fan, but it works pretty well most of the time). Just
follow a few basic XSS protection rules, and you will have few problems.
Filter input elements for HTML, don't put stupid things in cookies that can
I love Postgresql to death, it's one of the shining stars of the Open Source
movement IMHO. It's rock solid, crashes less frequently than Oracle in my
experience, and does almost everything I could ask of it (granted - I don't
ask much often, just simple things like consistent behaviour, which
I evaluated Drupal with PostgreSQL, but it wasn't powerful enough, and it's
written in PHP which is buggy, and lots of modules force you to use MySQL
which is not ACID (I'm sorry but inserting 31-Feb-2008 and not throwing an
error by default makes you non-ACID in my book). PostgreSQL support was
If you haven't already, make sure you've done a vacuum full recently. When
in doubt, pg_dump the db, and reload it, and see if that helps, but this
works for me:
create table overview as select _id from t_documentcontent;
alter table overview add constraint overview_pkey primary key (_id);
If you have to access the data this way (with no where clause at all - which
sometimes you do) then I have already provided a solution that will work
reasonably well. If you create what is essentially a materialized view of
just the id field, the sequence scan will return much fewer pages than
to view the next
page.
Alex
On Jan 13, 2008 11:43 PM, Alex Turner [EMAIL PROTECTED] wrote:
If you have to access the data this way (with no where clause at all -
which sometimes you do) then I have already provided a solution that will
work reasonably well. If you create what is essentially
Oh - if you do this then make sure that you have the primary key index on
overview too.
Alex
On Jan 14, 2008 12:53 AM, Alex Turner [EMAIL PROTECTED] wrote:
If you combine it with Tom Lane's suggestion - it will go even better,
something like:
select * from t_documentcontent where _id
what trigers i need to add, and test the insertions.
Thanks again
On Jan 14, 2008 5:54 AM, Alex Turner [EMAIL PROTECTED] wrote:
Here is a table I threw together to demonstrate the approximate speed of
a materialized view in this case:
trend=# explain analyze select property_id from
Why the hell would you buy a 1U chassis in the first place when perfectly
good cheap 4U chassis exists that will take 8 or more drives?
1U motherboards are a pain, 1U power supplies are a pain and 1U space for
drives sucks.
Most tests I've seen these days show that there is very little actual
I get the following error installing the binary RPMS for RedHat es 4:
[EMAIL PROTECTED] postgres]# rpm -Uvh compat-postgresql-libs-4-1PGDG.i386.rpm
error: Failed dependencies:
libc.so.6(GLIBC_2.4) is needed by
compat-postgresql-libs-4-1PGDG.i386
libcrypto.so.6 is needed by
-0500 mailte Alex Turner folgendes: I seem to be having a problem with pg_dump in 8.1.2, it's not dumping indexes at all.Is this a known problem, should I just do an upgrade?
I can't see a necessity to dump a index. But, i hope, and i'm sure, pg_dump dumps the definition for a index...The dump
11/10/06, Joshua D. Drake [EMAIL PROTECTED]
wrote:On Fri, 2006-11-10 at 11:23 -0500, Tom Lane wrote: Alex Turner
[EMAIL PROTECTED] writes: Well yes - thats what I mean, the definition for the index.It's not dumping the index defs.It also looks like it's not dumping roles fully
either.I
I would be happy to point someone to the dump file, it's about 500Meg thoughAlexOn 11/10/06, Alex Turner
[EMAIL PROTECTED] wrote:Sure thing, I hope it's as simple as user error!
#!/bin/shexport DATE=`date +%Y%m%d`/usr/local/pgsql/bin/pg_dump -Upostgres -hlocalhost trend /backup/trend.dump
occurred to me that I didn't have a good backup ;)Alex.On 11/10/06, Andreas Kretschmer
[EMAIL PROTECTED] wrote:
Alex Turner [EMAIL PROTECTED] schrieb: Sure thing, I hope it's as simple as user error! #!/bin/sh export DATE=`date +%Y%m%d` /usr/local/pgsql/bin/pg_dump -Upostgres -hlocalhost trend
I seem to be having a problem with pg_dump in 8.1.2, it's not dumping indexes at all. Is this a known problem, should I just do an upgrade?Thanks,Alex TurnerMint Pixels
Awesome - thank you!AlexOn 10/9/06, Ron Johnson [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-Hash: SHA1On 10/09/06 19:10, Alex Turner wrote: I have a table whose definition is basically create table foo ( a int, b int, c int,
d date ); and when fully populated, select relpages*8192
I have a table whose definition is basicallycreate table foo (a int,b int,c int,d date);and when fully populated, select relpages*8192::long/reltuples from pg_class where relname='foo';
gives around 52. Why is it so wide when there are only 4*4=16 bytes of actual data?The table was populated in
Is relpages always supposed to be right?:select count(*) from result_entry;trend=# select count(*) from result_entry;count---59913(1 row)trend=# select relpages from pg_class where relname='result_entry';
relpages-- 0(1 row)trend=#Alex
http://dev.mysql.com/doc/refman/5.1/en/replication-row-based.html5.1AlexOn 7/10/06,
Jan Wieck [EMAIL PROTECTED] wrote:
On 6/30/2006 11:12 AM, Scott Marlowe wrote: I agree with Tom, nice notes.I noted a few minor issues that seem to derive from a familiarity with MySQL.I'll put my corrections
Of course if you really want good performance, 6 drives is a little light, and U320 is definatley not the way to go as you are limited to 320MB/sec per channel (an the DL380 comes with all drives on one channel) (not that you could saturate that with only 6 drives in RAID 10 anyway). Given that
Please note that your single Fibre Channel card is limiting you to 256MB/sec read speed from your array, which is not enough for a 13 drive RAID 5.First test would be to run a basic bonnie++ benchmark against your drive array and see what kind of throughput you are getting for linear read, linear
Compaq RAID controllers are known to be slow under linux.Alex.On 6/26/06, Tony Caduto [EMAIL PROTECTED]
wrote:Scott Marlowe wrote: On Mon, 2006-06-26 at 08:59, Tony Caduto wrote:
MG wrote: Hello, we are using PostgreSQL 8.0.3 together with RAID on OpenServer 6. When we do a big SELECT-query the
I think you may be a little confused...Last time I checked, Oracle RAC doesn't actualy support clustering the I/O, it's one Database backend with multiple instances on the front-end, which is only clustering the CPU bound part (it's also VERY expensive).
If by clustering you mean multiple seperate
Just a quick thought - I know that I don't fully understand tables with oids, and table without oids, is there a link to some more information about why you need oids, or why you don't that I could reference as I'm a bit lost on the subject of oids
Alex.On 6/12/06, Tom Lane [EMAIL PROTECTED]
I suspect that my manualy vacuum every 10 days or so really wasn't nearly enough ;)AlexOn 6/9/06, Jim C. Nasby
[EMAIL PROTECTED] wrote:This tells me that you need to be vacuuming more. Autovac is your
friend.On Thu, Jun 08, 2006 at 07:14:01PM -0400, Alex Turner wrote: Yeah - I just did a reindex
I hope I'm reading this query wrong:trend=# select relname, relpages*8192/reltuples from pg_class where reltuples0 order by relpages desc limit 10; relname | ?column?---+--
property | 19935.4468376195result_entry_pkey | 1611.15654062026result_entry |
Yeah - I just did a reindex, that fixed the indexes at least.AlexOn 6/8/06, Jim C. Nasby [EMAIL PROTECTED]
wrote:On Thu, Jun 08, 2006 at 06:03:23PM -0400, Alex Turner wrote: I hope I'm reading this query wrong:
trend=# select relname, relpages*8192/reltuples from pg_class where reltuples0 order
could you just add the postgres user to the apache group?AlexOn 6/5/06, Tony Caduto [EMAIL PROTECTED]
wrote:Just wondering if anyone has done this:Change the user the DB runs under from postgres to apache on a
established server?I would think I would just change ownership on all the data dir
Maximum througput of a single drive is around 80MB/second, a 300MB/sec interface won't change that.AlexOn 6/1/06, Riccardo Inverni
[EMAIL PROTECTED] wrote:Hi Alex, thanks for the answer (thanks to the other guys too!).
http://www.cdw.com/shop/products/default.aspx?EDC=912784 SATA - ~$320
Is
SAS and SATA will give you the best throughput for your array total. U320 is limited to 320MB/channel.AlexOn 5/30/06, Scott Marlowe
[EMAIL PROTECTED] wrote:On Tue, 2006-05-30 at 16:28, Riccardo Inverni wrote:
Hi guys,I have to update a Linux box with PostgreSQL on it, essentially for data
Compare these two drives:http://www.storagereview.com/php/benchmark/suite_v4.php?typeID=10testbedID=4osID=6raidconfigID=1numDrives=1devID_0=279devID_1=308devCnt=2
Prices:http://www.cdw.com/shop/products/default.aspx?EDC=984588 - SAS - ~$950
http://www.cdw.com/shop/products/default.aspx?EDC=912784
Raid 5 on the 9550SX is supposed to be significantly better than the 9500 series.I would be carefull of benchmarks listed out there. For instance, whilst looking for supporting material, I came cross this gem:
http://www.gamepc.com/labs/print_content.asp?id=9550sx4lpcookie%5Ftest=1
They claim the
I have the time to do it, but not the $$s ;)AlexOn 4/15/06, Francisco Reyes [EMAIL PROTECTED]
wrote:Alex Turner writes: Suggests that the 9550SX is at least competitive with the others.
Thanks for the links. I know I like the 3ware/AMCC cards because of their very good RAID 10 performance.Raid 10
A... good point.Why oh why does tyan have two boards with the same prefix ;)!!!AlexOn 4/15/06, Guy Rouillier
[EMAIL PROTECTED] wrote:Alex Turner wrote: Raid 5 on the 9550SX is supposed to be significantly better than the
9500 series. I would be carefull of benchmarks listed out there.For
create table person (id serial8,name text);AlexOn 4/3/06, Alban Hertroys [EMAIL PROTECTED]
wrote:Ottavio Campana wrote: CREATE TABLE person ( id SERIAL,
name TEXT ); how can I do it with a INT8 instead of a INT4?Do you really expect that sequence to reach over 2 billion? OtherwiseI'd stick with
The solution that I have seen typical is to have both webserver and database machine behind a firewall both NATed, with only HTTP and HTTPS ports open on the webserver. SSH is not open, as trusted clients connect via the VPN in the firewall. The database machine, unlike the webserver, will not
I would suppliment this with just saying that your controller card is
your performance,
the only cards I've seen score well on linux, and people have
expressed on this list for SCSI are the LSI card, for SATA, LSI, 3ware
(now AMCC) and Areca claim good linux support and seem to work well.
Steer
isn't
doing any write transactions at all at this point.
Anyone any idea what might be happening here?
Alex Turner
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
the Jdbc3PoolingDataSource to connection. The code isn't
doing any write transactions at all at this point.
Anyone any idea what might be happening here?
Alex Turner
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ
I think he meant
create sequence test_seq;
select setval('test_seq',(select max(primary_key_id) from my_table));
not max value of a serial type.
Alex
On 11/3/05, Marc Boucher [EMAIL PROTECTED] wrote:
On Wed, 02 Nov 2005 19:29:10 -0800, you wrote:
It's a migration thing - MySQL prevented
On 11/3/05, Hannes Dorbath [EMAIL PROTECTED] wrote:
On 03.11.2005 04:12, Alex Turner wrote:
I would have to say that for security purposes - I would want magic
quotes _on_ rather than off for the whole reasons of SQL Injection
that we already talked about.
magic_quotes is evil and does
My point is that with magic_quotes on in PHP, php already escapes
quotes for you in all inbound variables. This makes the process
automatic, and therefore fool proof, which is kinda the whole point.
You want a mechanism that there isn't an easy way around, like
forgetting to db_quote once in a
Curiously none are security reasons, they are more portability reasons
(and pretty thin ones at that)... but then this is PHP we are talking
about - let me just say register_globals and end it there.
I would have to say that for security purposes - I would want magic
quotes _on_ rather than off
I assume they are probably thinking of a free for non-commercial use,
which is great and all, but I assume that like the majority of folks
here, I am using postgres very much for commercial use, and not just
to run my personal website! So I would say it's not a big deal,
infact it's not even a
I don't know too much about this solutions, but It always seemed to me
that simple numeric validation plus magic-quotes will work just fine.
Simply validate any numeric input (or you can just quote it with
postgresql, and postgres will do it for you), and auto-escape any
string inputs
Can you demonstrate a URL/attack that would constitute an injection
attack that would get around magic-quotes, or provide some links to
such?
Alex
On 10/31/05, MaXX [EMAIL PROTECTED] wrote:
Hi,
Yonatan Ben-Nes wrote:
Hi all,
I'm currently trying to build a defence against SQL INJECTION,
I didn't think query plans were cached between sessions, in which case
prepeared statements aren't worth much for most HTTP based systems
(not counting luckily re-using the same connection using pgpool)...
Please correct me if I'm mistaken - I like being wrong ;)
Alex
On 10/31/05, Jim C. Nasby
Of course not counting the Western Digital Raptor SATA drive, which
are priced more like SCSI drives also, and have many of the features
of a SCSI drive including NCQ
Alex
On 10/28/05, Bruce Momjian pgman@candle.pha.pa.us wrote:
Andrus wrote:
QUANTUM FIREPALLP LM20.5 is a widely used ATA IDE
I have read it before - it's a _fantastic_ resource, and I will
probably make every junior tech I ever hire read it too.
On 10/28/05, Bruce Momjian pgman@candle.pha.pa.us wrote:
Alex Turner wrote:
Of course not counting the Western Digital Raptor SATA drive, which
are priced more like SCSI
As sort of a side discussion - I have postulated that quoting all
incomming numbers as string would be an effective defense against SQL
Injection style attacks, as magic quotes would destory any end-quote
type syntax:
in_value=1
select * from table where my_id='$in_value';
as an example for PHP
Beleive me, when you get data feeds with bad data and you have to do
each insert as an xact because copy will just dump out, you can hit
1bil really fast.
AlexOn 10/24/05, Martijn van Oosterhout kleptog@svana.org wrote:
On Mon, Oct 24, 2005 at 11:25:00AM -0600, Michael Fuhr wrote: PostgreSQL 8.1
On 24 Oct 2005 22:00:55 +0200, Harald Fuchs [EMAIL PROTECTED] wrote:
In article [EMAIL PROTECTED],Alex Turner [EMAIL PROTECTED]
writes: 1.( ) text/plain(*) text/html As sort of a side discussion - I have postulated that quoting all incomming numbers as string would be an effective defense against
I would ask you to ask the reverse question, why would you use MySQL
when it still doesn't contain all the features of postgresql, has a bad
query optimizer, a poor track record on scalability and will silenty
truncate/accept invalid data, invalidating ACID, not only that you have
to pay for it.
I believe based on semi-recent posts that MIN and MAX are now treated
as special cases in 8.1, and are synonymous with select id order by id
desc limit 1 etc..
Alex
On 10/24/05, Douglas McNaught [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] writes:
However, in the process of investigating this,
with much.
Alex Turner
NetEconomist
On 10/20/05, Marc G. Fournier [EMAIL PROTECTED] wrote:
On Thu, 20 Oct 2005, Doug Quale wrote: Guy Rouillier [EMAIL PROTECTED] writes: Doug Quale wrote: # select 'a'::char(8) = 'a '::char(8);
?column? --t (1 row) Trailing blanks aren't significant in fixed-length
snip
multi-master.It provides a certain amount of scaling, but nothingI've seen or heard suggests that the license cost couldn't just as
easily and effectively be thrown at larger hardware for betterscaling.The really big reason to use RAC is five-nines situations:you're trying to make sure that
so that they can actualy _scale_ when a business
grows.
AlexOn 10/13/05, Chris Travers [EMAIL PROTECTED] wrote:
Alex Turner wrote: Support for windows 98 was infact extended to June 2006: http://support.microsoft.com/gp/lifean1RightAnd it was extended again last year as it was supposed
clients _want_ me to cross join
it for select purposes, but I'm legaly required to keep it in a
seperate database.
Maybe it's just difference shock - PostgresqlOracle so I'm scared ;), but I don't like dblink very much ;)
snip
Alex Turner
NetEconomist
;).
AlexOn 10/13/05, Tino Wildenhain [EMAIL PROTECTED] wrote:
Am Donnerstag, den 13.10.2005, 13:00 -0400 schrieb Alex Turner:... If I had just one wish for postgresql it would be to support cross-database queries like Oracle.This is a HUGE pain in the ass,
and DBI-Link syntax is clunky as hell. I
, PostgreSQL's schemas and Oracle'sseparate databases are functionally identical, nomenclature aside.
On Thu, 2005-10-13 at 13:58, Alex Turner wrote: I could, but it would breach the terms of our contract.Our contract with the data providers clearly specifies seperate databases ;), so I'm kind of tied
oracle insuch a way as to disable any database to database access / joining.Seems to me the second you can run a query that hits both databases you
might well be in breach of contract, depending on the terminology used.On Thu, 2005-10-13 at 14:44, Alex Turner wrote: Of course, but _legaly_ we would
information/a link to
documentation that clarifies that stuff?
Alex Turner
NetEconomistOn 10/11/05, Gregory Youngblood [EMAIL PROTECTED] wrote:
On Mon, 2005-10-10 at 11:04 -0700, Steve Crawford wrote: Gregory Youngblood [EMAIL PROTECTED] writes: I've been using SuSE and PostgreSQL for a fairly
Compared to MySQL ditching referential integrity because of a typo, I
would consider these 'gotchas' extremely minor, hence the reason I use
Postgresql not MySQL. Postgresql does what you expect from an
RDBMS system out of the box in 99.99% of cases. I don't have to
toggle things on special like,
Sorry.
AlexOn 10/6/05, Gavin M. Roy [EMAIL PROTECTED] wrote:
This sure sounds like a flamewar bait email?On Oct 6, 2005, at 11:07 AM, Aly S.P Dharshi wrote: http://sql-info.de/postgresql/postgres-gotchas.html
Any comments from folks on the list ? Cheers, Aly. -- Aly S.P Dharshi [EMAIL PROTECTED]
Support for windows 98 was infact extended to June 2006:
http://support.microsoft.com/gp/lifean1
AlexOn 10/6/05, Joshua D. Drake [EMAIL PROTECTED] wrote:
On Thu, 2005-10-06 at 21:40 +0300, Andrus wrote: Just so I know (and am armed ;) ), are there any new comparable features in MySQL 5.0 that
wondering if you can avoid the dereference oid
lookup by created the index as keyword,product_id instead of just
keyword.
Alex Turner
NetEconomistOn 9/20/05, Oleg Bartunov oleg@sai.msu.su wrote:
contrib/tsearch2 ( http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/ )might works for you. It might
on an island with a one-shot pistol and the sight
of me sails dissapearing over the horizon!
Alex Turner
NetEconomist
P.S. For those who didn't know - it's national talk like a pirate day.
50 pieces of eight to that man there!!
You are exactly right, the FM prefix is exactly what I'm seeking!
I missed that table right below the main formaing table that describes
the prefixes.
May you find much buried treasure,
Alex Turner
NetEconomistOn 9/19/05, Dianne Yumul [EMAIL PROTECTED
would have expected.
Alex Turner
NetEconomistOn 9/15/05, Tom Lane [EMAIL PROTECTED] wrote:
CSN [EMAIL PROTECTED] writes: Just something I was curious about - is there any difference at all between character varying (in the
SQL spec) without a length specified and text (not in the SQL spec
Add to that they just re-released Sid Meier's Pirates, and I'm a hopeless case mateys.
AlexOn 9/19/05, IanL PostgreSQL Lists [EMAIL PROTECTED] wrote:
Alex Turner wrote: May you find much buried treasure,Somebody PLEASE burn his Privates of the Caribbean DVD!
One might even suggest that this should really be a default for all
tables everywhere, because at some time or another, someone wants to
know when something got put in the database...
Alex.On 6/3/05, Wiebe de Jong [EMAIL PROTECTED] wrote:
The way I do it is to add a timestamp field with a default
True, although a trigger have the benefit of being able to capture the
value before it was changed allowing some measure of versioning in your
data which can be a lifesaver...
Alex Turner
netEconomistOn 6/3/05, Wiebe de Jong [EMAIL PROTECTED] wrote:
I don't use this for all
for a change to be _ahead_ of the
game?
Alex Turner
netEconomistOn 6/3/05, Martijn van Oosterhout kleptog@svana.org wrote:
On 6/3/05, Wiebe de Jong [EMAIL PROTECTED] wrote: The way I do it is to add a timestamp field with a default value of now(). Unfortunately, this won't help with any records
I think simply initialising the system causes writes in the system
tables and the WAL...
I'm sure someone more knowledgeable can chime in.
Alex. Turner
netEconomist
On 5/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Why? Any specific reason that you are aware of ?
Are there any writes
If you simply put your database tables in their own tablespace, then
move that tablespace to a WORM device, I can't see why that wouldn't
work as long as you keep all the system tables etc.. on the regular RW
tablespace
Alex Turner
netEconomist
On 5/11/05, [EMAIL PROTECTED] [EMAIL PROTECTED
can use COM on Windows (= Java), Applescript on the
Mac and lots of open source applications use it as their scripting
language
Consequently, Python alone is likely to get everything done that you
will ever need in your whole life.
[snip]
Alex Turner
netEconomist
the appropriate solution :)
Alex Turner
netEconomist
On 5/10/05, Just Someone [EMAIL PROTECTED] wrote:
Hi,
I'm looking into creating a hosted application with Postgres as the
SQL server. I would like to get some ideas and oppinions about the
different ways to separate the different clients
output to all of the above. Very
excellent tool, but I think it's about $4k/license. Is it worth it?
hell yeah.
Alex Turner
netEconomist
On 5/9/05, Mark Borins [EMAIL PROTECTED] wrote:
Sorry, I should have also specified that we are looking for a tool where we
can save the schema externally
1 - 100 of 138 matches
Mail list logo
