*guess i'm not used to seeing such thoughtful responses*
please keep us all apprised on how your implementation progresses!
Martin
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerkung / Note de
déni et de confidentialité
This mes
Thank you gentlemen. I believe I am now enlightened.
1. The maximum number of rows per table is not limited by an algorithm at
CREATE/ALTER TABLE other than to enforce an absolute maximum number of
columns of 1600.
2. The ability to store any individual row depends on its content.
I hasten t
Sam Mason writes:
> Just out of interest; what would happen if you had:
> CREATE TABLE wider (
> col0001 TEXT,
> col0002 TEXT,
> -- [ ]
> col9998 TEXT,
> col TEXT
> );
> CREATE TABLE store (
> pk1 INTEGER,
> pk2 TEXT,
> PRIMARY KEY (pk1,pk2),
>
On Sat, Apr 11, 2009 at 05:43:06PM -0400, Tom Lane wrote:
> In principle, every varchar column could get toasted into an 18-byte
> (more in pre-8.3 versions) TOAST pointer, meaning you could get to
> somewhere around 450 columns in 8K regardless of how wide they are.
Wow, never realised it was tha
Thanks Sam, that's excellent advice.
If a developer doesn't jump in with a definitive formula, that is the path I
will take.
Regards
Gerry
- Original Message -
From: "Sam Mason"
To:
Sent: Sunday, April 12, 2009 7:23 AM
Subject: Re: [GENERAL] Maximum number of columns in a table
Sam Mason writes:
> On Sun, Apr 12, 2009 at 05:33:35AM +1000, Gerry Scales wrote:
>> I have a situation where I need to load tables from another database
>> which may theoretically contain up to 1000 columns per table and this
>> information will determine whether I need to rebuild PostgreSQL with
On Sun, Apr 12, 2009 at 05:33:35AM +1000, Gerry Scales wrote:
> The FAQs state "Maximum number of columns in a table? 250-1600
> depending on column types".
>
> Is there a location which gives instructions for calculating whether a
> number of columns of different types can be accommodated?
>
> I
varlena columns can
be supported in a table with a standard 8K blocksize?
Gerry
__ Information from ESET NOD32 Antivirus, version of virus signature
database 4001 (20090411) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
information will
determine whether I need to rebuild PostgreSQL with a larger blocksize.
Splitting into multiple tables is not always an easy option.
Many thanks
Gerry
__ Information from ESET NOD32 Antivirus, version of virus signature
database 4001 (20090411) __
The messa
Antivirus, version of virus signature
database 4001 (20090411) __
The message was checked by ESET NOD32 Antivirus.
http://www.eset.com
Sam Mason writes:
> As others have said; the design of PG is such that it's built to assume
> you're always connected to exactly one database. I'd guess this is an
> artifact from a long time ago when PG didn't have multiple databases.
It's possible that that was true way back in Berkeley prehis
On Apr 11, 2009, at 1:49 PM, Sam Mason wrote:
As others have said; the design of PG is such that it's built to
assume
you're always connected to exactly one database. I'd guess this is an
artifact from a long time ago when PG didn't have multiple databases.
--
Sam http://samason.me.uk/
On Sat, Apr 11, 2009 at 01:15:44PM -0400, li...@mgreg.com wrote:
>
> On Apr 11, 2009, at 12:56 PM, Tom Lane wrote:
> >
> >There is no such edge case. DROP DATABASE has to be issued while
> >connected to some database, and it won't let you drop the DB you're
> >connected to.
> >
> >And CREATE DATA
On Apr 11, 2009, at 10:15 AM, li...@mgreg.com wrote:
So, how does needing to connect to a database before querying about
existing databases make any sense?
Well, you have to connect to the database server, no matter what, in
order to check on the existence of a database (unless you are doin
On Saturday 11 April 2009 10:15:44 am li...@mgreg.com wrote:
> On Apr 11, 2009, at 12:56 PM, Tom Lane wrote:
> > There is no such edge case. DROP DATABASE has to be issued while
> > connected to some database, and it won't let you drop the DB you're
> > connected to.
> >
> > And CREATE DATABASE ha
On Apr 11, 2009, at 12:56 PM, Tom Lane wrote:
There is no such edge case. DROP DATABASE has to be issued while
connected to some database, and it won't let you drop the DB you're
connected to.
And CREATE DATABASE has to be issued while connected to some database,
so createdb still has to have
[ forgot to respond to this bit... ]
"li...@mgreg.com" writes:
> What if you hit that edge case where there are in fact no databases?
There is no such edge case. DROP DATABASE has to be issued while
connected to some database, and it won't let you drop the DB you're
connected to.
> I suppose y
li...@mgreg.com wrote:
I'm sorry, I'm confused by your reply. I may have said "table" when I
meant "database". I believe it absolutely *does* make sense to
connect without specifying a database first. What if you hit that
edge case where there are in fact no databases? I suppose you could
"li...@mgreg.com" writes:
> What do you mean when you say the "catalogs...are database-
> specific" ? If I'm understanding what you're saying, my whole point
> is that I don't want to be tied to a database to do any kind of
> querying about the PG engine itself. Does that make sense?
No, i
On Saturday 11 April 2009 9:10:33 am li...@mgreg.com wrote:
> On Apr 11, 2009, at 11:56 AM, Tom Lane wrote:
> > There are, although we don't spell the commands like that. This is
> > not
> > relevant to the question of whether it makes sense to connect without
> > being connected to a specific dat
On Apr 11, 2009, at 11:56 AM, Tom Lane wrote:
There are, although we don't spell the commands like that. This is
not
relevant to the question of whether it makes sense to connect without
being connected to a specific database. It doesn't, because the
catalogs that you have to inspect to fi
On Apr 11, 2009, at 10:49 AM, li...@mgreg.com wrote:
On Apr 11, 2009, at 11:39 AM, Raymond O'Donnell wrote:
The answer is still "no". :-)
The usual thing it to connect to the "postgres" database (or to
"template1" in older versions of PG), and then you can issue
queries to
see what's the
On Sat, Apr 11, 2009 at 11:49:25AM -0400, li...@mgreg.com wrote:
> I was
> hoping there were some higher level management items like "show
> databases", and "show tables", etc in Postgres as well.
The standard way would be to use the "information_schema", it's in the
SQL standard and supported
"li...@mgreg.com" writes:
> Hrm...Ok, well, for the record, I'm moving some systems from MySQL to
> Postgres and am in the process of getting familiar with it. I was
> hoping there were some higher level management items like "show
> databases", and "show tables", etc in Postgres as well.
On Apr 11, 2009, at 11:39 AM, Raymond O'Donnell wrote:
The answer is still "no". :-)
The usual thing it to connect to the "postgres" database (or to
"template1" in older versions of PG), and then you can issue queries
to
see what's there. You're pretty much guaranteed that one of those
data
On 11/04/2009 16:30, li...@mgreg.com wrote:
> Quick question: Does PGSQL provide a mechanism by which to connect to
> the server without specifying a database? I saw a thread back in 2005
> that said "no"
> (http://archives.postgresql.org//pgsql-interfaces/2005-02/msg00031.php),
> but I was curi
On Sat, Apr 11, 2009 at 11:30:00AM -0400, li...@mgreg.com wrote:
> Quick question: Does PGSQL provide a mechanism by which to connect to
> the server without specifying a database? I saw a thread back in 2005
> that said "no"
> (http://archives.postgresql.org//pgsql-interfaces/2005-02/msg000
Hi All,
Quick question: Does PGSQL provide a mechanism by which to connect to
the server without specifying a database? I saw a thread back in 2005
that said "no" (http://archives.postgresql.org//pgsql-interfaces/2005-02/msg00031.php
), but I was curious as to whether that's changed. Basi
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thank you Sam for the valuable input!
Best regards,
Pedro Doria Meunier
GSM: +351 96 17 20 188
Skype: pdoriam
Sam Mason wrote:
> On Sat, Apr 11, 2009 at 02:47:53AM +0100, Pedro Doria Meunier wrote:
>> Actually what I have is a fully internationa
On Sat, Apr 11, 2009 at 02:47:53AM +0100, Pedro Doria Meunier wrote:
> Actually what I have is a fully internationalized site by means of
> getttext.
> *Some* of the content comes from the PGSQL database where 2 tables
> relation with others (namely for sensor data description).
Why not continue u
On 2009-04-09, Eric Smith wrote:
> All,
>
> From the C API, how do I check for the existence of a column name in
> a given table?
you can look at the information schema, column-names in a result-set,
or error messages. which is most apropriate depends on the context.
--
Sent via pgsql-gen
On 2009-04-06, SHARMILA JOTHIRAJAH wrote:
> Hi,
> I use this Oracle function(from AskTom -
> http://asktom.oracle.com/pls/asktom/f?p=100:11:0P11_QUESTION_ID:210612357425)
>
> ops$tk...@dev8i> create or replace
> function in_list( p_string in varchar2 ) return myTableType
> How ca
On 2009-04-05, Johan Nel wrote:
> Jennifer,
>
> Jennifer Trey wrote:
>> Hi, I am trying to create my DB schema on the server through my
>> development laptop.
>>
>> I have installed Web Server 2008 and PostgreSQL. They are both running.
>> For some reason its not working. Do I need to open som
33 matches
Mail list logo
