"Havrylyak Roma" <[EMAIL PROTECTED]> writes:
> The first and last notice are mine from stored procedures.
> But what about second and third noticies. How can I debug where the error
> occur???
> What such error "Socket command type N unknown" is stand for???
> Nov 14 17:07:18 empire logger: NOTIC
DaVinci <[EMAIL PROTECTED]> writes:
> I have a problem with a script creating database. I don't know where can be
> error. Can you help me, please.
> Relation 'empleado' does not exist
Hm. I can't duplicate this problem --- running the given script under
7.0.2 produces no error here. May
Joe Kislo <[EMAIL PROTECTED]> writes:
> At the top of the import file there is a BEGIN;
> and at the bottom there is a commit. This should make this entire
> import a single transaction.
> During this process I accidentially hit control-C, canceling the whole
> shabang. The transaction obviou
Florian Steffen <[EMAIL PROTECTED]> writes:
> CREATE TABLE events (name NAME, description TEXT, date TINTERVAL);
> CREATE INDEX events_date_idx ON events (date);
> ERROR: DefineIndex: type tinterval has no default operator class
> What does that mean ?
It means there's no support for indexes on
I've never used PGSQL in a production environment, so forgive me if I'm
missing some of the common nuances assosciated with PGSQL. I have
burrowed through the dox, but havn't found anything which goes into the
detail I need.
I was trying to import a database into PGSQL, I have a file which
conta
Hello,
I tried to execute the following statements:
CREATE TABLE events (name NAME, description TEXT, date TINTERVAL);
CREATE INDEX events_date_idx ON events (date);
The first statement is executed without any problem, but when I'm running the
second one, I've got the following message:
ERROR:
I am wondering if you can declare a variable within a function using plpgsql
which can be calculated within that function to be a table which you can
then use in either a select or update statement.
I am wanting to be able to calculate a variable (ie logfilename) as the
table I want to then use i
Hi all,
Can anyone tell me if there is a way to avoid Postgres automatically
aborting a transaction under certain error conditions. In particular,
if I try to insert a record into a table and the insert fails due to a
duplicate key on a unique index my whole transaction is aborted.
I would prefer
Hi
We're currently starting to migrate one of our server's for a different
physical and logical platform.
In the previous platform we are using Postgres 6.3.2, in the current we
will use 6.5.x (I know that there is a version 7 but for now we are
migrating to 6.5).
I'm doing pg_dump of every tab
On Tue, Nov 14, 2000 at 10:35:52AM +0100, dominique papin wrote:
> But I kept an eye on the future development. Now I have read the summary
> of TOAST project which will be implemented in the future 7.1 release. It
> seems to me that it could fix my problem with blobs in postgresql, am i
> right
I don't know how I did but ...
I loose my history in psql (I can't use the arrows anymore...)
Can somebody tell me how to recovert them ?
Do I have to recompile postgres or re ... initdb ?
Thanks for help
A beginner ...
Hello.
I have a problem with a script creating database. I don't know where can be
error. Can you help me, please.
* Error:
Relation 'empleado' does not exist
* script:
-8<--
create database multi;
\connect multi
-
At 09:27 AM 11/15/00 -0800, Tom Samplonius wrote:
> AOLServer isn't the only system that can pool database connections, so
>can servlets/JSP, ColdFusion, ASP, etc. No doubt AOLServer would be more
>widely accepted if it used something other than TCL.
There are two separate modules that support
The first and last notice are mine from stored procedures.
But what about second and third noticies. How can I debug where the error
occur???
What such error "Socket command type N unknown" is stand for???
Nov 14 17:07:18 empire logger: NOTICE: cost=0.0829333, interval=00:10:22
Nov 14 17:07:18 e
At 01:53 PM 11/15/00 -0500, markw wrote:
>I'd rather not pollute the application's SQL with postgres-isms. Not that I
>don't love postgres, but there are always critics looking for a reason to use
>Oracle or (gasp) MS-SQL.
Define some global variable with the name of the database being run (curr
At 11:22 AM 11/13/00 -0500, Robert D. Nelson wrote:
>Still...Regardless of what database they're running, either their
>abstraction layer is shit or their queries really need optimized. Is that
>perhaps why, even at 5 clients, the page views he shows never went
>significantly above 10/sec?
Th
Hi,
In june, I had to migrate a web site using paradox tables on a winNT to
a Linux box. I had chosen first postgresql 7.0 for its solid-based
features.
But unfortunately, when I started to migrate my tables, a problem raised
: the implementation of blobs in Postgre. My tables stored lots of
blob
Hi,
I read several mails here regarding to 7.0.3, but I can find 7.0.2 from
www.postgresql.org. Can anyone please tell me where I can get 7.0.3?
Thanx
--
Limin Liu
(bcc to -hackers)
The Benchmark Factory software, recently acquired by Quest Software,
can be downloaded for a 30-day trial (limited # of users) at:
http://www.benchmarkfactory.com/emaildatabase/FormBenchmarkFactoryTrial.asp?product=BenchmarkFactory
(note long URL above might have wrapped)
Tha
Hi everybody!
Is this a bug?:
When I'm executing this (see below) query I have unexpected backend
closing. When I will remove last line with
"AND user_database.status_id = 'A'" -
- it's working OK.
But there are not a lot of conditions!
Do anybody know about this problem? If
Hi,
I read several mails here regarding to 7.0.3, but I can find 7.0.2 from
www.postgresql.org. Can anyone please tell me where I can get 7.0.3?
Thanx
--
Limin Liu
Hi everybody!
Is this a bug?:
When I'm executing this (see below) query I have unexpected backend
closing. When I will remove last line with
"AND user_database.status_id = 'A'" -
- it's working OK.
But there are not a lot of conditions!
Do anybody know about this problem? If
Speaking of MySQL, has anyone looked at www.mysql.org recently?
They have a big news article:
MySQL wins Linux Journal Readers Choice Award again!
For the third Year in a row MySQL won the Readers Choice Award in Linux
Journal. Considering that MySQL earlier this fall won the Linux Magazine
Edi
This's great. I have tested Postgres and MySQL with the benchmark
shipped with mysql and (of course) MySQL out perform Postgres.
I wonder does anyone know where can we download the ANSI SQL benchmark
(AN3AP) suite? I'd like to run this benchmark test myself, since
this is the only benchmark I h
Off of Slashdot:
http://www.phpbuilder.com/columns/tim20001112.php3
is an article that is quite favorable to PostgreSQL, about
PostgreSQL vs. MySQL on Sourceforge's database. Across-the-board
positive.
--titus
Thanks Tom for your emails and persistence to help me going. I'm eager to
see what this database can do for my business now.
:)
Jason
At 11:38 PM 11/12/00 -0500, Michael Fork wrote:
>Thought this may be of interest to some...
>
>http://www.phpbuilder.com/columns/tim20001112.php3
I just submitted it to slashdot, what the heck :)
- Don Baccus, Portland OR <[EMAIL PROTECTED]>
Nature photos, on-line guides, Pacific Northwest
Hi Bryan,
Try this:
select * from t where date_part('days', 'now'::timestamp - s) = ?;
Subtracting two timestamps in this way returns an 'interval', which
(unless you use the 'age' function) doesn't figure out the months and
the years - so 3 months would be rendered as "92 00:00"
Also, note th
On Mon, 20 Nov 2000, Mickaël Jouanne wrote:
> We had a database server on Mysql and we move to postgres last month.
Not enough. You need to specify the exact version, and also the version of
your operating system. Let's assume Linux.
> 'load average: 3.23' or some times higher than that.
Who i
Hello !
We had a database server on Mysql and we move to postgres last month.
But there is problems that i don't understand !
When i runthe "top" command the load average is very high :
'load average: 3.23' or some times higher than that.
And yestaerday i look to a 'top' and i found something
30 matches
Mail list logo
