| |
thread by: Prabu Subroto |
last post Nov 23 '05 by: Oliver Elphick
Dear my friends...
I want to change the datatype of a completed table
(has had already content).
But I don't know how.
Here is my try:
"
kv=# alter table customer alter column address set
type char(150);
ERROR: syntax error at or near "type" at character 47
|
thread by: Mark Cave-Ayland |
last post Nov 23 '05 by: Tom Lane
Hi everyone,
I'm trying to write a recursive plpgsql function in PostgreSQL 7.4.2
that given a tree node id (ictid) will return all the nodes below it in
the tree, one row per node. When I try and execute the function I get
the following error message:
CONTEXT: PL/pgSQL function "findsubcategories" line 15 at for over
select rows...
|
thread by: Jay |
last post Nov 23 '05 by: Oliver Elphick
hi people,
i am using mysql and i am having the following problem....
I know this is not the correct to ask this problem. but i am need of
help urgently thats why i posted this here.
but please help
i have a table with the following fields .when i try to enter data i get
the following error.any help would b
|
thread by: N. David |
last post Nov 23 '05 by: N. David
Hello. I have created a new group in the Google Groups beta site for
PHP + PostgreSQL development.
This group is for questions on advanced web development with PHP and
PostgreSQL using Linux. Topics include functions, regular expressions,
classes (OOP), speed, security, editor customization, SQL, and
software installation/maintenance.
...
|
thread by: Gunasekaran Balakrishnan |
last post Nov 23 '05 by: Bruce Momjian
Hi,
I am seeing a different sorting behaviour for varchar columns in
Postgres 7.4.2.
postgres 7.4.2 is ignoring case for varchar columns for "ORDER BY"
commands where as 7.2.2 is not.
I am in a situation where I need to do diff from the select outputs of
two databases - one in 7.2.2 and one in 7.4.2.
|
thread by: Ulrich Wisser |
last post Nov 23 '05 by: Ulrich Wisser
Hello,
my web application grows slower and slower over time. After some
profiling I came to the conclusion that my SQL queries are the biggest
time spenders (25 seconds). Obviously I need to optimise my queries and
maybe introduce some new indexes.
The problem is, that my application uses dynamic queries. I therefor can
not determine...
|
thread by: CSN |
last post Nov 23 '05 by: Bernd Helmle
Just wondering, is updateable views slated for a
future version of Postgresql? In addition to using
rules that is.
CSN
__________________________________
Do you Yahoo!?
|
| |
thread by: A Palmblad |
last post Nov 23 '05 by: Martijn van Oosterhout
Today, queries to one of our tables started giving the following error:
ERROR: root page xxxx of "primary_index_name" has level 0, expected 3.
What would cause that? We did have a earlier today, methinks they are probably related. It's a big table, in the neighbourhood of 45 million rows.
How can I fix the problem?
-Adam Palmblad
|
thread by: Kaarel |
last post Nov 23 '05 by: Robert Treat
Would PostgreSQL be a good enough choise for GnuCash (or Quickbooks or
the likes) type of program?
What could be the potential drawbacks of using PostgreSQL (perhaps its
big size)?
What would be a better database for that kind of job?
Kaarel
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will...
|
thread by: Kevin Bartz |
last post Nov 23 '05 by: Tom Lane
I'm de-duping a 45-million-row table (about 4 gigs) by creating a new table
with the unique rows of the first table (should be about 3 gigs). I'm on a
64-bit SuSE Linux with 2 gigs of memory and another gig of swap space. I
tracked postmaster's use of memory and swap space after I run the query, and
I noticed that as soon as postmaster first...
|
thread by: Hubert Fröhlich |
last post Nov 23 '05 by: Devrim GUNDUZ
Hi list,
when doing a large Insert I get in the logfile:
2004-08-03 07:23:46 LOG: recycled transaction log file "000001BA000000BD"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C2"
2004-08-03 07:34:00 LOG: recycled transaction log file "000001BA000000C3"
2004-08-03 07:34:00 LOG: recycled transaction log file...
|
thread by: yoursoft |
last post Nov 23 '05 by: yoursoft
Dear List!
I'm new on this list, and in PostgreSql too.
I have the following problem:
I would like to lock out users after the 5th failed login (incorrect
password).
I can't found any information from it in PostgreSql docs.
Can you help me, how to make it?
|
thread by: Prabu Subroto |
last post Nov 23 '05 by: Holger Klawitter
Dear my friends...
I want to drop a rule but I get an error message.
Could you tell me my I can not drop (delete) the rule?
Thank you very much in advance.
ps: Here is my try underbelow:
postgres@patrix:~> psql kv
|
thread by: Gellert, Andre |
last post Nov 23 '05 by: Gellert, Andre
Hello,
yesterday I ran into problems installing my first PostgreSQL on Solaris.
My main problems consisted on missing packages, because the test system I
had to use was a very small installation.
After spending hours on installing gcc+friends, we decided to install a new
full solaris on the hardware.
My question to avoid installation : Are...
|
thread by: Grant |
last post Nov 23 '05 by: Joshua D. Drake
I'm trying to set up the Interchange 5.2 shopping cart
(icdevgroup.org) to use the CREATE SEQUENCE
functionality of pgsql properly and I'm having some
trouble. The table is called order_items and the
field that should sequence is called autonumber. The
Interchange DB config file looks like this for my
order_items table:
Database...
|
| |
thread by: Steve Crawford |
last post Nov 23 '05 by: Matthew T. O'Connor
I've been running pg_autovacuum for a week or so, now and while I like
it I'm having trouble trusting it.
I have several small (~0-50 record) working tables that have high
insert/update/delete activity. When I first set up pg_autovacuum they
were being vacuumed every ~1-4 hours during the day and less often at
night. Most of the time the...
|
thread by: Prabu Subroto |
last post Nov 23 '05 by: Prabu Subroto
Dear my friends...
I am developing a database application with postgres
7.2.x, qt on SuSE 9.1 . I am in a situation where I
have to use QDataTable and I have to use QSqlCursor
that support only 1 table manipulation ( QSqlCursor *
cursor = QSqlCursor("viewpatrix", true, db); ).
So, as a strategy I make a view. with this view I hope
I can...
|
thread by: Janning Vygen |
last post Nov 23 '05 by: Janning Vygen
Hi,
i searched the docs and the archives and was really wondering that i have not
found anything searching for "functional index primary key".
i would like to have a table of members with nicknames which are
case-insensitive but i would like to save the user given name case-sensitive
to display 'JimKnopf' instead of 'jimknopf':
CREATE...
|
thread by: David Garamond |
last post Nov 23 '05 by: Scott Marlowe
When I distribute a binary-only distribution of Postgre to a client, can
I exclude some parts of Postgres (to make it smaller), e.g.
documentation (all of doc/), some PL's, or even psql, initdb, pg_dump,
etc.?
--
dave
|
thread by: Prabu Subroto |
last post Nov 23 '05 by: Michal Taborsky
Dear my friends...
My boss requested that my application is equipped with
emoicon (smiley) in the sales report. That's why I
need to know, is it possible to save a small image
into the postgres? with which data type should I
define the column (field)?
I have a currently table, salesreport. Its fields are
: noapp (appointment number,...
|
thread by: Secrétariat |
last post Nov 23 '05 by: Bill Moran
Hello !
My ODBC driver in MS Visual Basic 6 refers also to "Stored procedures" as Record source.
What are these stored procedures, I don't find anything in the 7.4 documentation,
Where can I find documentation ?
Many thanks.
Luc
|
thread by: Markus Bertheau |
last post Nov 23 '05 by: Markus Bertheau
В Пнд, 02.08.2004, в 14:49, Federico Di Gregorio пишет:
> On lun, 2004-08-02 at 14:30 +0200, Markus Bertheau wrote:
> > Hi,
> >
> > I wonder if there is some kind of support for PostgreSQL's arrays in
> > psycopg? The fetch routines return the literal array syntax of
> > PostgreSQL. I'd want the fetch routines to return a list for...
|
thread by: Si Chen |
last post Nov 23 '05 by: Secrétariat
Hello.
It seems that every time I make a change to pg_hba.conf, I have to
restart the database server for the new authentication to take effect.
Is there a way to have the server use the new pg_hba.conf authentication
without restarting the production server.
Thanks,
Si
|
| |
thread by: Jonathan Scott |
last post Nov 23 '05 by: Jonathan Scott
All,
I am looking for documentation on the pg_proc.proacl column. I am working on a schemadiff and when I expect the acl to be the same, they come out slightly different. I searched the PG 7.4 doc site, and didn't find anything except the one liner on the pg_proc description page.
Any kind of documentation, other than the code itself, would...
|
thread by: Janning Vygen |
last post Nov 23 '05 by: Grant McLean
Hi,
EXPLAIN on delete stamements works, but doesn't show me all the subsequent
deletes or checks which has to be done because of foreign keys
cascading/restricting.
Is there a solution to show up which tables are checked and which scans the
planner is going to use to check these related tables?
kind regards,
|