Re: [GENERAL] Column limitation?

Kandy Wong wrote: Hi, I'd like to know is there a column limitation for PostgreSQL? like column size and maximum number of columns per table? Thank you. Kandy ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] thank you

have as much opportunity to interact with the PG community. That is until I can convince my new employer to realise the dark side of Microsoft SQL Server. :) -- Paul Lambert Database Administrator AutoLedgers - A Reynolds Reynolds Company ---(end of broadcast

[GENERAL] Error accessing db with psql

too, no pre-existing database system) so I can just blast it and restart, but I'm curious to know what I accidentally deleted since I'm 99.41421356237309504% sure I didn't delete anything other than some files out of my WAL_Archive directory. -- Paul Lambert Database Administrator AutoLedgers

Re: [GENERAL] Archiving problem on Windows

Cheers, Paul. -- Paul Lambert Database Administrator AutoLedgers - A Reynolds Reynolds Company ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Archiving problem on Windows

And what does pgsql show when you do a show archive_command; -- Paul Lambert Database Administrator AutoLedgers - A Reynolds Reynolds Company ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose

Re: [GENERAL] log_line_prefix='%t %u %d %h %p %i %l %x ' causes error

Andrus wrote: log_line_prefix='%t %u %d %h %p %i %l %x ' I checked and all options are legal. That works fine for me... are you sure log_line_prefix is line 482 in your config file? You might have inadvertently put a superfluous % somewhere else. -- Paul Lambert Database Administrator

Re: [GENERAL] Query re disk usage

Paul Lambert wrote: I've just noticed in the tablespace documentation (Ch 19.6) that PG makes use of symbolic links that point to any user-defined tablespaces but AFAIK W2K3 doesn't support symlinks. OK, W2K3 supports a thing it calls Junctions, which are similar to symlinks - and PG

Re: [GENERAL] Query re disk usage

Magnus Hagander wrote: On Thu, 2007-11-22 at 17:04 +0900, Paul Lambert wrote: OK, W2K3 supports a thing it calls Junctions, which are similar to symlinks - and PG appears to be using that in this case. Crisis averted. I was just going to suggest that. It's a pretty neat feature

Re: [GENERAL] POLL: Women-sized t-shirts for PostgreSQL

... do we still get the shirt? :) I'd definitely like some PG shirts, polo and tee. -- Paul Lambert Database Administrator AutoLedgers - A Reynolds Reynolds Company ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your

[GENERAL] Query re disk usage

, access_reports_processed text ) WITHOUT OIDS TABLESPACE ts_autodrs_main ; Cheers, P. -- Paul Lambert Database Administrator AutoLedgers - A Reynolds Reynolds Company ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [GENERAL] Query re disk usage

Paul Lambert wrote: I note however, that the pg_database directory on C drive also grows at the same time to 116MB. That was meant to say the pg_tblspc directory. Both directories (my tablespace and pg_tablespace) contain the same set of files - same names and sizes, eg both contain a file

Re: [GENERAL] Query re disk usage

noticed in the tablespace documentation (Ch 19.6) that PG makes use of symbolic links that point to any user-defined tablespaces but AFAIK W2K3 doesn't support symlinks. -- Paul Lambert Database Administrator AutoLedgers - A Reynolds Reynolds Company ---(end of broadcast

[GENERAL] Function to determine next payment date

- but if someone could point it out to me that would be muchly appreciated. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Function to determine next payment date

Paul Lambert wrote: I'm trying to create a function to determine the next due payment date of a recurring expense. I have a table containing the date the payment first started, and a payment frequency key which relates to a payment ID in another table containing a string defining how

Re: [GENERAL] copy command - date

maintenance_id: 3665 OK SM 07/07/13 06:09 That's not complaining about the date, that is complaining that your input file does not contain the maintenance_id column. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast

Re: [GENERAL] copy command - date

Paul Lambert wrote: novice wrote: I'm using pg version 8.2.4. What is the best method to load this data? I have just a little over 55,000 entries. db5= \copy maintenance FROM test.txt ERROR: invalid input syntax for integer: 3665 OK SM 07/07/13 06:09 CONTEXT: COPY maintenance

Re: [GENERAL] TimestampTZ

