On Nov 27, 2007, at 8:36 PM, Gregory Stark wrote:
I think (but I'm not sure) that the kernel in OSX comes from BSD.
Kind of. Mach is still running underneath (and a lot of the app APIs
use it directly) but there is a BSD 'personality' above it which
(AIUI) is big parts of FreeBSD ported
Johan Vromans [EMAIL PROTECTED] writes:
Doug McNaught [EMAIL PROTECTED] writes:
Yeah, LISTEN/NOTIFY is definitely a lighter-weight solution--I didn't
think of that before.
LISTEN/NOTIFY looks like a synchronisation mechanism. You can notify a
subscriber that something happened. But in my
Johan Vromans [EMAIL PROTECTED] writes:
Greetings,
For a big application, I want to generate reports from the database and
keep these on-line as long as they reflect the actual contents of the
database. I only want to regenerate the reports when needed, i.e.,
when the database contents have
Johan Vromans [EMAIL PROTECTED] writes:
Doug McNaught [EMAIL PROTECTED] writes:
I would put an AFTER trigger on all the tables concerned that
inserts a row into an audit table. [...] Audit tables are useful for
other things too, if you can afford them.
I think auditing is much too heavy
Philippe Ferreira [EMAIL PROTECTED] writes:
Yeah, LISTEN/NOTIFY is definitely a lighter-weight solution--I didn't
think of that before.
Hi,
I'm interested too in using this method !
Can anyone give a simple example of how to use/implement it ?
Or good links to clear/quick documentation
Bruno Wolff III [EMAIL PROTECTED] writes:
On Tue, Feb 07, 2006 at 15:28:31 +0300,
Nikolay Samokhvalov [EMAIL PROTECTED] wrote:
The real situation would be as the following.
I want to use some algorithm to hide real number of registered users
in my table user. So, I don't want to use simple
James Harper [EMAIL PROTECTED] writes:
Is there an API method to be able to execute pl/pgsql (or any other
language) code directly from C?
Eg (please excuse the line wrapping, and the fact that this doesn't
represent a case where this would actually be useful!)
result = PQexecPL(plpgsql,
Richard Sydney-Smith [EMAIL PROTECTED] writes:
pch := pchar('pg_dump -C -h '+host+' -U '+usr+' -p '+pswd+ ' -f
'+bckup_path+' '+dbase);
to postgres.
as the operator is obviously logged in how do I
(1) trap their user id
(2) Send the call to pg_dump without knowing their password?
Myatluk Andrey [EMAIL PROTECTED] writes:
Hi, Chris!
I've set the sequence owner to my database user. It hasn't changed
anything.
I guess I have to connect through psql as user and then see what
happens.
If it fails, what could be my next step?
That would depend on the error message you
Alexander Farber [EMAIL PROTECTED] writes:
Hello,
I've created a user and a database both wrongly named phpbb.
After that I have renamed both to punbb using ALTER DATABASE
and ALTER USER. Now everything works fine, except I always
have to specify the database when connecting (both using
Alexander Farber [EMAIL PROTECTED] writes:
but I do specify the database username:
h754814:afarber {109} psql --help | grep -w user
-U NAME database user name (default: phpbb)
h754814:afarber {110} psql -U punbb
psql: FATAL: database phpbb does not exist
And it
Devrim GUNDUZ [EMAIL PROTECTED] writes:
http://pgfoundry.org/projects/pgnixinstaller/
We are actively looking for developers for the project. Please drop me
an e-mail if you want to join this project. We will use Python, so you
need to be a Python guy to join the project. We are in planning
Devrim GUNDUZ [EMAIL PROTECTED] writes:
On Mon, 2006-01-30 at 20:03 -0500, Doug McNaught wrote:
What value does this bring to systems that have a good package system
and up-to-date repositories? I can install Postgres today on Ubuntu
using a GUI tool, and install another GUI tool
Marc G. Fournier [EMAIL PROTECTED] writes:
On Tue, 31 Jan 2006, Devrim GUNDUZ wrote:
On my RHEL boxes, I do never ever recompile the kernel since Red Hat
does not provide support if I do so :)
Is everything 'loadable modules' then? I can't imagine you have some
mammoth kernel running on
Rich Shepard [EMAIL PROTECTED] writes:
When installing the application I specified the database name as 'contacts'
(not very innovative or clever, but descriptive). When I open the database
with 'psql contacts' and ask to have the tables dumped (with \d), they go
streaming by on the
Rich Shepard [EMAIL PROTECTED] writes:
On Sat, 28 Jan 2006, Eric B. Ridge wrote:
Again, you can't use redirection via the psql prompt. But you can do it
via your shell command line:
$ psql -c \dt xrms.tables
Well, that doesn't seem to be working here, either:
[EMAIL PROTECTED] ~]$
A. Kretschmer [EMAIL PROTECTED] writes:
am 27.01.2006, um 14:21:31 + mailte Matthew Henderson folgendes:
Okay, so if I have 7.4 installed and I have the old
harddisk mount under /mnt/hda can I do something
like
pg_dump /mnt/hda/path_to_old_database dump.txt
No, this is imposible
Oliver Fürst [EMAIL PROTECTED] writes:
Hi all,
I have a question regarding rules on views. Are the commands inside a
ON INSERT (or UPDATE) DO INSTEAD (implicit) transactions for postgres?
I tried to put BEGIN; and COMMIT; around the commands in a ON ... DO
INSTEAD ( ) block, but keep
Oliver Fürst [EMAIL PROTECTED] writes:
Basically I'm worried that the whole relying on the last value of a
sequence isn't such a great idea.
'currval()' is specifically written to Do The Right Thing. See the
docs.
-Doug
---(end of
Oliver Fürst [EMAIL PROTECTED] writes:
But is nowhere stated if (multiple) commands inside a rule are treated
as an implicit transaction as a whole.
If you don't specifically open a transaction at the top level (i.e. in
'psql' or SQL from your application's code), PG will encapsulate every
Rich Shepard [EMAIL PROTECTED] writes:
So, now I can see the tables in the various databases, but SQL-Ledger still
cannot:
Internal Server Error
The server encountered an internal error or misconfiguration and was unable
to complete your request.
How do I get this fixed, please?
Rich Shepard [EMAIL PROTECTED] writes:
On Thu, 26 Jan 2006, Joshua D. Drake wrote:
Although I am glad you were able to get up and running, typically you don't
want to move libs like that. Instead update your /etc/ld.so.conf and run
ldconfig.
True, Josh. What I'd prefer to do is remove
Patrick Hatcher [EMAIL PROTECTED] writes:
Attempting to do my first trigger and I'm confused about which FOR EACH I
should use: ROW or STATEMENT. I import about 80K rows into an existing
table each day. If I do a STATEMENT, will the changes only happen on the
new 80K rows I inserted or will
Patrick Hatcher [EMAIL PROTECTED] writes:
Here is the trigger the way it is currently written. I add some additional
information from another table:
If you're modifying each row before it goes in, it should definitely
be a FOR EACH ROW trigger.
-Doug
---(end of
Benjamin Smith [EMAIL PROTECTED] writes:
in /var/log/messages, I see
Jan 24 17:00:04 kepler kernel: postmaster[26185]: segfault at
2516d728
rip 0043c82c rsp 007fbfffddd0 error 4
The insert statement is long, but doesn't seem to violate anything strange -
no weird
Zlatko Matić [EMAIL PROTECTED] writes:
So, it seems that numeric without parameters (precision, scale) behave
similar to float, but is much exact. Am I right or I missunderstood?
Right. It's also considerably slower, since floating point
calculations can use the hardware. Unless you're doing
Brian Dimeler [EMAIL PROTECTED] writes:
I'm trying to transition a database from one server to another, the
old one running Postgres 7.4.1 and the new, 8.1.1. When I try to
restore using a pg_dump plaintext sql file from a nightly backup via
the usual
psql thedb backup.sql
The best way to
David Blewett [EMAIL PROTECTED] writes:
In reading the documentation of Peter Gutmann's Cryptlib, I came
across this section:
The use of crypto devices can also complicate key management, since
keys generated or loaded into the device usually can't be extracted
again afterwards. This is a
Martijn van Oosterhout kleptog@svana.org writes:
That depends. As long as the data is appropriately sync()ed when
PostgreSQL asks, it should be fine. However, from reading the manpage
it's not clear if fsync() still works when mounted -o async.
If -o async means all I/O is asyncronous
Martijn van Oosterhout kleptog@svana.org writes:
Not directly. I suppose you could create a view that converted the
value to the right date on insert.
I think a trigger might make more sense.
-Doug
---(end of broadcast)---
TIP 9: In versions
Shane Wright [EMAIL PROTECTED] writes:
Actually I thought that *all* the database had to have fsync() work
correctly;
not for integrity on failed transactions, but to maintain integrity during
checkpointing as well. But I could well be wrong!
I think you're write, but what I was thinking
Rich Shepard [EMAIL PROTECTED] writes:
On Thu, 19 Jan 2006, Doug McNaught wrote:
Did you tell pg_restore to read from a file? Otherwise it will try to read
from your terminal, which probably isn't what you want.
Doug,
No, I didn't. I've no idea where the file was dumped, so I've
Rich Shepard [EMAIL PROTECTED] writes:
Well, so much for the book. It did seem to be rather sparse on the upgrade.
Hmmm-m-m. Wonder what is the most efficient way to get going again. Think
I'll try the 'pg_dumpall -format=c' from the old directory and see if there's
a new file there.
I
Rich Shepard [EMAIL PROTECTED] writes:
Using the 8.1.2 pg_dumpall from the 2004 data directory produces a 819K
file. But, when I then cd to the new data directory and run:
[EMAIL PROTECTED]:/var/lib/pgsql/data$ pg_restore /var/tmp/backup.sql
pg_restore: [archiver] input file does not
Eric Davies [EMAIL PROTECTED] writes:
Back in the days of 7.4.2, we tried storing large blobs (1GB+) in
postgres but found them too slow because the blob was being chopped
into 2K rows stored in some other table.
However, it has occurred to us that if it was possible to configure
Ottó Havasvölgyi [EMAIL PROTECTED] writes:
Hello,
I would like to move the data directory to another location. I have done this:
1. Stop PostgreSQL
2. Move data directory
3. Create a PGDATA env. variable to the new location
4. Start PostgreSQL
And it cannot start, because it cannot find
Doug McNaught [EMAIL PROTECTED] writes:
Dumb question, but are you sure you exported the PGDATA variable? Is
it pointing to the directory that actually contains postgresql.conf?
If you still have problems, post the exact error message that appears
in the logs.
Duh, I didn't read
Jeff Trout [EMAIL PROTECTED] writes:
Isn't the [expensive db name here]'s replication/failover just an
expensive addon?
As in if you don't pay for it you don't get it.
So we're basically in the same boat as them.. just an add on. we just
offer more variety.
Well, [cheap and crappy
Scott Ribe [EMAIL PROTECTED] writes:
The time the DB needs to find the record
should be the same since the record has to be found before the resultset is
assembled.
What if the query can be satisfied from an index? I don't know if PostgreSQL
has this kind of optimization or not.
Nope.
Dave Steinberg [EMAIL PROTECTED] writes:
My biggest problem is the lack of any real error message on the server.
I don't see anything wrong in the system logs, and there's no core
file in the /var/postgresql directory.
Are you sure core files are enabled; i.e. the server is running with
Dave Steinberg [EMAIL PROTECTED] writes:
My biggest problem is the lack of any real error message on the server.
I don't see anything wrong in the system logs, and there's no core
file in the /var/postgresql directory.
Are you sure core files are enabled; i.e. the server is running with
Dave Steinberg [EMAIL PROTECTED] writes:
You're not using the same PG connection from two different threads, or
fork()ing and trying to use the same connection in the parent and the
child, or anything like that?
Aha! In the ruby code, I am forking! I'll make the child reconnect
and see if
Allen Fair [EMAIL PROTECTED] writes:
Our databases can get large and we want to find the best way to plan for
when a database outgrows its current server.
How about a replication scheme and cutover? If so, is there a preferred
replication package to support this?
Slony-I was designed for
Leonel Nunez [EMAIL PROTECTED] writes:
You can use ByteA but the size will be about 4 times bigger
Are you sure? The intermediate form for bytea (escaped single-quoted
strings) is pretty inefficient, but once in the database the data is
stored as binary and can even be compressed.
Plus,
Tom Lane [EMAIL PROTECTED] writes:
Jon Lapham [EMAIL PROTECTED] writes:
Tom Lane wrote:
It is. We have been fooling with the postmaster startup logic to try to
eliminate this gotcha, but it's only very recently (8.0.2) that I think
we got it right.
So, then it would be correct to change
Uwe C. Schroeder [EMAIL PROTECTED] writes:
Is this just me or did anyone actually think about adding a UPS to
the machine and monitor it with NUT ? That way the machine would
shut down properly, making the whole stale pid-file issue
irrelevant.
UPSs fail. People kick out power cords. It's
Robert Treat [EMAIL PROTECTED] writes:
If by stripped down you mean without postgresql database support then
I'll grant you that, but it is no different than other any other pl
whose parent language requires postgresql to be installed. If packagers
are able to handle those languages than why
Fernando Schapachnik [EMAIL PROTECTED] writes:
I'm trying to figure out why Samba is failing at high loads if using
Postgres as a backend (7.3.9 in my setup). On startup in makes one
connection only against the database which is shared among all the
Samba processes. In turn, each issue a
josue [EMAIL PROTECTED] writes:
I did a pg_dumpall and this sentence to restore it back
./psql template1 -U postgres -p 9981 /home2/tmp/dbtest.tar
You need to use 'pg_restore' for tar format dumps.
-Doug
---(end of broadcast)---
TIP 3: if
Glenn Sullivan [EMAIL PROTECTED] writes:
Hi,
I have installed native postgresql8.0.1 on a PC running Windows XP
professional.
I am having trouble connecting to it from my application. The application
is a combination of java and C++ which was developed on Sun Solaris (Unix).
Thus on the
Joshua D. Drake [EMAIL PROTECTED] writes:
Also, a 32-bit machine can only hold so much RAM. If I'm correct, there
are ways to address more memory than that on a 32 bit machine, but I
wonder at what cost? In other words, is it a good idea to address more
than 4GB on a 32 bit machine? If not,
Tommy Svensson [EMAIL PROTECTED] writes:
I have just installed Postgresql and tried it for the first time.
One very serious problem I ran into was when actually trying to use
created tables.
Creating a simple table without any foreign keys works OK, but after
creating the
table it is not
Venkatesh Babu [EMAIL PROTECTED] writes:
Hello,
Thanks for providing info... I tried disabling
autocommit, as suggested by Mr. Greg Stark, I tried
issuing the command set autocommit to off, but got
the following error message:
ERROR: SET AUTOCOMMIT TO OFF is no longer supported
Martin,
This looks really good. I wish it were going into Sarge, though of
course the timing isn't right for that. :)
A couple things I noticed about the automated upgrade procedure
(pg_version_upgrade):
1) Since it uses pg_dumpall, it doesn't seem to be capable of handling
databases with
Administrator [EMAIL PROTECTED] writes:
Hello,
I was wondering if there's a correct method for running postmaster
with the option of listening on a select group of addresses. Does
postmaster accept multiple -h hostname options on the command-line,
or alternatively a comma-separated list of
Dave Smith [EMAIL PROTECTED] writes:
I am trying to add a unique constraint on a column that can be null. The
documentation states that null is treated as non equal values but I want
them to be equal. Is there another way of doing this other than writing
a before insert trigger?
UNIQUE
Dave Smith [EMAIL PROTECTED] writes:
On Thu, 2005-01-13 at 10:12, Doug McNaught wrote:
Are you really saying that you want 'NULL = NULL' to return 't'?
Yes
Well, that's not how NULL works.
-Doug
---(end of broadcast)---
TIP 2: you can get
Nageshwar Rao [EMAIL PROTECTED] writes:
Hi,
I would like to use shared disk for two Postgresql database. I mean
that two Postgresql Database point to same $PGDATA directory. Is this
possible in Postgresql Clarification is appreciated.
No, this is not possible.
You may want to
Karl O. Pinc [EMAIL PROTECTED] writes:
Hi,
I can't seem to get postgresql to use shared memory and performance is
terrrible.
1) Linux doesn't track shared pages (which is not the same as shared
memory) anymore--the field the in 'free' output is just there to
avoid breaking software.
Clark Endrizzi [EMAIL PROTECTED] writes:
Hi all,
I have a field that I'll be ordering and I noticed that ordering is
done logically and would confuse my users here (1,12,16,4,8, etc).
Sounds like you're storing a number in a text field. Numeric fields
sort in numerical order.
-Doug
Bob Parnes [EMAIL PROTECTED] writes:
I am having trouble connecting to a database on a debian server from a
client system, also debian. Acccording to the documentation, this is
possible without a password and offers the following example,
hosttemplate1 all 192.168.93.0
Michael Fuhr [EMAIL PROTECTED] writes:
On Sun, Dec 05, 2004 at 09:10:42PM +, Andrew M wrote:
The map i make reference to is a Jboss map used to make a jndi
connection to postgreSQL. What document do I need to access to get hold
of the envireonment variables, namely PGSSLMODE?
I
Calvin Wood [EMAIL PROTECTED] writes:
symbolic link. But on win32, there is no equivalent. However, even under
*nix system, I believe symbolic link can only be created for directories on
the same hard drive. This seems less than optimal. Typically, one would
place database files on RAID 5
Jeff Amiel [EMAIL PROTECTED] writes:
If postgres knows the field is an int8, why do I have to cast it in my query?
This is fixed in 8.0.
-Doug
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Simon Wittber [EMAIL PROTECTED] writes:
WMSDV=# \dt
List of relations
Schema | Name| Type | Owner
+---+---+---
public | Customers | table | simon
public | Persons | table | simon
(2 rows)
WMSDV=# select * from Customers;
ERROR: relation
Marc G. Fournier [EMAIL PROTECTED] writes:
No, the poster will still be included as part of the headers ... what
happens, at least under Pine, is that I am prompted whther I want to
honor the reply-to, if I hit 'y', then the other headers *are* strip'd
and the mail is set right back to the
Francis Reed [EMAIL PROTECTED] writes:
If I want to create a postgres database on multiple machines, is the
practice of tarring or zipping up binaries compiled on one machine and
untarring them on another, and using the binaries (initdb etc) acceptable?.
This removes the need for having a
Kenneth Downs [EMAIL PROTECTED] writes:
I am wondering if it is possible to pick up a database from one computer and
move it over to another and then just plug it back in.
No, unless you do the whole database cluster, and the two machines are
the same architecture and have the same version of
Janning Vygen [EMAIL PROTECTED] writes:
So how do i easily empty all page/file caches on linux (2.4.24)?
Probably the closest you can easily get is to put the Postgres data
files on their own partition, and unmount/remount that partition
before running yuour tests. Unmounting will sync and
Robert Fitzpatrick [EMAIL PROTECTED] writes:
What does it mean when you drop a database and then recreate with the
same name and all the objects are still there. I want to wipe out the db
and put back from pg_restore. After I re-create the db, all the old
tables are back before I run
A. Mous [EMAIL PROTECTED] writes:
Hi,
I've got clients connected to pgsql via ODBC. If they lose their connection
abruptly, all un-committed transactions are automatically rolled-back (I'm
assuming) but is there anything left behind that needs to be cleaned up on
the server side with
[EMAIL PROTECTED] writes:
The developers agree that multiple processes provide
more benefits (mostly in stability and robustness) than costs (more
connection startup costs). The startup costs are easily overcome by
using connection pooling.
Please explain why it is more stable and robust?
Ken Tozier [EMAIL PROTECTED] writes:
I've been looking though the PostgreSQL documentation but can't seem
to find a command for importing files. I read the documentation
related to large objects but this isn't what I'm looking for as I
don't want to import the entire file into a single field,
Eddy Macnaghten [EMAIL PROTECTED] writes:
The other thing to be aware of is if a large number of people are
writing to the database concurrently it can go wrong (any method). That
is if you insert a record (using nextval for the sequence), then someone
else quickly inserts a row too before
Tom Lane [EMAIL PROTECTED] writes:
Ricardo Perez Lopez [EMAIL PROTECTED] writes:
I have observed that, for PostgreSQL, one year is actually 360 days:
SELECT '1 year'::timestamp = '360 days'::timestamp;
?column?
-
t
Nonsense.
regression=# SELECT '1 year'::timestamp =
Edwin New [EMAIL PROTECTED] writes:
I need to increase the number of connections to PostgreSQL 7.2.1.
I have tried changing the value of max_connections in
Postgresql.conf. It was commented out (as are all other entries
except tcpip_socket = true). Setting it to any other
Mage [EMAIL PROTECTED] writes:
Hi,
can pgsql acceppt invalid date values? Sometimes it would be nice to
convert 2003-02-29 to 2003-03-01 or to 2003-02-28 automatically
instead of throwing back an error message.
If you want MySQL, you know where to find it.
-Doug
--
Let us cross
Jerry LeVan [EMAIL PROTECTED] writes:
Hi,
I am futzing around with Andrew Stuarts Catchmail program
that stores emails into a postgresql database.
I want to avoid inserting the same email more than once...
(pieces of the email actually get emplaced into several
tables).
Is the
Tom Lane [EMAIL PROTECTED] writes:
[EMAIL PROTECTED] writes:
And an error occurs :
psql:lineitem.loader.psql:1: ERROR: could not extend relation
24342131/24342133
/24342324: There is not enough space in the file system.
HINT: Check free disk space.
but my fileSystem has something like
Tom Lane [EMAIL PROTECTED] writes:
Doug McNaught [EMAIL PROTECTED] writes:
It's also possible that PG is trying to create a new table file and
he's out of inodes...
Good thought, although I think that this particular error message would
only come out from a seek/write failure and not from
Matt Roberts [EMAIL PROTECTED] writes:
Please accept my apologies if this is answered elsewhere in the archives
or docs but I have searched without luck.
I've always assumed that default ordering of selects are based on a first
in first out principle and that this remains true at the row
Scott Frankel [EMAIL PROTECTED] writes:
Additional note: configure warned of an old version of bison when I
attempted an install of postgresql7.4.5 the other day. Seems the
version
that comes with OSX 10.3.x is too old for postgres.
You only actually need Bison if you are building from
David Parker [EMAIL PROTECTED] writes:
Is there any concrete reason NOT to create tables WITHOUT OIDS? We are
going to have some very large tables in our app, so saving the space and
not worrying about int-wrap seems like a good idea, but I'm worried that
I'm missing something.
Nothing in PG
Matthew Metnetsky [EMAIL PROTECTED] writes:
On Tue, 2004-09-28 at 10:55, Katsaros Kwn/nos wrote:
So, does anyone know of (or have) good examples of queries within
functions (and returning sets of data)?
I'm not very experienced in PostgreSQL but maybe SPI functions is what you
need.
Tom Allison [EMAIL PROTECTED] writes:
Can I use the serial data type in lieu of an 'auto_number' field?
What are the exact semantics of an auto_number field?
I asked something like this some months ago and it seems that
auto_number fields were addressed through a combination of triggers
and
Joseph Healy [EMAIL PROTECTED] writes:
On Sat, Sep 25, 2004 at 07:20:23PM -0400, Tom Allison wrote:
Any idea how to set up a timestamp=now on every insert/update ?
when you create your table, use:
create table mytable (
id serial primary key,
updated timestamp
Reynard Hilman [EMAIL PROTECTED] writes:
Hi,
I have been having this problem where the database size suddenly grows
from the normal size of about 300Mb to 12Gb in one night.
When I look up the table size, the biggest one is only 41Mb and the
total of all table size is only 223Mb.
But in
Shah, Sameer [EMAIL PROTECTED] writes:
1. I have DataBase-A which is Oracle on Server A with FunctionA
(PLSQL)
2. I have DataBase-B which is Postgress on Server B with FunctionB
(PgSQL)
3. I need to call FunctionA from FunctionB
As far as I know, the on'y way to do
Anony Mous [EMAIL PROTECTED] writes:
A few days ago there was a fellow that had trouble connecting remotely to
the 8.0 beta win port. I had the same problem, but have since found the
solution. In postgresql.conf file, ensure the line listen_addresses is
set to '*', ie,
listen_addresses =
McDougall, Marshall (FSH) [EMAIL PROTECTED] writes:
I have an existing installation of 7.3.4 that appears to have been made with
--without-readline and --without-zlib parameters used at build time. How
do I change those parms without reinstalling the whole thing. I would
normally go
McDougall, Marshall (FSH) [EMAIL PROTECTED] writes:
I made sure that readline was indeed installed to no avail. The configure
still does not see the libs. Any ideas?
You don't say what system you're on, but most Linux distributions
split library packages like readline into 'runtime' and
Jeff Amiel [EMAIL PROTECTED] writes:
So I downloaded postgresql-7.4.5.tar.gz
ftp://ftp21.us.postgresql.org/pub/postgresql/v7.4.5/postgresql-7.4.5.tar.gz
uncompressed...
configure...
make
make install
I run psql and it gives me the Welcome to psql 7.4.5, the PostgreSQL
interactive
Tom Lane [EMAIL PROTECTED] writes:
Cornelia Boenigk [EMAIL PROTECTED] writes:
C:\psql -h 192.168.1.8 -U postgres -d minitest
psql: could not connect to server: Connection refused
Is the server running on host 192.168.1.8 and accepting
TCP/IP connections on port 5432?
Jan Wieck [EMAIL PROTECTED] writes:
On 8/4/2004 1:58 PM, David Rysdam wrote:
bytea will only go up to several thousand bytes according to the
docs. I assume it's not very precise because the maximum is 8196 -
$other_fields_in_row. My binary data could be a couple times that
or even much
Marcus Wegner [EMAIL PROTECTED] writes:
Is it possible to keep data safe with linux and psql after crash?
The short description of the scenario is:
- writing data with psql (using transactions), store process completed
- user hits the reset button or kernel crashes (whatever left the
Prabu Subroto [EMAIL PROTECTED] writes:
If I read your suggestion, that means...I have drop
the column salesid and re-create the column
salesid. and it means, I will the data in the
current salesid column.
Do you have further suggestion?
You can do it by hand without dropping the column:
[EMAIL PROTECTED] (Jim Seymour) writes:
Oh, if you're accepting punctuation nits ;), in most cases, the comma
should come after but, not before it. So your sentence should read
PostgreSQL will run on almost any hardware but, if you are...
Wrong. :)
You are sentenced to go read Strunk and
Michal Taborsky [EMAIL PROTECTED] writes:
Doug McNaught wrote:
But why not create a products_restricted view that uses the
CURRENT_USER function to see who's running it?
CREATE VIEW products_restricted AS
SELECT * FROM products WHERE Producer_ID = get_producer_id(CURRENT_USER
Juan Jose Costello Levien [EMAIL PROTECTED] writes:
Hello,
I am trying to use a trigger function I wrote in C. Basically what I
want to do is to audit a table when a row is inserted into another
table by copying the row to the new table. It compiles Ok and I
created a shared library
Simon Windsor [EMAIL PROTECTED] writes:
Hi
I understand that null and '' are different, and MySQL and Oracle
functions are confusing, but my question was not about replacing NULL
but replacing Empty strings. These are handled in MySQL/Oracle by the
same functions that do NULL checks.
Is
1 - 100 of 222 matches
Mail list logo