On Wed, Mar 08, 2006 at 03:03:22PM -0500, Louis Gonzales wrote:
> Two things come to mind:
> 1) do you have a defined postgresql user "joe" ?
> 2) 192.168.1.11/32 (without looking it up, I'm not sure if you can
> specify the subnetmask, as an alternative to the /DecimalNumber notation)
> This is c
Hi,
How to turn off the double-quoted field names in
pgadmin?
Thanks
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)
On Thu, Mar 09, 2006 at 03:57:46PM +1100, Noel Faux wrote:
> Given that this seems problem has occurred a number of times for a
> number I've written a small step by step procedure to address this
> issue. Is there any other comments you which to add. I was thinking
> that this should be added
Hi Michael,
Haven't tried it yet .. but THANK YOU !
I will try it later today assuming it works it will say us a LOT of
maintenance!
Regards
Paul Newman
-Original Message-
From: Michael Fuhr [mailto:[EMAIL PROTECTED]
Sent: 08 March 2006 23:48
To: Paul Newman
Cc: Louis Gonzales; Sc
Given that this seems problem has occurred a number of times for a
number I've written a small step by step procedure to address this
issue. Is there any other comments you which to add. I was thinking
that this should be added to the FAQ / troubleshooting in the docs.
How to repair corrupte
On Wed, Mar 08, 2006 at 12:56:38 -0300,
Rodrigo Sakai <[EMAIL PROTECTED]> wrote:
> Ok, but actually I'm not concerned about logging old values. I'm concerned
> about checking temporal constraints. Entity Integrity (PK) and Referential
> Integrity (FK).
Did you see the reference to 'Developing
On Thu, Mar 09, 2006 at 12:37:52PM +1100, Noel Faux wrote:
> I've been watching the post: Re: [GENERAL] Fixing up a corrupted toast table
> In there they mention deletion of the bad rows from the table based on
> the citid. If I could come up with a def of a back row, would this
> work, or are t
On Thu, Mar 09, 2006 at 12:29:17PM +1100, Noel Faux wrote:
> Thanks for all your help Michael, we wish to do a vacuum and dump before
> the upgrade to 8.02.
8.0.7 and 8.1.3 are the latest versions in their respective branches;
those are the versions to run to get the latest bug fixes.
> Do you b
Hi,
This is precisely what I'm after .. could you possibly give me an
example ?
Kind Regards
Paul Newman
-Original Message-
From: Jim Nasby [mailto:[EMAIL PROTECTED]
Sent: 08 March 2006 22:18
To: Michael Glaesemann
Cc: Tomi NA; pgsql-general
Subject: Re: [GENERAL] database/schema level
I've been watching the post: Re: [GENERAL] Fixing up a corrupted toast
table
In there they mention deletion of the bad rows from the table based on
the citid. If I could come up with a def of a back row, would this
work, or are there other issues?
Cheers
Noel
Michael Fuhr wrote:
On Thu, M
Hi,guys.Who knows the structure of the pgsql source codes.What
I means is that the content of the source codes and its function.
Thanks a lot
Thanks for all your help Michael, we wish to do a vacuum and dump
before the upgrade to 8.02. Do you believe this data corruption is a
postgres issue of an OS / hardware issue?
Cheers
Noel
Michael Fuhr wrote:
On Thu, Mar 09, 2006 at 11:13:40AM +1100, Noel Faux wrote:
Ok it worke
On Mar 8, 2006, at 3:07 PM, Tom Lane wrote:
Steve Atkins <[EMAIL PROTECTED]> writes:
make it happy by inserting a dummy row into the toast table
(chunk ID
as specified in the error, chunk sequence 0, any old data value).
Any attempt to touch the toast table gives me:
ERROR: cannot change
Hola soy novato en postgres.
Necesito llenar una tabla x con los datos contenidos en un archivo. Estoy utilizando el comando COPY. La cuestión es que no me permite introducir valores nulos en un campo de tipo timestamp, siendo que ya declare el tipo de dicho campo como nulo.
Alguiien sabe de
On Thu, Mar 09, 2006 at 11:13:40AM +1100, Noel Faux wrote:
> Ok it worked but we ran into another bad block :(
> /vacuumdb: vacuuming of database "monashprotein" failed: ERROR: invalid
> page header in block 9022937 of relation "gap"
> /
> So the command we used was:
> dd bs=8k seek=110025 conv=no
Ok it worked but we ran into another bad block :(
vacuumdb: vacuuming of database "monashprotein" failed: ERROR:
invalid
page header in block 9022937 of relation "gap"
So the command we used was:
dd bs=8k seek=110025 conv=notrunc count=1 if=/dev/zero
of=/usr/local/postgresql/postgresql-7.4.8/
On Wed, Mar 08, 2006 at 11:16:55PM -, Paul Newman wrote:
> So how can I get the schema name of the calling table trigger and use it
> in the form of set Search_path at the beginning of the function ?
Here's an example:
CREATE FUNCTION trigfunc() RETURNS trigger AS $$
DECLARE
schemaname t
Hi,
Yes my db is indeed like
dbname.myschema1.sometable
dbname.myschema2.sometable
dbname.myschema2.sometable2
dbname.myschema2.sometable3
Physically all data is in one db .. however each client has there own
schema (or virtual db). Each client schema has identical structure. And
a number of tabl
Steve Atkins <[EMAIL PROTECTED]> writes:
>>> make it happy by inserting a dummy row into the toast table (chunk ID
>>> as specified in the error, chunk sequence 0, any old data value).
> Any attempt to touch the toast table gives me:
> ERROR: cannot change TOAST relation "pg_toast_17410"
Ugh. M
On Feb 17, 2006, at 8:27 AM, Steve Atkins wrote:
On Feb 17, 2006, at 6:29 AM, Tom Lane wrote:
Steve Atkins <[EMAIL PROTECTED]> writes:
pg_dump: ERROR: missing chunk number 0 for toast value 25923965
[snip]
If that doesn't work, the standard technique for locating damaged
data
should
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-general-
> [EMAIL PROTECTED] On Behalf Of Emi Lu
> Sent: Wednesday, March 08, 2006 2:52 PM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] column type varchar(128) not null default '' vs
> varchar(128)
>
> Hello,
>
> Whe
Hello,
When setuping column types, is there the big efficiency difference
between the following two examples?
col varchar(128) NOT NULL default ''
vs.
col varchar(128)
Thanks a lot,
Ying
---(end of broadcast)---
TIP 1: if posting/re
There's nothing like that, but the good news is that you can have
multiple triggers call the same trigger function, and it wouldn't be
*too* hard to script the creation of all those triggers based on the
info in information_schema.tables.
On Mar 8, 2006, at 9:02 AM, Michael Glaesemann wrote
On Mar 7, 2006, at 8:06 PM, David Wall wrote:
I've upgraded from 8.0 to 8.1 and want to be sure I'm making the
changes that are required.
For my backups, I have removed the option --blobs because it says
this is no longer needed. I guess the backup automatically
includes blobs now?
You
On Wed, Mar 08, 2006 at 04:06:55PM -0600, Jim Nasby wrote:
> On Mar 7, 2006, at 4:42 PM, [EMAIL PROTECTED] wrote:
>
> >On Tue, Mar 07, 2006 at 05:36:37PM -0500, Tom Lane wrote:
> >>[EMAIL PROTECTED] writes:
> >>>ALTER TABLE A COLUMN AA ADD CONSTRAINT DELETE ON CASCADE
> >>
> >>You're missing t
On Mar 7, 2006, at 4:42 PM, [EMAIL PROTECTED] wrote:
On Tue, Mar 07, 2006 at 05:36:37PM -0500, Tom Lane wrote:
[EMAIL PROTECTED] writes:
ALTER TABLE A COLUMN AA ADD CONSTRAINT DELETE ON CASCADE
You're missing the specification of the foreign key, not to mention
spelling the CASCADE claus
Richard Huxton writes:
> Matroska80 wrote:
>> Hi i have a problem using tsearch2 with postgresql. Executing:
>> SELECT to_tsquery('default','kj');
>> return a
>> cache lookup failed for function 141542.
> Try the following:
> SELECT oid,* FROM pg_proc WHERE proname='to_tsquery';
> That should sh
=?ISO-8859-1?Q?Poul_M=F8ller_Hansen?= <[EMAIL PROTECTED]> writes:
>> Also, unless you have a really good reason to be using -Ft dump format,
>> I'd recommend -Fc format instead.
> Thanks, it takes much longer time, but the filesize is only 1/5 of the
> tar size, so it's ok.
If you're more conce
On Wed, Mar 08, 2006 at 09:06:36AM -0500, Kenneth Downs wrote:
> If there are triggers writing to %_SHARED within a transaction, and the
> transaction is rolled back, do the changes to %_SHARED roll back also?
What happened when you tried it?
CREATE TABLE foo (id integer, t text, last_t text);
other way is to set
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Session
Manager\Memory Management
bigger values
but to restore a lot of data on windows take so many time
2006/3/8, Tom Lane <[EMAIL PROTECTED]>:
> "Nik" <[EMAIL PROTECTED]> writes:
> > pg_restore: ERROR: out of memory
> > D
Try export TMPDIR=/var/tmp.
Also, unless you have a really good reason to be using -Ft dump format,
I'd recommend -Fc format instead. It's better tested and doesn't suffer
from various limitations of the tar format, notably the need for a temp
file.
Thanks, it takes much longer time,
"Nik" <[EMAIL PROTECTED]> writes:
> pg_restore: ERROR: out of memory
> DETAIL: Failed on request of size 32.
> CONTEXT: COPY lane_data, line 17345022: ""
A COPY command by itself shouldn't eat memory. I'm wondering if the
table being copied into has any AFTER triggers on it (eg for foreign key
Jussi Saarinen <[EMAIL PROTECTED]> writes:
> I can't connect to server1 (7.3.4) using client (8.0.7) at server2.
> I just get error:
> psql: FATAL: No pg_hba.conf entry for host 192.168.1.11, user joe,
> database template1
> Uncommented lines at server1's pg_hba.conf (postgresql service is
> res
Matroska80 wrote:
Hi i have a problem using tsearch2 with postgresql. Executing:
SELECT to_tsquery('default','kj');
return a
cache lookup failed for function 141542.
Try the following:
SELECT oid,* FROM pg_proc WHERE proname='to_tsquery';
That should show whether there is a function with tha
Matroska80 wrote:
Hi i have a problem using tsearch2 with postgresql. Executing:
SELECT to_tsquery('default','kj');
return a
cache lookup failed for function 141542.
(adding to my previous reply)
Or it could be a problem with that OID. Also try:
SELECT oid,* FROM pg_proc WHERE oid=14152;
--
Paul Newman wrote:
Hi,
We run with multiple identical schemas in our db. Each schema actually
represents a clients db. What we'd like to do is have a common schema
where trigger functions and the like are held whilst each trigger
defined against the tables is in there own particular schema. Thi
Paul,
What is the current schema layout for your db instances? I don't think
it's possible to share across db instances like this:
dbname1.myschema.sometable
dbname2.myschema.sometable
But you can share resources of the following type:
dbname.myschema1.sometable
dbname.myschema2.sometable
db
On Tue, Mar 07, 2006 at 06:34:33AM -, Paul Newman wrote:
> However at the moment we are placing the trigger functions within each
> schema along with trigger itself. The reason is that we don't know of a
> function or a variable that says "Give me the schema of the trigger that
> is calling thi
On Wed, 2006-03-08 at 14:32, Louis Gonzales wrote:
> Scott Marlowe wrote:
> > On Wed, 2006-03-08 at 14:19, Louis Gonzales wrote:
> >
> >
> > > Paul,
> > > When you say "multiple identical schemas" are they all separate
> > > explicit schemas? Or are they all under a general 'public' schema.
>
Scott Marlowe wrote:
On Wed, 2006-03-08 at 14:19, Louis Gonzales wrote:
Paul,
When you say "multiple identical schemas" are they all separate
explicit schemas? Or are they all under a general 'public' schema.
>From my understanding, when you create a new db instance, it's under
t
Nik wrote:
I am running PostgreSQL 8.1.3 on Windows 2003 Server.
I am trying to transfer the data from a table in db1on one machine to a
table in db2 on a different machine. The table size is about 22Gb
(about 280 million rows).
I was trying to do it by generating a backup file of the table in
On Wed, 2006-03-08 at 14:19, Louis Gonzales wrote:
> >
> Paul,
> When you say "multiple identical schemas" are they all separate
> explicit schemas? Or are they all under a general 'public' schema.
> From my understanding, when you create a new db instance, it's under
> the public level schema b
Paul Newman wrote:
Hi,
We run with
multiple identical schemas in our db.
Each schema actually represents a clients db. What we’d like to do is
have a common schema where trigger functions and the like are held
whilst each
trigger defined against the tables is in there own part
Jussi Saarinen wrote:
I have following environment:
Server1, rh9, ip:192.168.1.10:
postgresql-7.3.4-3.rhl9
postgresql-libs-7.3.4-3.rhl9
postgresql-server-7.3.4-3.rhl9
postgresql-jdbc-7.3.4-3.rhl9
Server2, fc4, ip:192.168.1.11:
postgresql-libs-8.0.7-1.FC4.1
postgresql-8.0.7-1.FC4.1
postgresql-s
On Wed, Mar 08, 2006 at 09:16:54AM -0500, Emi Lu wrote:
> In PostgreSQL 8.0.1 (plpgsql), I was trying to use array in the trigger
> function.
>
> DECLARE
> clear_id_colValueArrVARCHAR[100];
> BEGIN
> clear_id_colValueArr[1] := NEW.clear_id1;
> clear_id_colValueArr[2] := NEW.
Hi,
We run with multiple identical schemas in our db.
Each schema actually represents a clients db. What we’d like to do is
have a common schema where trigger functions and the like are held whilst each
trigger defined against the tables is in there own particular schema. This would
mean
Hi i have a problem using tsearch2 with postgresql. Executing:
SELECT to_tsquery('default','kj');
return a
cache lookup failed for function 141542.
But it's strange this happens now but not before and nothing has done on
database...some data break with tsearch2?
I am using postgres 7.4.6 and no
I am running PostgreSQL 8.1.3 on Windows 2003 Server.
I am trying to transfer the data from a table in db1on one machine to a
table in db2 on a different machine. The table size is about 22Gb
(about 280 million rows).
I was trying to do it by generating a backup file of the table in db1
and resto
I have following environment:
Server1, rh9, ip:192.168.1.10:
postgresql-7.3.4-3.rhl9
postgresql-libs-7.3.4-3.rhl9
postgresql-server-7.3.4-3.rhl9
postgresql-jdbc-7.3.4-3.rhl9
Server2, fc4, ip:192.168.1.11:
postgresql-libs-8.0.7-1.FC4.1
postgresql-8.0.7-1.FC4.1
postgresql-server-8.0.7-1.FC4.1
postg
On Wednesday 08 March 2006 11:59, Eduardo Muñoz wrote:
> statement.setObject(2, null);
> statement.setObject(3, null);
You need to use setNull( 2, Types.WHATEVER ).
--
--
Jan de Visser [EMAIL
On Wed, Mar 08, 2006 at 09:10:39AM -0800, [EMAIL PROTECTED] wrote:
> I have the lat and long data. I have created the geom column based on the
> lat and long data as below.
>
>
> UPDATE property SET geom =GeometryFromText('POINT(' || long ||
> ' ' || lat || ')',4326);
This looks like Po
There is the earthdistance package in the contrib directory. You may want to
look into that.
On Wednesday 08 March 2006 09:10, [EMAIL PROTECTED] wrote:
> I have the lat and long data. I have created the geom column based on the
> lat and long data as below.
>
>
> UPDATE property SET geom =Ge
> I am calculating the distance as below
>
> select distance(geom1, geom2)* 69.055
>
>
> It seems to be right. But I want to make sure.
One way to calculate is the Great Circle Distance, that's the way the FCC
(Federal Communications Commission) uses to calculate distance between two
Radio Stati
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
I have the lat and long data. I have created the geom column based on the
lat and long data as below.
UPDATE property SET geom =GeometryFromText('POINT(' || long ||
' ' || lat || ')',4326);
Now I have the geom columns in two tables
I am calculating the distance as below
select distan
Hi, I'm trying to make a PL/pgSQL function to update
or insert if the row is not present. I tested the
function and it works fine, but when I call it through
JDBC, it executes, but the row is not inserted or
updated. This is my JDBC code.
try{
connection.setTransactionIsolation
Emil Rachovsky <[EMAIL PROTECTED]> writes:
> I'm transfering data between postgre 8.0 and 8.1 using
> pg_dump and pg_restore, but I get "x errors ignored on
> restore". What could be the reason ?
If you aren't going to show us what the errors were, how can we guess?
rega
Hi,
maybe you got some languages like plpgsql already installed?
Thats something pg_restore doesn't really bother.
regards
Hakan Kocaman
Software-Development
digame.de GmbH
Richard-Byrd-Str. 4-8
50829 Köln
Tel.: +49 (0) 221 59 68 88 31
Fax: +49 (0) 221 59 68 88 98
Email: [EMAIL PROTECTED]
Emil Rachovsky wrote:
Hi,
I'm transfering data between postgre 8.0 and 8.1 using
pg_dump and pg_restore, but I get "x errors ignored on
restore". What could be the reason ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protec
Hi,
I'm transfering data between postgre 8.0 and 8.1 using
pg_dump and pg_restore, but I get "x errors ignored on
restore". What could be the reason ?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.y
Ok, but actually I'm not concerned about logging old values. I'm concerned
about checking temporal constraints. Entity Integrity (PK) and Referential
Integrity (FK).
For example, if you have the salary table:
Salary (employee_id, salary, start_date, end_date)
Where [star_date, end_date]
Hello Simon, sorry for the late answer! What I really need is a temporal
database that can check some temporal constraints, like, imagine you have
two tables:
employee (emp_id, name, address, start_date, end_date)
where [start_date, end_date] is the period that the employee worked or still
"surabhi.ahuja" <[EMAIL PROTECTED]> writes:
> i have a field whose type is varchar(16)
> and the field is multivalued, in the sense it is of the form
> abc\def\tez
> (i.e. backslash separed values)
To be blunt, this is a really poorly-chosen data representation.
To point out just one problem, ba
Please remember to cc the list. I'm forwarding this to the list in
case someone has any suggestions.
On Mar 8, 2006, at 23:53 , Tomi NA wrote:
On 3/8/06, Michael Glaesemann <[EMAIL PROTECTED]> wrote:
On Mar 8, 2006, at 22:11 , Tomi NA wrote:
> Does anything like that exist in postgresql?
> I
Hello,
In PostgreSQL 8.0.1 (plpgsql), I was trying to use array in the trigger
function.
DECLARE
clear_id_colValueArrVARCHAR[100];
BEGIN
clear_id_colValueArr[1] := NEW.clear_id1;
clear_id_colValueArr[2] := NEW.clear_id2;
clear_id_colValueArr[3] := NEW.clear_id3;
...
If there are triggers writing to %_SHARED within a transaction, and the
transaction is rolled back, do the changes to %_SHARED roll back also?
If not then I assume I should manually clear it at the start of
transactions, no?
begin:vcard
fn:Kenneth Downs
n:Downs;Kenneth
email;internet:[EMAIL P
On Mar 8, 2006, at 22:11 , Tomi NA wrote:
Does anything like that exist in postgresql?
It'd rid me of a whole lot of work if it did...and I'd still have
plenty more to keep me busy. :)
What do you mean by database/schema level triggers? Could you give an
example of what you're trying to d
Does anything like that exist in postgresql?It'd rid me of a whole lot of work if it did...and I'd still have plenty more to keep me busy. :)TIA,Tomislav
On Wed, Mar 08, 2006 at 03:13:40PM +0530, surabhi.ahuja wrote:
> please tell me is there any operator available which enables me to do the
> following:
>
> field contains
>
> eg field contains "abc" should return true, similary for def or tez
See "Pattern Matching" in the "Functions and Oper
On mið, 2006-03-08 at 15:13 +0530, surabhi.ahuja wrote:
>
> if it is not ther can i write my own operators? abd use them please
> send me the link where i can find documnetation on the same
http://www.postgresql.org/docs/8.1/interactive/extend.html
http://www.postgresql.org/docs/8.1/interactive/
i have a field whose type is varchar(16)
and the field is multivalued, in the sense it is of
the form
abc\def\tez
(i.e. backslash separed values)
please tell me is there any operator available
which enables me to do the following:
field contains
eg field contains "abc" should return
71 matches
Mail list logo
