On Fri, 19 Jan 2001 17:02:43 Gregory Wood wrote:
>> Does anyone else get annoyed when going on to an american site to
>> register or buy something and find that the state field is only
>> 2 characters long?
>
[snip]
>
>Does anyone else get annoyed when people jump all over someone because they
>di
> I wish Postgresql users were more outspoken -
>
> This page - http://openacs.org/philosophy/why-not-mysql.html
> and reading Bruce Momjian's pdf book - completely changed me
>
> I always heard comments like - "you don't need transactions" "you can
> get away with no subqueries" - "MYsql is go
We have added contrib/mysql to 7.1beta that converts MySQL dumps. If
you can, please add anything you consider appropriate to that and send
in a diff. It is written in Perl too.
Thanks.
> I hacked up a small perl script that does a first-pass attempt on
> converting mysql's database dump to
I just discoverred arrays, and I'm wondering if there's a way to do,
given table t1 (v int4, a int4[]), a query that does in effect :
"select v, i from t1 where EXISTS i SUCHTHAT a[i] = 45;"
I know I can do it with a separate table and a join, but this would
be much nicer.
Also, I wanted to me
> Unless your application logic tries to use OIDs as row identifiers,
> duplicate OIDs in user tables are not a problem.
Hmmm, that means that the following, which I use, is not strictly correct :
create table t1 (recordid SERIAL PRIMARY KEY, val INT4, name TEXT);
... much later ...
insert into
Tim Uckun wrote:
>
> >>hi,
> >>can anyone help me ? i need to convert a ms access .mdb file into
> >>somthing readable so i can insert it into my postgreSQL db...
> >>does anyone have any experiance? (preferably using PHP)
> >>Robert Korteweg
> >>The Netherlands
>
> Here is your steps.
> 1) Cr
I am comparing it to Oracle's public synonyms, where you can use different
names for things.
For example, table "THIS_IS_A_VERY_BYG_NAME" could be accessed using a
smaller name, example "TIAVBN".
> -Original Message-
> From: Peter Eisentraut [mailto:[EMAIL PROTECTED]]
> Sent: Friday, Janu
> > If I do a view that produces the data I want through joins, it takes
hours,
> > even with all fields indexed, and after VACUUM ANALYZE. Doing SET
ENABLE
> > SEQ_SCAN = OFF doesn't seem to make any difference. The query plan
changes,
> > but select times are still roughly the same... Doing the
I need to know how to select based on a value's membership in an array. I
have tried something like
select * from this_table where this_list *= 'a';
which I found after many obscure searches on google. However pgsql doesn't
know what to do with this operator. Any idea or advice are greatly
appre
I need to know how to select based on a value's membership in an array. I
have tried something like
select * from this_table where this_list *= 'a';
which I found after many obscure searches on google. However pgsql doesn't
know what to do with this operator. Any idea or advice are greatly
appre
Colin Taylor writes:
> Are Synonyms supported on Postgresql?
There is nothing in PostgreSQL that's called a "synonym" per se, so you
have to describe what you mean by it.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Best, depending on the scenario. In cases where you
are using a fixed number
of characters, there's no need for the overhead of a
varchar. For instance
if you are storing state abbreviations, they will
ALWAYS be 2 characters.
The database can look up those fixed fields
On 2001.01.19 16:10:33 +0100 Tom Lane wrote:
> Tony Grant <[EMAIL PROTECTED]> writes:
> > /usr/bin/initdb: /tmp/initdb.29795: Permission denied
>
> Pretty odd. Uh, you're sure /tmp is world-writable?
U...
I had a mail server problem that nuked my /tmp directory last week. The new
temp dir
"Gordan Bobic" <[EMAIL PROTECTED]> writes:
> If I do a view that produces the data I want through joins, it takes hours,
> even with all fields indexed, and after VACUUM ANALYZE. Doing SET ENABLE
> SEQ_SCAN = OFF doesn't seem to make any difference. The query plan changes,
> but select times are s
Guillaume =?ISO-8859-1?Q?L=E9mery?= <[EMAIL PROTECTED]> writes:
> So, I was wondering if it is possible to write C function, compiled as
> .so which can perform SQL queries such as SELECT or UPDATE ?
See the SPI features. I'm not convinced this will give you any huge
performance increase, howev
Tony Grant <[EMAIL PROTECTED]> writes:
> /usr/bin/initdb: /tmp/initdb.29795: Permission denied
Pretty odd. Uh, you're sure /tmp is world-writable?
regards, tom lane
>> I ran some test to see how many queries PostGreSQL can handle per
>> seconds through the libpq library : not more than 200.
>> [...]
>
> Care to share the specs on the system, or was that number consistent across
> several setups?
>
I made other tests today and obtain better results :
I have
> I ran some test to see how many queries PostGreSQL can handle per
> seconds through the libpq library : not more than 200.
>
> So, I was wondering if it is possible to write C function, compiled as
> .so which can perform SQL queries such as SELECT or UPDATE ?
>
> I think it could increase perfo
Hi,
I have a few questions concerning odbc.
I have set up Mandrake7.2 and compiled PostgreSQL with the unicode option.
What is the current state of postgres odbc unicode support?
Does the odbc-driver, which comes with postgres, support unicode?
I know that the DB supports it, but how about the d
On Fri, 19 Jan 2001, Matthew Taylor wrote:
> Umm I must have missed it in the manual, (read it 3-4 times tho) but what is
> the equivalent data dictionary structure in Postgres to the following in
> Oracle.
>
> Select table_name from user_tables;
>
> (gives a list of the table names in the databa
On Fri, Jan 19, 2001 at 21:29:41 +1100, Matthew Taylor wrote:
> Umm I must have missed it in the manual, (read it 3-4 times tho) but what
> is the equivalent data dictionary structure in Postgres to the following
> in Oracle.
>
> Select table_name from user_tables;
> etc various special tabl
Umm I must have missed it in the manual, (read it 3-4 times tho) but what is
the equivalent data dictionary structure in Postgres to the following in
Oracle.
Select table_name from user_tables;
(gives a list of the table names in the database(table space) used at the
time)
etc various speci
Hi,
Quick questions, I hope!
Are Synonyms supported on Postgresql?
If so, how can I list them?
Also, If so, what version did they began to be supported?
Thanks,
Colin
> > SELECT * FROM Table1 INNER JOIN Table2 ON (Table1.Field1 =
> > Table2.Field1)
> > WHERE Table1.Field1 = 'SomeValue';
> > [ is slow, but this is fast: ]
> > SELECT * FROM Table1 INNER JOIN Table2 ON (Table1.Field1 =
> > Table2.Field1)
> > WHERE Table1.Field1 = 'SomeValue' AND Table2.Field1 = 'S
Tom Lane writes:
> Jeff Self <[EMAIL PROTECTED]> writes:
> > Is there a way to run this script without removing the comments?
>
> You'll have to change the comments to one of the SQL-standard
> conventions:
At the risk of stating the obvious, you can keep the comments with
sed 's/^#/--
Quoting "Brett W. McCoy" <[EMAIL PROTECTED]>:
> On Fri, 19 Jan 2001, mg wrote:
>
> > I have troubles with jsp-based websites that have been generated by
> > Macromedia DreamWeaver UltraDev 1.0. My analysis revealed that the
> > problem lies in the JDBC driver not supporting prepareCall
> (prepar
I ran some test to see how many queries PostGreSQL can handle per
seconds through the libpq library : not more than 200.
So, I was wondering if it is possible to write C function, compiled as
.so which can perform SQL queries such as SELECT or UPDATE ?
I think it could increase performance...
Title: RE: [GENERAL] nested table
- Original Message -
From: Peeter
Smitt
To: Michael Ansley
Sent: Tuesday, November 28, 2000 9:56 AM
Subject: Re: [GENERAL] nested table
If it's so then you can't say PostgreSQL is ORDBMS,
or can you? Unfortunately i don't know how Oracle handles
On 2001.01.19 03:14:32 +0100 Tom Lane wrote:
> That's an interesting definition of "doing its job" :-(.
>
> How about you show us the exact output you're getting, not an
> interpretation?
7.0.3 on RedHat 6.2 with kernel 2.4.0
postgres]$ initdb -D /home/postgres
This database system will be in
29 matches
Mail list logo
