Anyone care to share the great books, articles, manifestos, notes,
leaflets, etc on data modelling they've come across? Ideally I'd like
to find a great college level book on data models, but I haven't come
across one that even slightly holds definitive resource-type status.
Feel free to reply
Back to this thread - I realize that in the COPY TO documentation, it
states the CSV file used for loading must be on the server's disk. If I
can't put files on the server's disk, I'm curious if I can use the STDIN
option from my JDBC client to load the data to the server? Using psql I
can
Christopher Condit schrieb:
Back to this thread - I realize that in the COPY TO documentation, it
states the CSV file used for loading must be on the server's disk. If I
can't put files on the server's disk, I'm curious if I can use the STDIN
option from my JDBC client to load the data to the
Hi, List!I use PG8.1Are there any abilities to detect primary key of a table?Sergey Karin
How can I select ('2006-01-01 9:00:00+02' at time zone 'GMT')::timestamp;
where instead of GMT it has the local time zone of the machine I am running
it on (which varies between my machines)?
I dont want to hard code the timezone of the machine into the query.. I want
to pick it up from the
Yes, it is not a problem via psql.But I want to detect primary key via libpq (e.g using select commands)2006/3/30, Michael Kleiser
[EMAIL PROTECTED]:\d your_tablewill show it create table foobar ( foo int primary key, bar int );
NOTICE:CREATE TABLE / PRIMARY KEY will create implicit
Sergey Karin schrieb:
Yes, it is not a problem via psql.
But I want to detect primary key via libpq (e.g using select commands)
Look into informational-schema
or start psql with the option -e
then use \d+ and see what it prints :-)
Regards
Tino
---(end of
On Thu, Mar 30, 2006 at 02:24:55PM +0300, Peter Nixonn wrote:
How can I select ('2006-01-01 9:00:00+02' at time zone 'GMT')::timestamp;
where instead of GMT it has the local time zone of the machine I am running
it on (which varies between my machines)?
I dont want to hard code the timezone of
On Thu, Mar 30, 2006 at 03:13:12PM +0400, Sergey Karin wrote:
Are there any abilities to detect primary key of a table?
In psql you could use \d tablename. To see the queries that psql
makes, execute \set ECHO_HIDDEN and then \d tablename. Here's
the documentation for the system catalogs that
Since Monday I have been seeing terminated by signal 11 messages in my 7.4.6 + Slon 1.0.5 system,. but only on the masterI've done a dumapall, initdb and restore , which reduced the frequency but I still get them 6-8 times a day.
After turning up logging it seemed to die when calling a very small
Tass Chapman [EMAIL PROTECTED] writes:
Since Monday I have been seeing terminated by signal 11 messages
in my 7.4.6 + Slon 1.0.5 system,. but only on the master
This kind of thing is almost always a hardware problem. 'memtest86'
is probably a good first step, and see if any of your cooling
Hi All;
Can Slony-I be used for circular replication (A
replicates B replicates A)
or there is some kind of problem with locking or
anything else?
If I avoid insert conflicts will the following
scenario succeed for the updates :
A: X.balance-= 5
B: X.balance-= 3
A receives the update
Bojidar Mihajlov wrote:
Hi All;
Can Slony-I be used for circular replication (A
replicates B replicates A)
or there is some kind of problem with locking or
anything else?
No - Slony is an asynchronous single-master replication scheme. As such
changes are only allowed at a master node.
Douglas McNaught [EMAIL PROTECTED] writes:
Tass Chapman [EMAIL PROTECTED] writes:
Since Monday I have been seeing terminated by signal 11 messages
in my 7.4.6 + Slon 1.0.5 system,. but only on the master
This kind of thing is almost always a hardware problem. 'memtest86'
is probably a good
On Thu, 2006-03-30 at 07:02, Tass Chapman wrote:
Since Monday I have been seeing terminated by signal 11 messages in
my 7.4.6 + Slon 1.0.5 system,. but only on the master
I've done a dumapall, initdb and restore , which reduced the frequency
but I still get them 6-8 times a day.
After
Hi Tino - thanks for your response.
Do you think that's the best way to go - just use Java to launch an
external load command to psql.exe? Does anyone else know of a way to
accomplish this with Java?
Thanks,
Chris
-Original Message-
From: Tino Wildenhain [mailto:[EMAIL PROTECTED]
I have where clause where all fields are CHAR(10) type and may have trailing
spaces.
SELECT ...
FROM r1, r2
WHERE r1.c1 || r1.c2 || r1.c3 = r2.c1 || r2.c2 || r2.c3;
This WHERE clause produces wrong result since || operator removes trailing
spaces.
Correct result is produced if || operator
Hi,
I'll hope this is the correct list for these questions... :-/
I need to define several unique data types. As my make one
to throw away exercise, I rewrote the ISBN data type in
the contrib directory (hopefully bringing it up to date
as well as adding stricter checks in the parser and
Andrus [EMAIL PROTECTED] writes:
I have where clause where all fields are CHAR(10) type and may have trailing
spaces.
...
Correct result is produced if || operator does not remove trailing spaces.
If you think that trailing spaces are significant data, you should
probably be using VARCHAR not
On Thu, Mar 30, 2006 at 11:51:41AM -0700, Don Y wrote:
- I assume I don't have to check the return value from
palloc()? (All of the src/backend/utils datatypes
seem to trust it implicitly) BTW, where is the interface
to palloc() et al. documented (or, is it a case of Use
the Source,
Martijn van Oosterhout kleptog@svana.org writes:
On Thu, Mar 30, 2006 at 11:51:41AM -0700, Don Y wrote:
- Can *_in() be ever invoked with a NULL argument? Or, can I
safely assume that the pointer I am passed is valid?
You can't get a NULL there. Yes, the pointer is valid cstring.
To be sure
I am having a problem with Sun Java Studio Creator because the latest
version of the JDBC driver returns a field length of -1 for text fields.
My question: Is a text field just a varchar(Integer.MAX_VALUE)? If I want
to use the data binding part of the SJSC tool I will need to convert my
Hi, Chris (great looking site, by the way)! thanks for responding. i
was just practicing on postgres and encountered this problem. i am
using pg admin for postgres and for some reason the commands you posted
does not seem to work. i was kinda looking for an built-in function
like upper() or
Hello,
I would like to create a function that lets me to search in a table
rows according differents parameters.
I looked in the documentation of postgresql 8.1 about Pl/Perl
procedures but I didn't found how to cross each row of a table with
Pl/Perl.
Someone would have an example of that with
Hi All;
Can Slony-I be used for circular replication (A replicates Breplicates A)
or there is some kind of problem with locking or anything else?
If I avoid insert conflicts will the following scenario succeed for the updates :
A: X.balance-= 5
B: X.balance-=3
Areceives the update from
and it took about 10 Minutes to execute. So it is nearly a hundred times
slower. Can this be verified? Is there anything that can be done about
that? Else I would need to have a few words with our programmers...
OK... I overstated a little bit. The real numbers are:
1.) 21.5 seconds
2.) 363.7
I have two questions:
1. In Postgresql, what is the name of the exact DATAFILE under the DATA
DIRECTORY ?
2. We want to prepare a backup machine (for disaster management)by passing
the pg_xlog diectory.First time we have made a base backup restore
the backup server by this
Hossa,
I just made a little test on our test-database. I have an excel sheet
with about 2000 entries that should be updated with the same value. In a
first try I generated an SQL-Syntax for every entry like:
UPDATE xyz SET status=-6 WHERE id=xyz1 AND status-1;
UPDATE xyz SET status=-6 WHERE
Tormod Omholt-Jensen wrote:
We are upgrading our systems to handle new languages and therefore we
need to change the encoding of our postgres database from LATIN1 to UTF-8.
I have pg_dumped the database and imported it into the new UTF-8 base.
It seems like this worked just fine.
Can
I'm not aware of one, but I would also be very interested.
Certainly Postgres is much more standards compliant. In terms of
developer features, Postgres is also much more advanced. Sybase also
has some unusual limitations in wierd areas like the maximum number of
bytes of index per row.
Sybase
Kai Hessing wrote:
and it took about 10 Minutes to execute. So it is nearly a hundred times
slower. Can this be verified? Is there anything that can be done about
that? Else I would need to have a few words with our programmers...
OK... I overstated a little bit. The real numbers are:
1.)
raj wrote:
Hi, Chris (great looking site, by the way)! thanks for responding. i
was just practicing on postgres and encountered this problem. i am
using pg admin for postgres and for some reason the commands you posted
does not seem to work. i was kinda looking for an built-in function
like
kurt _ wrote:
I am having a problem with Sun Java Studio Creator because the latest
version of the JDBC driver returns a field length of -1 for text fields.
My question: Is a text field just a varchar(Integer.MAX_VALUE)? If I
want to use the data binding part of the SJSC tool I will need to
Douglas McNaught wrote:
Michael Talbot-Wilson [EMAIL PROTECTED] writes:
How, really, do people pronounce PostgreSQL?
Postgres
The first sentence of the FAQ is:
PPostgreSQL is pronounced IPost-Gres-Q-L/I, and is also sometimes
referred to as just IPostgres/I.
Is that
Chris wrote:
kurt _ wrote:
I am having a problem with Sun Java Studio Creator because the latest
version of the JDBC driver returns a field length of -1 for text fields.
My question: Is a text field just a varchar(Integer.MAX_VALUE)? If
I want to use the data binding part of the SJSC
Chris [EMAIL PROTECTED] writes:
kurt _ wrote:
My question: Is a text field just a varchar(Integer.MAX_VALUE)?
varchar has a max of 255 characters,
You must be using some other database ;-)
The current Postgres code has a physical limit of 1G bytes for any
column value (and in practice
On Thursday 30 March 2006 21:27, Tom Lane wrote:
Chris [EMAIL PROTECTED] writes:
kurt _ wrote:
My question: Is a text field just a varchar(Integer.MAX_VALUE)?
varchar has a max of 255 characters,
You must be using some other database ;-)
The current Postgres code has a physical limit
In the last exciting episode, [EMAIL PROTECTED] (Aaron Glenn) wrote:
Anyone care to share the great books, articles, manifestos, notes,
leaflets, etc on data modelling they've come across? Ideally I'd like
to find a great college level book on data models, but I haven't come
across one that
Uwe C. Schroeder [EMAIL PROTECTED] writes:
On Thursday 30 March 2006 21:27, Tom Lane wrote:
My own take on this is that you should say what you mean. If you do
not have a clear application-oriented reason for specifying a particular
limit N in varchar(N), you have no business choosing a
Tom Lane wrote:
Chris [EMAIL PROTECTED] writes:
kurt _ wrote:
My question: Is a text field just a varchar(Integer.MAX_VALUE)?
varchar has a max of 255 characters,
You must be using some other database ;-)
Oops! Sorry :)
--
Postgresql php tutorials
http://www.designmagick.com/
Hi!
I'm configuring postgresql-8.1.3
with
./configure --with-perl --with-python --enable-nls --with-openssl --enable-debug --enable-cassert --with-tcl
being root, in
/usr/src/redhat/SOURCES/pg/postgresql-8.1.3
directory, on Fedora Core 4.
I have this error:
configure: error: file 'tclConfig.sh'
41 matches
Mail list logo
