Dinesh Pandey wrote:
./configure --enable-integer-datetimes --prefix=/usr/local/pgsql
--with-tclconfig=/usr/local/lib --with-tcl
configure: error:
*** Could not execute a simple test program. This may be a problem
*** related to locating shared libraries. Check the file 'config.log'
*** for
Title: RE: [GENERAL] return two elements
For my it would be sufficient that I could return a basic type in OUT/INOUT parameters, if in addition I could return a set fantastic!
-Mensaje original-
De: Alvaro Herrera [mailto:[EMAIL PROTECTED]]
Enviado el: martes 7 de junio de 2005
On Wed, 2005-06-08 at 05:31, Joseph Shraibman wrote:
I want to do the following:
BEGIN;
SELECT ... FROM table WHERE a = 1 FOR UPDATE;
UPDATE table SET ... WHERE a = 1;
if that resturns zero then
INSERT INTO table (...) VALUES (...);
END;
The problem is that I need to avoid race
Hi,
I'd like to use a Postgres 8 server from different locales (english, german,
hungarian, etc.). I can implement gettext into my client application so the
only thing i'd need (at least I think so) is a .po (or an .mo) file for each
locale.
I looked into Postgres installation directories and
Sorry I forgot to set LD_LIBRARY_PATH , after setting able to install.
LD_LIBRARY_PATH=/usr/local/lib
export LD_LIBRARY_PATH
Thanks
Dinesh Pandey
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Neil Conway
Sent: Wednesday, June 08, 2005 11:42 AM
Hi,
Should it be possible to create a compressed backup of a version 8.0.1
database running on linux and restore that backup on version 8.0.3
running on XP? I ask this because it does not seem to work for me. Many
problems seem to arise to do with tsearch2 extensions to tables, even
though
On Jun 8, 2005, at 4:47 AM, Együd Csaba wrote:
I'd like to use a Postgres 8 server from different locales (english,
german,
hungarian, etc.). I can implement gettext into my client application
so the
only thing i'd need (at least I think so) is a .po (or an .mo) file
for each
locale.
I
Hi,
I am trying to copy the data from an integer column into an array column in
the same table. Something like this
CREATE TABLE test (field1 INT, field2 INT, field3 INT[]);
INSERT INTO test VALUES(1);
INSERT INTO test VALUES(2);
INSERT INTO test VALUES(3);
INSERT INTO test VALUES(4);
INSERT
On Jun 8, 2005, at 8:21 AM, Adam Witney wrote:
Hi,
I am trying to copy the data from an integer column into an array
column in
the same table. Something like this
CREATE TABLE test (field1 INT, field2 INT, field3 INT[]);
INSERT INTO test VALUES(1);
INSERT INTO test VALUES(2);
INSERT INTO
To improve compatibility, I created a backup on the linux system (8.0.1)
using plain format, data only with triggers disabled. However, when I
try to restore the plain sql on the windows machine (8.0.3) it fails
because the first insert command fails a foreign key constraint. Can I
disable
Hi,
I¡¯m using postgreSQL with SSL these days. The version
I¡¯m using is 8.0.3. I found that it¡¯s impossible to
use an encrypted key file.
When you use a protected server.key file, you will be
prompted to input your passphrase EVERYTIME IT¡¯S
USED, not only when you start the server but also
I post to this list occasionally, and yet get maybe one spam email a month.
YMMV. Don't tell anyone, but I got a line on a great deal in Nigeria.
Rick
[EMAIL PROTECTED] wrote on 06/07/2005 09:56:16 PM:
Wes wrote:
It seems that for some time this list has been mirrored to Usenet
without
On Wed, Jun 08, 2005 at 01:21:19PM +0100, Adam Witney wrote:
UPDATE test SET field3[1] = field1;
Why does the UPDATE of field2 work, but the UPDATE of field3 does not?
What version of PostgreSQL are you using? The example should work
in 8.x. See the Release Notes:
Hi John,
thank you very much for your suggestion. I downloaded the file (hu.po) and
tried to find the given error message in it (using a text editor) with no
success. There was no e.g. SQL Error: fe_sendauth: no password supplied
lines in the po file. A also searched over the de.po and no such
On Jun 8, 2005, at 9:12 AM, Együd Csaba wrote:
thank you very much for your suggestion. I downloaded the file (hu.po)
and
tried to find the given error message in it (using a text editor) with
no
success. There was no e.g. SQL Error: fe_sendauth: no password
supplied
lines in the po file. A
There appears to be a problem with pgadminIII where the option to
disable triggers does not actually do anything! If I switch to the
pg_dump command line then the disable triggers works. Unfortunately I
still cannot restore a database backed up from a linux machine running
8.0.1 to an windows
Hi,
I¡¯m using postgreSQL with SSL these days. The version I¡¯m
using is 8.0.3. I found that it¡¯s impossible to use an
encrypted key file.
When you use a protected server.key file, you will be
prompted to input your passphrase EVERYTIME IT¡¯S USED, not
only when you start the server
On Wed, Jun 08, 2005 at 01:28:56AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm, be aware that you can't return a set if you have OUT/INOUT
parameters.
? News to me --- what are you worried about exactly?
It's surely possible that our idea of what this means is
Howard Cole [EMAIL PROTECTED] writes:
To improve compatibility, I created a backup on the linux system
(8.0.1) using plain format, data only with triggers disabled. However,
when I try to restore the plain sql on the windows machine (8.0.3) it
fails because the first insert command fails a
-Original Message-
From: Egyd Csaba [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 08, 2005 4:31 PM
To: 'Tom Lane'
Subject: RE: [GENERAL] Where to find translation of Postgres error messages?
Ah, I see. OK. So there are two ways of mine:
1. to translate myself the whole stuff in my
=?iso-8859-2?Q?Egy=FCd_Csaba?= [EMAIL PROTECTED] writes:
I looked into Postgres installation directories and found several .mo files
under the locale directory. But I wasn't able to find the string no
password supplied for example in neither of them.
I think we deliberately don't localize that
(Sorry, wrong subject line got sent)
Greetings!
Does anybody know how well the optimizer works when dealing with inherited
tables? I am currently using 8.0.1.
I have a table called eventlog.record_main, and a number of inherited
tables to partition the data (called
Greetings!
Does anybody know how well the optimizer works when dealing with inherited
tables? I am currently using 8.0.1.
I have a table called eventlog.record_main, and a number of inherited
tables to partition the data (called
eventlog_partition._day__record_main). luid is the primary key (all
On Wed, 2005-06-08 at 16:08 +0200, Magnus Hagander wrote:
Hi,
Im using postgreSQL with SSL these days. The version Im
using is 8.0.3. I found that its impossible to use an
encrypted key file.
When you use a protected server.key file, you will be
prompted to input your passphrase
Hello all,
why is the last definition of a view not working, although the
documentation says all three are equal?
Testcase:
CREATE SCHEMA one;
CREATE SCHEMA two;
CREATE TABLE one.one (
id SERIAL PRIMARY KEY
);
CREATE TABLE two.two (
id SERIAL PRIMARY KEY
);
CREATE TABLE
I read in documentation that primary key doesn't require additional indexes but I could find nothing about foreign keys.
Do I need to create additional indexes when I create foreign keys?
Example:
create table master
{
master_id INT4,
master_name VARCHAR(64),
CONSTRAINT master_pkey PRIMARY KEY
hi
i have a stituation a situation where i have multiple tables, and multiple triggers on all of them.
at least 1 or 2 triggers on at lease 4 different tables does updates to main cache table.
now.
i have tasks which involve simultaneously (from different machines even) modifying all of the
Sebastian Böck wrote:
Hello all,
why is the last definition of a view not working, although the
documentation says all three are equal?
CREATE OR REPLACE VIEW not_working AS
SELECT one.*
FROM one.one, two.two
JOIN join1 ON join1.id = one.id;
I think it's trying to join two
I dropped [EMAIL PROTECTED] from the Cc: because that account has serious
issues.
On Wed, Jun 08, 2005 at 08:16:32AM -0600, Michael Fuhr wrote:
On Wed, Jun 08, 2005 at 01:28:56AM -0400, Tom Lane wrote:
Alvaro Herrera [EMAIL PROTECTED] writes:
Hmm, be aware that you can't return a set if you
Richard Huxton wrote:
Sebastian Böck wrote:
Hello all,
why is the last definition of a view not working, although the
documentation says all three are equal?
CREATE OR REPLACE VIEW not_working AS
SELECT one.*
FROM one.one, two.two
JOIN join1 ON join1.id = one.id;
I think
=?ISO-8859-1?Q?Sebastian_B=F6ck?= [EMAIL PROTECTED] writes:
why is the last definition of a view not working, although the
documentation says all three are equal?
The documentation says no such thing...
CREATE OR REPLACE VIEW not_working AS
SELECT one.*
FROM one.one, two.two
Tom Lane wrote:
=?ISO-8859-1?Q?Sebastian_B=F6ck?= [EMAIL PROTECTED] writes:
why is the last definition of a view not working, although the
documentation says all three are equal?
The documentation says no such thing...
So I misinterpreted the following:
On Wed, 8 Jun 2005, Dan Black wrote:
I read in documentation that primary key doesn't require additional indexes
but I could find nothing about foreign keys.
Do I need to create additional indexes when I create foreign keys?
Example:
create table master
{
master_id INT4,
master_name
Sebastian Böck wrote:
Richard Huxton wrote:
Sebastian Böck wrote:
Hello all,
why is the last definition of a view not working, although the
documentation says all three are equal?
CREATE OR REPLACE VIEW not_working AS
SELECT one.*
FROM one.one, two.two
JOIN join1 ON join1.id
Dan Black wrote:
I read in documentation that primary key doesn't require additional indexes
but I could find nothing about foreign keys.
Do I need to create additional indexes when I create foreign keys?
Example:
create table master
create table slave
Do I need to create index
CREATE
Adam Witney [EMAIL PROTECTED] writes:
UPDATE test SET field2 = field1;
UPDATE test SET field3[1] = field1;
Why does the UPDATE of field2 work, but the UPDATE of field3 does not?
Works for me in 8.0 ;-). Before 8.0, if you tried to assign to just one
value of an array that was initially NULL,
Hi,
A possible countermeasure on Windows platform,
inspired by Magnus.Thanks ;)
First we remove the passphrase from the key file,
making it plain.
Windows provides a feature encrypted file system,
provide transparent encryption/decryption. We can log
on using the account we run Postgres with and
I have table:
CREATE TABLE public.test (
id INTEGER,
text1 VARCHAR(25),
text2 VARCHAR(25)
) WITH OIDS;
INSERT INTO test VALUES (1, 'qwerty', '111');
INSERT INTO test VALUES (2, 'asdfgh', '222');
and
I've observed that inserts into slave table became slower when I use foreign key than without one.
Can it be related to foreign key?
And I am interested how much performance of database with foreign
keys can be different from performance of database without foreign
keys? In other words, how much
Maybe I ask another way.
In Oracle there is a variable SQLERRM, where error message is placed.
How to get some message in PostgreSQL?
I searched documentation 3 or 5 times, and Google, and wrote on forums
topics and I have enough.
On Wed, 2005-06-08 at 12:39, Dan Black wrote:
I've observed that inserts into slave table became slower when I use
foreign key than without one.
Can it be related to foreign key?
And I am interested how much performance of database with foreign
keys can be different from performance of
I need some help please! I'm using PostgreSQL for a long time (about two
yeas), but always in a Linux box. So, I always could install and use it with no
major problems!
Unfortunetly now I have to use it on WinXP. So, here is my problem:
I intalled PostgreSQL 8.0.3 in WInXP (SP1) with
On Wed, Jun 08, 2005 at 08:03:40PM +0200, Gorodowienko Daniel wrote:
Maybe I ask another way.
In Oracle there is a variable SQLERRM, where error message is placed.
How to get some message in PostgreSQL?
I searched documentation 3 or 5 times, and Google, and wrote on forums
topics and I have
I think 21 interns will be enough :)2005/6/8, Scott Marlowe [EMAIL PROTECTED]:
On Wed, 2005-06-08 at 12:39, Dan Black wrote: I've observed that inserts into slave table became slower when I use foreign key than without one. Can it be related to foreign key? And I am interested how muchperformance
you will have to confirm your account by the following link
Is this bogus?
Clicking on the link goes to 62.193.220.183 which is not postgresql.org
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
Hi
On Wed, 8 Jun 2005, Matt Miller wrote:
you will have to confirm your account by the following link
Is this bogus?
Yes...
--
Devrim GUNDUZ
devrim~gunduz.org, devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.tdmsoft.com.tr http://www.gunduz.org
Matt Miller wrote:
you will have to confirm your account by the following link
Is this bogus?
Clicking on the link goes to 62.193.220.183 which is not postgresql.org
Quite. It is a phising scam probably.
---(end of broadcast)---
TIP 5:
Hi,
Phishing scam for sure. I thought it was hilarious in a way: Why
would the host of postgresql.org send himself a bill?.
Kind of a silly paradox.
Regards,
Arthur
On 6/8/05, Joshua D. Drake [EMAIL PROTECTED] wrote:
Matt Miller wrote:
you will have to confirm your account by the
Hi All,
How easy or difficult is it to get ggobi/xgvis working with postgresql?!
Is it possible to write a query and send the output straight to
ggobi/xgvis without much work?
Any pointers.
Thanks for your help.
Hrishi
---(end of broadcast)---
TIP
Matt Miller wrote:
you will have to confirm your account by the following link
Is this bogus?
Yes, if you're look at the email as text rather then html, you'll see
it's a phishing attempt. A very good reason to read your email in text.
Clicking on the link goes to 62.193.220.183 which
Another idea is to try an outer join:
SELECT child_table.parentid INTO tmp_table
FROM child_table LEFT JOIN parent_table
ON (child_table.parentid = parent_table.parentid)
WHERE parent_table.parentid IS NULL;
There's also
DELETE
FROM child_table
WHERE NOT EXISTS (select 1
from parent_table
Is is possible to tell PostgreSQL to ignore transactions committed
after some point? In particular I want to get it to rollback a
faulty recovery.
On a related note, how can I get the most recent transaction id from
the WAL segment that I want to rollback to?
TIA,
John Barham
Alvaro Herrera wrote:
No, we don't have SQLERRM support yet. If you were asking about getting
the messages from RAISE EXCEPTION, I'm afraid there's no way to get it
in the EXCEPTION clause.
If you want to contribute it, patches are welcome ...
Actually, Pavel Stehule sent in a patch for this
On Tue, Jun 07, 2005 at 10:25:26 -0700,
John Barham [EMAIL PROTECTED] wrote:
Is is possible to tell PostgreSQL to ignore transactions committed
after some point? In particular I want to get it to rollback a
faulty recovery.
PITR will let you do this. You need to have a complete backup of
On Thu, Jun 09, 2005 at 12:25:19PM +1000, Neil Conway wrote:
Alvaro Herrera wrote:
No, we don't have SQLERRM support yet. If you were asking about getting
the messages from RAISE EXCEPTION, I'm afraid there's no way to get it
in the EXCEPTION clause.
If you want to contribute it, patches
Alvaro Herrera wrote:
Huh, I meant a patch for getting the error message from RAISE EXCEPTION.
Does Pavel's patch address that too?
Yes.
(I just posted a revised patch to -patches, I'll apply it later tonight.)
-Neil
---(end of broadcast)---
I am a bit of a newbie to postgres, but I managed to install 8.0.4 on my
windows box and it mostly appears to be working fine;
I can set a primary key constraint, but when i try to set the foreign key it
requires a 'reference' - but there is nothing there to chose from.
I also have another
57 matches
Mail list logo