Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

2004-04-14 Thread Christopher Kings-Lynne
... on projects.postgresql.org, or similar.They really aren't doing any good in /contrib. I've already set up a category "conversion tools" on pgFoundry, and my idea was one project per target system. I reckon that by far the best way to do a mysql2pgsql converter is to just modify mysqldum

[GENERAL] PostGIS and 7.4.1

2004-04-14 Thread Romano J M Silva
Hello all,   I would like to know if the spatial support available in the 7.4.x versions of PostgreSQL is the same thing as PostGIS. If not, what are the differences?   Is it possible to retrieve spatial data through ODBC or libpq?   Thank you, Romano Magacho

[GENERAL] trigger function SQL statement

2004-04-14 Thread Dennis Gearon
If I have the following table: create table my_table( start TIME, end TIME ); and then I wanted a function as a trigger that would compare any INSERTS or UPDATES to see if there was any overlap in the interval between start and end of the new rows and existing rows, is there a single state

Re: [GENERAL] [HACKERS] Remove MySQL Tools from Source?

2004-04-14 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: >> And what to do with the other db conversion tools? Seems they should be >> kept together. > ... on projects.postgresql.org, or similar.They really aren't doing any > good in /contrib. Fair enough. They're not tightly tied to the backend, so I see

[GENERAL] upgrading postgresql from 7.2 to 7.3, getting error

2004-04-14 Thread Adam Williams
Hi, as my title states I'm trying to upgrade from 7.2 to 7.3 on redhat linux 9. I've been following the documentation instructions on the website but ran into problems. I searched on google but could not find my answer. On postgresql as user postgres I ran the command pg_dumpall > sroom1 and

Re: [GENERAL] constraint help

2004-04-14 Thread Stephan Szabo
On Wed, 14 Apr 2004, Dennis Gearon wrote: > I will have a table with, among other things, two time columns. > As per my last post, I will be using a variable time for the day-to-day > boundary, versus the traditional 12pm. > What I want to be able to do upon insert of a record with a pair of > ti

Re: [GENERAL] columns refered to in view

2004-04-14 Thread Richard Huxton
On Wednesday 14 April 2004 14:59, Alexander Cohen wrote: > I have created a view with this query: > > CREATE VIEW testview AS SELECT table.column AS col1, table2.column AS > coll2 FROM table, table2; > > Later on, i want to get the table and column name that a field refers > to in this view. In oth

Re: [GENERAL] constraint help

2004-04-14 Thread scott.marlowe
Maybe natural join is what you want? On Wed, 14 Apr 2004, Dennis Gearon wrote: > I will have a table with, among other things, two time columns. > As per my last post, I will be using a variable time for the day-to-day > boundary, versus the traditional 12pm. > What I want to be able to do upon

[GENERAL] Optimal configuration to eliminate "out of file descriptors" error

2004-04-14 Thread Joe Lester
I'm trying to figure out what the optimal Postgres configuration would be for my server (with 200 connecting clients, even though I'd really like to get it up to 500). I've got a 700 MHz eMac running Mac OS 10.3.2 (Panther) with 512 MB of RAM. I've messed around with some settings but I'm still ge

Re: [GENERAL] Donating

2004-04-14 Thread Marc G. Fournier
The infrastructure for this is currently being built, but, at this time, isn't public ... if you send an email out to [EMAIL PROTECTED], he'll be able to get you on the right track though ... On Wed, 14 Apr 2004, Jim C. Nasby wrote: > Is there no way to donate money to Postgresql? > -- > Jim C.

[GENERAL] constraint help

2004-04-14 Thread Dennis Gearon
I will have a table with, among other things, two time columns. As per my last post, I will be using a variable time for the day-to-day boundary, versus the traditional 12pm. What I want to be able to do upon insert of a record with a pair of times is to determine if the day to day boundary is be

[GENERAL] major-domo not set up right

2004-04-14 Thread Dennis Gearon
as per this page: http://archives.postgresql.org/pgsql-general/ I sent an email to: [EMAIL PROTECTED] with this single line in it: subscribe-digest pgsql-general and got back this error email: - subscribe-digest pgsql-general The subscribe

[GENERAL] mini survey

2004-04-14 Thread Dennis Gearon
I am doing a site where some of the pages will show various hours of some businesses. To make life easier for searching for open businesses PER DAY, I have pretty much decided to make an arbitrary dat-to-day boundary, instead of the usual midnight boundary. Some businesses that this applies to

