Not that I know anything about the internal workings of PG but it seems like a
big part of the issue is the on disk representation of database. I've never had
a problem with the whole dump/restore process and in fact anyone that has been
doing this long enough will remember when that process was
El Dom 14 Sep 2003 12:20, Lincoln Yeoh escribió:
At 07:16 PM 9/13/2003 -0400, Lamar Owen wrote:
'migration' server. And I really don't want to think about dump/restore
of 100TB (if PostgreSQL actually stores the image files, which it might).
Hmm. Just curious, do people generally backup
Teodor Sigaev [EMAIL PROTECTED] writes:
AFAICT tsearch2's incompatibility is in the redefined YY_INPUT macro,
which seems of no value for Postgres anyway. Can't we take that out?
I resolve problem with gm4 with a help of symlink and reorder my PATH. So, it
compiles but creates core dump
Not that my DB is that big.. but if it was and it contained any sort of
financial data (something that you might want to dispute 2 years down
the road) then I would have multiple replicated systems (which I do have
.. but they are MSSQL) and I would also be backing the data up to an
offsite
A message like this?
lost synchronization with server, resetting connection
Yeah, like that.
I get pissed way too often when people miss simplest things and bug me with
stupid questions, and now it's me.
Sorry guys.
---(end of broadcast)---
No, I mean the data.
select * from stocks where symbol = 'AADBX'
and
select * from stocks where symbol = 'aadbx'
would bring up the same result set.
Christopher Browne [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Quoth Relaxin [EMAIL PROTECTED]:
Is there a way to make
Quoth Relaxin [EMAIL PROTECTED]:
Is there a way to make Postgresql case-INSENSITIVE?
It already is.
portfolio=# select * from stocks limit 1;
symbol | description | exchange
+-+--
AADBX | AADBX | NYSE
(1 row)
portfolio=# sELeCT * FROM STOCKS LIMIT 1;
Is there a way to make Postgresql case-INSENSITIVE?
Thanks
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
select * from stocks where lower(symbol) = 'aadbx';
or
select * from stocks where symbol ilike =aadbx';
or
select * from stocks where symbol ~* 'aadbx';
HTH
Darren
On Sat, 13 Sep 2003, Relaxin wrote:
No, I mean the data.
select * from stocks where symbol = 'AADBX'
and
select * from stocks
Relaxin wrote:
No, I mean the data.
select * from stocks where symbol = 'AADBX'
and
select * from stocks where symbol = 'aadbx'
would bring up the same result set.
Look in the manuals, there are SQL functions like:
STRTOLOWER( ); STRTOUPPER() like those in 'C'
Usage:
---
SELECT *
FROM
On Sat, 13 Sep 2003, Relaxin wrote:
Is there a way to make Postgresql case-INSENSITIVE?
Case insensitive in what regard?
That textual comparisons are done case-insensitively in queries?
That object names are determined case-insensitively?
---(end of
Hi guys,
just a quick and probably stupid question. When I make a cluster
based on an index on a table, how can I remove it later? Should I
'create' a new one by using the primary key index?
Also, can I have more than 1 cluster on my table? Let me explain ...
can I put for instance the
Hi,
Would anyone able to
advise how can I call a function/Stored procedure? what command to
issue?
Thanks.
Best
Regards
___
Joseph
Keow
Hello
Does anyone understand what is meant by a case-insensitive database.
Are there some collations that can be changed or is there just no way to
have a true case-insensitive Postgresql database?
Thanks
Dennis Gearon [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Relaxin
Thank you, that was the answer I was look for.
Stephan Szabo [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
On Sat, 13 Sep 2003, Relaxin wrote:
No, I mean the data.
select * from stocks where symbol = 'AADBX'
and
select * from stocks where symbol = 'aadbx'
would bring
On Sat, 13 Sep 2003, Relaxin wrote:
No, I mean the data.
select * from stocks where symbol = 'AADBX'
and
select * from stocks where symbol = 'aadbx'
would bring up the same result set.
Potentially on some systems it'd be possible to
generate a case insensitive collation as part of a
On Sun, 2003-09-14 at 14:17, Christopher Browne wrote:
After a long battle with technology,[EMAIL PROTECTED] (Martin Marques), an
earthling, wrote:
El Dom 14 Sep 2003 12:20, Lincoln Yeoh escribió:
At 07:16 PM 9/13/2003 -0400, Lamar Owen wrote:
[snip]
Certainly there are backup systems
In this issue the following statement is made:
In plpgsql, you cannot run a dynamic SELECT statement and be able to
do anything with the selected data. You cannot assign the selected
value to a variable or return the selected value from the function. You
can, however, easily construct INSERT,
Stephan Szabo [EMAIL PROTECTED] writes:
Potentially on some systems it'd be possible to
generate a case insensitive collation as part of a locale
and then use such for LC_COLLATE on initdb which would make all
comparisons of text fields case insensitive.
Another possibility is to create a
create or replace function test(integer) returns boolean as '
declare
number alias for $1;
begin
if number = 0 then
return false;
else
return true;
end if;
end;' language 'plpgsql';
to call the function you can
SELECT test(1);
or can do
SELECT user_id,
user_name,
Thank you.
Calling from java code, is the same as:
select test(1);
Regards
Joseph
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, September 15, 2003 9:22 AM
To: Keow Yeong Huat Joseph
Cc: [EMAIL PROTECTED]
Subject: Re: [GENERAL] function call
create
How to install Cygwin PostgreSQL as NT Services on
Windows 2000.
i have do all procedure in postgresql-7.3.4.README
file but i found error
$ net start postmasterThe postmaster service
is starting.The postmaster service could not be started.
The service did not report an error.
Quoting Tom Lane [EMAIL PROTECTED]:
Network Administrator [EMAIL PROTECTED] writes:
The abstraction I am talking about would be a logical layer that would
handle
disk I/O including the format of that data (lets call this the ADH).
This sounds good in the abstract, but I don't see how you
- Forwarded message from elein [EMAIL PROTECTED] -
Delivered-To: [EMAIL PROTECTED]
Date: Sun, 14 Sep 2003 20:48:22 -0700
From: elein [EMAIL PROTECTED]
To: Avi Schwartz [EMAIL PROTECTED]
Cc: elein [EMAIL PROTECTED]
Subject: Re: [GENERAL] is General Bits Issue # 43 correct?
In-Reply-To:
Network Administrator [EMAIL PROTECTED] writes:
... However it seems to me that right now that this might not be
possible while the backend is changing between major releases.
Perhaps once that doesn't fluxate as much it might be feasible to
create these layer so that it is not too fat.
25 matches
Mail list logo
