On Fri, Mar 26, 2004 at 02:28:10 -0800,
Andrew Mayo <[EMAIL PROTECTED]> wrote:
> PLEASE can we have the native Win32 port SOON.
>
> It will totally and utterly hurt Microsoft in a very important area to
> have this port. Why?
People are working on it and from what I have seen on the lists
On 25 Mar 2004, Roger Dahl wrote:
> To find out which boxes contain a specific item, I would write a query
> like this:
>
> select b.name,
> from boxes b
> inner join item_box_maps m on m.box_id = b.id
> inner join items i on m.id = m.item_id
> where i.name = 'hammer';
Is this the actual query?
On Fri, Mar 26, 2004 at 11:53:47 -0600,
Guy Rouillier <[EMAIL PROTECTED]> wrote:
>
> I saw in the referenced sequence of posts that PostgreSQL will close a
> file for a table once it reaches 1 GB, and start a new file. So I'm
> concluding PostgreSQL has the ability to span multiple files for a
Thanks for your response. I looked the posts you reference, but, to be quite
frank, I didn't understand. I am confused regarding the sample code in the
documentation I am looking at. Here it is:
CREATE FUNCTION use_many_fields(tablename) RETURNS TEXT AS '
DECLARE
in_t ALIAS FOR $1;
BEGIN
[EMAIL PROTECTED] wrote:
> On 3/25/04 4:13 PM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote:
>
> > Are you sure your change is correct? We just added
> > "-D_POSIX_PTHREAD_SEMANTICS" in post 7.4.2, and the submitters did not
> > mention any problems with the -pthread line for gcc.
> >
> > I just tr
On Mar 26, 2004, at 6:28, Anony Mous wrote:
Thanks again. I've got it working using the API calls described.
pg_dump does return an exit code of 0 upon success. Does anyone know
off
hand what is returned when the process fails?
Not 0. You're looking for success, right?
--
Dustin Sallings
--
Andrew Mayo wrote:
PLEASE can we have the native Win32 port SOON.
All I can tell you is that a lot of energy and code is being thrown at
this problem and a lot of progress has been make. While it's not done
yet, it certainly appears that 7.5 will include a native win32 port!
But as i
Bruno Wolff III wrote:
> On Fri, Mar 26, 2004 at 11:53:47 -0600,
> Guy Rouillier <[EMAIL PROTECTED]> wrote:
>>
>> I saw in the referenced sequence of posts that PostgreSQL will close
>> a file for a table once it reaches 1 GB, and start a new file. So
>> I'm concluding PostgreSQL has the abilit
--- Rick Gigger <[EMAIL PROTECTED]> wrote:
> > So can I quietly beg the Win32 group to expedite
> this port. I believe
> > you will be utterly astonished at the demand.
> Please.
>
> I'm sure quietly begging certain developers with
> your pocekt book
> probably wouldn't hurt your cause either
On Fri, Mar 26, 2004 at 02:28:10AM -0800, Andrew Mayo wrote:
> PLEASE can we have the native Win32 port SOON.
I don't think anyone is dragging their heels on purpose. If it's
that important to you, consider contributing either in code or in
paid developer time.
A
--
Andrew Sullivan |
On Thu, 25 Mar 2004, Anoop Rajendra wrote:
> Hi, I was having some problems with inserting into a table with a trigger
> function attached.
>
> My code is shown below -
> CREATE OR REPLACE FUNCTION update_tv_prefs() RETURNS trigger AS '
> BEGIN
> SELECT * FROM tvprefs WHERE ch_number = NEW
On Wednesday 24 March 2004 10:59 am, Peter Lang wrote:
> I'm running pg_dump 7.3.4..does anyone
> have any suggestions on another method to confirm whether or not
> the db was successfully dumped?
>
> BTW I'm running under Win2k using Cygwin.
Normally you can check the exit status of the comma
Glad I could help. As Dustin pointed out, pg_dump
will return a non-zero value to indicate an error.
Regards,
Shelby Cain
--- Anony Mous <[EMAIL PROTECTED]> wrote:
> Thanks again. I've got it working using the API
> calls described.
>
> pg_dump does return an exit code of 0 upon success.
>
On Fri, 26 Mar 2004, Guy Rouillier wrote:
> (Resurrecting a subject I found searching the archives...)
>
> Newbie. We're investigating replacing our Oracle databases with
> PostgreSQL. Our largest database is currently 25 GB and growing. It
> contains time sequenced data. Under Oracle, we use
There is no license fee either for commercial or non commercial usage as
state: " Permission to use, copy, modify, and distribute this software and
its documentation for any purpose, without fee, and without a written
agreement is hereby granted, provided that the above copyright notice and
th
Hi,
I have inserted some images as binary data in one of my postgresql database
now i need to query on that using Geofunctions.
Or
Is it possible to use binary data images directly in Geodata types
Thanks.
---(end of broadcast)---
TIP 6: Have y
On 3/25/04 4:13 PM, "Bruce Momjian" <[EMAIL PROTECTED]> wrote:
> Are you sure your change is correct? We just added
> "-D_POSIX_PTHREAD_SEMANTICS" in post 7.4.2, and the submitters did not
> mention any problems with the -pthread line for gcc.
>
> I just tried it on Sourceforge's Solaris 9 and I
Dear Sir
I am a developer of one commercial organization. We
are going to develop some applications with PostgreSQL
7.3.3. I would like to know that is it necessary to pay any license charge on
the usage of PostgreSQL as database server for
commercial purpose. If so, how much of it?? Do
Hello All,
I installed RHEL-3 Work Station and I found there is no postgreSQL
server and pl package along with the distribution. Is RHN not distributing
these packages. If not where can I download it from. Can anybody help me
with this.
regards,
Prahalad
---(end
So can I quietly beg the Win32 group to expedite this port. I believe
you will be utterly astonished at the demand. Please.
I'm sure quietly begging certain developers with your pocekt book
probably wouldn't hurt your cause either. :)
Actually though from what I read here on this list native
Hi,
I'm running pg_dump 7.3.4. I have a nightly process that dumps a database
via pg_dump, and then checks for the existence of the dumped file afterwards
to confirm that the dump actually occurred. Just wondering, however, if a
corrupt disk prevented pg_dump from executing fully, would there st
Hi,
I have PostgreSQL compiled and i realized that it has some diferences from
the packages instalation like the way i access a database, when i compile i
have psql.bin that access the database and packages i have a link to
pg_wrapper
How can i compile and execute the same way the pack
Joe,
That's cool! Thanks for the tip. It looks like your "branch" is my
"ancestry". I'll look in contrib more often. I could use connectby() instead
of my homebrew plpgsql functions.
Shawn
- Original Message -
From: "Joe Conway" <[EMAIL PROTECTED]>
To: "Shawn Harrison" <[EMAIL PROTECTED
"Carsten B. Jensen" <[EMAIL PROTECTED]> writes:
> what am I doing wrong here?
Is there already a lock file by that name? It seems likely that you are
having a conflict against a pre-existing Postgres installation.
regards, tom lane
---(end of broa
"koju" <[EMAIL PROTECTED]> writes:
> With some reason, only btree functions are allowed to use in my project. I =
> modified all catalogs so that only bt- bp- related can be used. And it look=
> s like hash join and grouping are really depending on hash functions.
This is just about the silliest i
scott.marlowe wrote:
On Thu, 25 Mar 2004, Bas Scheffers wrote:
Guy,
1) Fill out form to get data.
2) Server responds with java and set of records.
3) Java applet displays one of the records and with out further
I see what you mean now, a business application in a browsers. It's
us
Juris Krumins wrote:
Hi everybody. I have a problem with my PostgreSQL DBMS.
In serverl log file I periodicly have errors like:
2004-03-24 11:43:18 ERROR: Relation "tmp_table1" does not exist
2004-03-24 11:43:18 ERROR: Relation "tmp_table1" does not exist
2004-03-24 11:43:18 ERROR: Relation 'tmp
PLEASE can we have the native Win32 port SOON.
It will totally and utterly hurt Microsoft in a very important area to
have this port. Why?
Well, many of you will know that MS give away a cut-down version of
SQL Server (MSDE) and this is bundled with a *lot* of Win32 apps.
Now, MSDE is pret
On Thu, 25 Mar 2004, Roger Dahl wrote:
> Hello everyone,
>
> I'm having trouble with a slow query and I wonder if anyone can help
> me speed it up. I have read the PostgreSQL documentation and FAQ but
> have been unable to find anything to help me out.
>
> I have three tables: items, boxes and ite
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> Can anybody show me the error of my ways?
Seems like I just answered this yesterday ... ah, here we go:
http://archives.postgresql.org/pgsql-general/2004-03/msg00862.php
I don't recall if 7.3 has all the functionality of 7.4 in this regard.
[EMAIL PROTECTED] writes:
> Ive been having a weird problem recently. Ive been using initdb to
> initialize a new postgres, but the as soon as i try and log in, i keep
> on getting and "no PostgreSQL user name specified in startup packet"
> error. Should this not be ok?
That's not an easy error
On Fri, 2004-03-26 at 09:28, Patrick Hatcher wrote:
While trying to find the physical disk space size each table in our
database (by matching the file name in the base directory to an entry
in pg_class), we found 4 files that constitute 5gigs that we cannot
match back to a entry in pg_class.
Is
See the FAQ entry about temp tables in function. Use EXECUTE.
---
Juris Krumins wrote:
>
> Hi everybody. I have a problem with my PostgreSQL DBMS.
> In serverl log file I periodicly have errors like:
>
> 2004-03-24 11:43:
On Wednesday 24 March 2004 04:31, Jeremy Semeiks wrote:
> Hello,
>
> I use psql interactively for data exploration, and often I want to do
> the same types of generic set operations on data in many different
> tables. For example, to calculate a similarity metric between 2
> different tables I migh
On Fri, 19 Mar 2004, Robert11 wrote:
> Hello:
>
> Am about to sign up for an on-line database course (introductory)
>
> Apparently, one must have on their PC for the course either
>
> Access
> postgre
> mysql
>
> Am really new at this.
> Access is a problem, as the package costs is $200.00 Wo
On Mon, 22 Mar 2004, marian wrote:
> When I do this,
> INSERT INTO orgdata ( name, fax, contact, email, phone, address,
> preferred ) VALUES ( 'wally', '123456789', 'wally', '[EMAIL PROTECTED]',
> '987654321', 'wally way', 'f' )
>
> I get
> ERROR: query rewritten 100 times, may contain cycles
> :
On Friday 26 March 2004 00:43, Mike Mascari wrote:
> Bas Scheffers wrote:
> >>I'm confused, where was the sarcasm?
> >
> > Sarcasm: "A form of wit that is marked by the use of sarcastic language
> > and is intended to make its victim the butt of contempt or ridicule."
> >
> > The banks, an corporat
On Sat, Mar 20, 2004 at 07:00:40AM -0800, Bob wrote:
> with Access, but would certainly like to try mysql first.
>
> Have downloaded it properly, I think, but can't get it to run.
If you're looking for MySQL help, you should probably try a MySQL
list. This is for Postgres support.
> Why does it
On Mon, 22 Mar 2004, marian wrote:
> When I do this,
> INSERT INTO orgdata ( name, fax, contact, email, phone, address,
> preferred ) VALUES ( 'wally', '123456789', 'wally', '[EMAIL PROTECTED]',
> '987654321', 'wally way', 'f' )
>
> I get
> ERROR: query rewritten 100 times, may contain cycles
Mike Mascari <[EMAIL PROTECTED]> writes:
> Bas Scheffers wrote:
>
> > Sarcasm: "A form of wit that is marked by the use of sarcastic language
Gee, a helpful dictionary there.
(I suppose that was sarcastic too)
--
greg
---(end of broadcast)---
On Sat, Mar 20, 2004 at 07:04:42PM -0800, Bill C. wrote:
> 1) A guy here had a compiled version of PostgreSQL for Solaris 8
> that he gave me to install on my Solaris 8 system. He said just
> untar it and you're good to go. I did, then I tried using the
> psql command to connect his server tha
Hello everyone,
I'm having trouble with a slow query and I wonder if anyone can help
me speed it up. I have read the PostgreSQL documentation and FAQ but
have been unable to find anything to help me out.
I have three tables: items, boxes and item_box_maps. The items table
holds ids and item names
CSN wrote:
Is it possible to have "less"-type paging with psql's
\s command? Or other ways like display the last 50
commands backwards?
__
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html
--
On Fri, Mar 19, 2004 at 11:34:30AM -0500, Robert11 wrote:
> I downloaded postgre, but I am a bit stumped on
> what to do next.
> The problem is I'm totally unfamiliar with ftp downloads.
>
> There are a bunch of folders.
>
> What do I open, or do next, please, to get started ?
What operating sys
(Resurrecting a subject I found searching the archives...)
Newbie. We're investigating replacing our Oracle databases with
PostgreSQL. Our largest database is currently 25 GB and growing. It
contains time sequenced data. Under Oracle, we use a partitioned
tablespace for the busiest table, so t
When I do this,
INSERT INTO orgdata ( name, fax, contact, email, phone, address,
preferred ) VALUES ( 'wally', '123456789', 'wally', '[EMAIL PROTECTED]',
'987654321', 'wally way', 'f' )
I get
ERROR: query rewritten 100 times, may contain cycles
: PGRES_FATAL_ERROR
What is going on here
---
"Vanole, Mike" <[EMAIL PROTECTED]> writes:
> I'm trying to query two timestamp(0) columns to determine elapsed time. I u=
> se the age() function which works fine, but I want to return the informatio=
> n in MINUTES.=20
Just subtract (giving an interval), use extract(epoch) to get the
interval in
"Robert Wille" <[EMAIL PROTECTED]> writes:
> I am running Postgres 7.3.3 on RedHat Linux 7.3. I have 14 tables, but
> when I run "pg_dump -c -F p -U username dbname", the output contains no
> data for three of them. Here is the relevant output for one of the
> tables:
> COPY message (recipient, s
48 matches
Mail list logo
