Re: [GENERAL] accounting package

Garry Saddington wrote: Does anyone know of a web based accounting(finance) package that uses Postgresql as a backend? LedgerSMB Rod -- Thanks Garry -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] Connect to Postgres problems

Christine Penner wrote: Hi, I'm having trouble getting a connection to Postgres to work from outside of my local network. It was working fine at one point. Then I had to change IP addresses and I can't get it to work. This is what I've done. On the computer with Postgres installed I have thi

Re: [GENERAL] postgres issue

Craig Ringer wrote: On 9/01/2010 10:53 PM, Amy Smith wrote: How to use mount for differnt region. I do not understand this question. Can you explain what you mean a bit more? Probably wants tablespaces? \\||/ Rod -- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] auto-filling a field on insert

semi-ambivalent wrote: On Oct 21, 8:54 pm, da...@fetter.org (David Fetter) wrote: On Wed, Oct 21, 2009 at 07:17:44PM -0700, semi-ambivalent wrote: If I have a table with fields A, B, C and D how could I do something such that if I insert values in fields A, B and C field D would be auto-filled

Re: [GENERAL] multi-company design/structure ?

John wrote: Hi, Is it better to create multi databases or create multi schemas? John, I just gave a talk on multi-tenant Pg clusters at PgConf West 2009 that may help you but ran into vehicle problems and just got home this evening. As quick as I can I'll get the bits-and-pieces pulled to

Re: [GENERAL] Best data type to use for sales tax percent

Jasen Betts wrote: On 2009-10-09, Peter Eisentraut wrote: On Fri, 2009-10-09 at 11:46 -0700, Christophe Pettus wrote: Domains are basically type aliases with an optional CHECK clause, so you could do something like: CREATE DOMAN sales_tax_rate AS DECIMAL(5,5) CHECK (VALUE >= 0); Th

Re: [GENERAL] how to use multiple schema's

Here is my first post which missed the list. Not that it makes that much of a difference now as all my points have been addressed by others. raa Himanshu Gupta wrote: Hi, I have multiple applications, i want to create separate schema for each of the application. I dont want to change search

Re: [GENERAL] how to use multiple schema's

Sam Mason wrote: On Wed, Sep 02, 2009 at 10:52:07AM -0400, Himanshu Gupta wrote: Thanks for response, bit if I point it to all the schema, I am just wondering how data insertion will work, I have multiple ables with same name in these applications. Do you know that you can schema qualify ta

Re: [GENERAL] how to use multiple schema's

OOPS I got caught by the reply verses reply-all and only sent this to Scott. Plus I see it has already been addressed in a later message. raa Scott Marlowe wrote: So, can you just set search_path to point to all the schemas at once then? Or does that not meet your needs? The only issue I s

Re: [GENERAL] PostgreSQL for Firefox Bookmarks?

Philip Rhoades wrote: People, It would be nice to be able to use PostgreSQL as the storage for Firefox Bookmarks - anyone know if this would be possible? how it could be done? Not sure about doing it with PostgreSQL but there is the Firefox Weave Service which might do what I think you're af

Re: [GENERAL] Drop Cluster

sw...@opspl.com wrote: Hi, I believe that command is specific to the debian/ubuntu distributions. in generic postgres, you'd simply stop the server, then delete the contents of the $PGDATA directory I am using CentOS 5 and postgrest 8.1.11 . Could not find the PGDATA directory. :( On my

Re: [GENERAL] Adding the host name to the PgSQL shell

Scott Mead wrote: On Mon, Jun 8, 2009 at 12:44 PM, Madison Kelly > wrote: Hi all, I work on a development and production server, and I am always double-checking myself to make sure I am doing something on the right server. Is there a way, lik

Re: [GENERAL] question on serial key

Brandon Metcalf wrote: g == gryz...@gmail.com writes: g> you should use it, whenever you need db to keep its own key internally. g> Advantage of sequence is also the fact, that you can have the sequence g> value used on different columns/tables . g> My rule of thumb is , in that case: as lo

Re: [GENERAL] Custom types and pg_dump

Tom Lane wrote: "Roderick A. Anderson" writes: While and after doing a import ("\i file_dump") I notice one table had two attributes with a type of "unknown". Is it a table, or a view? This is hardly unheard-of for views, consider Table. The columns are to

