Re: [GENERAL] pgFoundary?

Then I guess my next question is: why isn't it linked to from http://postgresql.org ? On Fri, Dec 03, 2004 at 12:35:23AM -0600, Thomas F.O'Connell wrote: > http://pgfoundry.org/ > > You had an extra 'a'. :) > > I'm not sure what the status of gborg is, at the moment. > > -tfo > > -- > Thomas F

Re: [GENERAL] Indexes?

Perhaps I'm missing something but let's say that the index has the following: toDate fromDate 1992-03-02 1991-01-23 1992-04-03 1990-06-13 1993-05-03 1991-01-22 ... ... ... 2004-12-01 2003-02-22 2005-03-04 2003-02-22 (a) 2005-03-05 2004-12-15 (b) 2005-03-05 2004-

Re: [GENERAL] pgFoundary?

http://pgfoundry.org/ You had an extra 'a'. :) I'm not sure what the status of gborg is, at the moment. -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Dec 3, 2004, at 12:28

[GENERAL] pgFoundary?

I've seen references to pgFoundary on the mailling lists, but I can't seem to find it anywhere. Does it actually exist? Is it the predecessor to gborg? Speaking of gborg, how come it isn't accepting projects right now? -- Jim C. Nasby, Database Consultant [EMAIL PROTECTED] Give you

Re: [GENERAL] Indexes?

Well, then it's decided to try with two indexes... Thx... :) BTJ Bruno Wolff III wrote: On Wed, Dec 01, 2004 at 23:16:48 -0800, Vincent Hikida <[EMAIL PROTECTED]> wrote: I believe that it is better to have a concatenated key of (toDate,FromDate). The reason the toDate should come first is that f

[GENERAL] reclaiming diskspace bloat w/near-zero downtime

I need to reclaim the diskspace from a heavily updated 7.3.4 table which has grown 95% bloated to 20gb of disk (indices and toast included), and I need to reclaim it while the table continues to get updates, and without interrupting/delaying access more than a few seconds. This is an explanat

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start

hi joel, just checked -- looks ok. PID is properly 'owned & operated' by the postmaster superuser defined in the launch command Who owns /var/run? What group? Does testuser have permission to delete files there? (May need to add testuser to the wheel or admin group?) good points =) already done,

[GENERAL] Is there a way to view a rewritten query?

I'm trying to set up some complex rules and having a hard time figuring out why they won't work. Being able to see the query after all the rules have been applied would be a huge help, but I can't seem to find a way to do this. log_statement only shows the original. debug_print_rewritten works, but

Re: [GENERAL] Select Database

Thanx JW> On 12/2/2004 4:39 AM, ON.KG wrote: >> Hi All! >> >> How could I select another database without new connection? >> >> For example, in PHP+MySQL we have mysql_select_db('database_name'); JW> You can't. An existing session cannot change the database connected to. JW> Jan --

Re: [GENERAL] Get diagnistic (row_count) 7.3 vs. 7.4 changes

