On Thu, Jan 11, 2001 at 12:13:34AM +0200,
Martin Lillepuu [EMAIL PROTECTED] wrote:
William Staniewicz wrote:
Is there any way to convert an Excel file (".xls")
to a delimited file? Maybe using sed?
search for xls2csv on freshmeat. it works for simpler excel files but
tends to
On Wed, Jan 24, 2001 at 05:24:20PM -0800,
David Wall [EMAIL PROTECTED] wrote:
Is there any thought about the general availability date? Is there likely
to be a migration issue if I use 7.1 beta now?
I had a problem reloading from a pg_dump file. The way views are done
seems to have changed
On Thu, Jan 25, 2001 at 10:01:21AM +0200,
Esa Pikkarainen [EMAIL PROTECTED] wrote:
Thank you very much. Fine! Just two little questiton s more:
1) Can COALESCE take more than two alternatives?
2) Does it treat a zero length string as NULL or NOT NULL?
Wouldn't it have been faster to
On Tue, Mar 06, 2001 at 12:00:53AM +,
Patrick Welche [EMAIL PROTECTED] wrote:
How can you get back to a timestamp from a number of seconds?
I use this sequence in a perl program where $time is the current time in
seconds since the epoch.
timestamp 'epoch' + '$time second'
On Wed, Mar 14, 2001 at 12:17:57PM -0800,
keith [EMAIL PROTECTED] wrote:
I am lost. I am a developer, new to Linux and to postgreSQL.
I am trying to install postgreSQL on a linux machine. Every command I try to run
gives me a command not found error. I cannot seem to do anything. I tried
I am looking for information on tuning memory usage for Postgres on Linux
(2.2 kernel). In particular I have a lot of memory relative to the size
of my database and am looking to reduce latency in queries.
Searching goegle turned up a few other cases of people asking about memory
tuning, but I
On Fri, May 04, 2001 at 09:57:02AM -0400,
Tom Lane [EMAIL PROTECTED] wrote:
=?iso-8859-1?Q?Micha=EBl_Fiey?= [EMAIL PROTECTED] writes:
I have a problem with a case sensitive 'order by'.
On my development platform, the 'order by' clauses are insensitive
Could this be a locale issue?
On Fri, May 18, 2001 at 12:17:47PM -0500,
DC [EMAIL PROTECTED] wrote:
I have an event that is three days long. In a table I want to be able to
enter Friday date and have Saturdays and Sundays fill in automatically. It
also has to check for the month/# of days in...
You can add intervals to
I am interested in having a constraint checked at the end of a transaction
that is close to a references constraint but not exactly the same.
Simplfied versions of the table create statements look like the following:
create table table1 (
col1 int primary key,
col2 int
);
create table table2
On Fri, Jul 13, 2001 at 11:01:28AM -0500,
Bruno Wolff III [EMAIL PROTECTED] wrote:
On Fri, Jul 13, 2001 at 09:40:24AM -0400,
Ryan Mahoney [EMAIL PROTECTED] wrote:
Is it possible for the COPY command to warn about duplicate key violations
(and not insert them...) but still proceed
On Thu, Jul 26, 2001 at 05:02:30AM -,
Dr. Evil [EMAIL PROTECTED] wrote:
I'm writing an application that requires cryptographicly-sound random
decimal digits in PG. One way to do this is with a plain old hash
like SHA1. The problem is that this produces a 20 byte string, when
what I
On Fri, Aug 17, 2001 at 11:37:33AM +0100,
Michael Ansley (UK) [EMAIL PROTECTED] wrote:
Um, no, primary keys should not always be opaque. Technical primary
keys should always be opaque. Relational modelling has been built to
I think it has more to do with efficiency and whether or not you
On Thu, Aug 16, 2001 at 03:28:47PM -0700,
Andrew Gould [EMAIL PROTECTED] wrote:
Hh. I see what you mean. Perhaps an office
policy regarding password protected screen savers or
screen locks would meet the regulation's intent. (It
would also be simple and cheap.)
This is a much better
On Sun, Aug 19, 2001 at 01:49:00PM -0400,
[EMAIL PROTECTED] wrote:
Hello
I have statements (highly simplified just to get
the point across) like
select a,b,c from a where d=2 order by e limit 10;
Now I think that because of order by the above query
already knows the result of the
On Mon, Aug 20, 2001 at 07:44:56AM -0500,
Bruno Wolff III [EMAIL PROTECTED] wrote:
Shouldn't:
select a,b,c, count(*) from a where d=2 order by e limit 10;
do what you want?
Upon further review, I see that this construct isn't valid.
---(end of broadcast
I think the problem is that the indexes on the words are not usable for
regular expression matching. If the words are folded to lower case
when the index is built, then using an exact match (or even like) should
be much faster.
---(end of
On Wed, Aug 22, 2001 at 11:54:43AM -0400,
Tom Lane [EMAIL PROTECTED] wrote:
Bruno Wolff III [EMAIL PROTECTED] writes:
I have two related questions about joins.
The latter. See
http://www.ca.postgresql.org/users-lounge/docs/7.1/postgres/explicit-joins.html
Thanks, this is what I
On Mon, Aug 27, 2001 at 02:31:01PM -0400,
Neal Lindsay [EMAIL PROTECTED] wrote:
If I create a columnA in a tableA that REFERENCES tableB(columnB) in
another table, where column B is not null, does that imply a NOT NULL on
my columnA? In other words, does it ensure that the value of A is
On Tue, Sep 25, 2001 at 08:42:04AM -0400,
Mike Arace [EMAIL PROTECTED] wrote:
Is there a function out there for pg which allows you to generate a random
number given a seed value? I'm trying to create a users table which would
require the storage of a password in a database field, and
On Thu, Jun 19, 2003 at 17:07:43 -0400,
Nailah Ogeer [EMAIL PROTECTED] wrote:
Please don't respond to other messages to start a new thread.
What i am trying to do is to maintain a linked list of all the relations
in a database. When i create a db then i want it to insert into the linked
On Thu, Jun 26, 2003 at 01:02:06 -0400,
Mike Mascari [EMAIL PROTECTED] wrote:
Hi,
Just a quick question, not unrelated to my
previous question, which I don't think will
get answered. I have a table with 13 fields.
Is that too many fields for one table.
Mathematically, a binary
On Thu, Jun 26, 2003 at 08:33:10 +0100,
Peter Childs [EMAIL PROTECTED] wrote:
On Thu, 26 Jun 2003, u15074 wrote:
Need to be run after deletes and updates (a delete is actually a delete
and an insert) if you do it with verbose on. Look at the vac number if it
Just to avoid confusion, the
On Thu, Jun 26, 2003 at 12:00:07 +0100,
Matt Browne [EMAIL PROTECTED] wrote:
Other tables also reference records in the address table, using a
similar sort of scheme.
I have foreign keys set up so that if, for example, a record in customer
is deleted, the corresponding records in the
On Tue, Jul 01, 2003 at 02:35:48 -0700,
Rudy Koento [EMAIL PROTECTED] wrote:
Hi,
I've realised that my tables' constraint was set to
IMMEDIATE. So, when I update one table, there's error
because of referential integrity. Reading the docs, I
read that SET CONSTRAINTS has no effect on
On Wed, Jul 02, 2003 at 12:08:56 +0900,
Jean-Christian Imbeault [EMAIL PROTECTED] wrote:
TAL=# insert into b select 'b', select 'b';
ERROR: parser: parse error at or near select at character 27
You probably want:
insert into b select 'b', 'b';
---(end of
On Wed, Jul 02, 2003 at 23:18:47 +0100,
Dominic Marks [EMAIL PROTECTED] wrote:
I had a number of ideas about how to implement this, one was
using a separate VIEW for each services table. However I
have discovered that PostgreSQL only supports read-only views
at the current time.
You can
On Thu, Jul 03, 2003 at 20:37:27 +0200,
jose antonio leo [EMAIL PROTECTED] wrote:
Hi all,
I need do a update from t1 set col='P' where int_art = (SELECT int_art from
t2 ).
I know that thios sentence is not correct but I'd like do the update for
everethigs rows that return the select.
On Thu, Jul 03, 2003 at 20:37:08 +0200,
Darko Prenosil [EMAIL PROTECTED] wrote:
But unfortunately, I think that triggers and rules are not working on system
objects.
You can't put triggers on system tables. I am not sure about rules, but I
would expect the same limitation.
You probably
On Tue, Jul 22, 2003 at 12:24:00 +0200,
Kian Spongsveen (spam account) [EMAIL PROTECTED] wrote:
could directly call currval *after* inserting. Doing a manual nextval()
before the insert is OK, too, but from my understanding it needs the sequence
name and not the column name?
Yes, nextval
On Wed, Aug 06, 2003 at 11:28:23 -0300,
Kolus Maximiliano [EMAIL PROTECTED] wrote:
I'm about to install postgres on a box that has daemontools on it
and I would like to use it. Is there anybody here already running postgres
from daemontools? Is it advisable? Do you have any problems
On Wed, Aug 13, 2003 at 14:14:20 -0700,
expect [EMAIL PROTECTED] wrote:
What's the big deal with importing text files? I have a 70 MB file to import
and it's been one problem after another. I used the copy command and it appears
that it's just not possible. I finally massaged the file
On Wed, Aug 06, 2003 at 13:40:29 -0300,
The Hermit Hacker [EMAIL PROTECTED] wrote:
just looking at the rsyncd.conf file on svr1 itself, is the following a
valid address:
hosts allow = \
114.73.139.66.in-addr.arpa, \
You could have an A record with a domain name
This isn't a bug and you should have asked on a different list. I am going
to move this over to pgsql-general.
On Mon, Nov 20, 2006 at 12:07:25 +,
S.Balaji [EMAIL PROTECTED] wrote:
In Redhat 7.2 use Pg; command in perl Scripts will working with out any
Problem.But in CentOS use Pg
On Tue, Dec 05, 2006 at 12:52:15 -0200,
Thiago Silva [EMAIL PROTECTED] wrote:
I was wondering if PostgreSQL authorization rules can be aplied on
specific rows of a given table. I mean, AFAIK the GRANT statement
cannot be used for such purpose.
You can do this kind of thing using a view
On Tue, Dec 05, 2006 at 17:31:53 +0530,
deepak pal [EMAIL PROTECTED] wrote:
hi can we make a field auto incrementing field using Time Stamp data type
You can use a column default that uses current_timestamp for its expression.
If you also want to handle updates or override cases where people
On Mon, Dec 18, 2006 at 22:18:43 -0500,
Chansup Byun [EMAIL PROTECTED] wrote:
Hi,
I'm trying to set up a trigger to prevent any duplicate entries into
my table. But I couldn't figure out how to make my trigger work.
Couldn't you use a unique constraint to do this?
On Tue, Dec 19, 2006 at 11:20:35 +0100,
Udo Zubel [EMAIL PROTECTED] wrote:
Hi Im engineering a PG database with my workmate.
Unfortunately the inheritance feature seems not to be able to solve my
problem.
I have a table order with an orderID, each order has 1 to n types of
articles, like
On Thu, Dec 21, 2006 at 21:04:33 +0100,
Tomasz Ostrowski [EMAIL PROTECTED] wrote:
But I need an ability to change passwords. The easiest way to do it
But do you have to use the native passwords in Postgres? If you use ldap or
pam, you could use passwords maintained somewhere else that had
On Thu, Dec 21, 2006 at 23:43:06 +0100,
Tomasz Ostrowski [EMAIL PROTECTED] wrote:
And everything I need would be very simple to do if there was an
option to disable self-change of passwords for ordinary users.
That seems like a feature not many other people are going to want.
You have the
On Tue, Jan 02, 2007 at 02:37:59 +0200,
Andrus [EMAIL PROTECTED] wrote:
Also Tom Lane strongly recommends using VARCHAR always and never use CHAR
columns.
If you just want to use Postgres, you might want to use 'text' instead of
'varchar', since you don't need to specify arbitrarylimits
On Tue, Jan 02, 2007 at 12:33:14 -0700,
Anthony Masinton [EMAIL PROTECTED] wrote:
I would like to combine data from different rows in one column into
one row.
I have two tables: 'locations' containing a dozen records about
cities and their geographic coodinates - the other
On Fri, Jan 05, 2007 at 09:30:46 -0800,
Wilton Wonrath [EMAIL PROTECTED] wrote:
I think that I will need to use LOCK TABLE or SELECT FOR UPDATE, but in
both cases if the client terminal shutdown suddenly the tuple/table
stays locked on the server for a indeterminate time.
You need to use
On Fri, Jan 05, 2007 at 15:26:45 -0500,
James Neff [EMAIL PROTECTED] wrote:
... and Moses said unto them, 'The eleventh commandment : thou shalt
store images in a database!'...
What if you had another database where you stored just the images and
not back it up if you don't want to?
I
On Mon, Jan 08, 2007 at 09:22:05 +0100,
Andy Dale [EMAIL PROTECTED] wrote:
Hi,
Sorry for the slight delay in my response.
I am using 3 PostgreSQL databases and writing to them using an SQL proxy.
These databases have a high write volume. On rebooting all 3 servers for
OS/Software
On Tue, Jan 09, 2007 at 10:10:46 -0600,
Jeanna Geier [EMAIL PROTECTED] wrote:
If I cast the entire operation to an INT:
(a.area * su.units_per_sqfoot::integer)::integer AS area_sq
or by
(a.area * su.units_per_sqfoot)::integer AS area_sq,
I'm getting an 'ERROR: integer out of range'
On Tue, Jan 09, 2007 at 08:28:29 -0500,
Chander Ganesan [EMAIL PROTECTED] wrote:
It would. A query that uses an inner join implies that a matching entry
must exist in both tables - so the join must occur, otherwise you could
be returning rows that don't satisfy the join condition.
While
On Mon, Jan 08, 2007 at 14:55:29 -0600,
Jeanna Geier [EMAIL PROTECTED] wrote:
Not quite sure what the: CONSTRAINT Relationship182 is exactly... can
anyone help me with this one? Haven't seen this one yet...
It is the name of that particular constraint. You would use that if you
were
On Mon, Jan 08, 2007 at 20:20:42 -0500,
Matthew Terenzio [EMAIL PROTECTED] wrote:
Is it true that you can't use COPY FROM to fill a table with a SERIAL
type column?
Or rather, how does one approach that situation most effectively?
In older versions of postgres you couldn't, in recent
On Tue, Jan 09, 2007 at 10:33:52 -0500,
Tom Lane [EMAIL PROTECTED] wrote:
No, that's still not right. With a LEFT JOIN you know that each row of
the narrow table will produce at least one row in the join view. What
you don't know is whether the row could produce more than one join row
On Thu, Jan 11, 2007 at 18:51:57 +0100,
Jiří Němec [EMAIL PROTECTED] wrote:
Hello,
I need to remove duplicates rows from a subquery but order these
results by a column what is not selected. There are logically two
solutions but no works.
SELECT DISTINCT sub.foo FROM (SELECT ...) AS sub
On Thu, Jan 11, 2007 at 20:07:29 +0100,
Marcus Engene [EMAIL PROTECTED] wrote:
Hi list,
I'd like to generate the latest year dynamically with generate_series.
This select works day wise:
This works but looks grotesque:
select distinct date_trunc ('month', now()::date + s.a)::date
On Mon, Jan 15, 2007 at 11:52:29 +0100,
Jan van der Weijde [EMAIL PROTECTED] wrote:
Does anyone have a suggestion for this problem ? Is there for instance
an alternative to LIMIT/OFFSET so that SELECT on large tables has a good
performance ?
Depending on exactly what you want to happen, you
On Tue, Jan 16, 2007 at 12:06:38 -0600,
Bruno Wolff III [EMAIL PROTECTED] wrote:
Depending on exactly what you want to happen, you may be able to continue
where you left off using a condition on the primary key, using the last
primary key value for a row that you have viewed, rather than
On Tue, Jan 16, 2007 at 04:14:26 -0800,
Max Ueda [EMAIL PROTECTED] wrote:
Some results made me think of coercion between int
types. For example, atributing a int8 value into a
int2 variable. Does it really happen (coercion)? Is
the int8 value automatically converted into int2, or
an error
On Tue, Jan 16, 2007 at 19:47:28 -0200,
Jorge Godoy [EMAIL PROTECTED] wrote:
There's been a while since I could use the website for the last time because
it looks like Brazilian networks are blocked somewhere after routers from
speakeasy.net (220.ge-3-0.er1.sfo1.speakeasy.net from this
On Wed, Jan 17, 2007 at 07:54:55 -0200,
Jorge Godoy [EMAIL PROTECTED] wrote:
Bruno Wolff III [EMAIL PROTECTED] writes:
The don't block a host I used to access. And not on several different
Brazilian networks from different carriers. The traffic stops at speakeasy
from my house (ADSL from
On Mon, Jan 01, 2007 at 18:46:26 +0100,
dfx [EMAIL PROTECTED] wrote:
Dear Sirs,
my question is very simple:
when I insert a row whith a serial field, a value is automatically
generated; how can I know this value, strictly of my row, without the risk
of to read the value of another
On Fri, Jan 19, 2007 at 09:31:49 +0100,
Bertram Scharpf [EMAIL PROTECTED] wrote:
Hi,
looking at the source code I find out that this works:
sandbox=# create role joe login password 'verysecret';
CREATE ROLE
sandbox=# create function validate_user_8_1(text,text) returns boolean
On Fri, Jan 19, 2007 at 18:24:32 +0200,
Andrus [EMAIL PROTECTED] wrote:
It might make more sense to use your own table of users and hashed
passwords
rather than postgres'. This would depend somewhat on the overlap of users
who
are using your application and those who connect directly
On Fri, Jan 19, 2007 at 15:22:12 -0500,
Jan Muszynski [EMAIL PROTECTED] wrote:
If I have an index that's composed of 2 columns:
Index index1 on tableA (foo,bar)
and I then:
Select cola, colb from tableA where foo=value
Will index1 still be used, or am I looking at a seqscan
On Fri, Jan 19, 2007 at 18:20:47 -0500,
Jeremy Haile [EMAIL PROTECTED] wrote:
That's interesting. So if you have a composite index on two columns, is
there much of a reason (usually) to create single indexes on each of the
two columns? I guess the single indexes might be slightly faster
On Sun, Jan 21, 2007 at 15:16:37 +0200,
Andrus [EMAIL PROTECTED] wrote:
No, the tables would be on the server, the same as was already being done.
Using a separate table makes it more future proof.
To access tables in server, you need to login into server.
To login into server, you need
On Mon, Jan 22, 2007 at 20:25:48 +0100,
Bertram Scharpf [EMAIL PROTECTED] wrote:
What I want to do is the following:
1. Login in from a program on a client as a particualar user.
For this case you shouldn't need to do anything tricky as long as the user
is login in as themselves. Just
On Tue, Jan 23, 2007 at 09:44:28 +0100,
Bertram Scharpf [EMAIL PROTECTED] wrote:
Hi Bruno,
Am Montag, 22. Jan 2007, 23:11:41 -0600 schrieb Bruno Wolff III:
If the web server is running on the same machine as the DB,
then consider using ident authentication and connecting using domain
On Tue, Jan 23, 2007 at 09:01:56 -0800,
Richard Troy [EMAIL PROTECTED] wrote:
On Mon, 22 Jan 2007, Bruno Wolff III wrote:
On Mon, Jan 22, 2007 at 20:25:48 +0100,
Bertram Scharpf [EMAIL PROTECTED] wrote:
What I want to do is the following:
1. Login in from a program
On Tue, Jan 23, 2007 at 10:12:13 -0500,
Brandon Aiken [EMAIL PROTECTED] wrote:
Out of curiosity, has the COUNT(*) with no WHERE clause slowness been
fixed in 8.x? Or is it still an issue of there's no solution that
won't harm aggregates with WHERE clauses?
Probably not in the sense that you
On Tue, Jan 23, 2007 at 14:15:23 -0500,
Jeremy Haile [EMAIL PROTECTED] wrote:
But there are ways that we could optimize count(*) queries for specific
circumstances right? Obviously this isn't trivial, but I think it would
be nice if we could maintain a number of rows count that could be used
On 01/23/07 17:22, Robert Sanford wrote:
January 07 of 2007 is a Sunday. Based on the documentation I would
expect that date to be the first day of the second week of the year
2007. That's not what I'm getting. When I run:
Read the 'week' documentation carefully. ISO weeks start on Mondays.
On Wed, Jan 24, 2007 at 02:17:53 +0800,
Erick Papadakis [EMAIL PROTECTED] wrote:
I was just looking at the ident/trust/etc authentication banter from
pgsql docs. Couldn't make out what greek was on there. When I jostled
a bit, and finally understood it, and really wanted to write it in
On Tue, Jan 23, 2007 at 23:19:47 -0600,
Adam Rich [EMAIL PROTECTED] wrote:
And your normal query would be this:
INSERT into mytable (id,value) values (1,foo),(2,bar);
Your new query would be like this:
INSERT into mytable (id,value) values (1,foo),(2,bar)
RETURNING id;
Note that
On Wed, Jan 24, 2007 at 20:14:07 -0800,
Neal Clark [EMAIL PROTECTED] wrote:
I was wondering...I currently have indexes on the primary key id and
foreign key id's for tables that resemble the following. Is this a
good idea/when would it benefit me? I don't want waste a lot of
On Thu, Jan 25, 2007 at 15:43:19 +1100,
Chris [EMAIL PROTECTED] wrote:
Carlos wrote:
What would be the faster way to convert a 7.4.x database into an 8.x
database? A dump of the database takes over 20 hours so we want to
convert the database without having to do a dump and resptore.
On Thu, Jan 25, 2007 at 08:34:08 -0700,
Isaac Ben [EMAIL PROTECTED] wrote:
Hi,
I'm trying to create a table with 20,000 columns of type int2, but I
keep getting the error message that the limit is 1600. According to
this message
On Thu, Jan 25, 2007 at 12:33:51 -0500,
John Smith [EMAIL PROTECTED] wrote:
guys,
i inserted 1 record into my database (default
nextval('sequencename'::regclass) where (start 1 increment 1)). then i
tried to insert 1 other record twice but both those inserts failed
because of a domain check
On Thu, Jan 25, 2007 at 10:47:50 -0700,
Isaac Ben [EMAIL PROTECTED] wrote:
The data is gene expression data with 20,000 dimensions. Part of the
project I'm working on is to discover what dimensions are truly
independent. But to start with I need to have
all of the data available in a
On Mon, Jan 29, 2007 at 11:50:35 +0900,
Paul Lambert [EMAIL PROTECTED] wrote:
In order to balance disk load and ensure faster data access, my current
SQL server setup has the data spread across 3 physical disk devices. One
question I would like to know which I can't find in the
On Jan 29, 2007, at 4:27 PM, Karen Hill wrote:
I was just looking at all the upcoming features scheduled to make it
into 8.3, and with all those goodies, wouldn't it make sense for this
to be a 9.0 release instead of an 8.3? It looks like postgresql is
rapidly catching up to oracle if 8.3
On Mon, Jan 29, 2007 at 15:51:54 -0800,
Rich Shepard [EMAIL PROTECTED] wrote:
On Tue, 30 Jan 2007, Michael Glaesemann wrote:
It was *discussed*. 8.1 to 8.2 (as does any move from M.x to M.y where x
y) requires a dump and reload.
Michael,
That's what I thought. However, it never
On Sun, Jan 28, 2007 at 23:46:27 +0200,
Andrus [EMAIL PROTECTED] wrote:
My application implements field and row level security.
I have custom table of users where user privileges are described.
However user can login directly to database using pgAdmin. This bypasses
the security.
How to
On Tue, Jan 30, 2007 at 16:43:14 -0800,
Richard Troy [EMAIL PROTECTED] wrote:
be better - and once were. (Example, anyone who thinks man pages are
great has obviously got a very limited experience from which to base their
opinion!) ... As a practical matter today we mostly have a choice of
On Thu, Feb 01, 2007 at 10:24:51 +0900,
Paul Lambert [EMAIL PROTECTED] wrote:
If you hide the database username and password within your application
(i.e. encrypted within the source code) so they cannot see the
credentials that you connect to the database with internally then they
have
On Thu, Feb 01, 2007 at 10:42:30 -0800,
Carl Lerche [EMAIL PROTECTED] wrote:
How can I index 2 dimensional data (latitude / longitude) with a
status_id column too (integer) so that I can perform the following
query as fast as possible:
SELECT * FROM profiles WHERE status_id = 1 AND
On Fri, Feb 02, 2007 at 07:20:04 +0900,
Paul Lambert [EMAIL PROTECTED] wrote:
How?
Use a debugger.
If it is encrypted within the source code then the only way to steal the
credentials would be to reverse engineer the application. And if someone
is going to do that then you can be
The following is just FYI.
I was recently doing some stuff with greatest() on oracle (9.2.0.8.0) and
noticed that it returned null if ANY of the arguments were null. Out of
curiosity I checked postgres' definition of that function and found that it
returns null only if ALL of the arguments are
On Sat, Jun 30, 2007 at 00:15:42 -0400,
Tom Lane [EMAIL PROTECTED] wrote:
Andrej Ricnik-Bay [EMAIL PROTECTED] writes:
On 6/30/07, Bruno Wolff III [EMAIL PROTECTED] wrote:
I was recently doing some stuff with greatest() on oracle (9.2.0.8.0) and
noticed that it returned null if ANY
On Sat, Jun 30, 2007 at 09:29:23 +0200,
Pavel Stehule [EMAIL PROTECTED] wrote:
Hello,
I have not Oracle, so I cannot test it, but PostgreSQL implementation
respect Oracle:
http://archives.postgresql.org/pgsql-patches/2005-06/msg00431.php
Maybe that reference was for an earlier version
On Wed, Sep 05, 2007 at 10:37:18 +1000,
Andrew Maclean [EMAIL PROTECTED] wrote:
In Table 9.4 of the documentation atan2 is described as follows:
atan2(*x*, *y*) inverse tangent of *x*/*y*
I am sure it should read as:
atan2(*y*, x) inverse tangent of y/x
Aren't those two statements
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 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 not help
On Sun, Jun 12, 2005 at 23:03:35 +0100,
Simon Windsor [EMAIL PROTECTED] wrote:
Has a roadmap and timescale been released for Postgres 8.1?
Feature freeze will be July 1. Expect a beta about 1 month after that
(based on past experience). The date of the release is highly variable,
but will
On Mon, Jun 13, 2005 at 22:27:31 +0200,
Együd Csaba [EMAIL PROTECTED] wrote:
The critical tables are vacuum analyzed in every hour. (Not vacuum full
because of the several minutes long exclusive lock)
Earlier the system had been running for 3 months without problems, but a few
weeks ago
On Tue, Jun 14, 2005 at 08:37:38 +1200,
David Mitchell [EMAIL PROTECTED] wrote:
I'm totally baffled as to why postgres won't use this index. I have a
table point with an index on it as so:
CREATE INDEX unit_point
ON point
USING btree
(unit_id, time);
When I try the following
On Tue, Jun 14, 2005 at 08:33:34 -0500,
Peter Fein [EMAIL PROTECTED] wrote:
Knowing the specifics of the data I'm putting in sometext, a halfway
decent hash function would make collisions so rare as to make the chance
insignificant (and collisions wouldn't break anything anyway). Is this
On Tue, Jun 14, 2005 at 15:54:50 -0500,
Peter Fein [EMAIL PROTECTED] wrote:
I'm unclear why I'd need to store the hash in a column. I suppose I
could have the hash column populated by a trigger on inserts, but this
seems to get me the same functionality is less obvious.
For the
On Wed, Jun 15, 2005 at 13:34:39 +0200,
Zlatko Mati? [EMAIL PROTECTED] wrote:
Hi.
Concerning Együd's question, I also wanted to ask about setting expiration
date for database. But, I would like to set validity in sense of certain
actions.
For example, I would like to prevent adding new
On Fri, Jun 17, 2005 at 14:35:01 +0200,
Jose Gonzalez Gomez [EMAIL PROTECTED] wrote:
The problem comes when you have questions that may be not applicable
(8), or optional (doesn't know, doesn't answer) (9). The easy solution
would be to have four tables:
yes_no
yes_no_not_applicable
On Fri, Jun 17, 2005 at 15:27:30 -0700,
Benjamin Smith [EMAIL PROTECTED] wrote:
I wrote a rule a while back that, due to the software being extended, now
needs to be deleted.
How do I drop a rule?
DELETE FROM pg_rules WHERE rulename='foo';
doesn't seem to cut it...
DROP
On Fri, Jun 17, 2005 at 22:54:59 -0700,
Jeffery Reedy [EMAIL PROTECTED] wrote:
I have been searching for the ability for replication between postgresql
database servers. Many of the solutions That I have seen either work only
un*x or requires an expensive commercial license. I am looking
On Sun, Jun 19, 2005 at 17:16:34 +0100,
Jose Gonzalez Gomez [EMAIL PROTECTED] wrote:
There would be no problem in doing so with such an easy case, but
think about having a table with cities (hundred, thousands?) and then
have four copies for each of the above posibilities with its related
On Tue, Jun 21, 2005 at 09:16:08 +0200,
[EMAIL PROTECTED] wrote:
I come from a MSSQL background and am trying to figure out how to write
deployment scripts for PostgreSQL. Typically, if I want to drop a
function, I would write a script that first checks for it's existence and
then performs
1 - 100 of 675 matches
Mail list logo