[GENERAL] Custom types and pg_dump

A quick request for a pointer to look or an answer. Background: I was asked to test the results of a pg_dump of a database. While and after doing a import ("\i file_dump") I notice one table had two attributes with a type of "unknown". I'm not sure of the Pg version it cam from but I was put

Re: [GENERAL] Community account

Scott Marlowe wrote: On Sat, Apr 18, 2009 at 8:27 AM, Rainer Bauer wrote: Hello Scott, Saturday, April 18, 2009, 4:21:29 PM, you wrote: SM> On Sat, Apr 18, 2009 at 3:49 AM, Rainer Bauer wrote: Hello, I signed up a couple of months ago but never received the confirmation email. If I try to

Re: [GENERAL] Move databases from Pg 7.2.1 to 8.3.x

Tom Lane wrote: "Joshua D. Drake" writes: On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote: The plan calls for a pg_dump using my workstation using CREATE the database and INSERTS (-C -D) . Then use psql to run the script created above to build the database on the

Re: [GENERAL] Move databases from Pg 7.2.1 to 8.3.x

Joshua D. Drake wrote: On Tue, 2009-04-14 at 09:58 -0700, Roderick A. Anderson wrote: I can't avoid it any longer and have to move an old RT2 installation to a new machine. (I'll upgrade to RT3 on that machine.) The plan calls for a pg_dump using my workstation using CREATE the da

Re: [GENERAL] Move databases from Pg 7.2.1 to 8.3.x

John R Pierce wrote: Roderick A. Anderson wrote: make sure pg_hba.conf on the old machine allows you to connect from the new machine's IP address as the user postgres (this may require setting a database password for the postgres user on the old machine if the 'host' authen

[GENERAL] Move databases from Pg 7.2.1 to 8.3.x

I can't avoid it any longer and have to move an old RT2 installation to a new machine. (I'll upgrade to RT3 on that machine.) The plan calls for a pg_dump using my workstation using CREATE the database and INSERTS (-C -D) . Then use psql to run the script created above to build the database

[GENERAL] Determining PUBLIC's permissions

I'm trying to determine the permissions PUBLIC has on several tables/views. Or would this be the default permissions for a table/view? pg_user, pg_roles, pg_group, pg_authid, pg_auth_members, pg_database, pg_tablespace, and pg_settings. \dp pg_user returns (0 rows). I am logged in to templ

Tangent Ref: [GENERAL] Valid characters for user/role/group names?

Roderick A. Anderson wrote: In my continuing quest for multi-tenant ways I'm trying to come up with a method to name roles, users, and groups that will not clash across the cluster. While testing and researching I discovered prior work. I was using different terminology.

[GENERAL] Valid characters for user/role/group names?

In my continuing quest for multi-tenant ways I'm trying to come up with a method to name roles, users, and groups that will not clash across the cluster. The plans are to have one database per tenant and place applications in different schema in those databases. This is working fine so far bu

Re: [GENERAL] Multi-tenant cluster

Scott Marlowe wrote: On Wed, Dec 24, 2008 at 8:17 AM, Roderick A. Anderson wrote: I've done some searching using Google and found a few papers and articles on multi-tenant databases. I still have to read through many of them but there didn't appear to be much reference to using Pos

[GENERAL] Multi-tenant cluster

I've done some searching using Google and found a few papers and articles on multi-tenant databases. I still have to read through many of them but there didn't appear to be much reference to using PostgreSQL in the ones I found. Can anyone suggest sources of information on this topic -- multi

Re: [GENERAL] Using dblink to connect as non-superuser

Robert Fitzpatrick wrote: I try to use dblink_connect while logged into the database as the superuser and it returns OK, but if I disconnect and use the same command as follows, it give and error, password is required. Even if I try to use the superuser login in the connect string below while con

Re: [GENERAL] Problems with Timezones in Australia

