On Fri, 16 Feb 2001, Mitch wrote:
> Helpful developers doesn't go near far enough..
>
> I've seen (and still do see) commercial support that isn't up to the grade
> of support I have gotten from the -general and -hackers lists. I can ask any
> question and I *always* get a response within minute
Actually, I responded a bit too hastily. That looks like a bug in psql to
me. I see it in 7.0.3 as well. The query that psql is generating is
incorrect:
SELECT relhasindex, relkind, relchecks, reltriggers, relhasrules
FROM pg_class WHERE relname='table.column';
It should be querying pg_attrib
You have to put the actual name (attribute) of the column, not "col1"
On Fri, 16 Feb 2001 14:24, Norman J. Clarke wrote:
> Hello,
>
> I have not been able to get psql to show column comments in version
> 7.1beta4. Am I doing anything wrong, or is this a bug? A transcript of
> my psql session is b
Try \d+ test_table.
Hope that helps,
Mike Mascari
[EMAIL PROTECTED]
-Original Message-
From: Norman J. Clarke [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 8:24 PM
To: [EMAIL PROTECTED]
Subject:[GENERAL] how to see column comments?
Hello,
I have not been a
> Yah. What I find is the developers set the general tone/culture of the
list.
> This affects the type of responses/support you get even from the other
list
> subscribers. So it's quite good here where you have kind and helpful
developers.
Helpful developers doesn't go near far enough..
I've see
On Tue, 13 Feb 2001, Paul M Foster wrote:
> Let me echo this. I have _never_ been on a list where so many of the
> developers of a product were subscribed as well. And these folks
> provide _very_ considerate and clear assistance. Hats off to them.
Yah. What I find is the developers set the gener
Hello,
I have not been able to get psql to show column comments in version
7.1beta4. Am I doing anything wrong, or is this a bug? A transcript of my
psql session is below.
Norm
--
norman=# create table test_table (col1 integer);
I was asked to develop a reasonably large database application for my
company intranet. My boss comes from a heavily windows background and wanted
it all developed in MS Access etc but we're basically a UNIX house and I
knew that would cause havoc with the software developers around here (and
mys
Forgot to mention, I'm using 7.03.
Thanks,
David
On Thu, 15 Feb 2001, David Wheeler wrote:
> Hmmm... I'm trying to create an index,
>
> CREATE INDEX idx_server__host_name ON server(LOWER(host_name));
>
> But it won't create. Here's the error:
>
> ERROR: DefineIndex: function 'upper(varchar
Hmmm... I'm trying to create an index,
CREATE INDEX idx_server__host_name ON server(LOWER(host_name));
But it won't create. Here's the error:
ERROR: DefineIndex: function 'upper(varchar)' does not exist
Anyone know what's up with that? The table does have the host_name column
of type VARCHAR.
Greetings folks,
I am setting up a db for test and demo.
I need some names to populate the db.
Anybody know where I can find a list of first ( Christian ) and some
surnames on the net?
--
Sincerely etc.,
NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN45863470
EMAI
I've been looking everywhere and I can't find this:
Everytime I create a temp table (Thanx Tom) within a procedure, a table
named like pg_temp.###.# is created (I know this is MY temp table). How
can I know the name (or alias) for this table so that I can, later on,
check if it already exists.
E
Louis-David Mitterrand wrote:
>
> On Thu, Feb 15, 2001 at 03:09:16PM -, Richard Huxton wrote:
> > From: "Louis-David Mitterrand" <[EMAIL PROTECTED]>
> >
> > > Is there a way to check the last time a table was UPDATEd or INSERTEd?
> > > Is there a timestamp somewhere in the system tables?
> >
I got a message much like that on NT 4, after I upgraded to Cygwin
1.1.8. Reinstalling the Cygwin 1.1.7 package fixed the problem for me.
On Thu, Feb 15, 2001 at 07:54:30PM +0100, bcs-brockmann.de wrote:
> When I do 'postmaster -i&' I get this message:
> C:\cygwin\usr\local\pgsql\bin\postgres.ex
Have you looked at the available ODBC drivers?
On Thu, 15 Feb 2001, [iso-8859-1] Kapil Tilwani wrote:
> help
> Hi,
>
> I am a fresh graduate from India in commerce and do
> know a little about programming using VB, Java and
> Oracle... I, along with 5 more friends, have received
> a small-time
Warren Vanichuk writes:
> I'm compiling up PostgreSQL 7.0.03 on a Ultra60 running Solaris 8. It
> compiles fine, but there are some questions I have regarding the parallel
> regression tests that I performed afterwards.
>
> During the tests I get the folloing errors from the script :
>
> sequent
Greetings.
I'm compiling up PostgreSQL 7.0.03 on a Ultra60 running Solaris 8. It
compiles fine, but there are some questions I have regarding the parallel
regression tests that I performed afterwards.
During the tests I get the folloing errors from the script :
sequential test create_function
On Thu, 15 Feb 2001, Tom Lane wrote:
> Not then either; you'd need to write
>
> SELECT *
> FROM mime_type
> WHERE LOWER(name) = LOWER('text/HTML');
>
> or equivalently
>
> SELECT *
> FROM mime_type
> WHERE LOWER(name) = 'text/html';
>
> which is what will result from constant-fold
I installed PostgeSQL on Windows 2000 like KevinLo disscipted in his
installation procedure.
The installation finished with no error.
When I do 'postmaster -i&' I get this message:
C:\cygwin\usr\local\pgsql\bin\postgres.exe: ***
recreate_mmaps_after_fork_failed
Startup failed - abort
NOTICE: IpcMe
Hunter Hillegas writes:
> I have an HTML form that submits to Postgre 7.1 beta 4 and I'm wondering how
> to get the current year from the database...
select extract(year from current_date);
> Also, is there a good reference to the PostgreSQL function library? I've
> looked around and can't seem
James Thompson writes:
> About a lifetime ago I used to do quite a bit of work w/ Oracle.
>
> It's command line sql tool had some pretty nice features that I haven't
> been able to find in psql. I was wondering if any of the following
> existed
>
> I think the first was called break on which
I have an HTML form that submits to Postgre 7.1 beta 4 and I'm wondering how
to get the current year from the database...
Basically they are entering dates but all I want them to have to enter is
the month and the day of the month and then get the current year from the DB
and programmatically fus
A little while ago there was a question about how to automatically update a
timestamp so I drafted the attached code.
NOTE - you need 7.1beta to use the attached code and plpgsql enabled on your
db.
I'm interested in any comments on the attached before I submit it for
possible inclusion in contr
The first row is the oid number. See developper doc
for more info
Regards,
PEJAC pascal
> Hi !
>
> Does anyone knows what means, after an INSERT for exemple the message :
>
> INSERT 19331808 1
>
> What the meaning of the two numbers ?
>
> I had a problem with a DB because I reached the max transaction ID.
>
> So, how could i know what is the maximum ? and what is the current
> transa
From: "Jean-Arthur Silve" <[EMAIL PROTECTED]>
> Does anyone knows what means, after an INSERT for exemple the message :
>
> INSERT 19331808 1
>
> What the meaning of the two numbers ?
Sorry - don't know what the first number is - I'm getting 0 here on testing.
The second is the number of rows in
Hi,
I have the following situation
Machine - A equiped with
- a database
- Internet application that receives records and stores them into a
table on this machine
Machine - B equiped with
- the same database
- the same internet application but it only receives records when
m
Title: RE: [GENERAL] postgres length limitation query
If you're talking about the length of the query string, it should be limited only by the memory available to the processes that handle it. If they run out of memory, it all goes pop! and then releases the used memory, and should carry on w
> "Mark Alliban" <[EMAIL PROTECTED]> writes:
> > pq_recvbuf: unexpected EOF on client connection
> > Server process (pid 2087) exited with status 139 at Tue Feb 13 15:38:08
2001
> > Terminating any active server processes...
> > Server processes were terminated at Tue Feb 13 15:38:08 2001
> > Rein
Hi !
Does anyone knows what means, after an INSERT for exemple the message :
INSERT 19331808 1
What the meaning of the two numbers ?
I had a problem with a DB because I reached the max transaction ID.
So, how could i know what is the maximum ? and what is the current
transaction ID ?
Is it t
Hello,
we have got a problem when executing some queries of tpch benchmark on
PostgreSQL.
For instance, the postgres parser do not accept the syntax of the query
number 9:
select nation2 , o_year, sum(amount) as sum_profit
from
(
select
n_name a
Robert Dege wrote:
>
> I am attempting to upgrade to 7.0.3 -- hence the dumpall command.
>
> There was a zero size file in template1 that was causing the problem.
> Thanks for the help.
>
> <>
Not too bad to ask anyway. We have seen people assuming
pg_log is some kind of unimpor
Hello,
is there any limit in the length of a query?
What postgres does if I give it a query that is bigger?
Thanks.
33 matches
Mail list logo
