Marc G. Fournier wrote:
> On Fri, 5 Nov 2004, Joshua D. Drake wrote:
>
>>
>>>
>>> I've posted details to the FreeBSD -stable and -current mailing list,
>>> but the simple summary is that 'ifconfig -alias' with no ip
>>> specific'd literally erases all IPs on that device, leaving the
>>> server run
ok. I gonna explain a little more my situation.
I have a postgres server (Linux) and clients
(Win2k+delphi application).
I need create a text file with some columns from a
table in the server machine, but this file must be
created only when the user wants. (click button on my
delphi program on t
Hi,
Am Sa, den 06.11.2004 schrieb Leo Martin Orfei um 13:52:
> ok. I gonna explain a little more my situation.
>
> I have a postgres server (Linux) and clients
> (Win2k+delphi application).
> I need create a text file with some columns from a
> table in the server machine, but this file must be
On Sat, 6 Nov 2004, Gaetano Mendola wrote:
Marc G. Fournier wrote:
On Fri, 5 Nov 2004, Joshua D. Drake wrote:
I've posted details to the FreeBSD -stable and -current mailing list,
but the simple summary is that 'ifconfig -alias' with no ip
specific'd literally erases all IPs on that device, leavi
OK
thank you
> On Fri, Nov 05, 2004 at 04:21:52PM -0400, Mario A. Soto Cordones wrote:
>
>> How can i get the Client Host name/IP Address for the current
>> connection(session). Is there any function or system table(view) which
>> will these details.
>
> In 8.0 you'll be able to use inet_client_ad
On Sat, Nov 06, 2004 at 11:09:07AM -0400, Marc G. Fournier wrote:
> On Sat, 6 Nov 2004, Gaetano Mendola wrote:
>
> >I used to have a script on my remote server that I was running in BG before
> >to touch the network, that script was bringing up the network if was down
> >for more then 2 minutes. M
Is there a way to create an index that would make this query be efficient
and not perform a sequential scan?
SELECT count(*) AS count,id FROM sometable GROUP BY id;
.. I've considered creating a rule on this table which would put the
results of this into another table anytime it is updated, but I
On Saturday November 6 2004 7:34, Net Virtual Mailing Lists wrote:
> Is there a way to create an index that would make this query be efficient
> and not perform a sequential scan?
>
> SELECT count(*) AS count,id FROM sometable GROUP BY id;
>
> .. I've considered creating a rule on this table which
I'd like to have a DB client connect using a username ('psuedodba')
different from the creator/owner ('dba') of the DB and its tables, but
still have that username be able to do everything the creator/owner can do
(alter tables, drop databases, etc). It appears that
"createuser -d -a
I am not clear how to use a trigger for this, I will need to look into
that
It is my understanding that Postgres does not have materialized views
though (which I believe would solve this problem nicely) - am I mistaken?...
- Greg
>Net Virtual Mailing Lists wrote:
>> Is there a way to cre
Hello,
I have a table with a rule that goes something like this:
CREATE OR REPLACE RULE sometable_delete ON DELETE DO delete FROM cache
WHERE tablename='sometable';
CREATE OR REPLACE RULE sometable_insert ON INSERT DO delete FROM cache
WHERE tablename='sometable';
CREATE OR REPLACE RULE sometable
Ed L. wrote:
> "createuser -d -a psuedodba"
>
> works for this purpose. Are there circumstances where 'psuedodba'
> lacks powers that 'dba' has to
> create/destroy/alter/update/insert/delete? Or are they truly
> equivalent in powers?
You have created a superuser, who can do anything. This
Since we have the discussion going, someone mentioned that the group name
should be comp.databases.postgresql. I think this is a good name and I'd
like to see what everyone thinks of it.
There is also the issue of the charter. I would like to get some feed back
on what the best charter could be
At the risk of asking an ill-formed oft-asked question that's
probably in the FAQ, is there any report generation tools that
are particularly suited for use with postgres databases?
--
% Randy Yates % "My Shangri-la has gone away, fading like
%% Fuquay-Varina, NC% t
I have a CSV file with 400,000 lines of email mailing list information that
I need to migrate to a new PostgreSQL database.
Each line has all the info I need except a PK (I usually use an int4 column
for a PK).
If the file were smaller I would probably just use Excel to pop in a PK and
then just
On Saturday November 6 2004 12:04, Randy Yates wrote:
> At the risk of asking an ill-formed oft-asked question that's
> probably in the FAQ, is there any report generation tools that
> are particularly suited for use with postgres databases?
Not sure if you're looking for open source products or c
Hi,
I'm using PostgreSQL 8.
I have two tables that I am doing a join on, and the join executes very
slowly.
The table called Notification has a text field called NotificationID,
which is its primary key. The Notification table also has an int4 field
called ItemID, and it has an index on the It
Hunter Hillegas wrote:
> I have a CSV file with 400,000 lines of email mailing list
> information that I need to migrate to a new PostgreSQL database.
>
> Each line has all the info I need except a PK (I usually use an int4
> column for a PK).
You could import the file into PostgreSQL and add a pr
On Sat, 06 Nov 2004 12:00:02 -0800, Mike Wertheim wrote:
> Does anyone have any suggestions on how to make this query run faster?
Does it help if you decrease the value of random_page_cost? - That value
can be changed run-time, from within psql. If you find that a certain,
lower value helps, you
Woodchuck Bill wrote:
> Mike Cox <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]
> berlin.de:
>
>> Since we have the discussion going, someone mentioned that the group name
>> should be comp.databases.postgresql. I think this is a good name and I'd
>> like to see what everyone thinks of it.
That sounds nice and easy...
So, I would do something like 'ALTER TABLE' to generate the PK column? What
would be the best way to populate it? Is there an area of doco I should be
looking at?
Thanks,
Hunter
> From: Peter Eisentraut <[EMAIL PROTECTED]>
> Date: Sat, 6 Nov 2004 21:21:25 +0100
> To
explain select notificationID from NOTIFICATION n, ITEM i where
n.itemID = i.itemID;
QUERY PLAN
--
Hash Join (cost=47162.85..76291.32 rows=223672 width=44)
Hash Cond: ("outer".itemid
the simplest way to do it seems to be adding a SERIAL column to your table, and then adding a primary key constraint:
1)insert data into table
2)ALTER TABLE ADD id SERIAL;
3)ALTER TABLE ADD CONSTRAINT _pk PRIMARY KEY (id);
you can check the docs for the SERIAL type: http://www.postgresql.or
On Saturday November 6 2004 2:13, Franco Bruno Borghesi wrote:
> the simplest way to do it seems to be adding a SERIAL column to your
> table, and then adding a primary key constraint:
>
> 1)insert data into table
> 2)ALTER TABLE ADD id SERIAL;
> 3)ALTER TABLE ADD CONSTRAINT _pk PRIMARY KEY (id);
I've tested it, and the SERIAL type populates the column when you add it
On Sat, 2004-11-06 at 18:56, Ed L. wrote:
On Saturday November 6 2004 2:13, Franco Bruno Borghesi wrote:
> the simplest way to do it seems to be adding a SERIAL column to your
> table, and then adding a primary key cons
At 10:11 PM +0100 11/6/04, Pierre-Frédéric Caillaud wrote:
explain select notificationID from NOTIFICATION n, ITEM i where
n.itemID = i.itemID;
QUERY PLAN
--
Hash Join (cost=47162.85..7
> I'm not a SQL guru by any stretch but would a
> constrained sub-select be appropriate here?
> Well, you're joining the entire two tables, so yes, the seq scan might
> be faster.
My mistake! When composing the email to state the problem, I accidentally
gave a wrong version of the join query.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Here's a question for the SQL guru's out there, which I've been trying to
solve for the last couple of hours. There's got to be a solution to this, but
somehow I can't find it.
Tables:
table1 (
uid int PK,
uname varchar(64)
)
tabl
<[EMAIL PROTECTED]> writes:
> Here is the corrected version, which still has the sequential scan...
> explain select notificationID from NOTIFICATION n, ITEM i where n.itemID
> = i.itemID and i.projectID = 12;
> QUERY PLAN
>
Hello,
Lets say I have data like this:
value1|value2|value3|value4||value(N)
--|--|--|--||
100 | 200 | 300 | 400 ||
10| 20 | | 40 ||
| 15 | | 16 ||
5 | | | ||
Now I want to sort these based on t
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
If someone knows this it would be great - because I'm still curious how to
solve it. However I just remodelled my db structure to eliminate the problem
(basically I pulled the several tables into one since each of the
table2/table3 tables only has
Devin L. Ganger wrote:
> On Sat, 06 Nov 2004 11:11:09 -0800, Mike Cox <[EMAIL PROTECTED]>
> wrote:
>
>> Since we have the discussion going, someone mentioned that the group
>> name
>> should be comp.databases.postgresql. I think this is a good name and
>> I'd like to see what everyone thinks
Polarhound wrote:
> Mike Cox wrote:
>
>> There is resistance in the mailing lists however, even though the groups
>> are
>> already on usenet and are in the managed "big 8" name space without RFD
>> and CFV.
>
> This now brings up the question of traffic numbers. Historically, if
> people are
Woodchuck Bill wrote:
> Mike Cox <[EMAIL PROTECTED]> wrote in
> news:[EMAIL PROTECTED]:
>
>> I cannot handle the volume of email that a mailing list would place
>> on my
>> inbox.
>
> Ever heard of a digest version?
>
I don't care. Its too much of a hassle to dig through without being able t
Devin L. Ganger wrote:
> On Sat, 06 Nov 2004 18:03:57 -0800, Mike Cox <[EMAIL PROTECTED]>
> wrote:
>
>> Devin L. Ganger wrote:
>
>> > I think you're pursuing this backwards, Mike. You should contact the
>> > current owner of the present mail-to-news gateway and build some sort
>> > of consensus
On Sat, 6 Nov 2004, Mike Cox wrote:
1. I tried subscribing to comp.databases.postgresql.general through my
usenet provider thinking it was a regular big 8 group. When it wasn't
found, I sent a request to my news provider to include it.
Most modern news readers allow for multiple news server ... j
On Sat, Nov 06, 2004 at 10:32:30PM -0500, Eric wrote:
> Is there a visual designer (open source) in linux for database? I would
> like to developp my data model on the computer...
>
> I see "dia" with uml library but... it won't export to SQL.
You can have UML diagrams exported to SQL with some
I'm afraid, I'm not used to SQL92 join syntax and almost all my experience
is in Oracle but how about:
SELECT t1.uid
, t1.xname
, t2.uid
, t3.uid
FROM table1 t1
INNER JOIN table2 t2 ON t1.uid = t2.uid
38 matches
Mail list logo
