I found this short discussion between Tom and Bruce, but that's about
it for autovacuum logging.
http://archives.postgresql.org/pgsql-general/2006-04/msg00489.php
It just seems like the processing database log statement should be
set to a lower level, since it just logs every time
It seems that all the postgresql mailing lists don't allow you to
automatically reply to the list only the sender. I don't get this with
all my other mailings list. Who I contact to have this rectified?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
On 4/26/06, chris smith [EMAIL PROTECTED] wrote:
Table joins can only be done against another table field, I don't
think you can do it using an expression like this. That should all be
in the where clause.
What do the timesheets and dummy_records tables look like?
timesheets.weekending is a
Seems like the problem has something to do with date arithmetic. I
can't seem to add an integer expression to a date constant. It works
if I add a integer constant to a date constant, but that's not what I
want. I tried cast(expression as integer) + date '2006-04-09' but I
get 'ERROR: operator
On Thu, 27 Apr 2006, Chris Velevitch wrote:
It seems that all the postgresql mailing lists don't allow you to
automatically reply to the list only the sender. I don't get this with
all my other mailings list. Who I contact to have this rectified?
What do you mean? Do you mean a Reply-To:
Chris Velevitch wrote:
It seems that all the postgresql mailing lists don't allow you to
automatically reply to the list only the sender. I don't get this
with all my other mailings list. Who I contact to have this
rectified?
Done on purpose. Use reply to all.
--
Guy Rouillier
On 4/27/06, Marc G. Fournier [EMAIL PROTECTED] wrote:
What do you mean? Do you mean a Reply-To: header added? If so, check out
the help docs, but there is a 'set replyto' you can add that will have it
added for your email address, without affecting everyone that doesn't want
it ...
help
On 4/27/06, Guy Rouillier [EMAIL PROTECTED] wrote:
Done on purpose. Use reply to all.
Isn't that a bad habit to get into? There's been a lot of press about
people who habitually reply all.
Besides, isn't the point of a mailing list is that it's a global
public discussion on a topic in which
On Thu, 27 Apr 2006, Chris Velevitch wrote:
In addition, it's not the norm. I subscribe to lots of mailing lists
and postgresql.org lists are the only ones that I've seem do that.
So what's the reasoning behind this choice?
http://www.unicom.com/pw/reply-to-harmful.html
Kris Jurka
On Thu, Apr 27, 2006 at 05:34:11PM +1000, Chris Velevitch wrote:
In addition, it's not the norm. I subscribe to lots of mailing lists
and postgresql.org lists are the only ones that I've seem do that.
So what's the reasoning behind this choice?
All sorts of reasons. One of the main ones
Hello,
I use postgres 8.1 and trie to run jboss over sequoia-ha
(http://sequoia.continuent.org/HomePage). But i have an problem with sequences.
Sequoia claims to support for good reasons and db-independece only
sql-standard(s). Therefore they DON'T support the postgres-specific select
If a transaction inserts rows to two tables will a procedure invoked by
an after insert on each row trigger on one table see all the records
inserted in the other table?
In other words - will the transaction run completely before the trigger
is fired?
Thanks for the help.
Balázs
On Thu, 27 Apr 2006, Schnabl, Sebastian wrote:
Hello,
I use postgres 8.1 and trie to run jboss over sequoia-ha
(http://sequoia.continuent.org/HomePage). But i have an problem with
sequences. Sequoia claims to support for good reasons and db-independece
only sql-standard(s). Therefore
On 4/27/06, Kris Jurka [EMAIL PROTECTED] wrote:
In addition, it's not the norm. I subscribe to lots of mailing lists
and postgresql.org lists are the only ones that I've seem do that.
So what's the reasoning behind this choice?
http://www.unicom.com/pw/reply-to-harmful.html
The author
I am curious, whether is it possible to connect to a PostgreSQL database
installed on WinXP for an application installed on the same box but running
in the Cygwin environment (the app. is the GRASS GIS).
many thanx
Tomas
---(end of broadcast)---
On 4/27/06, Tomas Lanczos [EMAIL PROTECTED] wrote:
I am curious, whether is it possible to connect to a PostgreSQL database
installed on WinXP for an application installed on the same box but running
in the Cygwin environment (the app. is the GRASS GIS).
There are no reasons why this shouldn't
On 4/27/06, Martijn van Oosterhout kleptog@svana.org wrote:
Fortunatly we have a mailing list manager that allows you to choose
which way you want it.
Please explain what you mean by this?
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
On Thu, Apr 27, 2006 at 06:59:19PM +1000, Chris Velevitch wrote:
On 4/27/06, Martijn van Oosterhout kleptog@svana.org wrote:
Fortunatly we have a mailing list manager that allows you to choose
which way you want it.
Please explain what you mean by this?
Go to the archives:
On Thu, Apr 27, 2006 at 01:34:06AM -0700, SunWuKung wrote:
If a transaction inserts rows to two tables will a procedure invoked by
an after insert on each row trigger on one table see all the records
inserted in the other table?
That's the idea.
In other words - will the transaction run
On 4/27/06, Martijn van Oosterhout kleptog@svana.org wrote:
Go to the archives:
http://archives.postgresql.org/pgsql-general/
Select To subscribe or unsubscribe
Goto Sign-in and Sign in
Goto Unsubscribe or Change Settings and tick (I beleive) replyto.
Have a nice day,
Thanks for that
-Disk 2: If the transaction log dies, all changes since the last checkpoint are lost, right?Again, if I set up an empty pg_xlog
directory somewhere else, the DB should run just fine, right?No, because there's no way to know what state the data pages are in.Data may have made it to disk, may not
Hi all,
I need some help to create types to use
in a table. For exemple, I want tocreate:
CREATE TYPE salary_type (
value
NUMERIC(10,2),
date DATE
)
CREATE TABLE employee (
num_employee
INT,
name VARCHAR(60),
salary salary_type
)
I know I need two functions written in C
You can have a looks at http://www.postgresql.org/docs/8.1/static/sql-createtype.htmlRegards/Shoaib
On 4/27/06, Rodrigo Sakai [EMAIL PROTECTED] wrote:
Hi all,
I need some help to create types to use
in a table. For exemple, I want tocreate:
CREATE TYPE salary_type (
value
Bert wrote:
This rule is creating first of all the insert and then i can run an
Update on this insert, so far its functioning. Your definition is quite
good but what are doing when you change the table definition? Rewrite
all Rules?
I actually use a data dictionary processor that
Connection conn = ...
CallableStatement cs = conn.prepareCall({? = call
nextval('seq_nm')}); cs.registerOutParameter(1, Types.BIGINT);
cs.execute(); long nextval = cs.getLong(1); cs.close();
Yeah, it seems to work, if i change the definition for calling the sequence in
conjunction with
Chris Velevitch wrote:
On 4/27/06, Guy Rouillier [EMAIL PROTECTED] wrote:
Done on purpose. Use reply to all.
Isn't that a bad habit to get into? There's been a lot of press about
people who habitually reply all.
Besides, isn't the point of a mailing list is that it's a global
public
On Thu, Apr 27, 2006 at 17:34:11 +1000,
Chris Velevitch [EMAIL PROTECTED] wrote:
On 4/27/06, Guy Rouillier [EMAIL PROTECTED] wrote:
Done on purpose. Use reply to all.
Isn't that a bad habit to get into? There's been a lot of press about
people who habitually reply all.
Reply all is the
On Thu, Apr 27, 2006 at 17:22:09 +1000,
Chris Velevitch [EMAIL PROTECTED] wrote:
On 4/27/06, Marc G. Fournier [EMAIL PROTECTED] wrote:
What do you mean? Do you mean a Reply-To: header added? If so, check out
the help docs, but there is a 'set replyto' you can add that will have it
added
On Thu, Apr 27, 2006 at 18:44:25 +1000,
Chris Velevitch [EMAIL PROTECTED] wrote:
One day I accidentally sent a private, personal reply out over one of
my own damn lists.
It's like he accidentally drove down a one way street in the wrong
direction, so he now drives everywhere in reverse,
On Thu, Apr 27, 2006 at 16:55:22 +1000,
Chris Velevitch [EMAIL PROTECTED] wrote:
Seems like the problem has something to do with date arithmetic. I
can't seem to add an integer expression to a date constant. It works
if I add a integer constant to a date constant, but that's not what I
want.
All opinions here sound good so I decided to use only one db engine
(PostgreSQL 8.1) and two databases; now I must tune my database
generator parameters (I use PowerDesigner by Sybase) in order to
work-arround the pg's identifier case sensitivity (newsgroups app (php
scripts) doesn't use quotes
I have a comments on tables in my database.
e.g. COMMENT ON TABLE my_schema.my_table IS 'Employee Information';
I know you can get comments using \d+
Is there a way to select comments?
Reason: I do a lot of perl interfaces. I find escape commands do not
work using DBI.
Thanks,
Ari
Yes, I read this opinion that MySQL is only sql interface to filesystem
:-)
I plan to use win1250 encoding because this is native czech windows
encoding (I do not understand why M$ invents the wheel and invents new
code pages (cp1250) although the code page latin2 was here all the
time). BTW
try:
select tax_code from warehouse.sec_trans group by tax_code
there was a discussion about this on the pgsql-performance a while back:
http://archives.postgresql.org/pgsql-performance/2004-10/msg00053.php
-ae
On Apr 25, 2006, at 4:10 PM, Tony Caduto wrote:
select DISTINCT tax_code from
I'm trying to set up PG, and am curious about the failure scenarios of
Postgres with respect to crashed disks. In a given Postgres
installation across many disks, which sections of Postgres can fail
gracefully (i.e. the customer data is safe and the installation can
be recreated without backups)?
[EMAIL PROTECTED] (Scott Marlowe) writes:
About the security thing. Security is a process, and you won't get
it from using two different database engines.
I'd argue that security is an emergent property which is either
supported by or undermined by particular
In article [EMAIL PROTECTED],
Jim C. Nasby [EMAIL PROTECTED] wrote:
% Keep reading... from the same paragraph:
%
% Clustering is a one-time operation: when the table is subsequently
% updated, the changes are not clustered.
But this isn't really relevant to the question. More to the point
is
Help! I was trying to make an installation of PHP 5.1.2 + Apache
2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I
got PHP to work with Apache quite smoothly, so did I marry PHP with
PostgreSQL - scripts connecting to the database work fine from
windows command line, except that
It is a possible?
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
P G wrote:
I have recently switched to Kubuntu and I just installed Postgres on
it. The installation was successful.
When I try psql, I get this error message, though:
% psql postgres
Error: You must install at least one postgresql-client-version package.
But I have installed
Richard Huxton wrote:
alexandre - aldeia digital wrote:
Hi,
If I do:
pg_dump -Fc -t TABLE database table-custom.sql
The pg_dump returns the DDL of the table, the data and the DDL for
indexes and PK. If I use -s, only the structure is returned but it's
include all elements.
But if I
On Apr 24, 2006, at 9:37 AM, Claudio Tognolo wrote:I am developing a temporal database and I have the necessity to control the integrity constraints befor the commit of the transiction.I cannot use the deferrable checking because the integrity constraints is a select and i cannot use the trigger
On Apr 26, 2006, at 3:17 AM, Teodor Sigaev wrote:
We knows installation of tsearch2 working with 4 millions docs.
What are the design goals for the size of the source tables? My
engineers are telling me of things their friends have tried and have
hit limits of tsearch2. One was
On Thu, 27 Apr 2006, Vivek Khera wrote:
On Apr 26, 2006, at 3:17 AM, Teodor Sigaev wrote:
We knows installation of tsearch2 working with 4 millions docs.
What are the design goals for the size of the source tables? My engineers
are telling me of things their friends have tried and have
Chris Velevitch [EMAIL PROTECTED] writes:
In addition, it's not the norm. I subscribe to lots of mailing lists
and postgresql.org lists are the only ones that I've seem do that.
You may think it's not the norm, but you're mistaken. This is how the
PG lists are run, as well as most other
This is not a postgreSQL issue -- you are having problems with your PHP
configuration...
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Help! I was trying to make an installation of PHP 5.1.2 + Apache
2.0.55 + PostgreSQL 8.1 on Windows 2003 Server, and I'm stuck. I
got PHP to
Hi folks I'm hoping somebody can demystify something for me.
I've got a test database that is going live.
During development I have not vacuum'd much, so to get started I did
Vacuum verbose analyze.
At the end of the process it told me that vacuum needed max_fsm_pages to
be set at about
From the system catalogs:
SELECT PC.relname, PD.description
FROM pg_catalog.pg_description PD, pg_catalog.pg_class PC
WHERE PD.objoid = PC.oid AND PD.objsubid = 0
Ari Kahn [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
I have a comments on tables in my database.
e.g. COMMENT ON
Yes, if you search the archives there was something on this. Maybe it was around
32-bit, but nonetheless, take a search through.
Aly.
Stanislaw Tristan wrote:
It is a possible?
---(end of broadcast)---
TIP 5: don't forget to increase your
Right, I think there has been discussion about this and general
agreement that the current autovacuum logging options are less than
ideal to put it mildly. Unfortunately, I don't think there has been any
action by anyone to do something about it. I hope to work on this at
some point, but
Well, one problem now is that everytime pg_autovacuum opens a database,
a message is placed in the logs:
LOG: autovacuum: processing database test
LOG: autovacuum: processing database test
LOG: autovacuum: processing database test
LOG: autovacuum:
On 4/28/06, Tom Lane [EMAIL PROTECTED] wrote:
Either write it as date + integer, or add an integer + date operator
I thought I did it in that order, but I'll check it again.
(not very hard, just transpose the inputs), or use PG = 8.0 which has
integer + date built in.
I'm using a shared host
On 4/27/06, Bruno Wolff III [EMAIL PROTECTED] wrote:
I believe that has been fixed in recent version of postgres. At some point
in the past there was only a date + int operator and not an int + date
operator.
Overloading makes it easy to forget that those are two different operators.
I'll
Holger Zwingmann wrote:
If I check, after the reconnect, for some given 'text key' my SELECT
won't find it and my procedure will thus insert a new (key,value) pair.
When I disconnect and reconnect sometimes later again, I will suddenly
find both of the keys with the next query and will thus
I've got a query that depends upon two pieces of data from another table for
use in a where clause.
If I perform this procedurally, I can issue two sql commands (see below),
one to get the two pieces of data to search upon (QUERY 1), and one to
perform the query with these two pieces of data
Mark Harrison wrote:
### QUERY 3: combine the two statements above by using two subselects
scratch1=# select id from p4_versions where
versionof=(select id from p4_files where p4path like
'%/date.txt')
and
version=(select headver from p4_files where p4path
Mark Harrison [EMAIL PROTECTED] writes:
I've got a query that depends upon two pieces of data from another table for
use in a where clause.
scratch1=# select id from p4_versions where
versionof=(select id from p4_files where p4path like '%/date.txt')
and
why not a join like below (not tested)
select id
from p4_versions a
join p4_files b on (a.versionof = b.id and a.version = b.headver)
where p4path like '%/date.txt'
-- Original Message ---
From: Mark Harrison [EMAIL PROTECTED]
To: Postgresql-General
Buenas, queria saber como sacar la edad de alguien. Me da el siguiente error con el siguiente codigo :
-- Function: funcion_saca_edad()
DROP TRIGGER trigger_saca_edad ON fechas;
DROP FUNCTION funcion_saca_edad ();
CREATE OR REPLACE FUNCTION funcion_saca_edad() RETURNS OPAQUE AS'
DECLARE
juan jose dominguez [EMAIL PROTECTED] schrieb:
Buenas, queria saber como sacar la edad de alguien. Me da el siguiente error
con el siguiente codigo :
**** ---- FFuunnccttiioonn::
ffuunncciioonn__ssaaccaa__eeddaadd(()) ****
**** DDRROOPP
On Apr 27, 2006, at 11:06 AM, Kenneth Downs wrote:I've got a test database that is going live. During development I have not vacuum'd much, so to get started I did "Vacuum verbose analyze". you probably really do have a lot of spare space in the files. i'd recommend vacuum full if you can, to
Hey,
I am trying to figure out some unexpected behavior in Postgresql.
When I create a rule that fires on a table after an update, and if
that rule has a SELECT statement in it, it seems to be attempting to
fire (on an empty set) regardless of how the conditional evaluates
after an update.
The
On Thu, Apr 27, 2006 at 10:17:51 -0400,
Vivek Khera [EMAIL PROTECTED] wrote:
On Apr 24, 2006, at 9:37 AM, Claudio Tognolo wrote:
I am developing a temporal database and I have the necessity to
control the integrity constraints befor the commit of the transiction.
I cannot use the
Hi,
I'd like to write a PostgreSQL server function (ideally in C) that takes
a set of objects and returns 1 or more rows from each object, such that
the rows returned can be cast to a desired rowtype. The structure of the
returned rows depends on additional arguments. For example, I'd like to
be
Hi.
Some people on the list may find the following interesting:
http://marc2.theaimsgroup.com/?l=apache-modulesm=114599516512637w=2
Since it uses Apaches apr_dbd, Postgres is one of the supported
platforms.
Sincerely,
Joachim
---(end of
Eric Davies [EMAIL PROTECTED] writes:
As far as I can see, you can't write a set returning function that
takes a set as input, as in
select getMetaData( select * from mytable);
Is a function of the type I'm trying to write even possible in PostgreSQL?
I don't think it's possible at
Hello list,
I've been having a bit of difficulty getting Postgres to use indexes on
some large tables that I have. Included below are the results from
'explain analyze' for two queries that should get the unique years of
data that are available from two different tables (tbl_ind_schools_edu
and
Mike Leahy [EMAIL PROTECTED] writes:
... When I try to get the distinct number of
years from these tables, it does a sequential scan to get two unique
values from the year column in the *_edu table, but it uses an index
scan to get a single unique value from the year column from the *_con
I have a customer table (very important) and have numerous fields in other
tables FK to the serial id of the customer table.
There's an option to delete a customer record, but it has to fail if any
records are linked to it (eg: invoices) in order to prevent the books from
getting scrambled.
Benjamin Smith [EMAIL PROTECTED] writes:
I want to be able to determine in advance whether or not a record is
deleteable before displaying the button to delete the record. If it's not
deleteable, it should say so before the user hits the button.
But, the only way that I've been able to
Forgot to add; another option is to use a PL function with an
exception handler. This may be a bit more elegant approach but not
necessarily easier.
FYI
Jerry Sievers [EMAIL PROTECTED] writes:
Benjamin Smith [EMAIL PROTECTED] writes:
I want to be able to determine in advance whether or
Tom,
Thanks for the advice. I realize that I have little understanding of
index usage in PostgreSQL - I'm doing my best to improve this. Below is
another comparison of the 'distinct' and 'group by' queries from the
same table with seqscan set to on and off. I does look like the group
by works
Benjamin Smith wrote:
I have a customer table (very important) and have numerous fields in other
tables FK to the serial id of the customer table.
What you need is a list of the foreign key definitions, out of which you
build SQL selects that check each child table based on foreign key.
This is pretty ugly but you can query pgsql for table attributes...
replace tablename and you'll get the schema for a table including
primary and foreign keys. You could shrink it down and look just
for the foreign key.
SELECT f.attnum AS number, f.attname AS name, f.attnum,
Hi,
I just wrote a pgsql.vim file for vim users. It helps you to colorize
the file which contains PostgreSQL SQL keywords:
http://www.gunduz.org/postgresql/pgsql.vim
In order to use this file, first edit filetype.vim file and add
PgSQL
au BufNewFile,BufRead *.pgsql
On 4/27/06, Aly Dharshi [EMAIL PROTECTED] wrote:
Yes, if you search the archives there was something on this. Maybe it was
around
32-bit, but nonetheless, take a search through.
There is a patch in the queue written by Magnus Hagander right now
which allows pg to build from the microsoft C
On Apr 19, 2006, at 20:31 , chris smith wrote:
On 4/19/06, Kynn Jones [EMAIL PROTECTED] wrote:
I keep bumping against this situation: I have a main database A,
and I want
to implement a database B, that is distinct from A, but
subordinate to it,
meaning that it refers to data in A, but
77 matches
Mail list logo