[GENERAL] Unique cosntraint based on contents of a field?

, Warren Bell -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Pre-calculate hash join

? -Warren -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] Creating new database

? Same sort of problem with psql: If I run 'psql database2' then I see everything from database1 as well. What am I missing here? Thanks for your time. Malcolm Warren

[Fwd: Re: [GENERAL] Creating new database]

. Thanks, Malcolm Vidhya Bondre ha scritto: can you specify the exact commands and the sequence. With this set up it should work. how do you import the data. Vidhya On Wed, Nov 18, 2009 at 5:18 PM, Malcolm Warren malc...@villeinitalia.com mailto:malc...@villeinitalia.com wrote: Dear All

Re: [GENERAL] Creating new database - SOLVED

Dear All, Thank you for your emails which were very helpful. I've finally solved it. template1 was full of data, presumably somehow from a badly-run dump and restore. So when I created the new database, that too was full of data from the template. I ran a clean pg_dump on template1 from my

[GENERAL] Bad Timestamp Format at 23 in ...

Format at 23 in 2008-09-16 18:41:00.479 error. I am guessing that it has something to do with how Java creates Dates on Unix verses Windows. Is this a JDBC issue or is there something I need to do in Postgres to make this work? -- Thanks, Warren Bell 909-645-8864 [EMAIL PROTECTED] -- Sent

Re: [GENERAL] Bad Timestamp Format at 23 in ...

-09-16 18:41:00.479 error. I am guessing that it has something to do with how Java creates Dates on Unix verses Windows. Is this a JDBC issue or is there something I need to do in Postgres to make this work? -- Thanks, Warren Bell 909-645-8864 [EMAIL PROTECTED] -- Sent via pgsql-general

[GENERAL] Problem escaping, nonstandard use of \\ in a string literal

as the driver. I see that you can escape by doing E'Joe\'s', but how do I get this to work without going through my code and shouldn't this be done by the driver. How do I get this all to work? -- Thanks, Warren Bell 909-645-8864 [EMAIL PROTECTED] -- Thanks, Warren Bell 909-645-8864

[GENERAL] CAST(integer_field AS character) truncates trailing zeros

I am trying to cast an int to a character. The int is the number 1000 it gets cast down to 1 and not 1000. How do I cast from int to character without loosing the trailing zeros? -- Thanks, Warren Bell -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] CAST(integer_field AS character) truncates trailing zeros

I guess it would help if I cast to the correct type. I was doing cast( cast( 1000 as integer ) as char ) instead of character varying, char(n) or text. Thanks, Warren Warren Bell wrote: I am trying to cast an int to a character. The int is the number 1000 it gets cast down to 1

[GENERAL] pg_dump auto login

prompting for a password? Thanks, Warren ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[GENERAL] ERROR: could not open file pg_subtrans...

order_pkey PRIMARY KEY (ord_pk), CONSTRAINT order_scanorder_ord_scn_fk FOREIGN KEY (ord_scn_fk) REFERENCES scanorder (scn_pk) MATCH SIMPLE ON UPDATE RESTRICT ON DELETE CASCADE ) I am a complete novice with postgres so bare with me. -- Thanks, Warren Bell

[GENERAL] Checking for a number