Scott Marlowe wrote: On Thu, Oct 16, 2008 at 8:52 AM, Roderick A. Anderson <[EMAIL PROTECTED]> wrote: Tom Lane wrote: CentOS 5 -- three, four, or maybe more, updates this year so far. :-) Is there a way to determine from a binary install (Devrim GÜNDÜZ's rpms) if it uses the syst

Re: [GENERAL] Problems with Timezones in Australia

Tom Lane wrote: "Roderick A. Anderson" <[EMAIL PROTECTED]> writes: Tom Lane wrote: No, you're behind the times: 8.2.4 and 8.1.9 are too old to know about this year's changes in southeast Australia DST laws. Which I imagine is what's biting you. Doesn't

Re: [GENERAL] Problems with Timezones in Australia

Tom Lane wrote: "Craig Ayliffe" <[EMAIL PROTECTED]> writes: I have several Postgres DB's not showing correct daylight savings time. From maillist etc I believe these are patched up to the right levels to have the correct time zones - but they don't seem to be working still. No, you're behin

Re: [GENERAL] Ideas on how to use external perl script

Sorry to all but my original reply went to Dave instead of the list. Gauthier, Dave wrote: Wait, I also appear to have plperlu (createlang plperlu seems to have worked successfully). Now if it will do what you need. :-) Rod -- -Original Message- From: Roderick A. Anderson

Re: [GENERAL] psql scripting tutorials

Kevin Hunter wrote: At 7:13am -0400 on Thu, 11 Sep 2008, Harald Fuchs wrote: Nice trick, but when I try the following variant: psql -v TEST=16 -c 'select :TEST as "input"' I get [a syntax error] This seems to be contrary to the psql manual page: Nope. Take a look at the -c option. Spe

Re: [GENERAL] [Q] DNS(bind) ER model

Mark wrote: On Thu, 2008-08-14 at 16:20 -0700, Roderick A. Anderson wrote: Anyone aware of an ER model for holding name server records? Working on the zone file data and I am getting close but keep running into the differences between MX records (with a priority) and the others that can hold

Re: [GENERAL] [Q] DNS(bind) ER model

Steve Atkins wrote: On Aug 15, 2008, at 12:16 PM, Andrew Sullivan wrote: On Fri, Aug 15, 2008 at 07:44:36AM -0700, Roderick A. Anderson wrote: Thanks again. This is a pretty specialized application (at this time) so the RRTYPEs used are limited. I am trying to make the model and Pg

Re: [GENERAL] [Q] DNS(bind) ER model

David Goodenough wrote: On Friday 15 August 2008, Roderick A. Anderson wrote: Anyone aware of an ER model for holding name server records? Working on the zone file data and I am getting close but keep running into the differences between MX records (with a priority) and the others that can

Re: [GENERAL] [Q] DNS(bind) ER model

Andrew Sullivan wrote: On Thu, Aug 14, 2008 at 04:20:14PM -0700, Roderick A. Anderson wrote: Anyone aware of an ER model for holding name server records? What about a datatype? I have reason to believe that a company I used to work for implemented such a thing. There was some talk of

[GENERAL] [Q] DNS(bind) ER model

Anyone aware of an ER model for holding name server records? Working on the zone file data and I am getting close but keep running into the differences between MX records (with a priority) and the others that can hold either a domain/sub-domain/host name or an IP address depending on whether i

Re: [GENERAL] ER Diagram design tools (Linux)

Kevin Kempter wrote: On Wednesday 05 March 2008 20:33:43 Conor McTernan wrote: I was wondering if anyone knows of any good ER Diagram tools for Postgres that run on Linux. If you're not against paying there is dbwrench . Java so it could be a bit of a problem because

Re: [GENERAL] DBA Book - Not "postgresql book - practical or something newer?"

Olexandr Melnyk wrote: Joe Celko's "SQL Programming Style" is a good not vendor-specific book. And maybe a bit too Developer/User-ish but very good his "SQL for Smarties". Rod -- As for PostgreSQL-specific books, I can only speak for one I read before: Bruce Momjian's "PostgreSQL: Introduc

Re: [GENERAL] DBI/DBD::Pg and transactions

Alan Hodgson wrote: On Wednesday 18 July 2007 14:29, "Roderick A. Anderson" <[EMAIL PROTECTED]> wrote: In the mean time if the script gets triggered again and the first instance isn't finished the second needs to not be able to select those records already being handled

Re: [GENERAL] DBI/DBD::Pg and transactions

