[EMAIL PROTECTED] wrote:
One of my friend lost data with mysql yesterday.. The machine was taken down for
disk upgrade and mysql apperantly did not commit the last insert.. OK he was
using myisam but still..:-)
It sounds like that is more a problem with improper operating protocols
than with t
Christopher Browne wrote:
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] wrote:
MySQL can tell you from it's index because it doesn't care if it gives you the
right number or not.
Under what circumstances would MySQL give the wrong number?
It would give the wrong number under _e
On Wed, Oct 08, 2003 at 07:03:19PM -0500, [EMAIL PROTECTED] wrote:
> Would PG know enough to do a commit regardless of how the database was
> shut down? A second question is whether doing a commit is what the user
> or application would always want to have happen, as it could result in a
> hal
Ang Chin Han <[EMAIL PROTECTED]> writes:
> Heck, even using myisam, mysql's count(*)'s still accurate, since all INSERTs,
> etc are autocommitted.
That's sort of true, but not the whole story. Even autocommitted transactions
can be pending for a significant amount of time. The reason it's accura
> In article <[EMAIL PROTECTED]>,
> Mike Mascari <[EMAIL PROTECTED]> writes:
>
>> [EMAIL PROTECTED] wrote:
>>> Has some one come up with a similar type script that could be used
>>> in a Postgresql database?
>
>>> The script below was created for a SQLServer database.
>>> Thx,
>>> -Martin
>
>> I h
[EMAIL PROTECTED] writes:
> We are using Postgresql as the backend database for our upcoming software
> application. We would like Postgresql to have the following functionalities :
>
> 1. Standard Error Codes along with textual error messages including error
> codes for errors while dumping/r
Hello,
There is now an updated version of plPerl with trigger support
available at the Command Prompt community page. It can
be viewed with documentation here:
https://www.commandprompt.com/entry.lxp?lxpe=285
Sincerely,
Joshua Drake
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODB
David Busby wrote:
List,
What are the recommended work arounds for cross database foreign keys?
As I understand it transactions are not atomic with the TCL method. I have
a situation that requires a master database and then a separate database for
every subscriber. Subscribers need read/write
Joshua D. Drake writes:
> Master of Ceremonies is a new position that was created by the core (at
> least Josh Berkus)
> for dealing with speakers.
>
> There are others, such as Editor-n-chief which is myself, and I am in
> charge of soliciting writers
> and working with publishers.
I find these
Hello,
I need to get a float8 to display as a number
db=# SELECT CAST('0.1' AS float8);
float8
1e-05
(1 row)
I need this to return 0.1 instead. I know about the to_char
function, but this seems to truncate the number after fourteen digits of
precision:
db=# SELECT CAST('0.
Yes, I know you've seen the above subject before, so please be gentle with
the flamethrowers.
I'm preparing to enter a discussion with management at my company
regarding going forward as either a MySql shop or a Postgresql shop.
It's my opinion that we should be using PG, because of the full ACID
Greetings,
I am new to this list. I have a problem with BLOBS using PostgreSQL7.3.4.
I used the lo_export utility to insert an image into a trial database. I have
not been able to use the lo_export utility to retrieve it. I have done this
successfully before using PostgreSQL7.2.
Assuming
Sorry for the repost again. I emailed the Admin asking to cancel it (I
originally posted from a non-subscribed address), but perhaps he missed
it.
John
John Wells said:
> Yes, I know you've seen the above subject before, so please be gentle with
> the flamethrowers.
>
> I'm preparing to enter a
On Wed, 8 Oct 2003 11:28:00 -0400 (EDT) John Wells <[EMAIL PROTECTED]> wrote:
> It's my opinion that we should be using PG, because of the full ACID
> support, and the license involved. A consultant my company hired before
> bringing me in is pushing hard for MySql, citing speed and community
> s
Rick Gigger wrote:
No offense taken. I am very meticulous about any software upgrades that I
do on my production systems. I'm not quite sure what you mean by "this
business since you have no idea what I am actually doing. For all you know
I am a boy scout developing a public service web site to
> "Shridhar" == Shridhar Daithankar <[EMAIL PROTECTED]> writes:
Shridhar> Yeah.. like inserting a biiig number in integer field in a transaction
Shridhar> without error and not getting it back after commit.. or accepting
Shridhar> '00-00-00 00:00:00' as a valid datetime stamp.. something like
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] wrote:
>> MySQL can tell you from it's index because it doesn't care if it gives you the
>> right number or not.
>
> Under what circumstances would MySQL give the wrong number?
It would give the wrong number under _every_ circumstance
Yes, I know you've seen the above subject before, so please be gentle with
the flamethrowers.
I'm preparing to enter a discussion with management at my company
regarding going forward as either a MySql shop or a Postgresql shop.
It's my opinion that we should be using PG, because of the full ACID
Oliver Elphick said:
> Unless they actually attach extra conditions to the GPL (i.e. "This
> product is licensed under GPL with the following extra conditions...")
> this is rubbish. The GPL allows you to do what you like with the
> software internally; its restrictions only apply to further
> dis
Hi John,
I've been thinking about this for sometime, since a couple of my
associates are looking to build a commercial app based around JDBC. The
difficulty came when we looked at redistributing a MySQL JDBC driver
.jar with the application. From what I can tell, since you distribute
the JDB
Richard Welty wrote:
On Wed, 8 Oct 2003 11:28:00 -0400 (EDT) John Wells <[EMAIL PROTECTED]> wrote:
It's my opinion that we should be using PG, because of the full ACID
support, and the license involved. A consultant my company hired before
bringing me in is pushing hard for MySql, citing speed
On Wed, 2003-10-08 at 16:28, John Wells wrote:
> Yes, I know you've seen the above subject before, so please be gentle with
> the flamethrowers.
>
> I'm preparing to enter a discussion with management at my company
> regarding going forward as either a MySql shop or a Postgresql shop.
>
> It's my
On Wed, Oct 08, 2003 at 15:40:13 +0100,
Harry Broomhall <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III writes:
> > On Wed, Oct 08, 2003 at 12:23:04 +0100,
> > Harry Broomhall <[EMAIL PROTECTED]> wrote:
> > >I wonder if anybody could give me a few pointers on a problem I face.
> > >
> > >
Bruno Wolff III writes:
> On Wed, Oct 08, 2003 at 12:23:04 +0100,
> Harry Broomhall <[EMAIL PROTECTED]> wrote:
> >I wonder if anybody could give me a few pointers on a problem I face.
> >
> >I need to do an UPDATE on table A, from an effective left outer join
> > on A and another table B
On Wed, Oct 08, 2003 at 12:23:04 +0100,
Harry Broomhall <[EMAIL PROTECTED]> wrote:
>I wonder if anybody could give me a few pointers on a problem I face.
>
>I need to do an UPDATE on table A, from an effective left outer join
> on A and another table B. (This is trying to perform a numb
On Wed, Oct 08, 2003 at 05:34:32PM +0900, Jean-Christian Imbeault wrote:
> On my RH 9.0 linux system when ./configuring 7.3.4 I get an error about
> not finding the readline libs, however both the readline and
> readline-devel rpms are installed:
On some linux redhat-ish distros I think you also
Title: RE: [GENERAL] using copy to load odd characters
--howdy:
--to reiterate the problem, i am simply doing
--a copy of a text file into a table:
[snip example]
testdb> \copy t_test1 from '/var/tmp/results.txt' with delimiter as '|'
[/snip example]
--the problem was that there wer
On my RH 9.0 linux system when ./configuring 7.3.4 I get an error about
not finding the readline libs, however both the readline and
readline-devel rpms are installed:
# rpm -qa | grep readline
readline-4.3-5
readline-devel-4.3-5
What library/rpm am I missing?
The config.log file has this to sa
I wonder if anybody could give me a few pointers on a problem I face.
I need to do an UPDATE on table A, from an effective left outer join
on A and another table B. (This is trying to perform a number translation,
where the items that need it are rare.)
The following points *I think* ar
No, you don't need a NULL entry in "table_type1" or
"table_type2".
When inserting NULL into a column which REFERENCES
another table, there is simply no referencing done.
/Mattias
Nagib Abi Fadel wrote:
What u suggest here is having a null entry in table TABLE_TYPE1 and
TABLE_TY
Hi All,
Firstly I've gotta say that I think that PostgreSQL is one of the finest
OSS projects out there and full credit to all of those involved.
After talking to a couple of other consultants who use Pg, and fully
encourage their clients in the enterprise that Pg is a perfectly viable
soluti
What u suggest here is having a null entry in table TABLE_TYPE1 and TABLE_TYPE2.
(This does not seem to be right.)
That way i would be able to make a referential integrity to each table by creating the table transaction like follows:
CREATE TABLE transaction (
transaction_id,
amount,
--- Richard Huxton <[EMAIL PROTECTED]> wrote:
> On Wednesday 08 October 2003 06:53, Nagib Abi Fadel
> wrote:
> > HI,
> >
> > let's say i have a tansaction table called
> TRANSACTION
> > (transaction_id,amount,type,type_id)
> >
> > Let's say a transaction can have multiple types:
> TYPE1, TYPE2 for
Hi All,
I've a problem with unclosed connections. Once a client aborts a connection
accidentelly (client crash or power failure eg.), it stucks in and postgres
won't restart or stop. Is there any way to close unused (dead) connections.
I'd guess that some kind of connection timeout option should do
On Wednesday 08 October 2003 06:53, Nagib Abi Fadel wrote:
> HI,
>
> let's say i have a tansaction table called TRANSACTION
> (transaction_id,amount,type,type_id)
>
> Let's say a transaction can have multiple types: TYPE1, TYPE2 for example.
>
> EACH type has his own definition and his own table.
>
Almost everything is possible if you accept to write your own triggers
and trigger functions. But there is no standard solution to this
problem.
There are of course inherited tables, but in the current
implementation, foreign key constraints doesn't work very well with
them (making them completly
HI,
let's say i have a tansaction table called TRANSACTION (transaction_id,amount,type,type_id)
Let's say a transaction can have multiple types: TYPE1, TYPE2 for example.
EACH type has his own definition and his own table.
Every transaction has a type that could be type1 or type2 that's why
Hi all,
I would like to setup a database which can accept HKSCS - "Hong Kong Supplementary Character Set". Here is the reference:
http://www.info.gov.hk/digital21/eng/hkscs/introduction.html
Can somebody tell me how to do it? I've try database encoding with EUC_TW, SQL_ASCII and UNICOD
38 matches
Mail list logo
