Slightly off topic for this thread... I figured I give it a whirl...
I've often wondered what sort of performance increase one would get by placing
the WAL on a solid-state drive like a 2 or 4GB TiGi. Has anyone tested this
type of setup for a performance gain? For a 2GB drive it runs ~$3000. It
On Sun, 30 May 2004 07:11:18 -0500
Bruno Wolff III <[EMAIL PROTECTED]> wrote:
> On Sun, May 30, 2004 at 12:18:05 +0200,
> Jurgen Defurne <[EMAIL PROTECTED]> wrote:
> >
> > Please do not reply or flame me for this.
> > --
> >
> > ---(end of
> > broadcast)---
Wei Shi <[EMAIL PROTECTED]> writes:
> Does anybody know why "key_column_usage", and
> "referential_constraints" are empty in
> information_schema?
They work for me ...
regards, tom lane
---(end of broadcast)---
TIP 2: you ca
I am currently designing an application which should be accessible from
different interfaces. For this I like to be using stored procedures to
process the contents of form submissions and dialog screens.
After studying the PG database, it seems to me that I can fulfill the
following requirements.
--- Paul Thomas <[EMAIL PROTECTED]> wrote:
>
> On 28/05/2004 20:46 Jeff Eckermann wrote:
> > I had a thought that the ODBC driver could be
> > stripping the trailing spaces, but the test I just
> did
> > (using MS Access via ODBC) worked fine.
>
> But that's using a different ODBC driver so won't
> a) The basic contents of the internal data dictionary can be used to
> check incoming fields from on their length and permitted contents.
>
> b) With a little extra work, I should be able to define a table which
> can be used to check field contents against field masks.
You can use column check
http://savannah.gnu.org/cgi-bin/viewcvs/*checkout*/gnumed/gnumed/gnumed/server/sql/gmI18N.sql?rev=1.15
Works for me. You'll have to make sure you get the entire
string for the URL. It may have been wrapped by your mail
handling agent.
> > - i18n_curr_lang holds the (ISO) language string per user
Guys,
I have a general question about designing databases for large data sets.
I was speaking with a colleague about an application we're preparing to
build. One of the application's tables will potentially contain 2 million
or more names, containing (at least) the fields first_name, last_name,
On Sun, 30 May 2004 20:04:50 +0200
Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> > a) The basic contents of the internal data dictionary can be used to
> > check incoming fields from on their length and permitted contents.
> >
> > b) With a little extra work, I should be able to define a table
> >
On 12 Feb 2004, Greg Stark wrote:
>
> "scott.marlowe" <[EMAIL PROTECTED]> writes:
>
> > Now, if you don't mind using the ODBC connector, you're scott free. but
> > you WILL be bound by the GPL, and the GPL (not MySQL's interpretation,
> > just the GPL in general) being applied to connect libs
> This then, removes the first part of my explanation, and dumps me
> completely in the second part, which is where the biggest problems
> reside.
AFAICT 7.4 does much better error handling (no, you can't
easily control error handling inside a transaction, though). It
reports errors in a way that c
On Feb 11, 2004, at 10:00 PM, Bruce Momjian wrote:
No one really has thought of that before. We could do it, though there
are admin reasons for restricting that ability. If we said only
superusers could change it, it wouldn't be very useful.
That's a good point.
It would be cool if SET could chan
Take a look at http://www.pgsql.com/graphics/Empowered_logos, it contains
several images in different formats.
Jason
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Stéphane Pinel
Sent: Tuesday, May 25, 2004 5:55 AM
To: PostgreSQL-general
Subject: [GENER
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] ("Mark Cubitt") belched
out:
> is there a problem with running sqlnet on the same server as postgres?
Only if having too much running leads to starvation of resources...
--
output = ("aa454" "@" "freenet.carleton.ca")
http://cbbrowne.co
Hi,
On an address that's has been unsubscribed from this list I'm still
getting messages from months ago. Always from the same server:
pcbuddy.net (ns.pcbuddy.net) [66.132.188.173]
The headers are:
Received: from sambucca.ecomtel.com.au [210.9.56.2]
by localhost with POP3 (fetchmail-5
On Thursday 12 February 2004 20:25, Prashanthi Muthyala wrote:
> Hi Richard
Hi Prashanthi - nice to hear from you again. I've taken the liberty of cc-ing
the general list on this, since there may be others who can help here.
> I am trying to migrate the database and its tables from mysql in my
>
[EMAIL PROTECTED] wrote:
> I have ported a PHP MySQL app to PostgreSQL, and a pg_send_query()
> call is returning error code 2 (PGSQL_TUPLES_OK). Unfortunately
> the PHP manual lists the error codes but doesn't indicate what
> they mean, and pg_result_error() returns a blank message.
>
> As the tok
"angshumitra ghosh" <[EMAIL PROTECTED]> writes:
> Can anyone please tell me why postmaster is shutting down ? What all
> causes the SIGINT signal to be sent to postmaster that causes rollback of
> open transactions and disconnection of open connections ?
I suspect that you are doing something
"John Wells" <[EMAIL PROTECTED]> writes:
> A common lookup the application will require is the full name, so prefix +
> first_name + middle_name + last_name.
> My friend's suggestion was to create a "lookup field" in the table itself,
> which would contain a concatenation of these fields created d
On Sun, 30 May 2004 22:08:10 +0200
Karsten Hilbert <[EMAIL PROTECTED]> wrote:
> > This then, removes the first part of my explanation, and dumps me
> > completely in the second part, which is where the biggest problems
> > reside.
> AFAICT 7.4 does much better error handling (no, you can't
> easil
From: "Doug McNaught" <[EMAIL PROTECTED]>
> "Cyril VELTER" <[EMAIL PROTECTED]> writes:
>
> > I'm trying to dump a database from a 7.1.3 server to a 7.4.2 one.
> >
> > It doesn't works because of difference in COPY format (unless I
use -d
> > which is VERY slow on a 16G database).
>
> Try
21 matches
Mail list logo