On Jun 11, 2005, at 5:28 AM, David Siebert wrote:
Quick question. can you set timestamptz to no fractional seconds?
The docs are very useful for things like this:
http://www.postgresql.org/docs/7.4/interactive/datatype-datetime.html
-
Name timestamp [ (p) ] times
I was usleeping in tiny increments in each iteration of the loop. I
didn't try break it into iterative groups like this.
Honestly, I'd prefer to see pg_autovacuum improved to do O(n) rather
than O(n^2) table activity. At this point, though, I'm probably not
too likely to have much time to h
- Original Message -
From: "Eric E" <[EMAIL PROTECTED]>
To:
Sent: Friday, June 10, 2005 7:24 PM
Subject: [GENERAL] return next and pl/perl
Hi all,
I'm working on implementing a function in PL/PERL that will ready
many rows. As such I'd like to use return_next to keep memory usa
Hi all,
I'm working on implementing a function in PL/PERL that will ready
many rows. As such I'd like to use return_next to keep memory usage
down. When I call return next, I get the following error message:
ERROR: error from Perl function: Can't call method "return_next" on
unblessed r
It's doing something in slony. Part of the initial sync operation I
guess. I guess it must be doing an alter table or reindex or something.
I don't understand why though.
I'll repeat my question on the slony mailing list. Thanks for the
response.
__
Marc
On Fri, 2005-06-10 at 18:48 -0400, Tom
On Fri, Jun 10, 2005 at 10:38:52AM -0500, Peter Fein wrote:
> This is interesting... You'd want to be able to generate either a bunch
> of CREATEs to create a schema from scratch or a 'patch' of ALTER
> commands to move b/w arbitrary revisions or to a working copy (ie, a
> live DB). This implies
Marc Munro <[EMAIL PROTECTED]> writes:
> Can someone explain this? I seem to have a query which is being blocked
> by a lock. I was under the impression that selects are never blocked.
AccessExclusiveLock blocks anything.
> A query of blocking locks shows this:
> object | t
Marc Munro wrote:
Can someone explain this? I seem to have a query which is being blocked
by a lock. I was under the impression that selects are never blocked.
Am I missing something or is this bad behaviour?
Do you happen to be running a vacuum full?
I am using slony and am synchronising
Can someone explain this? I seem to have a query which is being blocked
by a lock. I was under the impression that selects are never blocked.
Am I missing something or is this bad behaviour?
I am using slony and am synchronising a slave for the first time. In
the hope of seeing some progress on
No, I haven't tried that - I wasn't aware of pg_filedump. What's tricky
is that when the build detects a failure, it deletes the output
directory (so we don't get left with a half-built db) so I'll have to
fiddle with it
I just downloaded pg_filedump from the redhat site, so I'll play around
w
I just noticed that SRA has English language certification now,
available at a nationwide testing center. That's cool. Only the
"Silver" is in English so far, the Gold looks more interesting.
There is no syllabus or books that I could find, but I am taking the
test next wednesday. I'll let you
It is likely if the foreign key was in a base table.
:)
Fairly new with PG and missed this minor but
significant detail (keys not inherited)
--- Tom Lane <[EMAIL PROTECTED]> wrote:
> H Hale <[EMAIL PROTECTED]> writes:
> > I have created a new data type using CREATE TYPE.
> > Foreign keys const
"David Parker" <[EMAIL PROTECTED]> writes:
> The error only happens intermittently, but every occurrence is
> consistent:
>
> 1) always the same index - "attribute_pkey" on our "attirbute" table
> - one created implicitly by a primary key constraint
> 2) the error happens during a vacuum co
Am Freitag, den 10.06.2005, 08:42 +0400 schrieb go:
> Hi,
>
> Help me please to resolve the problem:
> Just After commiting transaction - writing ,say 90 rows,I try to select
> the same 90 rows - and get wrong set of rows (some of them: 1-2 replaced
> by unknown data). But after 10-20 seconds the
We are getting the
"index xyz is not a btree" error pretty frequently in our build system (in which
we build several databases). This is with 8.0.1 on Solaris 9/intel. During a
database build we create the database, import metadata, import some application
data, then finally run a vacuum on
John DeSoi wrote:
On Jun 10, 2005, at 11:38 AM, Peter Fein wrote:
This would obviously have to be pretty damn clever. Amongs the
difficulties would be ensuring that the patch applies changes in the
correct order (e.g. add column before adding foreign key). It's hard,
but I don't believe it's
H Hale <[EMAIL PROTECTED]> writes:
> I have created a new data type using CREATE TYPE.
> Foreign keys constaints are not being respected with
> columns using the new type.
That hardly seems likely. I'd look for bugs in your comparison
functions ;-)
regards, tom lane
Hello,
I have created a new data type using CREATE TYPE.
Foreign keys constaints are not being respected with
columns using the new type. As far as I can tell the
new type is working correctly except for foreign keys.
May be I have missed something when defining the new
type. Is there something sp
On Jun 10, 2005, at 12:02 PM, Bruce Momjian wrote:
Hrishikesh Deshmukh wrote:
Hi All,
Is there a way that makes it possible to export sql query results as
a xml file?
I use postgres 7.4.7 on a debian system. Do i need any packages to
export query results as a xml file if its possible?
No,
On Jun 10, 2005, at 11:38 AM, Peter Fein wrote:
This would obviously have to be pretty damn clever. Amongs the
difficulties would be ensuring that the patch applies changes in the
correct order (e.g. add column before adding foreign key). It's hard,
but I don't believe it's impossible.
As a
Just did a sanity check. I dumped the DB schema, and there is indeed a
foreign key reference into the table. Now interestingly, the table
pointing in has no index on the column, but is a relatively small table
with only entries near the end of the large table.
So looks like I was getting CPU bound
Edmund Dengler <[EMAIL PROTECTED]> writes:
> This table has 3 foreign keys, but that should not matter during deletes.
Richard was inquiring about foreign keys linking *into* this table, not
out of it.
In particular, foreign keys that don't have indexes on the referencing
columns; those will incu
I have tried to do an update to Postgresql 8.0.3 and got an error saying
this package targets the 686!
I am trying to install it on a celeron 733 for a test machine which last
time I checked was a 686.
Any suggestions besides using a tar ball?
By any chance has 8.0.3 made it into a YUM repositor
Hrishikesh Deshmukh wrote:
> Hi All,
>
> Is there a way that makes it possible to export sql query results as a xml
> file?
> I use postgres 7.4.7 on a debian system. Do i need any packages to
> export query results as a xml file if its possible?
No, we have discussed it but it seems there is no
Hi All,
Is there a way that makes it possible to export sql query results as a xml file?
I use postgres 7.4.7 on a debian system. Do i need any packages to
export query results as a xml file if its possible?
Thank you
Hrishi
---(end of broadcast)--
This table has 3 foreign keys, but that should not matter during deletes.
In addition, the tables being referred to are small, and should be in
cache.
I'm talking about FK that point this table... Not FK defined for this
table that point to other table. If Table A is referenced by 10 other
Russ Brown wrote:
> On 6/9/05, elein <[EMAIL PROTECTED]> wrote:
>
>>On Thu, Jun 09, 2005 at 04:16:46PM -0500, John Browne wrote:
>>
>>>How would you handle the migration of the data with these user
>>>scripts? Dump it to a temp table?
>>>
>>
>>If your scripts are correct, you should be able to lo
Greetings!
This table has 3 foreign keys, but that should not matter during deletes.
In addition, the tables being referred to are small, and should be in
cache.
There are no tables depending on it for references, so no dependent
triggers should be running.
Also, if this was a foreign key issue,
Edmund Dengler wrote:
Greetings!
We have a table with more than 250 million rows. I am trying to delete the
first 100,000 rows (based on a bigint primary key), and I had to cancel
after 4 hours of the system not actually finishing the delete. I wrote a
script to delete individual rows 10,000 at
Hi,
You have any foreign keys pointing this table ? That's the problem I
got when I wanted to delete all rows from a table with 5 FK. You may
search my name in the list archive and found the thread on this matter.
Ciao
/David
Edmund Dengler wrote:
Greetings!
We have a table with more
Greetings!
We have a table with more than 250 million rows. I am trying to delete the
first 100,000 rows (based on a bigint primary key), and I had to cancel
after 4 hours of the system not actually finishing the delete. I wrote a
script to delete individual rows 10,000 at a time using transaction
--- "Thomas F. O'Connell" <[EMAIL PROTECTED]> wrote:
> Phil,
>
> If you complete this patch, I'm very interested to see it.
>
> I think I'm the person Matthew is talking about who inserted a sleep
>
> value. Because of the sheer number of tables involved, even small
> values of sleep cause
Title: RE: [GENERAL] return two elements
I don't know that it happens with my email I will change the email of my subscription.
The examples are very interesting for my, and Alvaro Herrera's comments too.
In reference to INOUT/OUT params and return a set I have a doubt: I will be able to r
Ilja Golshtein wrote:
> Hi!
>
> >Done. Here is the patch (against CVS tip, but it should apply with
> >some fuzz in 8.0 or 7.4).
>
> Is this patch about CREATE TEMP TABLE AS SELECT only,
> or about SELECT INTO TEMP TABLE as well?
It should handle both because internally they are the same.
--
On Fri, Jun 10, 2005 at 12:27:32 +0200,
Dawid Kuroczko <[EMAIL PROTECTED]> wrote:
>
> In other words -- doing such a one row select means scanning the
> whole partitioned data. the primaryindex on logid is not used
> anywhere. Creating view (SELECT * UNION ALL SELECT * UNION ALL)
> does no
Thanks Tom... this reports that there were modifications to the tsearch2
functions. But this is how I worked around the restore problem, for
anyone that has similar issues:
1. pg_dump the 8.0.1 database in archive format.
2. Create an empty database on the 8.0.3 server
3. Run the contrib/tsearc
Hi Tom,
This sounds like the same "problem" which prevented PG from using the
indices, and thus giving abyssmal performance in this other thread:
I have two BIG tables (virtually identical) with 3 NOT NULL columns
Station_id, TimeObs, Temp_, with unique indexes on (Station_id,
TimeObs) a
try this,
test=# select array(select 1 from
generate_series(0,array_upper('{1,2,3,4,5}'::int[],1)));
?column?
---
{1,1,1,1,1,1}
(1 row)
test=# select array(select true from
generate_series(0,array_upper('{1,2,3,4,5}'::int[],1)));
?column?
---
{t,t,t,t,t,t}
(1 row
Am Freitag, den 10.06.2005, 16:15 +0530 schrieb Dinesh Pandey:
> In short, a "superuser" is a user who can create other users.
> But if the user is not super user, he is not allowed to install the
> language 'plpgsql' and 'pltcl' for database.
> But my problem was the language is already installe
Am Freitag, den 10.06.2005, 11:51 +0100 schrieb Richard Huxton:
> Tino Wildenhain wrote:
> >
> > No :-) But if you are able to create databases, you are a superuser :-)
> > And as a superuser you can also create the untrusted functions.
>
> Not quite - if you can create USERS you are a superuser.
FYI:
http://www.fabalabs.org/research/papers/FabalabsResearchPaper-OSDBMS-Eval.pdf
Jochem
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
Tino Wildenhain wrote:
No :-) But if you are able to create databases, you are a superuser :-)
And as a superuser you can also create the untrusted functions.
Not quite - if you can create USERS you are a superuser.
--
Richard Huxton
Archonet Ltd
---(end of broadc
On Thu, Jun 09, 2005 at 06:10:28PM -0700, Otto Blomqvist wrote:
>
> Is there any way to set all elements in a long boolean array (bool[]) to
> the same value ?
In PostgreSQL 7.4 and later you could write a polymorphic function
to fill any type of array. Here's a simple example that handles
one-
In
short, a "superuser" is a user who can create other users.
But if the user is not super user, he is
not allowed to install the language 'plpgsql' and 'pltcl' for database.
But my problem was the language is already
installed but getting error on creation of the function.
And
Am Freitag, den 10.06.2005, 15:21 +0530 schrieb Dinesh Pandey:
> Hi Richard/ Michael
>
>
>
> Thanks for your great help.
>
>
>
> I got the problem.
>
>
>
> Actually, I was not getting the cause of this problem, because it was
> working properly at our end.
>
>
>
> Actually this prob
On Jun 10, 2005, at 5:51 AM, Dinesh Pandey wrote:
Hi Richard/ Michael
Thanks for your great help.
I got the problem.
Actually, I was not getting the cause of this problem, because it was
working properly at our end.
Actually this problem occurs when the function is being created by t
On Jun 10, 2005, at 7:26 PM, Michael Glaesemann wrote:
On Jun 10, 2005, at 6:51 PM, Dinesh Pandey wrote:
Actually this problem occurs when the function is being created by
the user who has not created the current database.
Solution: The database must be created by the user who is creati
Hello.
I've tried data partitioning using INHERITS mechanism (pgsql 8.0.3).
The schema looks like this:
CREATE TABLE log (
logid integer NOT NULL PRIMARY KEY,
logdate timestamp(0) without time zone NOT NULL,
typeid integer NOT NULL,
ip inet,
[.]
)
On Jun 10, 2005, at 6:51 PM, Dinesh Pandey wrote:
Actually this problem occurs when the function is being created by
the user who has not created the current database.
Solution: The database must be created by the user who is creating
the pltcl function? Right
This is a coincidence.
Onl
Dinesh Pandey wrote:
Hi Richard/ Michael
Thanks for your great help.
I got the problem.
Actually, I was not getting the cause of this problem, because it was
working properly at our end.
Actually this problem occurs when the function is being created by the user
who has not created the curren
Don't forget to cc: the list.
jeremy ` wrote:
yea sory I an using pgadmin3, and thats the prog that I'm not sure how
to set foriegn keys with.
OK - to make a foreign key where bar.foo_ref references foo.foo_id you
should do the following:
1. Select table "bar" then "constraints"
2. Right-cli
Hi
Richard/ Michael
Thanks
for your great help.
I
got the problem.
Actually,
I was not getting the cause of this problem, because it was working properly at
our end.
Actually this problem occurs when the
function is being created by the user who has not created the current d
On Tue, Jun 07, 2005 at 04:01:02PM -0700, Ian Burrell wrote:
>
> CREATE OR REPLACE FUNCTION test_date_time_exists() RETURNS BOOLEAN AS '
> BEGIN
> RETURN EXISTS (
> SELECT * FROM pg_class
> WHERE relname = ''test_date_time''
> AND pg_table_is_visibl
>
OR
>
3. Problem With Database user permission?
Only
a superuser can create a pltclu function. "dbUSER" must be a
PostgreSQL
superuser if it created the pltclu function. You client
must
use a PostgreSQL superuser to create a pltclu function.
What do mean with super user. The
Sorry I didn't get it exactly. Because the same function (send e-mail) I am
able to create at my end, but our client is not able to create it at their
end.
1. Is there some problem in installation?
Or
2. Problem with system user permission executing that database?
OR
3. Problem With Database use
Dinesh Pandey wrote:
Sorry I didn't get it exactly. Because the same function (send e-mail) I am
able to create at my end, but our client is not able to create it at their
end.
1. Is there some problem in installation?
2. Problem with system user permission executing that database?
3. Problem Wi
On Jun 10, 2005, at 5:38 PM, Dinesh Pandey wrote:
Sorry I didn't get it exactly. Because the same function (send e-
mail) I am
able to create at my end, but our client is not able to create it
at their
end.
1. Is there some problem in installation?
No.
Or
2. Problem with system user per
Dinesh Pandey wrote:
I have installed the Postgres from "postgres" user with pltcl option and
able to create these function with another dbUSER successfully and never get
this error.
But our client is getting this error, How to solve it now? Any Idea?
If you created an untrusted function as us
I
have installed the Postgres from “postgres” user with pltcl option and able to
create these function with another dbUSER successfully and never get this error.
But
our client is getting this error, How to solve it now? Any Idea?
Thanks
Dinesh
Pandey
-Original
Message--
On Jun 10, 2005, at 4:10 PM, Dinesh Pandey wrote:
I am using Postgres-.8.0.1.
I am creating a function with ‘pltclu’ language. I have already
created database with ‘pltclu’language. But on creation this
function I am getting this error and failed to create this function
Hi,
I am using Postgres-.8.0.1.
I am creating a function with ‘pltclu’ language. I have already created
database with ‘pltclu’
language. But on creation this function I am getting this error and failed to create
this function
-
ERROR: Permission denied for
Help! I have a similar problem. Does anybody know how to solve a problem2005/6/8, Ian Burrell <[EMAIL PROTECTED]>:
We have some functions which need to dynamically create a temporarytable if it does not already exist. We use the following function:CREATE OR REPLACE FUNCTION test_date_time_exists()
62 matches
Mail list logo
