On 23/01/2010 3:31 PM, Grzegorz Jaśkiewicz wrote:
On Fri, Jan 22, 2010 at 7:15 PM, Erik Jonesejo...@engineyard.com wrote:
Hello,
Given that the EU has approved Oracle's acquisition of Sun w/ MySQL it's fairly
likely that there may be a number of people and companies looking to move from
Greg Smith wrote:
My guess is that there's something wrong with your config such that
writes followed by fsync are taking longer than they should. When I
see sync=0.640 s into a SAN where that sync operation should be near
instant, I'd be looking for issues in the ZFS intent log setup, how
You probably need to ask the mxODBC developers (who AFAIK don't hang out
on this list) what they are doing with that data. It sounds fairly
likely to me that the bytea value is just being sent as a string without
any special encoding. That would explain both the null sensitivity you
mention
I am logged in as superuser. I am trying to create something similar to
this:
Code:
CREATE TABLE tbl_unit_convfunctions(
unit_from integer REFERENCES tbl_units (unit_id),
unit_to integer REFERENCES tbl_units (unit_id),
proc_id oid REFERENCES pg_proc (oid)
)but no matter what I refer to from
I havn't been able to find documentation on how to use \d. When I open the
psql interface (through either port ) it asks for a password but doesn't
allow any entry of a password.
However, after my last e-mail to you, I came across something interesting -
at least to me.
I use pg_admin
Hi,
i'm a python/c developer and i need an asynchronous (python) interface to
communicate with a database. I like PostgreSQL so i'm trying to write a
mock-up for a python extension module to use LibPQ in my asynchronous
programs.
I've started to study the docs about libpq just yesterday, so if i
2010/1/23 Craig Ringer cr...@postnewspapers.com.au:
An InnoDB `AUTO_INCREMENT' column under MySQL 5.x is pretty similar to a
sequence.
I increasingly think it's pretty safe to just
's/AUTO_INCREMENT/SERIAL/g'
in DDL. Apps that use MyISAM aren't going to be fussy about how it works,
and
On 23/01/2010 15:51, Bob Pawley wrote:
I havn't been able to find documentation on how to use \d. When I open
Hi Bob,
In brief:
\dt lists all the tables in the current schema
\d tablename gives the structure of the named table
.. and loads of others. The docs are here:
On Fri, 2010-01-22 at 11:15 -0800, Erik Jones wrote:
Does anyone know of any good, current migration tools out there?
There is an open source tool developed by EnterpriseDB: MigrationWizard
On Saturday 23 January 2010 6:15:36 am Davor J. wrote:
I am logged in as superuser. I am trying to create something similar to
this:
Code:
CREATE TABLE tbl_unit_convfunctions(
unit_from integer REFERENCES tbl_units (unit_id),
unit_to integer REFERENCES tbl_units (unit_id),
proc_id oid
On Saturday 23 January 2010 7:51:28 am Bob Pawley wrote:
I havn't been able to find documentation on how to use \d. When I open the
psql interface (through either port ) it asks for a password but doesn't
allow any entry of a password.
That would depend on the settings in pg_hba.conf, whether
John R Pierce wrote:
I know the database has a lot of write volume overall, and its only
one of several databases running in different zones on the server. I
know nothing about the SAN, I suspect its a EMC Symmetrix of some
sort. Probably a generation or two behind latest. The operations
Jakub Bednář wrote:
Hi All,
We decide add support PostgreSQL database (now supporting only Oracle
database) to our product.
In Oracle we mapping Java BigDecimal to number(19, 2), in PostgreSQL to
numeric(19, 2).
If I store to BigDecimal column number without decimal, e.g. 3, than
Oracle
Ivan Sergio Borgonovo m...@webthatworks.it writes:
- installing postgresql-server-dev-[version]
- apt-get source postgresql-server-dev-[version]
- copy from there a contrib dir in my ~ (or wherever you prefer)
- export USE_PGXS=1; make
Don't forget apt-get build-dep postgresql-[version]
I
Greg Smith wrote:
John R Pierce wrote:
I know the database has a lot of write volume overall, and its only
one of several databases running in different zones on the server. I
know nothing about the SAN, I suspect its a EMC Symmetrix of some
sort. Probably a generation or two behind latest.
Hi, everyone:
First I can successful run this query:select name, ts_rank_cd(vectors, query)
as rank from element, to_tsquery('item') query where query @@ vectors order by
rank desc;But actually I want to run this one:select name, ts_rank_cd(vectors,
query) as rank from element, 'item'::tsquery
On 23/01/2010 11:52 PM, Alessandro Agosto wrote:
Hi,
i'm a python/c developer and i need an asynchronous (python) interface
to communicate with a database. I like PostgreSQL so i'm trying to write
a mock-up for a python extension module to use LibPQ in my asynchronous
programs.
What's wrong
Hi:
I'm dealing with a hierarchical design where changes in one record can and
should cause changes in other records lower inthe hierarchy. I'm trying to use
update triggers to do this. And recursion would be a real nice way to do this.
What I need to know is if, in the after update trigger
Xu,
FTS has nothing with your problem, it's general limitation/feature.
Oleg
On Sat, 23 Jan 2010, xu fei wrote:
Hi, everyone:
First I can successful run this query:select name, ts_rank_cd(vectors, query) as rank
from element, to_tsquery('item') query where query @@ vectors order by rank
19 matches
Mail list logo