[SQL] psql hangs during load of pg_dumpall file

Hi,   I am using version 8.1.3 on Windows XP professional (I have also tested this under 8.1.4). I have created a pg_dumpall file from my database after loading a couple of megabytes of data (approximately 2 Mbytes) into a schema containing roughly 30 tables and 20 sequences.   When I

Re: [SQL] formatting intervals with to_char

On 10/4/06, Graham Davis <[EMAIL PROTECTED]> wrote: I haven't heard any replies from this, so in the meantime I've found ahacky way to get the output I desire.  I'm basically calculating thehours on the fly and piecing together a formatted string withconcatenations like this: SELECT(((EXTRACT(day f

Re: [SQL] i have table

--- "Penchalaiah P." <[EMAIL PROTECTED]> wrote: > > Hi ... > > I have one table with 12 fields.. > > > > CREATE TABLE addition_alteration_memo > > ( > > addition_alteration_memo int8 NOT NULL DEFAULT > nextval('addition_alteration_memo_addition_alteration_memo_seq'::regclas > s), > > c

Re: [SQL] i have table

On Wed, 2006-10-04 at 13:02, Aaron Bono wrote: > On 10/4/06, Daryl Richter <[EMAIL PROTECTED]> wrote: > On 10/4/06 12:20 PM, "Aaron Bono" <[EMAIL PROTECTED]> > wrote: > > > > So do it as needed and convert your application slowly. > > > > I just name

Re: [SQL] Assigning a timestamp without timezone to a timestamp

Hi I am also interested in this type of setup. However, in the example below I am a little confused as to why the table entry is 1, -3 And the subsequent select statement . I would appreciate an explanation on the select statement. I do not understand the syntax. Thanks in advance Hector Villar

Re: [SQL] formatting intervals with to_char

I haven't heard any replies from this, so in the meantime I've found a hacky way to get the output I desire. I'm basically calculating the hours on the fly and piecing together a formatted string with concatenations like this: SELECT (((EXTRACT(day from time_idle)*24)+EXTRACT(hour from time_i

Re: [SQL] i have table

On 10/4/06, Daryl Richter <[EMAIL PROTECTED]> wrote: On 10/4/06 12:20 PM, "Aaron Bono" <[EMAIL PROTECTED]> wrote:> On 10/4/06, Erik Jones <[EMAIL PROTECTED]> wrote: Aaron Bono wrote:>>> On 10/4/06, *Erik Jones* <[EMAIL PROTECTED] [EMAIL PROTECTED]> wrote: >> There is one non-SQL re

Re: [SQL] Assigning a timestamp without timezone to a timestamp

Hi, Christopher, christopher wood wrote: > what is AFAICT ? "As Far As I Can Tell". It's explained in the "Jargon File": http://www.catb.org/jargon/html/A/AFAIK.html HTH, Markus -- Markus Schaber | Logical Tracking&Tracing International AG Dipl. Inf. | Software Development GIS Fight aga

Re: [SQL] How to overwrite a table [only data]?

Hi, Ezequias, Ezequias Rodrigues da Rocha wrote: > I would like to overwrite a table with problem with his original. But > there are some points. > > I can't just delete and restore it becouse it has a foreign key and > when I try to delete it ask for drop cascade. As long as the delete and re

Re: [SQL] i have table

On 10/4/06 12:20 PM, "Aaron Bono" <[EMAIL PROTECTED]> wrote: > On 10/4/06, Erik Jones <[EMAIL PROTECTED]> wrote: >> >> Aaron Bono wrote: >>> On 10/4/06, *Erik Jones* <[EMAIL PROTECTED] > >>> wrote: >>> >>> There is one non-SQL related reason that I like to be able t

Re: [SQL] Update 3 columns w/ 1 function calc 3 values?

Hi, paallen, [EMAIL PROTECTED] wrote: > I am moving some of my old MS Access functions to > plpgsql. > > My function was made to return coordinates, X,Y,Z > for a point along a curved line. Depending on the actual kind of data, you might want to look into the PostgeSQL geometry types, or PostG

Re: [SQL] Assigning a timestamp without timezone to a timestamp

Hi Markus, what is AFAICT ? In the commercial space, I believe DB2 is one of the best From: Markus Schaber <[EMAIL PROTECTED]> Reply-To: PostgreSQL SQL List To: pgsql-sql@postgresql.org CC: christopher wood <[EMAIL PROTECTED]> Subject: Re: [SQL] Assigning a timestamp without timezone to a ti

Re: [SQL] i have table

On 10/4/06, Erik Jones <[EMAIL PROTECTED]> wrote: Aaron Bono wrote:> On 10/4/06, *Erik Jones* <[EMAIL PROTECTED] [EMAIL PROTECTED]>>> wrote:>> There is one non-SQL related reason that I like to be able to order > columns, at least the way they are displayed whenever the table is> descri

Re: [SQL] Assigning a timestamp without timezone to a timestamp

Hi, Christopher, christopher wood wrote: > But I can't even take credit for that, my business partner suggested > using Postgres. So I guess he's a smart one, too. :-) At least as long as he understands that free software does not mean a TCO of zero dollars, that's the main mistake when busines

Re: [SQL] i have table

Aaron Bono wrote: On 10/4/06, *Erik Jones* <[EMAIL PROTECTED] > wrote: There is one non-SQL related reason that I like to be able to order columns, at least the way they are displayed whenever the table is described: human comprehension. For example, I li

Re: [SQL] How to overwrite a table [only data]?

On 10/4/06, Ezequias Rodrigues da Rocha <[EMAIL PROTECTED]> wrote: Hi list, I would like to overwrite a table with problem with his original. But there are some points. I can't just delete and restore it becouse it has a foreign key and when I try to delete it ask for drop cascade. As I know the

Re: [SQL] i have table

On 10/4/06, Erik Jones <[EMAIL PROTECTED]> wrote: There is one non-SQL related reason that I like to be able to ordercolumns, at least the way they are displayed whenever the table isdescribed:  human comprehension.  For example, I like to group all keysin a table before data, that includes primary

Re: [SQL] i have table

There is one non-SQL related reason that I like to be able to order columns, at least the way they are displayed whenever the table is described: human comprehension. For example, I like to group all keys in a table before data, that includes primary as well as foreign keys. So, say I'm bui

Re: [SQL] Assigning a timestamp without timezone to a timestamp

Thanks Markus, But I can't even take credit for that, my business partner suggested using Postgres. I have been a DB2 DBA most of my professional life (25 years) until recently, and a huge proponent of DB2 against the likes of Oracle and MS-SQL. So far I am very impressed with Postgres but

[SQL] How to overwrite a table [only data]?

Hi list, I would like to overwrite a table with problem with his original. But there are some points. I can't just delete and restore it becouse it has a foreign key and when I try to delete it ask for drop cascade. As I know the drop cascade delete in both tables the rows related. Is it correct

Re: [SQL] i have table

Hi, Penchalaiah, Penchalaiah P. wrote: > now I want to add one more field in this table.. but that field has to > come next to cda_no.. I mean as a 3^rd field.. If I am adding that field > it is coming last field … In SQL, field order in the table is not given by design. A "SELECT * FROM table"

Re: [SQL] Assigning a timestamp without timezone to a timestamp

Hi, Chris, Hi, Andrew, Chrisj wrote: > please be patient with me sometimes I am slow but I usually get there. Andrew Sullivan wrote: > Sorry, I'm dim, > Told you I'm dim. That's just plain wrong. You guys are using PostgreSQL, and that's the proof that you're the brightest people on the pla