for the timezone zone. -- Paul Lambert Database Administrator AutoLedgers ---(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

Re: [GENERAL] TimestampTZ

Paul Lambert wrote: Refer to this paragraph: (8.5.1.2) For timestamp with time zone, the internally stored value is always in UTC (Universal Coordinated Time, traditionally known as Greenwich Mean Time, GMT). An input value that has an explicit time zone specified is converted to UTC using

Re: [GENERAL] WAL Queries

it in the Write Ahead Log section of postgresql.conf file in the PGDATA directory. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [GENERAL] WAL Queries

the modification is being undertaken, just a quick restart once you have saved the file. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [GENERAL] WAL Queries

space you need is largely dependant on the size of your database and the size and frequency of updates coming through. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Changing column types

this. Is there any way, using the system catalogues - pg_tables, pg_attributes etc that I can automatically change all text type fields to varchar or am I better of just recreating the schema? -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast

Re: [GENERAL] Changing column types

Paul Lambert wrote: Owing to a problem with the way access and a couple of other programs I've found handle text columns in PG as something they call 'memo', I want to change all of the text columns in my database to varchar. There's about 600 text columns all up, so I'm looking for a quick

Re: [GENERAL] varchar(n) VS text

to text fields and, if so, is there any easy way of writting a script to change all varchar fields to text? -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [GENERAL] varchar(n) VS text

the wrong character varying from the dropdown list. CREATE TABLE tester ( test_varchar character varying[], test_text text ) If I change it to character varying(20) it works fine. Apologies for that. Thanks for the other info though. -- Paul Lambert Database Administrator AutoLedgers

Re: [GENERAL] Windows Vista Support

is completed you can re-enable it without issue. Regards, -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

that in the near future, if my schedule allows. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

Ron Johnson wrote: On 05/12/07 01:51, Paul Lambert wrote: Sure it's been around nearly since the dawn of time, but it's still an actively developed operating system. I've finally got my Alpha server at home up and running now too, and I What are you running? Off hand I couldn't tell you

Re: [GENERAL] backup and restore

/continuous-archiving.html -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

[Fwd: Re: [GENERAL] backup and restore]

/continuous-archiving.html Are you trying to use PG to backup an MS SQL server database? -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose

Re: [GENERAL] Fault Tolerant Postgresql (two machines, two postmasters, one disk array)

RkulQKSefuR04O6D/3xlbaY= =7cNv -END PGP SIGNATURE- -- Paul Lambert Database Administrator AutoLedgers ---(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

Re: [GENERAL] Idle session timeout?

-land? You need to alter some settings in the registry. See: http://msdn2.microsoft.com/en-us/library/aa302363.aspx -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 6: explain analyze is your friend

[GENERAL] Vacuuming

); Is there any point in vacuuming? Also, is there any point in recreating indexes on this table after a load like this or will indexes have been correctly maintained/updated by the above insert. Note: This insert often loads tens of millions of records. BTW, this is on Windows. Thanks, Paul. -- Paul

Re: [GENERAL] Vacuuming

and copy in new data 3) Vacuum - now changed to analyze. 4) Create indexes I add steps one and four on the assumption that adding 40 million records in one hit might get the indexes confused - but if they are pretty stable I can remove these steps. P. -- Paul Lambert Database Administrator

Re: [GENERAL] Vacuuming

. regards, tom lane Thanks for all the help Tom, educational as always. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose

[GENERAL] PG Books

this question, but sometimes I like to go on and on and on and on. Thanks for your input though. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [GENERAL] PG Books

to the backend database. ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org/ -- Paul Lambert Technical Support Team Leader and Database Administrator AutoLedgers Level 3, 823 Wellington

Re: [GENERAL] PG Books

Guillaume Lelarge wrote: Paul Lambert a écrit : I've come across a couple of books on PG that appear interesting and was wondering if others have read them and what their thoughts are. (Excuse me if this topic has already been covered previously) Practical PostgreSQL - Command Prompt

[GENERAL] Using MS Access front-end with PG

an access program from SQL server to PG? Is there any way to change the text qualifier in PG or the case sensitivity? TIA, P. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Using MS Access front-end with PG]

Tom Lane wrote: Paul Lambert [EMAIL PROTECTED] writes: Is there any way to change the text qualifier in PG No. I suppose you could hack the Postgres lexer but you'd break pretty much absolutely everything other than your Access code. or the case sensitivity? That could be attacked

Re: [GENERAL] Using MS Access front-end with PG]

to work :) -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

Re: [GENERAL] Using MS Access front-end with PG

Paul Lambert wrote: I've got an MS Access front end reporting system that has previously used MS SQL server which I am moving to Postgres. The front end has several hundred if not thousand inbuilt/hard-coded queries, most of which aren't working for the following reasons: 1.) Access uses

Re: [GENERAL] PgSql on Vista?

Settings - Other Settings for the duration of the installation. After install completes you can turn it back on... if you want - personally I leave it off, it's an incredibly annoying feature. Note, turning UAC off and on both require reboots. P. -- Paul Lambert Database Administrator AutoLedgers

