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
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
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
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
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
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
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
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
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
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]
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
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:
> >
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
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
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
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.
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
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
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
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
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
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
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
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
... 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
25 matches
Mail list logo