On my opinion row_count should not be null due to the last operation produced some records, copied to the temp table. Basically it's irrelevant for me whether it fixed or not, I'll have to port this code fast and going to use select count. > -Original Message- > From: Tom Lane [mailto:[EM

Re: [GENERAL] psql connection timeout

On Thu, Dec 02, 2004 at 11:32:34PM -0500, John DeSoi wrote: > Is there a way to control how long psql waits for a connection? If the > host IP address is mistyped, psql (8.0b4) hangs for over a minute on OS > X. Try setting the PGCONNECT_TIMEOUT environment variable: env PGCONNECT_TIMEOUT=5 ps

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

Marc G. Fournier From: wrote: > Mike Cox <[EMAIL PROTECTED]> writes: > >> REQUEST FOR DISCUSSION (RFD) >> unmoderated group comp.databases.postgresql > >>This is a formal Request For Discussion (RFD) for the creation of >>the worldwide unmoderated Usenet newsgroup

[GENERAL] PostgresSQL Beta 5 Install Problem on Windows Server 2003

The following occured during the installation of Beta-5 on Windows 2003 Standard Server. After clicking 'Finish' and files copying... "Failed to connect to the database. Procedural languages files are installed, but are not activated in any databases" "server closed the connection unexpecte

Re: [GENERAL] 3rd RFD: comp.databases.postgresql (was: comp.databases.postgresql.*)

Marc G. Fournier From: wrote: > Mike Cox <[EMAIL PROTECTED]> writes: > >>Marc G. Fournier From: wrote: > >>> The pgsql.* hierarchy is a not a private one, it is a public one carried >>> by several of the large usenet servers. > >>Doesn't "private" denote a hierarchy in its own domain such as >>

[GENERAL] psql connection timeout

Is there a way to control how long psql waits for a connection? If the host IP address is mistyped, psql (8.0b4) hangs for over a minute on OS X. Thanks, John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL ---(end of broadcast)--- TIP 2

[GENERAL] general questions on Postgresql and deployment on win32 platform

I have gone through the documentation that come with version 8 beta 4 and I have a number of questions. (1) backup/restore I notice that in the documentation, it seems to suggest that an online backup, made via pg_start_backup() and pg_stop_backup() functions would back up all databases running

Re: [GENERAL] table inheritance and DB design

On Thu, Dec 02, 2004 at 10:53:37PM -0500, Berend Tober wrote: > I learned that the unusual behavior (or at least the behavior that > seems weird to me) regarding relational integrity and uniquness > constraints as been around for a while, and some people actually think > is is SUPPOSED to work tha

Re: [GENERAL] table inheritance and DB design

> I am trying to create a database, which allows me to store appointment > information. ... > > Now, I want to have several tables, say Car and Driver, which INHERIT from > the Resource table. I also want AppRes table can enforce a ref. constraint > on the Resource table. So, in the future I can ad

Re: [GENERAL] relation does not exist error

Wow, 4 responses in 10 minutes to my newbie question. Thanks guys. I'm coming from a SQL Server background, so quoting table names didn't immediately spring to mind. I can see support will not be a problem. 10 out of 10. Sw. ---(end of broadcast)-

Re: [GENERAL] Rules

>> Planning on witting a rule for a view, and i was wondering if anyone >> could suggest a good Internet resource? > > http://www.postgresql.org > > (Sorry, couldn't resist.) > But here is a simple working example of making a view updatable: CREATE TABLE consumable ( consumable_pk serial NOT

[GENERAL] table inheritance and DB design

Greetings.   I am trying to create a database, which allows me to store appointment information. The key here is that I don't know what resources will be associated with an appointment, but they will all have a unique id. So, I want to have an Appointment table, a Resource table and a many-to-many

Re: [GENERAL] relation does not exist error

Simon Wittber <[EMAIL PROTECTED]> writes: > WMSDV=# \dt > List of relations > Schema | Name| Type | Owner > +---+---+--- > public | Customers | table | simon > public | Persons | table | simon > (2 rows) > > WMSDV=# select * from Customers; > ERROR: re

Re: [GENERAL] relation does not exist error

On Fri, Dec 03, 2004 at 11:01:16AM +0800, Simon Wittber wrote: > List of relations > Schema | Name| Type | Owner > +---+---+--- > public | Customers | table | simon > public | Persons | table | simon > (2 rows) > > WMSDV=# select * from Customers; > ER

[GENERAL] relation does not exist error

I'm evaluationg PostgreSQL 8.0 beta 5 for a new development project. I've created a user 'simon' and a database named 'WMSDV'. I've created some tables (see below) and assigned arwdRxt privledges to the 'simon' user. However, when i use psql, I am unable to select these tables. I receive a 'rela

Re: [GENERAL] Rules

> Planning on witting a rule for a view, and i was wondering if anyone > could suggest a good Internet resource? http://www.postgresql.org (Sorry, couldn't resist.) ---(end of broadcast)--- TIP 7: don't forget to increase your free space map sett

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start;

(From someone else who doesn't know what doesn't know, ... :-/) (B (B>sudo -u testuser sh -c "nohup /usr/local/pgsql/bin/postmaster [...] (B... (B (B> >> note that my cmd line refers to the conf file, which has the external (B> >> PID id'd in it: (B> > (B> >> external_pid_file = '/

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start;

hi, But who is it owned by, and with what permissions? same owner as postmaster, 0644 or 0600 If you do the "touch" as some other user than the postmaster runs as, it's very plausible the postmaster can't write the file. (That doesn't yet explain why it goes south afterward, but first we need to

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

OpenMacNews <[EMAIL PROTECTED]> writes: > stop postgres > touch PIDfile (if _not_ there) > reboot > --> NO launch, nothing in the logs > verify PIDfile exists ... it does But who is it owned by, and with what permissions? If you do the "touch" as some other user than the postm

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start;

hi, note that my cmd line refers to the conf file, which has the external PID id'd in it: external_pid_file = '/var/run/postgresql.pid' Oh, now you tell us ;-) heh. sorry -- just thought it was SOP. in case you haven't noticed, i'm at that 'wunnerful' ramp-up stage that i dunno what i dunn

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

OpenMacNews <[EMAIL PROTECTED]> writes: > note that my cmd line refers to the conf file, which has the external > PID id'd in it: > external_pid_file = '/var/run/postgresql.pid' Oh, now you tell us ;-) Still, I'm not sure what could be the problem. The only code that reacts to that setting

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start;

hi tom, In that case it's a problem in your launch script. The postmaster doesn't even know that such a file exists; it keeps its lock file in the data directory. well, h. the launch script is currently simplified (for testing) to just the pid-checking-if-stmt + the single line launch cmd. t

Re: [SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

OpenMacNews <[EMAIL PROTECTED]> writes: > although i've seen nothing pid-related in my logs, preceding my startup file > launch cmd with a pid check/delete: >if [ -f /var/run/postgresql.pid ]; then >rm -rf /var/run/postgresql.pid >fi >(launch cmd) > seems to have done the tri

Re: [GENERAL] data integrity and inserts

On Thu, Dec 02, 2004 at 14:20:35 -0600, Timothy Perrigo <[EMAIL PROTECTED]> wrote: > The first way also makes it possible to put the constraint on multiple > fields: > > create unique index uidx_abc on my_table(col_a, col_b, col_c); You can do that with unique constraints as well. ---

Re: [GENERAL] Rules

Have you looked at the html docs? It looks like "34.2. Views and the Rule System" might be what you are looking for, but I didn't check it closely. On Thursday 02 December 2004 05:34 pm, Jamie Deppeler saith: > HI, > > Planning on witting a rule for a view, and i was wondering if anyone > could s

Re: [GENERAL] Adding Reply-To: to Lists configuration ...

Chris Green <[EMAIL PROTECTED]> wrote: > > On Thu, Dec 02, 2004 at 01:59:07AM -0500, Greg Stark wrote: > > > > > > (On that note I would dearly love to get rid of the stupid "[GENERAL]" > > "[HACKERS]" etc tags? ... [snip] > > > I absolutely agree I hate the damn things with a passion. >

[GENERAL] Rules

HI, Planning on witting a rule for a view, and i was wondering if anyone could suggest a good Internet resource? thx begin:vcard fn:Jamie Deppeler n:Deppeler;Jamie org:Once;Development adr:;;46 Roseneath Street;North Geelong;Vic;3215;Australia email;internet:[EMAIL PROTECTED] title:Database Admin

[SOLVED] Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

hi tom, LOG: 0: logger shutting down LOCATION: SysLoggerMain, syslogger.c:361 I should have twigged to that before --- if you're running the syslogger, then nothing except very early startup messages is going to go to stderr. Look in wherever you told it to put the log output. i thou

Re: [GENERAL] Upcoming Changes to News Server ...

On Wed, Dec 01, 2004 at 06:25:53PM +, Woodchuck Bill wrote: > > Jan, Gary may be blunt at times, but try to understand things from his > perspective. He is posting to Usenet. He expects his replies to appear on > Usenet. You are accustomed to your way of writing and reading messages. He > i

Re: [GENERAL] Select Database

On 12/2/2004 4:39 AM, ON.KG wrote: Hi All! How could I select another database without new connection? For example, in PHP+MySQL we have mysql_select_db('database_name'); You can't. An existing session cannot change the database connected to. Jan -- #

Re: [GENERAL] List archives not being updated?

On Thu, 2 Dec 2004, Joshua D. Drake wrote: Joshua D. Drake wrote: Marc G. Fournier wrote: Joshua? Taking a look now. Looks like we are having a minor DNS issue which is causing the DNS lookup to srv5 to fail. Sincerely, Joshua D. Drake Everything looks fine on the main server itself ... and Jo

Re: [GENERAL] List archives not being updated?

'k, let me know how it goes ... just checked UUnet's name server: # nslookup svr5.postgresql.org ns.uunet.ca Server: ns.uunet.ca Address: 142.77.1.1 Name:svr5.postgresql.org Address: 66.98.251.16 and it resolves fine :( Yeah it is definately a local issue here. Sincerely, Joshua D. Drake S

Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

OpenMacNews <[EMAIL PROTECTED]> writes: > LOG: 0: logger shutting down > LOCATION: SysLoggerMain, syslogger.c:361 I should have twigged to that before --- if you're running the syslogger, then nothing except very early startup messages is going to go to stderr. Look in wherever you

Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

On Thu, Dec 02, 2004 at 12:43:57PM -0800, OpenMacNews wrote: > given my additions of: > > -n do not reinitialize shared memory after abnormal exit > -i enable TCP/IP connections > -h HOSTNAME host name or IP address to listen on Why don't you use postgresql.conf

Re: [GENERAL] List archives not being updated?

On Thu, 2 Dec 2004, Joshua D. Drake wrote: Marc G. Fournier wrote: Joshua? Taking a look now. Looks like we are having a minor DNS issue which is causing the DNS lookup to srv5 to fail. 'k, let me know how it goes ... just checked UUnet's name server: # nslookup svr5.postgresql.org ns.uunet.ca Se

Re: [GENERAL] Pl/Perl w/ Postgres 8.0 on Windows

Thanks to both of you gentlemen. I actually had to restart Postgres after installing ActiveState Perl before I could successfully run createlang and add the language. Seems to be working now, though. Cheers, Eric Magnus Hagander wrote: Hi all, I am throughly enjoying using Postgres 8.0 on W

Re: [GENERAL] List archives not being updated?

On Thu, 2 Dec 2004, Michael Fuhr wrote: The list archives at http://archives.postgresql.org/ don't appear to have been updated since Tue 30 Nov. Is something amiss? Fix. -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 3: i

Re: [GENERAL] List archives not being updated?

Joshua D. Drake wrote: Marc G. Fournier wrote: Joshua? Taking a look now. Looks like we are having a minor DNS issue which is causing the DNS lookup to srv5 to fail. Sincerely, Joshua D. Drake Everything looks fine on the main server itself ... and John grab'd his update this morning around 3a

Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

hi tom, -- On Thursday, December 2, 2004 12:33:48 PM PST -0500 Tom Lane <[EMAIL PROTECTED]> wrote: OpenMacNews <[EMAIL PROTECTED]> writes: sudo -u testuser sh -c "nohup /usr/local/pgsql/bin/postmaster -n -i -h 10.0.0.6 -D /var/data/pgsql -c config_file=/etc/pgsql/postgresql.conf >/var/devlogs

Re: [GENERAL] List archives not being updated?

Marc G. Fournier wrote: Joshua? Taking a look now. Looks like we are having a minor DNS issue which is causing the DNS lookup to srv5 to fail. Sincerely, Joshua D. Drake Everything looks fine on the main server itself ... and John grab'd his update this morning around 3am, so rsyncd on our side

Re: [GENERAL] [HACKERS] Adding Reply-To: to Lists configuration ...

On Thu, Dec 02, 2004 at 01:59:07AM -0500, Greg Stark wrote: > > > (On that note I would dearly love to get rid of the stupid "[GENERAL]" > "[HACKERS]" etc tags? Filtering on subject is a dumb way to filter your mail, > there are perfectly good headers inserted by the list manager that don't get >

Re: [GENERAL] List archives not being updated?

On Thu, 2 Dec 2004, Tom Lane wrote: "Marc G. Fournier" <[EMAIL PROTECTED]> writes: Joshua? Everything looks fine on the main server itself ... and John grab'd his update this morning around 3am, so rsyncd on our side is working as well ... problems on your end? It looks like the issue is that the

Re: [GENERAL] data integrity and inserts

The first way also makes it possible to put the constraint on multiple fields: create unique index uidx_abc on my_table(col_a, col_b, col_c); On Dec 2, 2004, at 1:51 PM, Ian Harding wrote: The second is shorthand for the first. you get to choose the index name in the first one. Ian Harding Pro

Re: [GENERAL] data integrity and inserts

"Ian Harding" <[EMAIL PROTECTED]> writes: > The second is shorthand for the first. you get to choose the index name > in the first one. IIRC you can force the index name in the second case too, by using the fully unabbreviated CONSTRAINT syntax: ..., CONSTRAINT indexname UNIQUE(colname)

[GENERAL] Select Database

Hi All! How could I select another database without new connection? For example, in PHP+MySQL we have mysql_select_db('database_name'); Thanx ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresq

Re: [GENERAL] List archives not being updated?

"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > Joshua? Everything looks fine on the main server itself ... and John > grab'd his update this morning around 3am, so rsyncd on our side is > working as well ... problems on your end? It looks like the issue is that the toplevel web pages haven't

Re: [GENERAL] [HACKERS] Adding Reply-To: to Lists

On Thu, 2 Dec 2004, Greg Stark wrote: (On that note I would dearly love to get rid of the stupid "[GENERAL]" "[HACKERS]" etc tags? Filtering on subject is a dumb way to filter your mail, there are perfectly good headers inserted by the list manager that don't get confused by cross-posts and pers

Re: [GENERAL] Indexes?

On Thu, Dec 02, 2004 at 07:11:29AM +0100, Bjørn T Johansen wrote: > I have a table where I need to use "..where curdate between fromDate and > toDate". > Is it best to have two indexes, one for FromDate and one for toDate or just > one index for both the fields? You could try it both ways and u

Re: [GENERAL] [HACKERS] Adding Reply-To: to Lists configuration ...

On Thu, Dec 02, 2004 at 01:59:07AM -0500, Greg Stark wrote: > (On that note I would dearly love to get rid of the stupid "[GENERAL]" > "[HACKERS]" etc tags? Filtering on subject is a dumb way to filter your mail, I am with you on this. I find the tag useless and annoying. -- Alvaro Herrera (<[

Re: [GENERAL] Indexes?

On Wed, Dec 01, 2004 at 23:16:48 -0800, Vincent Hikida <[EMAIL PROTECTED]> wrote: > I believe that it is better to have a concatenated key of > (toDate,FromDate). The reason the toDate should come first is that for more > "recent" records, finding curDates less than toDate is much more selectiv

Re: [GENERAL] data integrity and inserts

The second is shorthand for the first. you get to choose the index name in the first one. Ian Harding Programmer/Analyst II Tacoma-Pierce County Health Department [EMAIL PROTECTED] Phone: (253) 798-3549 Pager: (253) 754-0002 >>> Scott Frankel <[EMAIL PROTECTED]> 12/01/04 10:48 AM >>> 1. CREATE

Re: [GENERAL] [HACKERS] Adding Reply-To: to Lists configuration ...

Bruno Wolff III <[EMAIL PROTECTED]> writes: > It is also possible for mailing list software to handle this preference for > you (by not sending copies to addresses on the list that appear in the > recipient headers), but I don't know if the software in use has that > capability. I've noticed som

Re: [GENERAL] List archives not being updated?

Joshua? Everything looks fine on the main server itself ... and John grab'd his update this morning around 3am, so rsyncd on our side is working as well ... problems on your end? On Thu, 2 Dec 2004, Michael Fuhr wrote: The list archives at http://archives.postgresql.org/ don't appear to have be

Re: [GENERAL] Indexes?

On Thu, Dec 02, 2004 at 07:11:29 +0100, Bjørn T Johansen <[EMAIL PROTECTED]> wrote: > I have a table where I need to use "..where curdate between fromDate and > toDate". > Is it best to have two indexes, one for FromDate and one for toDate or just > one index for both the fields? Assuming that

Re: [GENERAL] Indexes?

I believe that it is better to have a concatenated key of (toDate,FromDate). The reason the toDate should come first is that for more "recent" records, finding curDates less than toDate is much more selective than finding curDates greater than fromDate. Actually I'm not sure if fromDate is that

[GENERAL] problem with multiple invocations of a deferred constraint trigger

Hello all, I have two tables (simplified): create table clin_episode ( pk serial primary key, started timestamp with time zone, fk_clin_narrative integer unique default null ); create table clin_narrative ( pk serial primary key, fk_episode integer not

[GENERAL] List archives not being updated?

The list archives at http://archives.postgresql.org/ don't appear to have been updated since Tue 30 Nov. Is something amiss? -- Michael Fuhr http://www.fuhr.org/~mfuhr/ ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [GENERAL] (b)trim anomalies

Thomas F. O'Connell wrote: > Nice. Thanks, Bruce. If I felt as if I could speak a little more > authoritatively about why it had been missing, I would've offered to > document it. > > Now it is a psql/postgres internals issue that causes \df trim not to > reveal anything? It doesn't reveal

Re: [GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

OpenMacNews <[EMAIL PROTECTED]> writes: >sudo -u testuser sh -c "nohup /usr/local/pgsql/bin/postmaster -n -i -h > 10.0.0.6 -D /var/data/pgsql -c config_file=/etc/pgsql/postgresql.conf > >/var/devlogs/postgres.log &" Hmm, isn't this letting postmaster stderr disappear into the bit bucket? Try

Re: [GENERAL] Changing column type from oid to int4

Mario Weilguni <[EMAIL PROTECTED]> writes: > Did somebody ever try to change the type to a compatible type? I plan to > change a column from oid to int (once it holded a lob, now some sort of id) > with modifying pg_attribute: > update pg_attribute > set atttypid=(select oid from pg_type w

Re: [GENERAL] (b)trim anomalies

Nice. Thanks, Bruce. If I felt as if I could speak a little more authoritatively about why it had been missing, I would've offered to document it. Now it is a psql/postgres internals issue that causes \df trim not to reveal anything? -tfo -- Thomas F. O'Connell Co-Founder, Information Archi

Re: [GENERAL] (b)trim anomalies

OK, I have documented that the second parameter to btrim() is optional, and default to a space. Patch attached and applied. --- Thomas F. O'Connell wrote: > Not entirely. > > Per

[GENERAL] pgsql8b5 not launching on OSX system start; otherwise OK

hi all, i've a new install of pgsql8b5 running on OSX 10.3.6. i can readily start it from the command line with: sudo -u testuser sh -c "nohup /usr/local/pgsql/bin/postmaster -n -i -h 10.0.0.6 -D /var/data/pgsql -c config_file=/etc/pgsql/postgresql.conf >/var/devlogs/postgres.log &" after whic

Re: [GENERAL] pg_restore taking 4 hours!

Thierry Missimilly wrote: Rodrigo Carvalhaes a écrit : Hi! I am using PostgreSQL with a proprietary ERP software in Brazil. The database have around 1.600 tables (each one with +/- 50 columns). My problem now is the time that takes to restore a dump. My customer database have arount 500mb (on the

Re: [GENERAL] md5 checksum mismatch

Bill Kurland wrote: I've downloaded several versions of postgresql from several mirrors. On none of them did the md5 checksums from http://www.gtsm.com/postgres_sigs.html match the md5 checksum from the postgresql-*.tar.gz source file I downloaded. As a follow-up to my last message, "md5sum --ch

[GENERAL] Changing column type from oid to int4

Did somebody ever try to change the type to a compatible type? I plan to change a column from oid to int (once it holded a lob, now some sort of id) with modifying pg_attribute: update pg_attribute set atttypid=(select oid from pg_type where typname='int4') where attname='whatever' and

Re: [GENERAL] Poor Performance with Distinct Subqueries with EXISTS and EXCEPT

I wasn't sure whether EXCEPT would create a unique set from among the results of both queries. As in, if the first part of the query (before the EXCEPT clause), without the DISTINCT, yielded yahoo.com yahoo.com would the query reduce that to a single yahoo.com regardless of whether it showed u

Re: [GENERAL] Poor Performance with Distinct Subqueries with EXISTS and EXCEPT

=?iso-8859-15?Q?Pierre-Fr=E9d=E9ric_Caillaud?= <[EMAIL PROTECTED]> writes: > I may be mistaken, but you may be doing the same thing twice : you're > basically writing : > SELECT DISTINCT X WHERE Y EXCEPT SELECT DISTINCT X WHERE NOT Y > Is this not a way to get an empty result s

Re: [GENERAL] Pl/Perl w/ Postgres 8.0 on Windows

> Hi all, > I am throughly enjoying using Postgres 8.0 on Windows, so > I can develop my Windows client against Postgres. > I would like to write some pl/perl functions, and I'm a > little stumped. > Now comes the sad confession - I installed PG from the > Windows installer rather than bu

Re: [GENERAL] md5 checksum mismatch

Bill Kurland wrote: I've downloaded several versions of postgresql from several mirrors. On none of them did the md5 checksums from http://www.gtsm.com/postgres_sigs.html match the md5 checksum from the postgresql-*.tar.gz source file I downloaded. I can't imagine that all these file are corrup

Re: [GENERAL] Displaying more than six digits from a real number

--- Tom Lane <[EMAIL PROTECTED]> escreveu: > Clodoaldo Pinto <[EMAIL PROTECTED]> writes: > > The 7.4.2 manual says the precision of a real number is 6 decimal digits. > > Is it possible to force the display of more than six decimal digits of a > > real number > > Perhaps the extra_float_digits

Re: [GENERAL] Get diagnistic (row_count) 7.3 vs. 7.4 changes

Tom Lane wrote: Maksim Likharev <[EMAIL PROTECTED]> writes: in 7.3.3 GET DIAGNOSTICS was returning number of selected rows into a temp table in 7.4.5 GET DIAGNOSTICS returns 0 Hmm. I'm not sure if that's a bug or an improvement. The command did not return any rows to plpgsql, so in that sense ro

Re: [GENERAL] Poor Performance with Distinct Subqueries with EXISTS and EXCEPT

Now, since I'm actually interested in unique domain names rather than unique users, I need to get all the unique domain names corresponding to users who have acted on a message. That's what the part of the query after the EXCEPT is. I don't understand this part at all. What does it mean ?

[GENERAL] ISO week and extract(dow from source)

>From the 7.4.2 manual, Date/Time Functions and operators, 9.8.1. EXTRACT, date_part: week: (The ISO-8601 week starts on Monday.) dow: The day of the week (0 - 6; Sunday is 0) Why is Sunday dow 0, if the iso week starts on Monday and the iso week is used in extract(week from source)? Cl

Re: [GENERAL] Need Help and suggestion.

Artistic-HO- IT-Department wrote: Hi I have a user table in which number of users are created in a database rather creating postgresql user. We are having only one database user, through which we connect database. OK Like Mr. A add intry into table and data is copied into audit table. Mr. B edit e

Re: [GENERAL] UNION with ORDER BY -allowed?

On Thu, Dec 02, 2004 at 10:13:26AM -0500, [EMAIL PROTECTED] wrote: > > -Original Message- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Chris Green > > Sent: Thursday, December 02, 2004 9:56 AM > > To: [EMAIL PROTECTED] > > Subject: [GENERAL] UNION with ORDER BY -allow

Re: [GENERAL] pg_restore taking 4 hours!

Rodrigo Carvalhaes a écrit : Hi! I am using PostgreSQL with a proprietary ERP software in Brazil. The database have around 1.600 tables (each one with +/- 50 columns). My problem now is the time that takes to restore a dump. My customer database have arount 500mb (on the disk, not the dump file)

Re: [GENERAL] UNION with ORDER BY -allowed?

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of John > Sidney-Woollett > Sent: Thursday, December 02, 2004 10:10 AM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: Re: [GENERAL] UNION with ORDER BY -allowed? > > > wrap the whole statement in a

Re: [GENERAL] UNION with ORDER BY -allowed?

> -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Chris Green > Sent: Thursday, December 02, 2004 9:56 AM > To: [EMAIL PROTECTED] > Subject: [GENERAL] UNION with ORDER BY -allowed? > > > It's not quite clear (to me at least) whether I can have a UNION an

Re: [GENERAL] UNION with ORDER BY -allowed?

wrap the whole statement in another select select col1, col2, col5, col6 from ( SELECT col1, col2, col5, col6 FROM table WHERE col2 = 'X' UNION SELECT col3, col4, col5, col6 FROM table WHERE col4 = 'X' ) as t o

[GENERAL] UNION with ORDER BY -allowed?

It's not quite clear (to me at least) whether I can have a UNION and an ORDER BY in a SELECT statement. What I want to do is:- SELECT col1, col2, col5, col6 FROM table WHERE col2 = 'X' UNION SELECT col3, col4, col5, col6 FROM table

[GENERAL] PostgreSQL Authors wanted

Hi, beehive KG is considering publishing a quarterly online technical journal on PostgreSQL. If you would want to write for us please visit this page for more details:. http://www.beehive-eu.com/PostgreSQLAuthors.html Thanks and regards, Mark ---(end of broadcast)---