Re: [GENERAL] db schema diff

2004-04-14 Thread Jeremiah Jahn
by comments, I mean these: -- -- TOC entry 16 (OID 166152808) -- Name: user_credit_card; Type: TABLE; Schema: public; Owner: copa -- these have really gone away in a new version, and if so, which one..? On Wed, 2004-04-14 at 10:26, Tom Lane wrote: > Jeremiah Jahn <[EMAIL PROTECTED]> writes: > >

[GENERAL] Donating

2004-04-14 Thread Jim C. Nasby
Is there no way to donate money to Postgresql? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Member: Triangle Fraternity, Sports Car Club of America Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Wher

Re: [GENERAL] cache lookup of relation 165058647 failed

2004-04-14 Thread Juris Krumins
On Wed, 14 Apr 2004, Richard Huxton wrote: > On Wednesday 14 April 2004 10:35, Juris Krumins wrote: > > > 2004-04-14 12:24:54 [74021] LOG: query: SELECT d.config_id, d.text1 as > > text, d.field_name, > > 2004-04-14 12:24:54 [74021] LOG: duration: 0.005295 sec > > 2004-04-14 12:24:54 [74021]

Re: [GENERAL] Filesystem vs. Postgres for images

2004-04-14 Thread Steve Atkins
On Wed, Apr 14, 2004 at 10:15:51PM +0900, Alex wrote: > Hi, > is the file system approach really easier and faster? What if you need > to protect the image data e.g. you dont want users just to just dowload > the pictures directly from your website? It can be much faster, if implemented correctl

Re: [GENERAL] db schema diff

2004-04-14 Thread Tom Lane
Jeremiah Jahn <[EMAIL PROTECTED]> writes: > Although now consistent, is there a way to strip out the comments? since > they differ between dbs? Not any more they don't ... unless you use the --verbose option, pg_dump's comments should look the same too. regards, tom lane

Re: [GENERAL] cache lookup of relation 165058647 failed

2004-04-14 Thread Tom Lane
Juris Krumins <[EMAIL PROTECTED]> writes: > So bacicaly we have only 4 places, which cane generate errors like that, > and all this places refer to HeapTupleIsValid function. Hmm. What's even more interesting is that none of them are in places that I would expect to be called during a CREATE TABL

Re: [GENERAL] Stored procedures output variables

2004-04-14 Thread Bill Moran
Shachar Shemesh wrote: Hi List, How do I define a stored procedure that has an output variable? I am looking for a way that will not significantly change the way the argument is called. Can I, for example, pass a reference to variable in some way? If I understand your question, the best way is

Re: [GENERAL] db schema diff

2004-04-14 Thread Jeremiah Jahn
Although now consistent, is there a way to strip out the comments? since they differ between dbs? Right now, I use grep, but I have this need to live in a perfect world were everything is just a command line option..:) On Mon, 2004-04-12 at 16:57, Tom Lane wrote: > Igor Shevchenko <[EMAIL PROTE

[GENERAL] Stored procedures output variables

2004-04-14 Thread Shachar Shemesh
Hi List, How do I define a stored procedure that has an output variable? I am looking for a way that will not significantly change the way the argument is called. Can I, for example, pass a reference to variable in some way? Shachar -- Shachar Shemesh Lingnu Open Source Consulting

Re: [GENERAL] cache lookup of relation 165058647 failed

2004-04-14 Thread Tom Lane
Richard Huxton <[EMAIL PROTECTED]> writes: > The error is complaining about a relation that used to have an OID of > 165058647. This is almost certainly a temporary table. Are there any plpgsql > functions referring to a temporary table, or do you create, drop, recreate > tmp_table1 within the s

Re: [GENERAL] Filesystem vs. Postgres for images

2004-04-14 Thread Jeremiah Jahn
Your code is retrieving the file from the file system. It doesn't have to be accessible from the web server at all. Our current design uses a JDBC connection to the database for the metadata (digital signature,path,name,file type, etc..) and a SOAP call to the same server (but doesn't have to be) t

Re: [GENERAL] cache lookup of relation 165058647 failed

2004-04-14 Thread Juris Krumins
On Wed, 14 Apr 2004, Tom Lane wrote: > Richard Huxton <[EMAIL PROTECTED]> writes: > > The error is complaining about a relation that used to have an OID of > > 165058647. This is almost certainly a temporary table. Are there any plpgsql > > functions referring to a temporary table, or do you creat