Do you do a lot of updates and/or deletes? If so, you need to VACUUM your
database. When rows are modified, they are not actually deleted. They are
just flagged to be ignored.
Vacuum cleans up the rows.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.
hi,
I have been a postgres user for serveral months. But recently I find a "mysterious"
things
in my /usr/local/pgsql/data/base/The_Database_Name/The_table_name.
In a particular table name "fred" there are only 50 rows and 13 columns. The column
types are int,
float, varchar, where
varchar's s
Can someone help me understay array usage in postgresql? After reading
the user manual (ch8), I tried to create a 2-d array of float8s...
and yet the database seems broken: when I ask for a row back I get
nothing!
Or, if I ask for a row another way, I get two rows! Please help!
Jason
p.s. how
>
Hi,
I reduced my trigger to do following :
(Trigger gets invoked for Table1 in Db1)
1. conn=PQconnectdb ( db2 )
2. PQexec(conn,"begin") <--- FAILS
3. PQfinish(conn)
I get failure in step (2) with following message in 'postmaster.log'
ERROR: begin
pq_recvbuf: une
I'm having problems getting a simple PL/pgSQL trigger to work. I suspect
that something may not be set up correctly, but I have no idea what.
Specifically, I'm trying to get the example working in the 'PL/pgSQL Trigger
Procedure' section of the documentation (located at:
http://www.postgresql.org/
How can i get a schema of my database???
(structures of tables, indexes, triggers, rules, etc, etc ..)
Thanks!
Gerardo Tagliani
Linux Registred User #139437
---
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.
Mine _arrived_ last Thurday from Barnes and Noble. No notice about
shipping though!
Rod
--
On Sun, 17 Dec 2000, Brett W. McCoy wrote:
[snip]
> Greetings from Amazon.com.
>
> We thought you'd like to know that we shipped your items today,
> and that this completes your order.
>
> ...
>
> T
On Mon, 18 Dec 2000, Brian C. Doyle wrote:
> Okay now I am an Idoit. How do I tell what is used for the carriage
> return? I know how to make the replacement I just can not tell they
> characters used.
Are you on Windows, Unix or Mac?
-- Brett
http://www.c
Okay now I am an Idoit. How do I tell what is used for the carriage
return? I know how to make the replacement I just can not tell they
characters used.
At 11:52 AM 12/18/00 -0500, Brett W. McCoy wrote:
>On Mon, 18 Dec 2000, Brian C. Doyle wrote:
>
> > I have a file that I am trying to impo
On Mon, 18 Dec 2000, Brian C. Doyle wrote:
> I have a file that I am trying to import/copy into a table. The problem
> that I am having is that there are carriage returns through out the
> document. These carriage returns should be copied into the column it
> belongs to yet during the
> copy ta
Can JDBC ResultSets be returned from user defined functions with
postgreSQL?
Is there more documentation for functions then is available on
www.postgresql.org?
Thanks,
Joel
Hello all,
I have a file that I am trying to import/copy into a table. The problem
that I am having is that there are carriage returns through out the
document. These carriage returns should be copied into the column it
belongs to yet during the
copy table from '/home/location/file.ext' usin
El Lun 18 Dic 2000 12:43, Wade D. Oberpriller escribió:
> You should be able to do the following:
>
> CREATE TABLE table1 (
> field1 INTEGER CHECK ((field1 >= 0) AND (field1 <= 10))
> );
Thanks!!! Didn't know that!
--
System Administration: It's a dirty job,
but someone told I had to do i
You should be able to do the following:
CREATE TABLE table1 (
field1 INTEGER CHECK ((field1 >= 0) AND (field1 <= 10))
);
Wade Oberpriller
>
> Hi,
> how should I write a constraint that can keep an INT field with values
> between 0 and 10? Do I have to use two checks on the same field?
>
Hi,
how should I write a constraint that can keep an INT field with values
between 0 and 10? Do I have to use two checks on the same field?
TIA
--
System Administration: It's a dirty job,
but someone told I had to do it.
Rolf Johansson <[EMAIL PROTECTED]> writes:
> When I do a SELECT xx FROM xx WHERE xx >= 'Å' in psql, it returns lines where
> xx is starting with "A". With "Ö", it returns lines where xx starts with "O".
> I've tried to set LC_ALL to sv_SE or swedish, nothing happens.
Don't forget that the contro
"Johann Woeckinger" <[EMAIL PROTECTED]> writes:
> But when using a Tcl-based interface (e.g. pgaccess or home made tcl
> based programs) to insert such characters into a table, they are not correct
> displayed on queries by use of psql - they appear as two 'unreadable'
> characters (they appear
The User's Guide covers the "CREATE SEQUENCE" statement quite well.
gerardo tagliani wrote:
> Where can i get help, or some tutoral that talks about the
> "sequence" (create sequence) statment.
> thanks!
>
> Gerardo
>
> Gerardo Tagliani
>
> Linux Registred User #139437
>
Where can i get help, or some tutoral that talks about the
"sequence" (create sequence) statment.
thanks!
Gerardo
Gerardo Tagliani
Linux Registred User #139437
---
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.ema
I'm running PostgreSQL 7.0.3 on RedHat 7.0 eng.
In the database I have several lines of data beginning with "Å", "Ä" or "Ö"
(swedish special characters).
When I do a SELECT xx FROM xx WHERE xx >= 'Å' in psql, it returns lines where
xx is starting with "A". With "Ö", it returns lines where xx star
I use PostgreSQL 7.0.3 on Linux (i386) platform, Tcl 8.3 is installed.
When entering National special characters (e.g. accented german
characters) by use of psql into a database, all seems to be ok., the special
characters appear correct on queries (locale seems to work well in this case).
But
21 matches
Mail list logo