Re: [GENERAL] PgSql on Vista?

Dave Page wrote: Paul Lambert wrote: After install completes you can turn it back on... if you want - personally I leave it off, it's an incredibly annoying feature. Doesn't the security center keep popping up to point out that it's turned off? Regards Dave Ahh, but there is an option

Re: [GENERAL] pg_dumpall and version confusion

Porting it to Windows could be tricky though, given its use of symlinks and wrapper scripts. FWIW, as of Vista and Server Longhorn, Windows now supports Symlinks. I don't know about wrapper scripts though. -- Paul Lambert Database Administrator AutoLedgers ---(end

Re: [GENERAL] PgSql on Vista?

Alvaro Herrera wrote: Dave Page escribió: Paul Lambert wrote: After install completes you can turn it back on... if you want - personally I leave it off, it's an incredibly annoying feature. Doesn't the security center keep popping up to point out that it's turned off? You mean, like

Re: [GENERAL] PG periodic Error on W2K

Magnus Hagander wrote: On Thu, Mar 01, 2007 at 10:45:16AM -0500, Tom Lane wrote: Magnus Hagander [EMAIL PROTECTED] writes: On Thu, Mar 01, 2007 at 09:44:19AM +0900, Paul Lambert wrote: I am periodically getting errors pop up on the server console of the following nature: The File or directory

Re: [GENERAL] PG periodic Error on W2K

[EMAIL PROTECTED] wrote: Date: Thu, 01 Mar 2007 10:06:44 +0900 From: Paul Lambert [EMAIL PROTECTED] To: Joshua D. Drake [EMAIL PROTECTED] Cc: pgsql-general@postgresql.org Subject: Re: PG periodic Error on W2K Message-ID: [EMAIL PROTECTED] I propound to all my sincerest

[GENERAL] Thanks to all

in the future ;) Regards, Paul. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[GENERAL] PG periodic Error on W2K

al. keep on operating as though there was nothing wrong, but the errors continue to pop up sporadically on the console. Thoughts? Ideas? Suggestions? Should I bugger off? -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast

Re: [GENERAL] PG periodic Error on W2K

Joshua D. Drake wrote: Paul Lambert wrote: I'm running PG 8.2.3 on We doze 2000 Server. (Should I apologise for that up front to appease the masses?) Probably ;) I propound to all my sincerest of apologies for installing what I believe to be a marvel of human creation in Postgres on what

[GENERAL] Error upgrading on W2K

to continue fine after this point and when I check in psql I have 8.2.3 installed and the databases appear to be operational. Any thoughts on what the error might have been and if I need to check anything in particular to verify correct install? Cheers, Paul. -- Paul Lambert Database

Re: [GENERAL] Setting up functions in psql.

during the loading process. Cheers for the pointer. P. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [GENERAL] ROLE INHERIT

use whatever database privileges have been granted to all roles it is directly or indirectly a member of. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

[GENERAL] Setting up functions in psql.

that I'm having a mental blank trying to figure out... How would I execute a function (such as the above) from psql? -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [GENERAL] Setting up functions in psql.

Tom Lane wrote: Paul Lambert [EMAIL PROTECTED] writes: What I am confused about is: Why does the creation of a function fail if a table it uses does not exist when the function itself is creating the table further up to where it references it? Because the function isn't actually being

Re: [GENERAL] How to search, how to post?

)--- TIP 5: don't forget to increase your free space map settings Regards, Paul. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [GENERAL] PGSQL 8.2.3 Installation problem

