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
http://www.postgres
won't get to work with PG anymore and thus
won't 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 & R
server 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 - A Reynolds & Reynolds Company
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
ettings
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 y
;%p" E:\PostgreSQL\WAL_Archive\%f
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
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 Adm
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, bu
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
symlink
f to E drive.
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.
--
Paul Lambert
Database Administrator
AutoLedgers - A Reynolds & Reynolds Company
-
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
xt not null ,
des text ,
user_id text null,
access_reports_processed text
) WITHOUT OIDS TABLESPACE ts_autodrs_main
;
Cheers,
P.
--
Paul Lambert
Database Administrator
AutoLedgers - A Reynolds & Reynolds Company
---(end of broadcast)-
don't show up... 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,
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 definin
OP;
RETURN start_date;
END;
$$ LANGUAGE PLPGSQL STABLE;
Since it's my first function in PL/pgSQL I've probably missed something
pretty obvious - 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
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
g the offset 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
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&qu
ce, line 1, column 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
---
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&#
quick way of
doing 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
---
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
whilst 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
rd disk?
Enable 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
itially through pgAdminIII and
it appears I selected 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.
--
Pa
) values ('abc''test');
It works fine.
But that's beside the point - my question is should I convert everything
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
Au
unts.
Once the install 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 ind
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 co
I
start 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
HbMQG+6IeiSZqQCfRMst
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 y
/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 an
/continuous-archiving.html
--
Paul Lambert
Database Administrator
AutoLedgers
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
g Windows...:(
any idea if/where this could be set in MS-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
load.
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
c
I:
1) Drop Indexes
2) Truncate 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
Da
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
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 P
nterface 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,
ne email asking 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?
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.) A
is not... so I'll get 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
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
t;)
Has anyone had any experience with moving 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
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
tur
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
--
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
> Security 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
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 F
to advise me 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
[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: <[EMAI
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
ns et 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 broa
he install seemed 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 Lamber
t
often) and will be done whilst database access is removed so performance
is not a problem 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
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 act
able before creating
the function, I'm just curious as to why it should fail)
Secondly, and here's the obviously easy one 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
rty.
"A role with the INHERIT attribute can automatically 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
fairly straight 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
Data
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 of
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
hem again I 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
you will be flooded 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
-
broadcast)---
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?
stgres' user that PG runs under may not have
access to those dirs.
Only 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)---
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
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?
customers, the easiest way for me to secure your
data is to unplug the network cable on the server. ;)
--
Paul Lambert
Database Administrator
AutoLedgers
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
passwords 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 Admin
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 databas
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
abase 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 L
other story. 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 Ad
to OpenVMS ;) and then use it on that (I 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)---
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 an
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 PROTEC
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
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:
http://stoned.homeunix.org/~itsme/postgre/>.
greetings,
Nicolas
My apologies, being rel
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
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 co
weenbloze - unless there is an OpenVMS port? ;)
Thanks in advance for any suggestions/information.
Cheers,
Paul.
--
Paul Lambert
Database Administrator
AutoLedgers
79 matches
Mail list logo