Greg Sabino Mullane wrote: -BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 Will a $sth->execute() of a "SELECT ... FOR UPDATE" statement allow me to update the selected records using $uth->execute( ... ) if $sth and $uth are both created/prepared from the same database handle "$dbh"? You

[GENERAL] DBI/DBD::Pg and transactions

Hopefully the original post went astray and this isn't a duplicate. I don't see it in the archive so I'll assume I have a bogus SMTP setup at work for my home account. I've tried the Pg docs, DBI book, and Google searches but haven't found anything useful on this topic. I realize this is mor

Re: [GENERAL] changing the permission of _lots_ of tables

000 mailte Richard Huxton folgendes: Roderick A. Anderson wrote: Works great ... up to a point. I now need to change the users and owners associated with all the tables without changing their permissions. Is there a way or hack to do mass changes like these. Write a small plpgsql function

[GENERAL] changing the permission of _lots_ of tables

Back in September Bobby Gontarski asked about copy db1 to db2. Jim Nasby came back with the suggestion of using db1 as the template for creating db2. Works great ... up to a point. I now need to change the users and owners associated with all the tables without changing their permissions.

Re: [GENERAL] Does a GRANT on a table cascade/implied to its SEQUENCES

Tom Lane wrote: "Roderick A. Anderson" <[EMAIL PROTECTED]> writes: I've add a new user and as I go though granting various accesses to the different tables I realized many of those tables have primary keys that are generated by a sequence. Do I need to grant access

[GENERAL] Does a GRANT on a table cascade/implied to its SEQUENCES

I'm working on an application ( using Catalyst ) and realized I was using a user with too many privileges to access the database. I've add a new user and as I go though granting various accesses to the different tables I realized many of those tables have primary keys that are generated by a s

Re: [GENERAL] Viewing Database Scheme

Rich Shepard wrote: I'm trying to help the XRMS developers add postgres support ('cause that's what I use). They've done well so far with help from other postgres users, but now I've been asked to help getting the indices correct. Hi Rich. Seems once again we're meeting in the same places.

[GENERAL] SQL Lint

Just rejoined after a year of so of being away and have a question. The Search from the PostgreSQL.org mail-archives site isn't working ( or maybe not working like I think it should ) I get a 503 Server error. The quesion just came up, as we start the process of moving from MySQL to PostgreSQ

[GENERAL] default column value using a function, trigger, or whatever

I am trying to come up with a method to have a default value for a column based on a function and other columns. I'm hoping ( well not too much ) that what I figure out here will apply to MS SQL Server as I am stuck using it unless I can prove there ain't no way it's going to happen. ( Now th

Re: [GENERAL] DBs and Schemas

On Wed, 7 Jan 2004, Martijn van Oosterhout wrote: > Are you actually going to be doing joins between these applications? > If not, why not setup multiple databases, then you can be sure they > won't conflict. Well in at least one situation I can think of there will be joins. And with a minimum o

Re: [GENERAL] DBs and Schemas

On Tue, 6 Jan 2004, Oliver Elphick wrote: > You can use ALTER DATABASE to set that up permanently, without touching > the application. I'd thought of this but since there will be several applications installed and some, I am sure, will have same-named tables this could back-fire. Rod -- "

Re: [GENERAL] DBs and Schemas

On Tue, 6 Jan 2004, Adam Ruth wrote: > One thing I'd suggest would be to modify the application to issue a > "set search_path = yourschema;" at the beginning, then the rest of the > application wouldn't need to change. That's what I did when I did > something similar. Neat idea. I was thinki

Re: [GENERAL] Scripting a new db server setup

On Sun, 4 Jan 2004, A E wrote: > Hi, > Was wondering if there are ways to completely script a new postgresql > installation. I need to be able to create the db, users, and db > elements from one command so that I can included it in a setup > routine. How about pgbash. Is it still being supporte

Re: [GENERAL] Installing Postgres w/RH9

On Tue, 23 Dec 2003 [EMAIL PROTECTED] wrote: > I just installed RH9 on a new machine and installed postgres in the > installation process. I got the following error when trying to > start the postmaster so... I tried removing the postgres software > then reinstalling. rpm first said the softwa

Re: [GENERAL] LIMIT modifier

