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 quer
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)---
T
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,
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
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
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
-
>> 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
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
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
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 f
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: Hav
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
-
> 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?
http://www.pos
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 much perfo
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 h
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 ad
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
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.
--
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
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');
--
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
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 N
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 IN
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
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_nam
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:
http://www.postgresql.org/docs/8.
=?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.
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 it'
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
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"
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 "sourc
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 K
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 joi
On Wed, 2005-06-08 at 16:08 +0200, Magnus Hagander wrote:
> > 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 y
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.___record_main). is the primary key (all
tables
(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
eventlog_partition.___record_m
=?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 localiz
--- [EMAIL PROTECTED] wrote:
> 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
>
I posted on this list with this yahoo.com address and now receive
upwards of 30-40 spam emails per
-Original Message-
From: Együd 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
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
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
> 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 se
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 m
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
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 li
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:
http://www.postgresql
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
>
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 when
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 fore
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
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 IN
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 look
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 ts
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
T
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 fou
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 rac
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 1
57 matches
Mail list logo