with information relating to file system access from everything else on your server - and turn on advanced output) that may show you more information about what the error was from the file system point of view. -- Paul Lambert Database Administrator AutoLedgers ---(end

Re: [GENERAL] Stored Procedure examples

was told they already existed... it was hair pulling stuff there for a couple of minutes. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose

[GENERAL] Installing on weendoze vista.

into the administrator group. I'm assuming PG hasn't been certified under vista yet? If this is correct, is there any plan to do so? Has anyone tried it under server longhorn? -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast

Re: [GENERAL] Stored Procedure examples

Paul Lambert wrote: Walter Vaughan wrote: This may not help, but I noticed using pgAdminIII, you can create a procedure or a function, but they seem to have the same creation interface and use the same icon. A procedure is a function that returns null. That should have said void

Re: [GENERAL] How to create an archive for old records?

forward task of doing an INSERT INTO followed by a DELETE FROM. As for a single command... I'm not aware of any INSERT INTO AND DELETE ORIGINAL variant so it would have to be two SQL commands, albeit it uncomplicated. -- Paul Lambert Database Administrator AutoLedgers

Re: [GENERAL] PGSQL 8.2.3 Installation problem

thing I can think of anyway, if not then I am not sure why you would be having a problem. Regards, Paul. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire

[GENERAL] Footprints on Postgres

in a Weenblows environment I wouldn't mind hearing from you on your experiences. Regards, Paul. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

[GENERAL] Postgres training down under.

Are there any companies in the great land of Australia that offer Postgres training courses? I see a number listed for around the US on the postgresql.org website - just curious if anything similar goes on down under. Cheers, P. -- Paul Lambert Database Administrator AutoLedgers

Re: [GENERAL] How to allow users to log on only from my application not from pgadmin

Bruno Wolff III wrote: On Thu, Feb 01, 2007 at 10:24:51 +0900, Paul Lambert [EMAIL PROTECTED] wrote: If you hide the database username and password within your application (i.e. encrypted within the source code) so they cannot see the credentials that you connect to the database

Re: [GENERAL] How to allow users to log on only from my application not from pgadmin

embedded within your source. In this case, then perhaps a 'proxy' application running on your own server would be the best option (I think someone else suggested this earlier in the thread) for serving the database requests. -- Paul Lambert Database Administrator AutoLedgers

Re: [GENERAL] How to allow users to log on only from my application not from pgadmin

. ;) -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing

Re: [GENERAL] How to allow users to log on only from my application not from pgadmin

by any means they come by. I'm no Postgres expert, but I'm sure like any other RDBMS, postgres does not know, nor care, what application is doing the connection but rather just accepts an ODBC connection and the credentials that are passed to it. Regards, Paul. -- Paul Lambert Database

Re: [GENERAL] How to allow users to log on only from my application not from pgadmin

be a lot more than the apparent gain from having that functionality. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your

Re: [GENERAL] Any Plans for cross database queries on the same server?

. It would be a very reliable choice on which to run a high-availability database As for your young people don't know any better comment... I'm a young 25 years of age, and I know much greener pastures than Weenblows or Unix. ;) -- Paul Lambert Database Administrator AutoLedgers

[GENERAL] Load balancing across disks

know, I'm dreaming) - OpenVMS makes unixish systems look like they have the reliability of weenblows, I'll tell you that much :D) Cheers. -- Paul Lambert Database Administrator AutoLedgers ---(end of broadcast)--- TIP 4: Have you searched our list

Re: [GENERAL] [Fwd: [PORTS] M$ SQL server DTS package equivalent

Thanks all for your tips and pointers. Looking at copy I think it may do just what I need. The tables I load the data into have the same columns in the same order as those in the CSV file. Loading data in this manner is going to be a rare occurance - just when we install a new customer site

Re: [GENERAL] Installing Postegres side-by-side with M$ SQL server]]

Alban Hertroys wrote: Paul Lambert wrote: G'day folks, I'm faily new to the world of Postgre so excuse me if these questions seem ignorant. My current employer develops a software package which runs on OpenVMS on HP Alpha/Itanium servers and contains a custom database comprised

Re: [GENERAL] Installing Postegres side-by-side with M$ SQL server]]

Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/22/07 07:09, Paul Lambert wrote: Alban Hertroys wrote: Paul Lambert wrote: [snip] I'd imagine there aren't too many VMS programmers around that would be willing to port Postgres either, but if anyone

Re: [GENERAL] Installing Postegres side-by-side with M$ SQL server

Nicolas Barbier wrote: 2007/1/19, Paul Lambert [EMAIL PROTECTED]: A number of months ago I was pointed towards Postgre as a reliable database server Please don't use the word Postgre: url:http://stoned.homeunix.org/~itsme/postgre/. greetings, Nicolas My apologies, being relatively new

Re: [GENERAL] Installing Postegres side-by-side with M$ SQL server]]

Ron Johnson wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 01/22/07 14:01, Paul Lambert wrote: Ron Johnson wrote: On 01/22/07 07:09, Paul Lambert wrote: Alban Hertroys wrote: Paul Lambert wrote

[GENERAL] [Fwd: [PORTS] M$ SQL server DTS package equivalent in Postgres]

Sorry, posted this to the wrong list :( Original Message Subject: [PORTS] M$ SQL server DTS package equivalent in Postgres Date: Tue, 23 Jan 2007 10:15:06 +0900 From: Paul Lambert [EMAIL PROTECTED

[GENERAL] Installing Postegres side-by-side with M$ SQL server

- unless there is an OpenVMS port? ;) Thanks in advance for any suggestions/information. Cheers, Paul. -- Paul Lambert Database Administrator AutoLedgers