I need to check if the last two characters of a field are a number. I am trying something like this but it does not want to work. substring(TRIM(field8) from '..$') SIMILAR TO '\d\d' How should I do this? -- Thanks, Warren Bell ---(end of broadcast

[GENERAL] COPY Command and a non superuser user?

How do I get a non superuser user to be able to run the COPY command? -- Thanks, Warren ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do

[GENERAL] Function with COPY command?

. CREATE OR REPLACE FUNCTION import_text_file(char(255)) RETURNS void AS $$ DECLARE filename ALIAS FOR $1; BEGIN COPY table FROM 'C:\\somefile.txt'; END; $$ LANGUAGE plpgsql; -- Thanks, Warren ---(end of broadcast)--- TIP 3: Have you checked our

[GENERAL] Performance Problems

/autovacuum -U postgres -P password -H 127.0.0.1 -p 5432 It does speed back up after I do a full vacuum on it. What can I do to keep the performance consistent. Thanks, Warren Bell ---(end of broadcast)--- TIP 4: Have you searched our list archives

[GENERAL] PDF Documentation?

Is there a pdf version of the documentation ? I find HTML version much harder to read than a printed copy. Thanks, Warren Bell ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Speed problems

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Scott Marlowe Sent: Wednesday, September 14, 2005 8:24 AM To: Warren Bell Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Speed problems On Tue, 2005-09-13 at 21:01, Warren Bell wrote

[GENERAL] Speed problems

and this will not speed it up. I drop the table and recreate it and insert one record and it speeds right back up takeing only 100 ms to do the query. I am fairly new to Postgres. What do I need to do to keep this table from slowing down? Thanks, Warren Bell ---(end

Re: [GENERAL] Speed problems

On Tue, 2005-09-13 at 13:20, Warren Bell wrote: I am having problems with performance. I think this is a simple question and I am in the right place, if not, please redirect me. I have a table with 36 fields that slows down quite a bit after some light use. There are only 5 clients connected

[GENERAL] postgres 7.2.4 - errors after vacuuming/reindexing in single user mode

can we do to recover? What happened, and what did we do wrong? Thanks in advance, Warren Warren White CTAC Engineer III email: [EMAIL PROTECTED] phone: 781.895.3611 cell: 781.738.3416 msn: [EMAIL PROTECTED] eDial - a division of ALCATEL 266 2nd Avenue Waltham, MA 02451

[GENERAL] Serial column has suddenly stopped working

I have been using a serial column in my most important postgres table for a couple of years. But today it has suddenly started assigning zero instead of the next number, which clearly is causing chaos. I have restarted Postgres, but it has not solved the problem. I cannot re-assign the serial

Re: [GENERAL] Serial column has suddenly stopped working

The answer is 3. Mistake of mine. I put in a field of the same name to display it, and it was also sending 0 with the statement. Thank you for helping me get to the bottom of it. Malcolm Warren Richard Huxton wrote: Malcolm Warren wrote: Thank you for your reply. Yes, I get the next number

[GENERAL] Use of oids

an example of using them as primary and foreign keys (which fortunately I decided was not very wise) and certainly doesn't say anything about phasing them out in the future. Can anybody shed any light on this? Malcolm Warren ---(end of broadcast

Re: [GENERAL] rotating log files

} Alternatively, instead of restarting postgres, the copytruncate option can be used to truncate the log file in place, allowing postgres to continue writting to the file without needing to restart. Sincerely, Warren ---(end of broadcast)--- TIP 1

Re: [GENERAL] Inserting values into a SERIAL field

the vacuum. This is a Debian 2.2 system running PostgreSQL 7.0.3... Help? :) Sincerely, Warren ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl

[GENERAL] vacuum analyze returns OID IS INVALID. TUPGONE 1 on pg_language

during this time was the postgres process handling the vacuum shot up to 685MB worth of RAM usage (638 shared) during the vacuum. This is a Debian 2.2 system running PostgreSQL 7.0.3... Help? :) Sincerely, Warren ---(end of broadcast)--- TIP 4

[GENERAL] Regression test questions.

, btree_index and other wonderful things are failing the regression test. Is this normal? Should I be worried about this, or is this a shortcoming in the tests themselves? Sincerely, Warren

Re: [GENERAL] selecting a random record

ail_linkid_idx Index "linkdaystatsdetail_linkid_idx" Attribute | Type ---+- linkid| integer btree Thanks in advance, Sincerely, Warren

[GENERAL] Question about migration.

, are going to change, I'm simply remove one drive and replacing it for another. Or should I go the longer route of dumping the databases, reinstalling pgsql on the drive, initdb, and then load the databases back in from the dump? Opinions? :) Sincerely, Warren

Re: [GENERAL] How to format strings

( text1, '.' ), text2 ), '@domain.com' ) as result from test; result -- [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] (3 rows) Perhaps somebody has a better way? :) Hope this helps! :) Sincerely, Warren

Re: [GENERAL] Does this table exist?

to PostgreSQL, so this could also be 'dynamite fishing' ;) Sincerely, Warren - Warren Vanichuk, Systems Engineer, Street Light Productions Ltd.

[GENERAL] A question about PL/pgSQL

only have to worry about 1 or 0 rows being returned from the select statement. I attempted something like IF SELECT id FROM overview WHERE id = 100 ... but I get an 'error near SELECT' returned from the database. Any help would be apprieciated.. :) Sincerely, Warren

[GENERAL] Postgresql 7 does not always start on RH 6.2

deas would be appreciated. Regards Warren

[GENERAL] PGAccess

will, it will spit out an error. Has anyon ever ran into this type of problem and most importantly, how do you fix it? I can access everything fine with psql and jdbc, this is the only tool that gives me any problems. David Warren [EMAIL PROTECTED]