On Mon, 15 Dec 2003, Arjen van der Meijden wrote: > "Nonstandard Clauses > > The clauses DISTINCT ON, LIMIT, and OFFSET are not defined in the SQL > standard." Humm. Is there a SQL standard to return a subset of the selected tuples? This being contrary to relational theory I believe. :-) >

[GENERAL] LIMIT modifier

I'm dealing with a project that requires me to query a MS SQL Server. Not a PostgreSQL issue I know but I want to ask if the LIMIT modifier is SQL standard? MS SQL Server uses a TOP modifier. select top 1 * from xxx; Whereas all the SQL RDBMS' I've used before used select * f

Re: [GENERAL] perl(Pg) (S)RPM

On Tue, 2 Dec 2003, Lamar Owen wrote: > Because Pg is no longer distributed as a part of the main tarball, but a > contrib is being distributed that requires it. This is an issue with the > main tarball, not with the RPM packaging, IMO. Someone needs to step up to > the plate and build a Pg R

[GENERAL] perl(Pg) (S)RPM

Any pointers as to why (really) I'm getting this error when I try to install Pg 7.4 from a SRPM build? perl(Pg) is needed by postgresql-contrib-7.4-0.2PGDG I only disabled tcl, tkpkg, pltcl, and python in the SPEC file. I could not install the contrib stuff but I really want the plperl

Re: [GENERAL] SRPM (PGDG) will not build

