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 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 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 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 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 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 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
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 Thu, Aug 31, 2006 at 11:41:41 -0700,
Josh Berkus josh@agliodbs.com wrote:
In general, I think that people who harp on PostgreSQL's lack of a
benevolent dictator as an inhibitor to progress are people who are not
comfortable with democracy and are looking for excuses why company X needs
On Wed, Aug 30, 2006 at 12:12:30 +0300,
Devrim GUNDUZ [EMAIL PROTECTED] wrote:
More will be in FC Extras. Please let me know that if you want to see
any PostgreSQL related software in the repository. I do have time to
package all related stuff.
Do you think you could have a way to store
On Thu, Jul 27, 2006 at 15:15:32 +0200,
Tomasz Ostrowski [EMAIL PROTECTED] wrote:
* PostgreSQL integers (as returned by nextval()) are 4 bytes. This
means only 32 bit strength - much too low for today computers.
They are actually 8 bytes. Since session ids aren't valuable for very long
you
On Thu, Jul 27, 2006 at 10:22:33 -0600,
Ian Johnson [EMAIL PROTECTED] wrote:
I want to develop an application in PostgreSQL but when starting the
service I get the following message:
An old version of the database format was found.
You need to upgrade the data format before using
On Wed, Jul 12, 2006 at 13:38:34 -0700,
[EMAIL PROTECTED] wrote:
Hi,
Thanks again.
One more question. Will crosstab function work if i will not know the
number/names of columns before hand? Or I need to supply colum
headings?
I checked a bit into this, and the actual contrib name is
On Wed, Jul 12, 2006 at 07:08:15 -0700,
[EMAIL PROTECTED] wrote:
Thank you for the suggestions.
I will try to describe the problem better.
I have two problems to solve. First one is that I have to transpose a
table.
I have table A that looks like this:
date product price
On Wed, Jul 12, 2006 at 07:55:49 -0300,
Clodoaldo Pinto [EMAIL PROTECTED] wrote:
I have already counted 6 very similar answers. Is there some problem
with the list software that prevents people from noticing it has
already been answered?
In my case, my mail server had been heavily loaded
SQL_ASCII may also be an option (assign no special meaning to
characters at all), but I'm less sure of that. Can email address
contain multibyte characters? I didn't think so...
E-Mail addreses themselves can't, but the comment field of an
address can.
The comment field itself, in
On Mon, Jul 10, 2006 at 20:05:13 -0400,
Chris Browne [EMAIL PROTECTED] wrote:
worse, over time. Fortunately LD rates have been tending to fall...
Unless you call a country where the local phone company is charging userous
rates andmay be giving kickbacks to people who can get people to call
On Tue, Jul 11, 2006 at 06:05:18 -0700,
[EMAIL PROTECTED] wrote:
Hello,
I'm a pgsql novice and here is what I'm trying to do:
1.I need to create a dynamic table with the column names fetched
from the database using a select statement from some other table. Is
it possible? Could you
On Tue, Jul 11, 2006 at 13:11:16 -0400,
Paul Tilles [EMAIL PROTECTED] wrote:
Version postgres 7.4.7:
Following sql
UPDATE tablename SET value = 0.0 where value!=-9.4;
results in the error message
ERROR: operator does not exist: smallint !=- integer
HINT: No operator matches the
On Sun, Jul 09, 2006 at 20:35:39 -0700,
nuno [EMAIL PROTECTED] wrote:
hi there.
i'm trying to clear data in a table but somehow it takes way too much
time than i once expected (i'm using the formal 'delete from xxx' type
of query.).
this table's got several foreign keys and i suspect
On Thu, Jun 29, 2006 at 14:27:30 +0200,
Martijn van Oosterhout kleptog@svana.org wrote:
On Thu, Jun 29, 2006 at 01:21:19PM +0100, Simon Riggs wrote:
The issue is the difference between start of transaction and time when
the serializable snapshot is taken. Since BEGIN and other commands may
On Wed, Jun 28, 2006 at 14:48:01 -0400,
Brad Nicholson [EMAIL PROTECTED] wrote:
I'm seeing something fairly unintuitive about serializable transactions.
When a transaction is on the serializable level, a SELECT query sees
only data committed before the transaction began; it never sees
On Tue, Jun 27, 2006 at 00:52:48 -0300,
Bruno Almeida do Lago [EMAIL PROTECTED] wrote:
Oracle 8.1.7 used to have a severe lock contention when FKs had no index
(causing an sx table lock). AFAIK this was fixed on 9i with the addition
of shared row locking.
In Postgres this problem wasn't
On Tue, Jun 27, 2006 at 20:49:46 +0530,
surabhi.ahuja [EMAIL PROTECTED] wrote:
it is ok if i uninstall the current version of postgres 8.0.0
You need to dump you database(s) first unless you are upgrading to something
in the 8.0.x series.
---(end of
On Tue, Jun 27, 2006 at 13:43:21 +0200,
Christian Rengstl [EMAIL PROTECTED] wrote:
Hi list,
i am in the middle of breaking my head over designing a database and came to
the following question/problem: i have persons whose values (integer) have to
be entered in the db, but per person the
On Tue, Jun 20, 2006 at 00:49:21 -0400,
louis gonzales [EMAIL PROTECTED] wrote:
Florian,
I understand where you're coming from. Indexes are always unique and
all RDBMS systems use them to 'uniquely' identify a row from the the
perspective of internal software management. Index !=
On Tue, Jun 20, 2006 at 10:43:32 -0400,
A.M. [EMAIL PROTECTED] wrote:
You are using a completely outdated interface to postgres. Looking on
CPAN, Pg.pm was last updated 04 Apr 2000. Which version of postgresql are
you using? It is likely that the old interface blows up when connecting to
a
On Mon, Jun 19, 2006 at 13:43:17 -0600,
Chris Smith [EMAIL PROTECTED] wrote:
I am doing some preliminary work on the next major release of a piece of
software that uses PostgreSQL. As odd as this sounds, it seems that a huge
percentage of the new features that have been requested involve
On Sat, Jun 17, 2006 at 16:50:59 -0700,
Kevin Jenkins [EMAIL PROTECTED] wrote:
For example
filename date revision
file110/05/06 1
file110/05/07 2
file210/05/08 1
I want to do a query that will return the greatest date for each
unique filename
If the revisions for a
On Sun, Jun 18, 2006 at 04:18:23 +1000,
Mark Constable [EMAIL PROTECTED] wrote:
Another anti-burnout question, how would I turn on the ability
to view any SQL requests in the logfile ?
I think this section of the manual will answer your question:
On Tue, Jun 13, 2006 at 09:04:15 -0700,
Benjamin Arai [EMAIL PROTECTED] wrote:
Hi,
I have a database where there are three columns (name,date,data). The
queries are almost always something like SELECT date,data FROM table WHERE
name=blah AND date 1/1/2005 AND date 1/1/2006;. I
On Wed, Jun 14, 2006 at 13:51:50 -0700,
[EMAIL PROTECTED] wrote:
Starting with this:
create sequence languages_seq increment by 1;
create table languages (
id integer primary key default nextval('languages_seq'),
language_name varchar(100)
);
insert into languages (id,
On Wed, May 31, 2006 at 00:26:02 -0700,
Berislav Lopac [EMAIL PROTECTED] wrote:
Actually, my situation is like this:
I had a properly running version of Postgres when my Windows crashed. I
Installed a fresh copy on Windows on another disk, and then Postgres on
top of it. Then I started
On Wed, May 31, 2006 at 09:36:23 +0200,
Arnaud Lesauvage [EMAIL PROTECTED] wrote:
I am the only IT here, and my boss asked me to find a way to have
the database always online, without my intervention.
Last time I went on vacation, the server crashed and no one was
able to repair it.
Your
On Wed, May 31, 2006 at 15:34:46 -0500,
Edward Coyle [EMAIL PROTECTED] wrote:
I want to move a windows server 2003 based postgres database from one server
to another server, can I just copy and paste the base folder or do I have to
do a backup and restore? If so what options work best for
On Sun, May 28, 2006 at 07:24:56 -0700,
Berislav Lopac [EMAIL PROTECTED] wrote:
I have recently reinstalled my Windows mychine, including the
PostgreSQL server, but (due to a system crash, unrelated to Postgres) I
wasn't able to dump my databases to import them now. However, I have a
full
On Fri, May 26, 2006 at 09:09:25 -0700,
John Taylor [EMAIL PROTECTED] wrote:
I have a select statement that goes as follows:
SELECT * FROM product prod, prod_alias pa, category cat, company co
WHERE prod.catid = cat.catid
AND prod.coid = co.coid
AND prod.prodid = pa.prodid;
If
On Mon, May 22, 2006 at 12:59:06 +0300,
Joe Kramer [EMAIL PROTECTED] wrote:
On a related note, which objects need to be GRANTed specifically?
There is a saying that following objects can have permissions GRANTed:
1. TABLE
2. DATABASE
3. FUNCTION
4. LANGUAGE
5. SCHEMA
6. TABLESPACE
On Fri, May 19, 2006 at 12:21:28 -0700,
Siah [EMAIL PROTECTED] wrote:
Some pointers could help. any arguments pro/against saving bin data
in db?
If you want transactional semantics you want the data in the DB. If not,
then you will probably get better perfomance if it isn't.
I am not sure that Postgres needs CPAN. CPAN is particularly useful for
handling dependencies. I doubt that there will be lots of dependencies in
Postgres add ons. So having something like the current system where you
download and build packages from source isn't going to be improved much
with a
On Thu, May 11, 2006 at 09:52:41 -0600,
Mark Gibson [EMAIL PROTECTED] wrote:
Is there a disadvantage to having the primary key for a table be a text
type vs. an integer type? Performance? Any difference between having a
varchar or char as a primary key?
You probably want to use 'text'
On Thu, May 11, 2006 at 10:43:50 -0600,
Mark Gibson [EMAIL PROTECTED] wrote:
I've got a followup - The primary key for the table in question consists
of 2 varchar fields: picture 'state' and 'city' where city is guaranteed
to be unique within a state, and (state, city) form a unique key.
On Thu, May 11, 2006 at 18:41:25 -0500,
Jim C. Nasby [EMAIL PROTECTED] wrote:
On Thu, May 11, 2006 at 07:20:27PM -0400, Bruce Momjian wrote:
My damn powerbook drive recently failed with very little warning, other
than I did notice that disk activity seemed to be getting a bit slower.
IIRC
On Fri, May 12, 2006 at 16:29:05 -0400,
John DeSoi [EMAIL PROTECTED] wrote:
But mainly I just want to thank the other posters for junior sales
sheeple from MS and I don't particularly like MacOSX. It seems
entirely too Charlie and the Chocolate factory for me. Almost spewed
Diet Coke
On Tue, May 09, 2006 at 22:17:21 +0300,
Joe Kramer [EMAIL PROTECTED] wrote:
Right on! SHA2 should fallback the same as AES!
Note that it's SHA256, not SHA2.
SHA-1 is really a fix of the original SHA (sometimes referred to as SHA-0).
---(end of
On Tue, May 09, 2006 at 12:10:32 +0200,
Jean-Yves F. Barbier [EMAIL PROTECTED] wrote:
Naa, you can find ATA | SATA ctrlrs for about EUR30 !
But those are the ones that you would generally be better off not using.
Definitely NOT, however if your server doen't have a heavy load, the
software
On Mon, May 08, 2006 at 18:37:31 -0700,
leo camalig [EMAIL PROTECTED] wrote:
Good Day
I Just want to ask on how to allow a non-local in PostgreSQL without adding
it in
pg-hba.conf
That isn't possible. You need to grant the access using that file.
I just want to view
Please keep replies copied to the list so that others can learn from and
contribute to the discussion. I don't remember where this was, but it looks
like general is probably reasonable.
On Mon, May 08, 2006 at 15:02:20 +0100,
Joao Miguel Ferreira [EMAIL PROTECTED] wrote:
Bruno and all,
On Mon, May 08, 2006 at 23:10:31 +0900,
kmh496 [EMAIL PROTECTED] wrote:
doesn't that user have to exist since you are using ident method? that
means unix username == postgres username.
do you have a user named maragato_test on the system?
did you create that user in postgres and on the
On Tue, May 02, 2006 at 14:20:03 -0400,
Matthew T. O'Connor matthew@zeut.net wrote:
Hey all, I was just wondering if there were any plans to get 8.1.4
release in the near future. I'm seeing semi-frequent out of memory
errors that are related to a bugfix that Tom put in post 8.1.3. (Yes I
On Fri, Apr 28, 2006 at 13:52:09 +0200,
Alban Hertroys [EMAIL PROTECTED] wrote:
I realize that this isn't possible for intervals like '1 year 3 months',
but we only use relatively simple intervals like '3 months', '6 weeks'
and '100 hours'.
Is there some easy way to query such intervals
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.
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
On Wed, Apr 26, 2006 at 21:33:32 +0200,
Holger Zwingmann [EMAIL PROTECTED] wrote:
Hi,
I just realized that is is possible to do a (backup) copy of a database
by copying the root folder within the same OS.
There are some other conditions as well. Postgres needs to be shut down when
you do
On Mon, Apr 24, 2006 at 12:42:43 +0530,
karthick muthu [EMAIL PROTECTED] wrote:
hello guys,
what do u think about the near future of postgre?
Can you be more specific?
You can see some of the TODO items that have been done for 8.2 at:
http://www.postgresql.org/docs/faqs.TODO.html
Note that
On Thu, Apr 20, 2006 at 13:52:38 -0300,
Fernan Aguero [EMAIL PROTECTED] wrote:
+[ Bruno Wolff III [EMAIL PROTECTED] (19.Apr.2006 14:39):
|
|
| Granting access to a schema allows use of that schema. It does not grant
| access to objects contained in the schema. You will need to do
On Wed, Apr 19, 2006 at 06:19:50 -0400,
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 not vice versa.
I
On Wed, Apr 19, 2006 at 09:29:50 -0300,
Fernan Aguero [EMAIL PROTECTED] wrote:
The following works, but I'm not sure about the consequences
of granting USAGE to a schema, as the documentation is
not clear, IMO : For schemas, allows access to objects
contained in the specified schema
On Fri, Mar 31, 2006 at 22:18:20 -0300,
Reimer [EMAIL PROTECTED] wrote:
The main reason of my question is that we have a ERP software house client
with many customers running PostgreSQL and one of their big customers is
trying go buy another ERP system that uses Sybase instead of
On Sat, Mar 25, 2006 at 14:30:54 +0100,
Leif Jensen [EMAIL PROTECTED] wrote:
1) I wonder that no one has mentioned anything about security issues in
those two. I know that I'm a novice and that I didn't use MySql very much,
but it seems to me that the PostgreSQL security is much better than
On Thu, Mar 23, 2006 at 15:24:16 -0600,
Michael Lea [EMAIL PROTECTED] wrote:
$s = $db-prepare('SELECT id FROM person WHERE lname = ? AND fname = ?');
But this does not, returning an empty list:
$s-execute('Cher', undef);
= NULL will return NULL for every row and no rows will be
On Tue, Mar 21, 2006 at 21:16:03 +0800,
William ZHANG [EMAIL PROTECTED] wrote:
Sigurdur Gunnlaugsson [EMAIL PROTECTED]
On Mon, 2006-03-20 at 21:10, Wei Wei wrote:
Try:
order by count(id)/age::float
Or you can use the standard grammer:
order by cast(count(id)/age as float)
On Wed, Mar 22, 2006 at 00:10:53 +0200,
Devrim GUNDUZ [EMAIL PROTECTED] wrote:
Hi,
On Tue, 2006-03-21 at 17:02 -0500, Jerry LeVan wrote:
I accidently upgraded my linux/intel to fc5 from fc4 and
something happened...
Postgres cannot find some needed shared libraries any
more.
We
On Mon, Mar 20, 2006 at 13:10:51 -0800,
Wei Wei [EMAIL PROTECTED] wrote:
In a query, there is something like
order by count(id)/age
where both id and age are the integer data type.
From a query result, I believe the operation count(id)/age yields a integer.
I need it in real data
On Thu, Mar 16, 2006 at 18:11:33 +0100,
Kai Hessing [EMAIL PROTECTED] wrote:
The 'status'-row can contain either 1 or -1 and -4. And now I would like
to implement the action that if the the status field in the master table
for a special sid is changed, all status-fields in phon for entries
On Fri, Mar 17, 2006 at 10:33:18 +0100,
Kai Hessing [EMAIL PROTECTED] wrote:
OK, it is really a little bit odd. I try to explain what should be done.
I have 1:n connection between stud and phon (One student does have
different phonenumbers, fax, eMails, etc...). A positive status means
On Thu, Mar 16, 2006 at 10:31:54 +1100,
Chris [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
i am working on this postgresql statement. it picks up all non-null
values only. is there a way to pickup all hour values (if any hour
value not existing, still find them and assign their value to
On Mon, Mar 13, 2006 at 17:50:44 -0600,
Kevin Grittner [EMAIL PROTECTED] wrote:
Short of being compelled by law to open our records, I'm not
comfortable providing any performance comparison which names the
vendor.
An open records request inquiring about vendors and contracts with the
State
On Tue, Mar 14, 2006 at 23:27:24 -0500,
Stephen Frost [EMAIL PROTECTED] wrote:
* Bruno Wolff III ([EMAIL PROTECTED]) wrote:
On Mon, Mar 13, 2006 at 17:50:44 -0600,
Kevin Grittner [EMAIL PROTECTED] wrote:
Short of being compelled by law to open our records, I'm not
comfortable
On Fri, Mar 10, 2006 at 09:36:16 -0500,
Emi Lu [EMAIL PROTECTED] wrote:
Good morning,
In a plpgsql function, I am trying to insert 900, 000 records into
several tables. I remembered people mentioned before that it is better
and more efficient to commit actions for let's say every 5000
On Thu, Mar 09, 2006 at 12:56:21 -0500,
Chris Kratz [EMAIL PROTECTED] wrote:
Hello All,
Is there any way in postgres to have an aggregate that uses input from two
columns without using composite types? The example we are working on is a
first or last aggregate which requires a data
On Wed, Mar 08, 2006 at 12:56:38 -0300,
Rodrigo Sakai [EMAIL PROTECTED] wrote:
Ok, but actually I'm not concerned about logging old values. I'm concerned
about checking temporal constraints. Entity Integrity (PK) and Referential
Integrity (FK).
Did you see the reference to 'Developing
On Sat, Mar 04, 2006 at 03:35:02 +1100,
Alex [EMAIL PROTECTED] wrote:
Hi,
i want to calculate the price difference, change% of 2 price records. Is
there an easy way to do that within one query, rather than writing a
function?
You can use a self join to do this. It won't be spectaculatly
On Mon, Feb 27, 2006 at 18:34:16 +0300,
Nikolay Samokhvalov [EMAIL PROTECTED] wrote:
On 2/27/06, Bruno Wolff III [EMAIL PROTECTED] wrote:
The alternatives to distinct on are painful. They are generally both harder
to read and run slower.
'DISTINCT ON' is evil constuction, because (w/o
On Tue, Feb 28, 2006 at 09:14:59 +0530,
Jeevanandam, Kathirvel (IE10) [EMAIL PROTECTED] wrote:
Hi all,
Please don't hijack existing threads to start new ones. This can cause
people to miss your question and messes up the archives.
Performance questions should generally be posted to the
On Mon, Feb 27, 2006 at 00:25:57 +0300,
Nikolay Samokhvalov [EMAIL PROTECTED] wrote:
On 2/26/06, Karsten Hilbert [EMAIL PROTECTED] wrote:
past'. Yes, standard is 'talkative', but I prefer only standard
things, because it helps me to understand other databases and
'academical things'.
On Fri, Feb 24, 2006 at 10:52:53 -0400,
Marc G. Fournier [EMAIL PROTECTED] wrote:
On Fri, 24 Feb 2006, Bruce Momjian wrote:
Greatbridge had major funding, and succeeded in burning it off in, what,
12 months?
It's been a long time, but I thought they still had a significant amount
of money
On Thu, Feb 23, 2006 at 13:55:34 -0600,
Brandon Metcalf [EMAIL PROTECTED] wrote:
If I have a column called date with data type timestamp without time
zone I know I can use
SELECT * FROM table WHERE date (now()::DATE - 7)::TIMESTAMP;
You can do this without converting to timestamp:
On Fri, Feb 10, 2006 at 07:34:35 -0500,
Doug McNaught [EMAIL PROTECTED] wrote:
Bruno Wolff III [EMAIL PROTECTED] writes:
Or, just start your sequence counting at 100. Or use bigint and
start it at a billion.
That may work if you only have access to one id number, but you don't need
On Tue, Feb 07, 2006 at 15:28:31 +0300,
Nikolay Samokhvalov [EMAIL PROTECTED] wrote:
The real situation would be as the following.
I want to use some algorithm to hide real number of registered users
in my table user. So, I don't want to use simple sequence, when every
new registered user in
On Mon, Feb 06, 2006 at 10:54:49 -0500,
Hrishikesh Deshmukh [EMAIL PROTECTED] wrote:
Hi All,
I am trying to create a simpel table to handle geneId and productId but the
data file which i want to read in has for some genes more than one productId
ex:
GeneId | ProID1 /// ProID2 /// ProID3
On Mon, Feb 06, 2006 at 15:43:30 +0300,
Sergey Karin [EMAIL PROTECTED] wrote:
Hi, List!
I use PG8.1
Are there any abilities to change current user during pl/pgsql function
execution?
I developed function that have 'security definer' option and created under
superuser. But for executing
On Fri, Jan 27, 2006 at 10:25:00 -0600,
Aaron Colflesh [EMAIL PROTECTED] wrote:
#2 would seem to be the simplest except I'm really not too keen on the
idea of manipulating a table like that on the fly (even though I did
proof of concept it and it seems to be simple enough to be fairly
On Fri, Jan 27, 2006 at 10:40:05 -0600,
Aaron Colflesh [EMAIL PROTECTED] wrote:
Bruno Wolff III wrote:
On Fri, Jan 27, 2006 at 10:25:00 -0600,
Aaron Colflesh [EMAIL PROTECTED] wrote:
#2 would seem to be the simplest except I'm really not too keen on the
idea of manipulating a table
On Thu, Jan 26, 2006 at 18:24:36 +0100,
LaroG [EMAIL PROTECTED] wrote:
Hey.
I am new here. I’m from Poland:-)
I have one question (I don’t now if this is the right group for this question
and … if my English is enough good… :P):
Are the developers going to implement some system trigger
On Thu, Jan 26, 2006 at 12:55:46 -0500,
George Woodring [EMAIL PROTECTED] wrote:
I am looking for suggestions on storing and retrieving geocode
information.
My application currently stores 2 columns (lat, long) as numeric and I
have a btree index on them. This works fine for the current
On Wed, Jan 18, 2006 at 14:26:28 -0700,
Assad Jarrahian [EMAIL PROTECTED] wrote:
Hello,
I have a table called X
it contains 3 fields of importance(amongst others).
time (timestamp), snooze (int) , inbox (int)
The time column sometimes has null values.
What I want is that every time a
On Thu, Jan 19, 2006 at 02:05:41 -0800,
bgolda [EMAIL PROTECTED] wrote:
Hello, this is my first post, please don't shoot...
I was just experimenting with transactions (PG 8.1), and there is
something which puzzles me. If i write 'SET TRANSACTION ISOLATION LEVEL
SERIALIZABLE;' in my
On Thu, Jan 05, 2006 at 23:04:55 -0600,
Angshu Kar [EMAIL PROTECTED] wrote:
Could you please tell me what's the syntax with INSERT for this?
http://developer.postgresql.org/docs/postgres/sql-insert.html
---(end of broadcast)---
TIP 2: Don't
On Thu, Jan 05, 2006 at 22:51:55 -0600,
Angshu Kar [EMAIL PROTECTED] wrote:
Hi Pgsql,
I've a table schema in pg say as:
(A B C D E)
where none of these fields allow null.
Now, I've a flat file that has got tab-delimited data for B,C and E fields.
And A,B come from sequences.
On Mon, Jan 02, 2006 at 11:21:40 -0800,
Mike [EMAIL PROTECTED] wrote:
I am new in this field and would appreciate it if someone points me to
the right direction.
I have a website with lots of users and each have lots of data in
multiple tables. I want to create a search box where a user
On Fri, Dec 30, 2005 at 13:30:40 -0800,
CSN [EMAIL PROTECTED] wrote:
I have three columns, and one of them can be null. I'd
like to create a unique constraint across all three
columns and allow only one null value. e.g.
a|b|c
abc|123|null
abc|123|null # not allowed
abc|456|null
On Tue, Dec 27, 2005 at 15:49:43 -0800,
Gregory S. Williamson [EMAIL PROTECTED] wrote:
Petr,
As long as the new server is the same operating system, and the versions of
postgres are the same, you can do a binary copy of the data directory and
move it to the new machine, point the new
101 - 200 of 675 matches
Mail list logo