On Sat, Jun 04, 2005 at 11:31:02 +0200,
Joachim Zobel [EMAIL PROTECTED] wrote:
These are both things I want to avoid. I am not trying to solve a real
world problem, I want to understand the limits of SQL. And it seems that
a plain SELECT that tells me if a path exists is not possible.
On Sat, Jun 04, 2005 at 21:53:24 +0200,
Joachim Zobel [EMAIL PROTECTED] wrote:
Am Samstag, den 04.06.2005, 07:38 -0500 schrieb Bruno Wolff III:
On Sat, Jun 04, 2005 at 11:31:02 +0200,
Joachim Zobel [EMAIL PROTECTED] wrote:
... And it seems that
a plain SELECT that tells me
On Thu, Jun 02, 2005 at 16:57:14 -0400,
Douglas McNaught [EMAIL PROTECTED] wrote:
A serial column is basically just syntactic sugar for the above, so
you're not losing anything.
In recent versions of postgres, I do think you lose something. I don't
believe the dependency will get tracked as
On Fri, Jun 03, 2005 at 14:09:32 -0500,
Peter Fein [EMAIL PROTECTED] wrote:
Hi-
Let's say I have a base table B (with a PK id, say) and two derived
tables D1 D2 (with different cols). For a given B.id, I'd like to
allow only a corresponding row in *either* D1 or D2, but not both. Any
On Fri, Jun 03, 2005 at 16:04:26 -0500,
Peter Fein [EMAIL PROTECTED] wrote:
Ok, this makes a lot of sense is just cleaner. Would you continue to
do it this way if there were around a dozen derived tables (most with
one or two columns)? I remember reading somewhere (perhaps the PG
docs?)
On Thu, Jun 02, 2005 at 14:08:54 +0200,
KÖPFERL Robert [EMAIL PROTECTED] wrote:
To me it seems that the definer of this table missed the concept index ...
or the concept database
One usually looks up data using a key, but if the whole row is the key, what
data shall be looked up.
You
On Thu, Jun 02, 2005 at 13:26:32 +0200,
Havasvölgyi Ottó [EMAIL PROTECTED] wrote:
I tried to simulate this unexpected result, but with no success. Here in
Hungary we had daylight saving this year on the 27th of March
(http://webexhibits.org/daylightsaving/b.html). So I tried these:
On Thu, Jun 02, 2005 at 06:22:01 +0100,
Eisenhut, Glenn [EMAIL PROTECTED] wrote:
Folks - hi
Is it possible to determine when a row was inserted into a table using the
system catalogs or such.
I have the situation where I need to find out when a user was added to a user
table - the
On Thu, Jun 02, 2005 at 17:48:47 +0530,
Dinesh Pandey [EMAIL PROTECTED] wrote:
Yes I am storing some error messages in data column, and the PK columns
are party of search criteria.
If you need to be able to search based on the entire stored error message,
than you might try adding an indexed
On Thu, Jun 02, 2005 at 13:40:53 +0100,
Richard Huxton dev@archonet.com wrote:
Actually, Dinesh didn't mention he was using this for the speed of
lookup. He'd defined the columns as being the PRIMARY KEY, presumably
because he feels they are/should be unique. Given that they are rows
On Thu, Jun 02, 2005 at 18:00:17 +0100,
Richard Huxton dev@archonet.com wrote:
Certainly, but if the text in the logfile row is the same, then hashing
isn't going to make a blind bit of difference. That's the root of my
concern, and something only Dinesh knows.
Sure it is. Because the
On Thu, Jun 02, 2005 at 17:04:22 -0400,
David Parker [EMAIL PROTECTED] wrote:
Is there a function call that will return the pid of the postgres
process associated with the current client connection?
I thought I remembered seeing one, but I looked through the development
docs and didn't see a
On Tue, May 31, 2005 at 18:03:04 +0100,
Richard Hayward [EMAIL PROTECTED] wrote:
Is it possible to prevent a user from changing their password?
I have a database with a 'Guest' account, that will have limited
access. I don't want any of my guests to change the Guest account
password.
Your
On Thu, Jun 02, 2005 at 01:54:12 +0200,
Havasvölgyi Ottó [EMAIL PROTECTED] wrote:
Thank you Tom.
It was a bit confusing because my WHERE clause looked something like this:
... WHERE date_field - current_date '21 days'::interval;
And then I got records, whose with date_field's year was
On Tue, May 24, 2005 at 13:49:40 -0300,
[EMAIL PROTECTED] wrote:
Another feature I missed is the returning clause
of the Oracle INSERT SQL command, which allow the
user to retrieve the serial value after an insert
command, which works even in a concurrent network
environment.
While it
On Tue, May 24, 2005 at 19:31:28 -0300,
Marc G. Fournier [EMAIL PROTECTED] wrote:
On Tue, 24 May 2005, James Croft wrote:
Scott Marlowe wrote:
I'd go for 8.0. It's quite stable now, and 8.1 will take as long as it
needs to take to come out, which could be anything, but will likely be
no
On Fri, May 20, 2005 at 08:40:26 +0200,
BARTKO, Zoltán [EMAIL PROTECTED] wrote:
Hello folks,
Problem:
I would need some help with the system I am working on. It is an
information system built on PgSQL 8 and after searching all over the
net I found no function I could use to determine
On Fri, May 20, 2005 at 08:19:58 -0400,
John D. Burger [EMAIL PROTECTED] wrote:
I find all these statements about the near-uselessness of
NUMERIC^NUMERIC to be pretty amazing. It's fine to say, no one seems
to be asking for this, so we haven't implemented it yet, but, c'mon,
folks,
On Tue, May 17, 2005 at 14:05:46 -0500,
Kris Jurka [EMAIL PROTECTED] wrote:
On Tue, 17 May 2005, FERREIRA, William (COFRAMI) wrote:
hi at present my j2ee application use an Oracle database with XA
transactions. i'm migrating Oracle to PostgreSQL, and i'm looking for a
XA driver for
On Sun, May 15, 2005 at 13:59:00 +0200,
Samer Abukhait [EMAIL PROTECTED] wrote:
Does PostgreSQL support by anyhow the parameter named notation in
function calling?? (like oracle's: parameter_name = argument_value)
If not, is it on the wish list?
It is on the TODO list.
On Mon, May 16, 2005 at 11:43:09 +0300,
Margus Roo [EMAIL PROTECTED] wrote:
Hello.
I have 2 variables type timestamp. Example date1 = 2005-01-01 23:00 and
date2 = 2005-05-04 12:00. I want get something like age(date2,date1) but
ouput format must by hours::minutes.
Is that bossible?
On Mon, May 09, 2005 at 15:48:44 -0400,
Hrishikesh Deshmukh [EMAIL PROTECTED] wrote:
Hi All,
How can one use a table created for saving the results for a query be
used in WHERE for subsequent query!!!
Step 1) create table temp as select gene from dataTable1 intersect
select gene from
On Tue, May 10, 2005 at 18:32:39 -0700,
Bob Lee [EMAIL PROTECTED] wrote:
I have two timestamps -- start and end. I use age(end,start)
to give me a session time and then I subtotal those. If
the total times are less than 24 hours I get a time is the
format of XX:xx:xx -- this is great. But if
On Thu, May 05, 2005 at 15:46:16 -0700,
Daniel Browning [EMAIL PROTECTED] wrote:
[I posted this recently to ports, but I think this is a more proper location]
Is anyone working on an 8.0.2 RPM for x86_64 on Red Hat Enterprise
Linux 4? There is a i686 version for RHEL4, and a x86_64 version
On Wed, May 04, 2005 at 10:56:25 +0200,
Zlatko Matic [EMAIL PROTECTED] wrote:
I will try...if it will be useless, I will quite. Then the only solution
will be make-table query based on nested pass-through query, so I will be
working on local JET tables that will be refreshed from server on
On Wed, May 04, 2005 at 11:47:12 -0400,
Greg Stark [EMAIL PROTECTED] wrote:
Bruno Wolff III [EMAIL PROTECTED] writes:
How do I create sequence ?
You can't create a sequence for a view. You would need to have it in a
table that is joined as part of the view.
Sure you can. You can
On Wed, May 04, 2005 at 18:24:53 +0200,
Hervé Piedvache [EMAIL PROTECTED] wrote:
Why I get 26927405 nonremovable row versions in 185707 pages ?
How to remove them ? I need to free the space quickly !
Those rows will still be visible to transactions that started before
the delete was
On Wed, Apr 27, 2005 at 13:56:02 +0100,
deepak [EMAIL PROTECTED] wrote:
The following bug has been logged online:
This isn't a bug, its a question. I am moving the discussion over to
the general list.
Bug reference: 1633
Logged by: deepak
Email address: [EMAIL
On Wed, Apr 27, 2005 at 10:23:19 -0500,
Scott Marlowe [EMAIL PROTECTED] wrote:
My first recommendation would be to put everything into one database.
it looks like you've got 6 databases. If you've still got the template0
database, you can probably get rid of that one as well. If you're
view has
a unique numeric field. It would help to know how it knows that a column
has those properties and how it uses the information.
- Original Message -
From: Bruno Wolff III [EMAIL PROTECTED]
To: Zlatko Matic [EMAIL PROTECTED]
Cc: pgsql-general@postgresql.org
Sent: Monday, April
On Sun, Apr 24, 2005 at 22:16:14 +0200,
Zlatko Matic [EMAIL PROTECTED] wrote:
I know that it sounds crazy,
but I need a bigserial coulumn in a view that is consisted of several tables.
That column should not be based on bigserial column of any table, but should
be a calculated column...
On Fri, Apr 22, 2005 at 11:14:35 -0300,
Leandro Repolho [EMAIL PROTECTED] wrote:
Hello guys, i installed my postgresql 8.0.2 successfuly and its
working fine, but my postgres user works with any password, how can i
solve ?
I already tryed to change the password trough the pgAdmin3 but didn´t
On Fri, Apr 22, 2005 at 11:34:29 +0100,
David Roussel [EMAIL PROTECTED] wrote:
I usually put DDL statements in a transaction, for a couple of
reasons: so that a mistake doesn't leave me with half-done work
(any error will cause the entire transaction to roll back), and to
make the
On Fri, Apr 15, 2005 at 21:58:31 +1000,
Alex [EMAIL PROTECTED] wrote:
Hi,
i have a table
ProdId | LastUpdate
---+
100| 2005-04-01
100| 2005-03-01
100| 2005-02-01
200| 2005-04-01
200| 2005-03-01
200| 2005-02-01
- How can i select only the
On Wed, Apr 13, 2005 at 09:57:09 -0400,
Matt Van Mater [EMAIL PROTECTED] wrote:
Also, I forgot to mention earlier that I tried using transactions to
speed things up, but since I expect to see certain inserts fail I
would need to rework my code so the whole transaction doesn't fail if
one
On Wed, Apr 13, 2005 at 13:54:05 +0200,
Matthias Loitsch [EMAIL PROTECTED] wrote:
So I thought I could make a foreign key on a different Schema (db), and
use the same table
And well, thats where I started to search if this is possible ... and,
in fact my main question is: Is this a
On Sat, Apr 09, 2005 at 15:19:58 +0200,
Michal Hlavac [EMAIL PROTECTED] wrote:
Oleg Bartunov wrote:
so, what's the problem ? psql diplo ltree.sql
ok, I can add ltree via superuser, but I must grant access for user
diplo to every function...
it is possible to do that easier?
Functions
On Thu, Apr 07, 2005 at 11:51:10 +1000,
Chris Smith [EMAIL PROTECTED] wrote:
Is there another way to approach this?
I'm trying to delete records through a webapp and if there are 500,000
records for example, I can't really leave the page open and expect it to
finish...
Maybe you could
On Tue, Mar 29, 2005 at 18:40:56 +0200,
Robin Ericsson [EMAIL PROTECTED] wrote:
Devrim GUNDUZ wrote:
PostgreSQL RPM Building Project[1] has built RPMs for 8.0.2beta1. RPMs
for Red Hat Linux 9, Red Hat Enterprise Linux Enterprise Server 3.0,
Fedora Cor 1,2,3 are now available, and more to
On Wed, Mar 30, 2005 at 13:09:33 -0500,
Adam Siegel [EMAIL PROTECTED] wrote:
We perform a vacuum full after each mass delete. This cycle can happen
many times during over a couple of weeks. We are in a test lab
environment and are generating a lot of data.
One of the problems we have
On Sun, Apr 03, 2005 at 11:06:22 +0200,
Karsten Hilbert [EMAIL PROTECTED] wrote:
On Thu, Mar 31, 2005 at 09:43:27AM +0300, Andrus wrote:
Empty data is a date which is less that all other dates.
Why would that be ? Empty of type unknown cannot be less
than (nor more than nor equal to)
On Sun, Apr 03, 2005 at 15:46:18 +0200,
Karsten Hilbert [EMAIL PROTECTED] wrote:
type date or some such. However the best would be to use
-infinity.
+/- infinity are only available as timestamps, not dates.
Hm, any particular reason why ? Apart from no one having
gotten around to
On Fri, Apr 01, 2005 at 10:37:11 +0200,
[EMAIL PROTECTED] wrote:
And idea that just came up around here that sounds like a pretty neat
workaround, which we're gonna try, is to drop the foreign key
constraints, and just use a check constraint for the allowed values. If
the cardinality of
On Fri, Apr 01, 2005 at 11:42:35 +0200,
Shaun Clements [EMAIL PROTECTED] wrote:
I have a questions regarding my order by problem.
If you index a table, can you query the table using ORDER BY. ?
Whether or not a table is indexed doesn't affect whether or not you can
use ORDER BY. It may
On Fri, Apr 01, 2005 at 14:00:40 -0700,
Krause, Lewis [EMAIL PROTECTED] wrote:
Is there a way to do a case sensitive group by.
It should be that way by default. If you want case insensitive, then
you can group by lower(whatever).
---(end of
On Wed, Mar 30, 2005 at 16:45:43 -0700,
Mark Fox [EMAIL PROTECTED] wrote:
What I want is SELECT statement that references no tables but returns
the days in a given month. I'm now thinking that I might be able to
come up with something using an IN clause and using EXTRACT, but
haven't
On Wed, Mar 30, 2005 at 00:35:25 -,
Mohan, Ross [EMAIL PROTECTED] wrote:
Any pointers?
The online documentation is very good. For generic Postrges questions, that
is probably your best resource. There may be better places to get answers
about questions on converting from Oracle to
On Sun, Mar 27, 2005 at 19:46:41 -0600,
Related question: Once I switch the 8.0.1 system over to be the production,
can I reverse the direction and restore .dmp files on the 7.4.5 system or
are the tablespace terms in the dump files going to cause problems?
The 8.0.1 dumps will probably
On Sun, Mar 27, 2005 at 23:58:35 -0500,
Mike Mascari mascarm@mascari.com wrote:
Without parallel query, the *only* way to decrease the execution time of
a single query whose data has been fully cached is to buy the
latest-and-greatest which is increasing in speed at decreasing rates,
On Mon, Mar 28, 2005 at 16:13:59 -0600,
Dale Sykora [EMAIL PROTECTED] wrote:
CREATE TABLE user_data(
name varchar(32),
write_access bool DEFAULT 'f'
);
CREATE TABLE actions(
action varchar(32),
user varchar(32) -- somehow make sure user = user_data.name where
On Mon, Mar 21, 2005 at 08:04:01 +0100,
Szmutku Zoltán [EMAIL PROTECTED] wrote:
Hi everybody ,
I tried using Postgre, but I have some problems.
I create a constraint ( R1=0 ), and after connect to server from VFP via
ODBC .
In the client program I turn on the transactions . (
On Wed, Mar 23, 2005 at 20:47:36 +0200,
Andrus [EMAIL PROTECTED] wrote:
I thought about this.
1. It seems that user prefer to see separate numbers for each sequence.
First invoice has number 1 , second invoice has number 2
This suggests that invoices for different categories can have
On Thu, Mar 24, 2005 at 14:37:59 +0200,
[EMAIL PROTECTED] wrote:
Hi
I am new to PostgreSQL and find that the standard documentation is very
thin. I would like to buy a more comprehensive book. All the available
books seem very out of date!!! Firstly, does it matter if I buy a book
that
On Wed, Mar 23, 2005 at 14:10:30 +0200,
Adrianna Pinska [EMAIL PROTECTED] wrote:
More specifically, I've been looking for a way to persuade postgresql
to output the create script for a single object - without much
success. It seems that pg_dump can output a dump of the entire
database
On Tue, Mar 22, 2005 at 17:27:25 +0530,
Rajarshi Mukherjee [EMAIL PROTECTED] wrote:
Hello all,
i have a function that updates a table. I gave execute grant on it to
a particular user but no grant on the table in question.
when logging in as that user and executing the function, i
On Tue, Mar 22, 2005 at 17:47:48 +0530,
Rajarshi Mukherjee [EMAIL PROTECTED] wrote:
PLEASE GIVE ME AN EXAMPLE..
Please read the documentation of the CREATE FUNCTION command.
On Tue, 22 Mar 2005 06:24:58 -0600, Bruno Wolff III [EMAIL PROTECTED] wrote:
On Tue, Mar 22, 2005 at 17:27:25
On Sat, Mar 19, 2005 at 01:43:07 -0800,
Benjamin Smith [EMAIL PROTECTED] wrote:
Is it possible to have the equivalent of a serial data type in a table,
sub-categorized?
[snip]
Now, I want to create an entries table, and by default, count serially by
category, so that category 1 has
On Sat, Mar 19, 2005 at 22:37:55 +0200,
Andrus Moor [EMAIL PROTECTED] wrote:
I have table containing different types of documents (type A, B and C).
Each document type must have separate sequential ID starting at 1
ID of first inserted record of type A must be set to 1
ID of first
On Tue, Mar 15, 2005 at 12:57:52 +0800,
Qingqing Zhou [EMAIL PROTECTED] wrote:
Yu Jie [EMAIL PROTECTED] writes:
Hi all,
If I want to restrict the maximum size of one
table to 5MB, restrict the maximum size of database
file to 100MB, how can I do that restriction?
Is
On Wed, Mar 09, 2005 at 13:52:28 -0500,
Doug Bloebaum [EMAIL PROTECTED] wrote:
It's apparent why: the view determines which table it's going to use at
view creation time, not at query time, so this method is no good.
Is there a right way to accomplish what I'm trying to do?
I think the
On Thu, Mar 10, 2005 at 17:12:46 -0800,
James [EMAIL PROTECTED] wrote:
Do you guys have thoughts on how to implement this? I
am not expecting an easy solution but I wish to get
started asap. Any advice would be appreciated.
My usual solution is to use a perl script which talks to both
On Sat, Mar 12, 2005 at 11:30:03 +0100,
Leif B. Kristensen [EMAIL PROTECTED] wrote:
In MySQL, the checking on dates is very relaxed, so it's totally legal
to enter a date as '1731-00-00', and let your own program logic decide
that this means just the year 1731. Do I have to make my own
On Sat, Mar 12, 2005 at 10:41:08 +,
ILove TheSpam [EMAIL PROTECTED] wrote:
Lets say I have 3 tables:
surnames - surnameid serial (Primary Key), surname varchar (Unique)
firstnames - firstnameid serial (Primary Key), firstname varchar (Unique)
users - userid serial (Primary Key),
On Sat, Mar 12, 2005 at 23:05:41 +0200,
Andrus Moor [EMAIL PROTECTED] wrote:
I have table containing different types of documents (type A, B and C).
Each document type must have separate sequential ID starting at 1
ID of first inserted record of type A must be set to 1
ID of first
On Thu, Mar 10, 2005 at 13:22:05 +0100,
Karsten Hilbert [EMAIL PROTECTED] wrote:
Also notice that we do have views that display the missing
shots per schedule per patient. I just have not found a way to
join the two views (that is, given and missing) because that
would AFAICT require the
On Fri, Mar 11, 2005 at 15:25:28 +0100,
Együd Csaba [EMAIL PROTECTED] wrote:
Hi All,
I'd like to ask your opininon about how to handle DST on an 7/24 system.
My advice would be to use GMT and not have to worry about DST while
collecting data. When displaying data you might convert the
. For just playing around the file
system problem shouldn't be a problem.
Bruno Wolff III [EMAIL PROTECTED] írta:
On Fri, Feb 25, 2005 at 21:19:34 +0100,
Berényi Gábor [EMAIL PROTECTED] wrote:
I have a dotgeek.org free account, but they are about to leave
PostgreSQL for MySQL which
On Mon, Feb 28, 2005 at 10:13:00 -0700,
Ken Johanson [EMAIL PROTECTED] wrote:
Besides, the version-deprecation / version requirements you mention
exists in every piece of software I've even seen. Sometime they're okay
with a really old version, sometime only the newest will do. This is
On Mon, Feb 28, 2005 at 17:46:43 +0100,
Karsten Hilbert [EMAIL PROTECTED] wrote:
There are 5 vaccinations in a given vaccination schedule.
Patient had 3 shots.
I want the view to show me that shot 4 and 5 are missing
without having to enter the cardinality of the vaccination in
the
On Fri, Feb 25, 2005 at 15:12:07 -0800,
Si Chen [EMAIL PROTECTED] wrote:
Hello everyone. Thanks for the answers earlier about the new 8.0 version.
We have a client who is thinking about putting postgresql 8.0 on Windows
2003 Server, but he is concerned because this is the first version to
On Fri, Feb 25, 2005 at 21:19:34 +0100,
Berényi Gábor [EMAIL PROTECTED] wrote:
I have a dotgeek.org free account, but they are about to leave
PostgreSQL for MySQL which is too bad. Can you suggest me a
free/cheap PostgreSQL host where I can test an open-source program?
No web hosting is
On Mon, Feb 14, 2005 at 15:25:15 -0500,
Milla Erdee [EMAIL PROTECTED] wrote:
The updating view syntax in many cases might be preferred in certian
cases and other types of syntax in other cases, and it should be up to
the programmer to decide which is best for a certian application.. A
On Mon, Feb 14, 2005 at 15:12:56 -0600,
Cristian Prieto [EMAIL PROTECTED] wrote:
And it is working fine, but when I get a Unique_Violation (cuz there is a
iduser already) the sequence still advance to the next value. There is any
way to rollback or avoid holes in the sequence? I've read
On Sun, Feb 13, 2005 at 13:06:52 +1100,
Russell Smith [EMAIL PROTECTED] wrote:
Dear all,
There does not seems to be the latest version of the PostgreSQL documentation
online.
The release notes for 8.0 and 7.4 only go to version 8.0.0 and 7.4.6.
Where can I find the changes made from
On Sun, Feb 13, 2005 at 14:03:02 +1100,
Neil Dugan [EMAIL PROTECTED] wrote:
Hi,
I am trying to find out how to get the next record according to a
particular index.
I have a table with a name field and a serial field. The name field
isn't unique so I made an index on name(varchar)
On Fri, Feb 11, 2005 at 11:07:24 +,
David Goodenough [EMAIL PROTECTED] wrote:
I thought of using an inner select for the join, and using limit 1 to
get just the one, and forcing the order by to give me the billing
address by preference, but I am then dependant on the sort order
of the
Please use a relevant subject for your posts.
On Tue, Feb 08, 2005 at 23:14:57 +0530,
Surabhi Ahuja [EMAIL PROTECTED] wrote:
i have a table in which duplicate rows occur.
now i have to remove the duplicates. Please note that however, only the
duplicate rows have to be deleted and not
On Mon, Feb 07, 2005 at 16:20:36 -0500,
Berend Tober [EMAIL PROTECTED] wrote:
SELECT * FROM sample_table ORDER BY 1;
account_id,account_name
100,First account
110,Second account
*115,Fifth account
120,Third account
*125,Fourth account
I would expect to see
On Sat, Feb 05, 2005 at 17:25:06 -0500,
Reuben D. Budiardja [EMAIL PROTECTED] wrote:
Hello,
I am running postgres-7.3. I have a query like this:
SELECT question_id, question_text
FROM quiz_table
WHERE question_id IN (2,10,3,6,4,5);
But I want the output to be sorted in the way I give
On Thu, Feb 03, 2005 at 23:04:57 -0200,
Clodoaldo Pinto [EMAIL PROTECTED] wrote:
This one must be obvious for most here.
I have a 170 million rows table from which I want to eliminate
duplicate would be keys and leave only uniques.
I found a query in
On Fri, Feb 04, 2005 at 05:59:26 -0800,
Stephan Szabo [EMAIL PROTECTED] wrote:
On Fri, 4 Feb 2005, Eric Jain wrote:
I'm trying to fill a table with several million rows that are obtained
directly from a complex query.
For whatever reason, Postgres at one point starts using several
On Fri, Feb 04, 2005 at 08:56:37 -0600,
Shawn Harrison [EMAIL PROTECTED] wrote:
Mike Cox [EMAIL PROTECTED] wrote in message
Well, yes. You have to be a member of the mailing list you want to
post to even if you are posting through usenet. Otherwise your post
will bounce to you *email*
On Mon, Jan 31, 2005 at 09:45:16 -0700,
Steve Wampler [EMAIL PROTECTED] wrote:
Steve Wampler wrote:
I realize 7.2.4 is long in the tooth, but it's an old system that's been
running for several years now. Someday we'll upgrade...
There are more recent releases even within the 7.2.x series.
On Sat, Jan 29, 2005 at 00:34:07 -0800,
Chris Travers [EMAIL PROTECTED] wrote:
Maybe we should set the default authentication to only use TRUST on
local sockets only. At least as of 7.4, the default was to trust
network ports.
I believe the previous default was not to allow network
On Thu, Jan 27, 2005 at 05:54:24 -0800,
Anil [EMAIL PROTECTED] wrote:
I inserted a new DB with somewhere around 200 tables and each table
having some 100 entries. The table insertion went fine.
But I wanted to know whether the DB is perfect ...I mean my DB is not
corrupted. Are there any
On Sat, Jan 29, 2005 at 22:24:46 +0300,
Andrey V. Semyonov [EMAIL PROTECTED] wrote:
Hi there.
How do I create a sequence of type inet for automatic assignment an
IP/32 to a new row?
Neither nextval() nor CREATE SEQUENCE seem for me to work with type inet
(PostgreSQL 8.0.0, pgAdmin III v
On Thu, Jan 27, 2005 at 12:45:13 +0100,
Miguel Angel Tribaldos Hervas [EMAIL PROTECTED] wrote:
I only need to know if a table has changed since the last check
(create, update...), but I want to avoid a trigger + artificial records table.
Is this information recorded somewhere, in a system
On Thu, Jan 27, 2005 at 08:47:40 -0800,
[EMAIL PROTECTED] wrote:
What should the command look like using ~/.pgpass ?
You might also consider using using ident as the authentication method if
it is supported by your os.
---(end of broadcast)---
On Wed, Jan 26, 2005 at 23:12:25 +0100,
PFC [EMAIL PROTECTED] wrote:
How do you do a self-join on a subselect ?
like
SELECT a.x+b.x FROM (subselect) a, (subselect) b WHERE a.id = b.id+10
but without performing the subselect twice
On Thu, Jan 27, 2005 at 00:35:25 -0500,
Madison Kelly [EMAIL PROTECTED] wrote:
Hi all,
I have several tables with an 'id' column which is a simple 'serial
unique' type. Often when I insert a record the next thing I need is to
add or edit another table elsewhere using the ID of the
On Sun, Jan 23, 2005 at 10:23:50 +0100,
Ralph van Etten [EMAIL PROTECTED] wrote:
But I think there are situations where a serial isn't convenient
Like when you want an primary key which consists of the current
year and an sequence number. Like ('05', 1), ('05', 2), ('05', 3) etc.
With a
On Fri, Jan 21, 2005 at 12:02:09 +0100,
Marco Colombo [EMAIL PROTECTED] wrote:
On Fri, 21 Jan 2005, Greg Stark wrote:
Anyway, think of floats. If you want do to FP maths fast, you need to use
the native format supported by the CPU. When you dump, you get a text
form of the FP number, and
On Wed, Jan 19, 2005 at 11:06:56 -0500,
[EMAIL PROTECTED] wrote:
What does that mean?
http://en.wikipedia.org/wiki/Slashdot_effect
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
On Fri, Jan 14, 2005 at 11:36:26 -0800,
[EMAIL PROTECTED] wrote:
I saw the note in the docs that to_char(interval, text) is deprecated, and
will be removed. I searched the archives and saw more mentions of this,
but no real explanation as to how it is planned for us to get consistent
output
On Fri, Jan 14, 2005 at 17:49:42 -0800,
Steve Atkins [EMAIL PROTECTED] wrote:
That's correct, documented behaviour. A serial column is mostly just a
sequence in disguise. A sequence is guaranteed to give unique,
increasing values, but in many cases may miss a value (for several
reasons -
On Fri, Jan 14, 2005 at 11:16:16 -0500,
Eric Dorland [EMAIL PROTECTED] wrote:
* Disconnecting all other users before dropping the db, but that doesn't
seem possible (I could start and stop the db, but that doesn't stop any
clients from just reconnecting right away).
You could use an alter
On Thu, Jan 13, 2005 at 09:01:08 -0500,
Dave Smith [EMAIL PROTECTED] wrote:
I am trying to add a unique constraint on a column that can be null. The
documentation states that null is treated as non equal values but I want
them to be equal. Is there another way of doing this other than writing
On Mon, Jan 10, 2005 at 14:40:46 -0800,
Chris [EMAIL PROTECTED] wrote:
Basically what I want is to limit a user to not being able to view
certain tables within a schema, in this case the public schema. Say
we have 300 tables in a database but a particular user only needs
access to 3 of
On Tue, Jan 11, 2005 at 18:36:17 +,
Richard Huxton dev@archonet.com wrote:
Nirmalya Lahiri wrote:
Thanks Richard,
for your reply. Now I am explaining you what I want.
Let I have 4
functions..function_1(),function_2(),function_3(),function_4().
[snip]
Now after creating these
On Tue, Jan 11, 2005 at 15:40:07 +,
Peter Childs [EMAIL PROTECTED] wrote:
I thought pg_autovaccum was going to be built into 8.0 or was that
only a rumor.
Due to some unfortunate things it was not ready by the beta cutoff, so it
is staying in contrib for the 8.0 release.
301 - 400 of 675 matches
Mail list logo