Hello List!
I'm having an issue with my program; it's inserting into one record into a
view (named 'measurement') twice ,which it's not supposed to be - so, I'm
attempting to put a delete statement in the code to remove one of these
records, but am getting an error. (Will track down the real ins
.drawingid = old.drawingid); );
Thanks again,
-Jeanna
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Martijn van
Oosterhout
Sent: Friday, January 05, 2007 9:47 AM
To: Jeanna Geier
Cc: pgsql-general
Subject: Re: [GENERAL] Deleting From View?
On Fri, Jan 05
Interestingly enough... he doesn't have an INSERT rule...
The INSERTs all appear to be done using the JDBC and prepared statements in
the code.
-Original Message-
From: Martijn van Oosterhout [mailto:[EMAIL PROTECTED]
Sent: Friday, January 05, 2007 10:16 AM
To: Jeanna Geier
Cc:
We use WebDAV and Apache's Slide to store our images and, as someone pointed
out earlier, store the links to the images in our database.
WebDAV has provided us with excellent access control and security...
http://www.webdav.org/
http://jakarta.apache.org/slide/index.html
Just my 1/2 cents,
-Jean
Hello List!
OK, so I'm new to SQL and Postgres and am working on taking over this DB
work, and ran across a command that I'm not sure of and am wondering if you
can help me with... Probably a basic SQL question, but thought more than one
person on here would be able to point me in the right dire
Hello List!
I have a question regarding SELECT INTO...
Can it be used with Views? I have a View that is populated (~35,000 rows)
that I want to create a Table from the data in it
So, would I be able to copy the data from the View to the Table using the
SELECT INTO command?
Thanks much,
-J
Behalf Of Merlin Moncure
Sent: Monday, January 08, 2007 6:28 PM
To: Jeanna Geier
Cc: pgsql-general
Subject: Re: [GENERAL] SELECT INTO using Views?
On 1/9/07, Jeanna Geier <[EMAIL PROTECTED]> wrote:
> Hello List!
>
> I have a question regarding SELECT INTO...
>
> Can it be us
Hello List-
I'm having some problems with Views that I'd really appreciate some feedback
and ideas on...
I have a Java program that we're developing that's a CAD/blueprint program
that allows the user to select a room in a building and attach information
from the database about that room (i.e. ag
OTECTED] Behalf Of Richard Broersma
Jr
Sent: Wednesday, January 10, 2007 4:32 PM
To: Jeanna Geier; pgsql-general
Subject: Re: [GENERAL] Problems With VIEWS
> I get an error: "Cannot insert into a view." I
> haven't even viewed it, much less attempted to insert into it; and
Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Richard Broersma
Jr
Sent: Wednesday, January 10, 2007 5:04 PM
To: Jeanna Geier; pgsql-general
Subject: Re: [GENERAL] Problems With VIEWS
> 2007-01-10 16:45:33 ERROR: cannot insert into a view
> 2007-01-10 1
EWS
working and if I need to take the time to enter each RULE for the VIEWS
manually, so be it.
Thoughts and feedback, as always, are very much welcomed!
Thanks again,
-Jeanna
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Richard Broersma
Jr
Sent: Wednesday,
02 AM
To: Richard Broersma Jr
Cc: Jeanna Geier; Adam Rich; pgsql-general
Subject: Re: [GENERAL] Problems With VIEWS
On Thu, 11 Jan 2007 06:36:34 -0800 (PST), Richard Broersma Jr
<[EMAIL PROTECTED]> wrote:
>
> Either way. I like to create sql files with all of the DDL for creati
Hi List!
I'm attempting to do a restore of a database and I'm getting the following
error the I'm not familiar with:
COPY workorder (work_order_id, projectname, request_date, requestor,
request_detail, request_completion_date, request_a...
pg_restore: restoring data for table "worksite"
pg_resto
'workorder.workorder' table.
Hope that helps!
-Jeanna
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeanna Geier
Sent: Thursday, January 11, 2007 3:10 PM
To: pgsql-general
Subject: [GENERAL] RESTORE Error
Hi List!
I'm attempting to do a restore of
"\" at character 1
2007-01-11 15:38:48 ERROR: syntax error at or near "\" at character 1
2007-01-11 15:38:48 ERROR: syntax error at or near "\" at character 1
2007-01-11 15:38:48 ERROR: syntax error at or near "\" at character 1
2007-01-11 15:38:48 ERROR: syntax err
was: 34101631810987
(2491.8225222024057,8759.2336777975943)
(2440.9108777975944,8759.2336777975943) 35.69 35.69
f
f 0
34...
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Jeanna Geier
Sent: Thursday, January 11, 2007 3:
gh the issues
that I've had; you guys ROCK and the help is greatly appreciated!
-Jeanna
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Tom Lane
Sent: Thursday, January 11, 2007 9:28 PM
To: Jeanna Geier
Cc: pgsql-general
Subject: Re: [GENERAL] RESTORE Er
Hello List-
I'm having some problems in my program that I've been spending the day
going over and over and am now going to ask for some help, as I cannot see
the problem, but am hoping some seasoned sets of eyes will!
I have some VIEWS that need to get updated when the user chooses to delete
d
Hello List-
I'm attempting to do an INNER JOIN on one of the views in my database,
however, when I import the schema file that has it in there, it removes the
"INNER" from the statement. I've also tried to add it by modifying it via
the 'Properites' -> 'Definition' tab on the VIEW. But, when I pu
Hello List!
We're working on restructuring some of our tables in our databases
(removing, renaming, &/or adding columns to tables), & adding tables to the
database, etc. - and we have a database FULL of info that we want to restore
this database with once the updates are done; however, I know that
20 matches
Mail list logo
