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
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
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...
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
(prepareCall
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/^#/--/'
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 = 'SomeValue';
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
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
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 tables
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
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
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
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, however,
"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 still
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/
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
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
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 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,
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) Create your destination
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
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
didn't
22 matches
Mail list logo