On Tue, 25 Nov 2003, Lamar Owen wrote: > Hmmm The lines of error in question: > make[2]: Entering directory `/usr/src/redhat/BUILD/postgresql-7.4/src/port' > gcc -O2 -march=i386 -mcpu=i686 -Wall -Wmissing-prototypes > -Wmissing-declarations prod -I../../src/include -D_GNU_SOURCE -c -o path.

[GENERAL] SRPM (PGDG) will not build

Hopefully not fuel to the RPM discussion but I've downloaded the PGDG SRPM this AM made some changes to what packages/portions would build and am now getting the following error. gcc: cannot specify -o with -c or -S and multiple compilations Somewhere near line 719 in the spec file. The

Re: [GENERAL] Update of foreign key values

On Tue, 12 Aug 2003, Dennis Gearon wrote: > Yuup, always name constraints so it's easier to remove them. And if > you name them meaningfully, then others might understand why they > exist! (or later after a coffeeless morning) This "application" has grown as a fungus: in the dark and nourished on

Re: [GENERAL] Update of foreign key values

On Mon, 11 Aug 2003, Stephan Szabo wrote: > Yes. Either DEFERRABLE or INITIALLY DEFERRED must be given in order for > set constraints to be meaningful. This might be another good place to > consider a little clarification (or maybe a doc note in the interactive > docs) Phew. I thought I was goin

[GENERAL] Update of foreign key values

I have two tables in two databases (Pg 7.2.1 - yes I need to upgrade but there are several other dependencies I have to resolve first) and I need to update one database's tables so they can be merged into the other database's table. I know I can drop the constraints and update the tables (primary

Re: [GENERAL] 7.3.3 RPM build

On 26 Jun 2003, Manuel Sugawara wrote: > Lamar Owen <[EMAIL PROTECTED]> writes: > > > If you want to help troubleshoot, look at the > > filter-requires-perl-Pg.sh script (Source16) and see where it needs > > to be invoked > > But ... contrib *depends* on perl (see contrib/rserv for > insta

Re: [GENERAL] 7.3.3 RPM build

On Thu, 26 Jun 2003, Lamar Owen wrote: > > {/usr/src/redhat/RPMS/i386}# rpm -Uvh --test *.rpm > > error: Failed dependencies: > > perl(Pg) is needed by postgresql-contrib-7.3.3-1PGDG > > Argh. That's supposed to be fixed; apparently I did something wrong. Install > it with --nodeps for now

Re: [GENERAL] Performance question

On Mon, 10 Sep 2001, Tille, Andreas wrote: > Hello, > > Now I started some performance comparisons and did the following statement: > The MS-SQL server represents the result "immediately" - you just not notice > any delay. If I do it on the PostgreSQL server it takes 30s on comparable > hardwa

[GENERAL] Idea: jobs.postgresql.org

I was going to suggest this last week amd now it looks like it might be more important. (There was a namserver problem with this account soI never got Bruce's original post - just the replys/follow-ups.) Well since I got layed off last December it has been interesting trying to find employment i

Re: [GENERAL] Roll Back dont roll back counters

On Thu, 16 Aug 2001, Martijn van Oosterhout wrote: > You can tell the order anyway. The order doesn't change, it's only that > there may be numbers missing, Please note the message from "Michael Ansley (UK)". If two of more connections get a cache from a sequence and the inserts are 'sporatic'

Re: [GENERAL] Roll Back dont roll back counters

On Thu, 16 Aug 2001, Martijn van Oosterhout wrote: > Why do people care about holes anyway? I've never understood that... The single seat syndrome? (It's my database and I'm the only one using it.) Trying to put intelligence into the field? (I can tell the order the entries were made in the t

Re: [GENERAL] Would a PostgreSQL database on a DVD be usable?

On Mon, 6 Aug 2001, Allan Engelhardt wrote: > Peter Eisentraut wrote: > > > This won't work. You need to be able to write to the medium for a number > > of reasons. > > Is the reason that PostgreSQL must have log files etc. in the same > directory as the data files (it does not appear to suppo

Re: [GENERAL] Invoices

On Fri, 4 May 2001, Robert wrote: > I write the same application for the same reasons - we're three > partners and we all want to be able to create invoices and also see what > others create. Have you looked at SQL-Ledger? THough I disagree with some of the table designs it is a pretty good

Re: [GENERAL] pg_description usage pointers?

On Mon, 19 Mar 2001, will trillich wrote: > On Mon, Mar 19, 2001 at 09:50:20PM -0500, Bruce Momjian wrote: > > Psql backslash commands use it to describe tables, types, functions, > > etc. > > i realize that, coach. i'm wondering if any devious minds > out there are using it for something clever

Re: [GENERAL] design

On Tue, 30 Jan 2001, Jeff wrote: > I have a design question. Lets say we want to keep track of users and > their respective snail mail addresses. Each user can have up to 4 > different mailing address. Is it better to have all this information in > one table. Only if you have mostly 4 address

Re: [GENERAL] Whoohoo!

Mine _arrived_ last Thurday from Barnes and Noble. No notice about shipping though! Rod -- On Sun, 17 Dec 2000, Brett W. McCoy wrote: [snip] > Greetings from Amazon.com. > > We thought you'd like to know that we shipped your items today, > and that this completes your order. > > ... > > T

Re: [GENERAL] info please

On Tue, 12 Dec 2000 [EMAIL PROTECTED] wrote: > Hello, can you PLEASE send me some information on what this is all about. > I'm lost here. I'm brand new to the whole SQL language and I need all the > help I can get. > Thanks, Sounds like trolling for e-mail addresses. Sorry but I'm not an

Re: [GENERAL] Article involving Postgresql

On Tue, 5 Dec 2000, Adam Lang wrote: > I got a magazine dropped on my desk just now called Storage Management > Solutions. On the cover they have a listing for "Open Source > Databases".They talk about Postgresql, MySQL and Interbase. Just a snippet > of the article: Web Techniques has a pretty

Re: [GENERAL] Where do COMMENTs on columns go?

On Mon, 4 Dec 2000, Nancy Ellman wrote: > However, while I have been able to see the results of the first > example with > > \dd mytable Try \d+ mytable Rod

Re: [GENERAL] [Q] createdb for existing directory

On Mon, 16 Oct 2000, Alfred Perlstein wrote: > huh? How are you copying to an unmounted partition? Sorry I left that step out of the description. I usually mount it to some dumy point long enough to copy the files then unmount it and mount it to the database directory. Rod -- Roderic

[GENERAL] [Q] createdb for existing directory

then update /etc/fstab for the system. Seems to work but it is a kludgy method to do it. What I'd like to do is mount the partition before doing a createdb. Will this work with 7.1? (I'm writing up some instructions that I'd like to not have to change later.) TIA, Rod -- Roder

Re: R: [GENERAL] PostgreSQL book

. I did mine about two weeks ago. Rod -- Roderick A. Anderson [EMAIL PROTECTED] Altoplanos Information Systems, Inc. Voice: 208.765.6149212 S. 11th Street, Suite 5 FAX: 208.664.5299 Coeur d'Alene, ID 83814

Re: [GENERAL] Fake table name?

On Tue, 3 Oct 2000, Tom Lane wrote: > "Roderick A. Anderson" <[EMAIL PROTECTED]> writes: > > select tbl_key, equipname from equipment > > UNION > > select 'All', 'All Equipment' from ??? > > Postgres has a clean

Re: [GENERAL] postgres-user <-> unix user

Basically I think you'll need to add them as part of the adduser/useradd process and/or run a script against the passwd file to create them. rod -- Roderick A. Anderson [EMAIL PROTECTED] Altoplanos Information Systems, Inc. Voice: 208.765.6149212 S.

[GENERAL] ODBC/IIS/PsotgreSQL

up correctly. I am still researching but was hoping someone might have their own quick-and-dirty list of directions. Heck I'd go for a URL even ;-) TIA, Rod -- Roderick A. Anderson [EMAIL PROTECTED] Altoplanos Information Systems, Inc. Voice: 208.765.6149

Re: [GENERAL] Importing into Postgres from a csv file

Hope my partition survives the process (system's at home) since it was only 2 GByte with 1% used. Rod -- Roderick A. Anderson [EMAIL PROTECTED] Altoplanos Information Systems, Inc. Voice: 208.765.6149212 S. 11th Street, S

[GENERAL] I lied! [Solved] SQL Server to PostgreSQL

I hate it when I do this. See an answer I want and run with it rather than find the real answer. Turned out the data files (.mdb) _didn't_ belong to the database. They were a piece of the database that was used for a report. Back to the old grind wheel. Rod -- Roderick A. Anderson [

[GENERAL] [Solved] SQL Server to PostgreSQL

format by using MS Access. Only question left is what is the corresponding field type in PostgreSQL for a memo field in SQL Server/Access (varchar())? Again thanks for all the help, Rod -- Roderick A. Anderson [EMAIL PROTECTED] Altoplanos Information Systems, Inc. Voic

[GENERAL] Re: [SQL] password encryption

R USER username [ WITH PASSWORD 'password' ] [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ] [ VALID UNTIL 'abstime' ] Rod -- Roderick A. Anderson [EMAIL PROTECTED] Altoplanos Information Systems, Inc. Voice: 208.765.6149

[GENERAL] ODBC Stuff

ication is being written in perl (ActiveState) and compiled with perl2exe to make the installation impact (not a full perl installation) on the Windows systems a little lighter. Any and all pointers apprciated, Rod -- Roderick A. Anderson [EMAIL PROTECTED] Altopl

Re: [GENERAL] BIG Data and Perl

} I seem to remember reading somewhere that foreach's are faster and more memory conservative. (Been reading too many perl books lately so I can't say where I saw this.) Rod -- Roderick A. Anderson [EMAIL PROTECTED] Altoplanos Information Systems, Inc. Voice: 2

Re: [GENERAL] Hardware optimising

bottle neck will still be the the IDE interface. (Though I've seen some IDE controllers with onboard cache.) > It will, over the next few months, as money becomes available, be upgraded to: Depending on how fast the money trickles in you'd get some help cheapest with the RAM, then the S

Re: [GENERAL] July 1999 issue of Sys Admin

On Wed, 7 Jul 1999, Kaare Rasmussen wrote: > I'd like to ask if it's on the web? The magazine (www.samag.com) but not the article. Maybe later in the year. I can't remember the policy right now. Rod -- Roderick A. Anderson [EMAIL PROTECTED] Altoplanos Inform

[GENERAL] Soundex functions for triggers?

of the actual name. Is anyone on the list aware of someone building these functions so they are usable in triggers? (Of course I'm now thinking I've seen mention of soundex being a part of PostgreSQL. Go figure!) Any pointers or suggestions are greatly appreciated.

[GENERAL] SQL/Relational Design Text Book recommendations

you think should be used. TIA, Rod -- Roderick A. Anderson [EMAIL PROTECTED] Altoplanos Information Systems, Inc. Voice: 208.765.6149212 S. 11th Street, Suite 5 FAX: 208.664.5299 Coeur d'Alene, ID 83814