Marc G. Fournier wrote:
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 m
Hi Greg,
Although it doesn't really seem to be a very well-structured database
design, I think there is a solution.
If the amount of fields is low, you can just stick a CASE in the MAX like:
SELECT ...,
MAX(
CASE WHEN value1 > value2 THEN
(CASE WHEN value1 > value3 THEN value1 ELSE va
[posted and mailed to the list]
On 6 Nov 2004 01:44:34 -0800, "Robert G" <[EMAIL PROTECTED]> wrote:
>
>Mike Cox wrote:
>> REQUEST FOR DISCUSSION (RFD)
>> unmoderated group comp.databases.postgresql.general
>>
>> This is a formal Request For Discussion (RFD) for the creation of
>> a world
[EMAIL PROTECTED] ("Net Virtual Mailing Lists") wrote:
>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_updat
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
A bad link in the ftp source directory inspired me to check
the rest of it out:
* Main README file needs updating. The URL is given as:
http:/www.postgreSQL.org
but should be:
http://www.postgresql.org/
The copyright notice inside it is v
I tried a lot of apps. The one I prefer is "DbDesigner4" but I don't
see support for postgresql... Only Oracle, mySQL...
There is support for ODBC, I don't know if that will do the job if I
install Unix-ODBC and create a postgres data source.
The point is, IF I succeed to make it work with post
On Sun, 7 Nov 2004, Gary L. Burnore wrote:
This talk of opening up the list to the Big Eight and making a 2-way
gateway would have a devastating effect on the way the list currently
functions.
Then get the gateway removed. One way causes grief. Someone reads a
post, replies and bad stuff happens.
There is an ODBC driver for windows that will then talk native to the
PostgreSQL database, why not use that?
Also what features do you think something might be able to use anyway
to "optimise"?
Hope this helps,
On Sun, Nov 07, 2004 at 02:49:06PM -0500, Eric wrote:
> I tried a lot of apps. The o
"Uwe C. Schroeder" <[EMAIL PROTECTED]> writes:
> 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 var
He wants to be in the big 8. He would like to be under the comp.databases.*
domain and will not to move it to something like postgresql.*.
So he seems to agree with what was my original intention, which was to make
the current groups proper members of the big 8.
I also offered to let him take
Andy wrote:
> "Stephan Szabo" wrote:
>
> (politely snipped)
>
> Hi Stephan. As Robert tried to explain, this Mike Cox character is
> proposing that only the general list become an official Big-8
> newsgroup.
No that is not what I'm proposing. Each group MUST go through the RFD and
CFV seperat
On Sun, 07 Nov 2004 19:26:42 GMT, Stephan Szabo <[EMAIL PROTECTED]>
wrote:
>"Robert G" <[EMAIL PROTECTED]> wrote:
>>
>>Mike Cox wrote:
>>> REQUEST FOR DISCUSSION (RFD)
>>> unmoderated group comp.databases.postgresql.general
>>>
>>> This is a formal Request For Discussion (RFD) for the cre
On 7 Nov 2004 20:01:51 GMT, "Andy" <[EMAIL PROTECTED]> wrote:
>"Stephan Szabo" wrote:
>
>(politely snipped)
>
>Hi Stephan. As Robert tried to explain, this Mike Cox character
Hi Stephen, this "Andy" character isn't using a real name or address.
>is
>proposing that only the general list become a
On Sun, 7 Nov 2004, Mike Cox wrote:
Also, he pointed out that for those who want to get the postgresql
groups when their usenet sever doesn't carry them, the solution would be
to point their newsreaders to news.postgresql.org.
The other point I'd like to make ... we have two mail<->gateways setup
On Sun, 2004-11-07 at 16:32, Eric wrote:
> Is there a visual designer (open source) in linux for database? I would
> like to developp my data model on the computer...
'Druid' is a Java app that does schema diagrams and point and click
table management stuff:
http://druid.sourceforge.net/
I h
I have a database with a btree index on the 'removed' field,
which is of type 'date'. However it isn't being used:
techdb2=> explain select * from lines where removed > CURRENT_DATE;
QUERY PLAN
Seq Scan on lines
My company has a GUI report writer and renderer that we will be releasing under
an open source license shortly. You can see some intro material at
www.openmfg.com/solutions/openreports.php. Please contact me off-list at
[EMAIL PROTECTED] if you'd be interested in beta testing.
Regards,
Ned Lil
On Sun, 7 Nov 2004, Gary L. Burnore wrote:
The groups aren't listed as moderated. Anyone who wants to post is
able to. Those not on the mailing list don't go through. That's the
problem.
As long as the posting gets to the gateway, it gets put into the
moderator (me) queue for approval ...
M
> Bruno Wolff III wrote:
>
>> I saw a post indicating a request for discussion on the creation of an
>> official big 8 newsgroup comp.databases.postgresql.general. According to
>> the notice this newsgroup already exists in google groups and is actively
>> being used. The discussion will be in ne
Bruno Wolff III wrote:
> I saw a post indicating a request for discussion on the creation of an
> official big 8 newsgroup comp.databases.postgresql.general. According to
> the notice this newsgroup already exists in google groups and is actively
> being used. The discussion will be in news.groups
> 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 versionof the join query.
Here is the corrected version, which still has the sequential scan...
explain select notificat
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 of it.
I think you're pursuing this
>
> >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;
> >
> >Indexes cannot be used for retrieving results...
I'm not sure if i
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?
--
Bill
---(end of broadcast)---
TIP 9: the planner will ign
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 with *him* on what the problem and
"Devin L. Ganger" <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
>> Russ Allbery <[EMAIL PROTECTED]>, seems very knowledgable about this,
>> and I would be pleased if you could mail the postgresql list person
>> about this discussion and Russ's email address.
>
> Russ is a busy person;
In article <[EMAIL PROTECTED]>, Mike Cox
<[EMAIL PROTECTED]> wrote:
> I'm pretty much done with this anyway. It is a waste of time putting in
> anymore effort since no one seems to want it.
You're way too impatient. Things don't happen here in time scales that
are measured in hours or days. Ha
On Sun, 2004-11-07 at 14:54, Martijn van Oosterhout wrote:
> There is an ODBC driver for windows that will then talk native to the
> PostgreSQL database, why not use that?
Because I'm on linux :p
---(end of broadcast)---
TIP 1: subscribe and un
Hi.
Is it possible to dump a database on a 7.4.6 server and then restore it
on a 7.4.1 server?
should i use the 7.4.1 pg_dump or the 7.4.6 pg_dump?
should i use any switches?
thanks
---(end of broadcast)---
TIP 6: Have you searched our list archives
Klaas <[EMAIL PROTECTED]> wrote in
news:[EMAIL PROTECTED]:
>> No that is not what I'm proposing. Each group MUST go through the
>> RFD and CFV seperately. I started off with the most popular group
>> first. After It was done, I would have started on the rest.
>
> Not true. It is actually rat
On Fri, 5 Nov 2004 08:42:40 -0800 (PST), [EMAIL PROTECTED] (Andy M)
wrote:
>ALERT
>
>There is a person by the name of Mike Cox who's trying
>to turn this mailing list into a Big-8 newsgroup. Many
>of you know that this and most of the other postresql
>mailing lists are already gated to Google Grou
Hi all,
I wanted to install postgreSQL 7.4 on my ia32e box (x86_64 dual xeon PL370G4)
running WBEL3.0. I looked for binary RPMs but did not find any. So I tried to
rpmbuild --rebuild --define 'build9 1' postgresql-7.4.6-2PGDG.src.rpm
but during configure I get the error
checking for pyth
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.
Much better, especially if you
In news.groups, Mike Cox <[EMAIL PROTECTED]> writes:
> I'm pretty much done with this anyway. It is a waste of time putting in
> anymore effort since no one seems to want it.
Well, the problem from my perspective is that a lot of time and energy is
being spent on worrying about how to propose so
In news.groups, Devin L Ganger <[EMAIL PROTECTED]> writes:
> Mike Cox <[EMAIL PROTECTED]> wrote:
>> Russ Allbery <[EMAIL PROTECTED]>, seems very knowledgable about this,
>> and I would be pleased if you could mail the postgresql list person
>> about this discussion and Russ's email address.
>
I know this doesn't answer your question, but have
you considered doing it with DTS instead of BCP?
I used it recently to migrate an Access database to
PostGreSQL and it worked great. One of the big advantages is the ability to
transform the data as it is being converted.
It is also built in
But if you do build an index over "id" then pgsql would only have to do a
sequential scan on that index, which might be a lot faster if your table
contains a lot of other data, won't it?
Jerry
""Ed L."" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> On Saturday November 6 2004 7
hi
I have been trying to use the Postgresql library (libpq.so) and processes in my program.
The scenario is like that:
I have made a small shared library where I wrapp the Postgresql functions.
I then call those library functions (my library) from my program.
The program is to behave as a
stig erikson <[EMAIL PROTECTED]> writes:
> Is it possible to dump a database on a 7.4.6 server and then restore it
> on a 7.4.1 server?
Should work, but why aren't you updating the 7.4.1 server? There were
some pretty nasty bugs fixed between .1 and .6.
regards, tom lane
On Sat, 6 Nov 2004, Russ Allbery wrote:
If Marc was happy with them being turned into real Big Eight groups and
the technical issues of the gatewaying were worked out with Marco or
someone else
what 'techincal issues of the gatewaying'?
Marc G. Fournier Hub.Org Networking Services (h
=?iso-8859-1?Q?Einar_M=E1r_Bj=F6rvinsson?= <[EMAIL PROTECTED]> writes:
> The program starts by opening a connection to the database, enter the =
> infinite while loop to run some functions.=20
> Inside the while loop it forks many childs which then call one function =
> from the library I made.
A
> 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
At 12:16 AM 11/7/2004, Russ Allbery wrote:
In news.groups, Mike Cox <[EMAIL PROTECTED]> writes:
> I'm pretty much done with this anyway. It is a waste of time putting in
> anymore effort since no one seems to want it.
Well, the problem from my perspective is that a lot of time and energy is
being
At 04:29 PM 11/7/2004, Marc G. Fournier wrote:
On Sun, 7 Nov 2004, Gary L. Burnore wrote:
The groups aren't listed as moderated. Anyone who wants to post is
able to. Those not on the mailing list don't go through. That's the
problem.
As long as the posting gets to the gateway, it gets put into the
At 08:29 AM 11/6/2004, edward ohare wrote:
On Fri, 5 Nov 2004 08:42:40 -0800 (PST), [EMAIL PROTECTED] (Andy M)
wrote:
>ALERT
>
>There is a person by the name of Mike Cox who's trying
>to turn this mailing list into a Big-8 newsgroup. Many
>of you know that this and most of the other postresql
>mail
On Sun, 07 Nov 2004 21:16:05 GMT, Stephan Szabo <[EMAIL PROTECTED]>
wrote:
>Gary L. Burnore <[EMAIL PROTECTED]> wrote:
>>On Sun, 07 Nov 2004 19:26:42 GMT, Stephan Szabo <[EMAIL PROTECTED]>
>>wrote:
>>
>>>"Robert G" <[EMAIL PROTECTED]> wrote:
Hello Mike. A number of us from the mailing lis
On Sun, 7 Nov 2004 16:50:34 -0400 (AST), [EMAIL PROTECTED] ("Marc
G. Fournier") wrote:
>On Sun, 7 Nov 2004, Mike Cox wrote:
>
>> Also, he pointed out that for those who want to get the postgresql
>> groups when their usenet sever doesn't carry them, the solution would be
>> to point their newsre
Someone posted this official proposal to create
comp.databases.postgresql.general again. He wrote his own charter. As
far as I know, he did not consult any of the postgresql groups first.
There may be an upcoming vote on this, so please stay informed and read
news.newgroups.announce for updates.
A
Hi all,
I have to develop an embedded database with PostgreSQL.
I have a Linux Distribuction that works only in single user mode as root.
The postmaster daemon starts only if I 'm not root user.
Do you have a solution for this problem ??
Thanks.
---(end of broadcast)---
Here is what I get:
orfs=# \df+ get_datasets
List of functions
Result data type |Schema| Name | Argument
data types | Owner | Language
|
Andy wrote:
> Someone posted this official proposal to create
> comp.databases.postgresql.general again. He wrote his own charter. As
> far as I know, he did not consult any of the postgresql groups first.
> There may be an upcoming vote on this, so please stay informed and read
> news.newgroups.a
In article <[EMAIL PROTECTED]>,
Mike Cox <[EMAIL PROTECTED]> wrote:
>
>I would like to point out that it is NOT creating a different group. It
>will still be the same, and there will not be a split or anything. What
>will happen is that the postgresql group will become legitimate, and
>therefore
On 4 Nov 2004 17:17:20 GMT, "Andy" <[EMAIL PROTECTED]> wrote to
news.groups:
>Someone posted this official proposal to create
>comp.databases.postgresql.general again.
As the name says, this is a Request for Discussion, not an "official
proposal" (whatever that may be). Discussion about this is
Hi.
As most of you know, comp.databases.postgresql.general is a wonderful
resource. What you may not know is that it has not gone through a
process that would enable it to be listed on hundreds of usenet
servers worldwide by default.
Normally groups that are under the comp.* hierarchy go through
Andy M wrote:
> ALERT
>
> There is a person by the name of Mike Cox who's trying
> to turn this mailing list into a Big-8 newsgroup.
No, I'm trying to get teh postgresql groups which are already ON usenet to
follow proper usenet guidelines. In order to be under the comp.* hierarchy
the server
i am currently migrating a db from Oracle to Pg and in some
of my triggers i use variables, i.e. i have some thing like this:
[Oracle version]
CREATE OR REPLACE TRIGGER "USERACTION_VIEW"
INSTEAD OF INSERT ON "USERACTION_VIEW" DECLARE
UserActionID INTEGER;
UserA
Hi all,
I have to develop an embedded database with PostgreSQL.
I have a Linux Distribuction that works only in single user mode as
root.
The postmaster daemon starts only if I 'm not root user.
Do you have a solution for this problem ??
Thanks.
---(end of broadcast
[EMAIL PROTECTED] (Vivek Khera) writes:
> > "DP" == David Parker <[EMAIL PROTECTED]> writes:
>
> DP> I would like to be able to truncate all of the tables in a schema
> DP> without worrying about FK constraints. I tried issuing a "SET
> DP> CONSTRAINTS ALL DEFERRED" before truncating, but I s
On 4 Nov 2004 17:17:20 GMT, "Andy" <[EMAIL PROTECTED]> wrote:
>Someone posted this official proposal to create
>comp.databases.postgresql.general again. He wrote his own charter. As
>far as I know, he did not consult any of the postgresql groups first.
>There may be an upcoming vote on this, so pl
On Wed, 2004-11-03 at 18:10, Ed L. wrote:
> unfortunately, the requirement is 100% uptime all the time, and any
> downtime at all is a liability. Here are some of the issues:
Seems like 100% uptime is always an issue, but not even close to
reality. I think it's unreasonable to expect a single pi
What version of postgres are you using? In postgresql-7.4.6, I get an
empty query buffer when I try what you describe here.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-0005
On
We in Calicut UNIversity using posgresql in our examination wing.
Now we can not use our database. It gives some message as follows.
XLogFlush : request 0/D8949278 IS NOT SATISFIED. --FLUSHED ONLY TO 0/D1702530
What is this. Why this message comes. And how to overcome this problem?
Madhu VT
S
Eric wrote:
> Is there a visual designer (open source) in linux for database? I would
> like to developpASCIIata model on the computer...
>
> I see "dia" with uml library but... it won't export to SQL.
>
If you like Qt can use Qt-Designer (assuming you have the PostgreSQL odbc
driver installed
On Mon, 8 Nov 2004 07:56 am, "Miquel van Smoorenburg" wrote:
> I have a database with a btree index on the 'removed' field,
> which is of type 'date'. However it isn't being used:
>
> techdb2=> explain select * from lines where removed > CURRENT_DATE;
> QUERY PLAN
> --
On Sun, 7 Nov 2004, Gary L. Burnore wrote:
On Sun, 7 Nov 2004 16:50:34 -0400 (AST), [EMAIL PROTECTED] ("Marc
G. Fournier") wrote:
On Sun, 7 Nov 2004, Mike Cox wrote:
Also, he pointed out that for those who want to get the postgresql
groups when their usenet sever doesn't carry them, the solution wo
On Sun, 7 Nov 2004, Gary L. Burnore wrote:
User makes a comment in USENet. Post gets seen on usenet servers around
the world. Moderator chooses not to approve.
Unless ist Spam, moderator always approves ... I know, cause its me ...
Marc G. Fournier Hub.Org Networking Services (http
On Sun, 7 Nov 2004, Gary L. Burnore wrote:
At 04:29 PM 11/7/2004, Marc G. Fournier wrote:
On Sun, 7 Nov 2004, Gary L. Burnore wrote:
The groups aren't listed as moderated. Anyone who wants to post is
able to. Those not on the mailing list don't go through. That's the
problem.
As long as the postin
On Thu, 4 Nov 2004, Kenneth Downs wrote:
Then I've noticed some notes here and there that you are supposed to send
some emails to a list-server if you post, to avoid messing up the mailing
list? Is that right? Why would I be worried about a listserv?
There are no such requirements that I'm aware
Heu...
I search for a graphical DATA MODEL designer in linux to developp my
database project (to draw) it on screen instead of paper and pencil...
Thanks for answers about Database GUI developper... I will surely need
it later but for now, I want to "draw" boxes etc... on screen for my
tables and
Marc G Fournier <[EMAIL PROTECTED]> writes:
> On Sat, 6 Nov 2004, Russ Allbery wrote:
>> If Marc was happy with them being turned into real Big Eight groups and
>> the technical issues of the gatewaying were worked out with Marco or
>> someone else
> what 'techincal issues of the gatewaying'?
Th
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Karim Nassar)
wrote:
> On Wed, 2004-11-03 at 18:10, Ed L. wrote:
>> unfortunately, the requirement is 100% uptime all the time, and any
>> downtime at all is a liability. Here are some of the issues:
>
> Seems like 100% uptime is alw
On Sun, 7 Nov 2004, Russ Allbery wrote:
There are a couple of things that would be ideal to fix. One is that
currently the gateway isn't rewriting message IDs, which means that if
anyone else gates the same mailing lists into some other group, the
posts will conflict and posts will randomly dis
72 matches
Mail list logo
