Not really a PostgreSQL question, but maybe somebody here knows the
answer!
I recently purchased Groff and Weinberg's The Complete Reference SQL,
and a fine meaty tome it is too!
However, I find to my absolute *_horror_* that there doesn't appear to
be an electronic version of the sample
On Fri, 19 Dec 2003 12:11:51 -0800 (PST), Jeff Eckermann
[EMAIL PROTECTED] wrote:
--- Nikola Skoric [EMAIL PROTECTED] wrote:
Is there windows distribution of PostgreSQL? I
recieve contradictory
information :-) Some people say there is, some there
isn't. So, is
there? I've been browsing
A good indicator of the demand that there is for a native Win32 port. I
know it's already in the works, but I think that the upswing in
popularity of PG will be huge once the port is complete.
Whether you love or loath Windows, it's hard to ignore the potential
market share for a project
Thanx for ur suggestion... But I face a new problem
now...
connection.setAutoCommit works well with postgresql
7.3 .. but with postgresql 7.4 I am getting the
error...
Error in connection == ERROR: SET AUTOCOMMIT TO OFF
is no longer supported
I have tried pg73jdbc1.jar and pg73jdbc3.jar .. both
Where can I learn some more about the Rule system in PostgreSQL( ie
besides the manual)?
I'd also want to learn what query trees are generated by my queries?
How can I get them to show up? I am using pgAdmin3.
---(end of broadcast)---
TIP 1:
ezra epstein [EMAIL PROTECTED] writes:
I've stumbled against the inability to put null values within an array.
Are there any plans to remove that limitation?
It's on the TODO list. I think Joe Conway has made noises about doing
something about it, but I dunno if he expects to get to it during
There is a way to create them as CONSTRAINT triggers. It's totally
non-standard, not guaranteed to exist in future releases, yadda, yadda.
But it get's you where you want to be now().
Jan
ezra epstein wrote:
I've got the case of a table which has unusual FK constraints. I'm
implementing them
On Dec 21, 2003, at 11:47 PM, Tom Lane wrote:
Steven D.Arnold [EMAIL PROTECTED] writes:
Query (2) below is the same query, but we reverse the order of the
tables. It's obviously not quite the same query semantically, even
though in my case it should always produce the same result.
Since it is in
Hi, everybody!
I was wonderring if there is a way to make logrotate work with postgres
logs?
More precisely, the question is - is there any way to tell a running
postmaster process to reopen its log file?
I tried kill -HUP ... but that doesn't seem to do anything...
Is there just no way to do
Dima Tkach wrote:
Hi, everybody!
I was wonderring if there is a way to make logrotate work with postgres
logs?
More precisely, the question is - is there any way to tell a running
postmaster process to reopen its log file?
I tried kill -HUP ... but that doesn't seem to do anything...
Dear all,
Before reading all this let me assure you nothing is out of control just
DONT PANIC
I was just going through the pages of http://www.2038.org
and was concerned by the fact my computer using Linux will rollover to
Fri Dec 13 20:45:52 1901
after
Tue Jan 19 03:14:07 2038
Now
Il lun, 2003-12-22 alle 19:40, Dima Tkach ha scritto:
Hi, everybody!
I was wonderring if there is a way to make logrotate work with postgres
logs?
More precisely, the question is - is there any way to tell a running
postmaster process to reopen its log file?
I tried kill -HUP ... but
How can I hide all details from users regarding data and structure,
limiting access to data through functions I create?
I don't want a user to be able to see the structure of a table with \d
{tablename} in psql.
TIA
---(end of broadcast)---
TIP 5:
Paul,
once you get through the book perhaps you could submit a book review to
the techdocs website, along with a pg_dump of the sample database.
Robert Treat
On Mon, 2003-12-22 at 05:50, Richard Huxton wrote:
On Monday 22 December 2003 07:47, Paul Ganainm wrote:
Not really a PostgreSQL
Hello:
I know that hardware requirements are dependent upon many factors.
However I need a sanity check on this configuration.
First the purpose of the database.
- database will be used to support a risk analysis group in a small
financial firm.
- there will be daily bulk loads to the
I am considering a generic box with a single 2 - 2.6 Gig processor.
2 Gig of RAM and mirrored 200 Gig drives.
Use RAID 5 or 0+1...
Does this config cover the above requirements very well.
Does anybody know if RedHat 9 or Fedora can address 2 Gig
of RAM out of the box?
Yes they can.
Does this config cover the above requirements very well.
Does anybody know if RedHat 9 or Fedora can address 2 Gig
of RAM out of the box?
Yes they can.
The last time I built an RH system, one with 1GB, I had to recompile
the kernel and change the 'High Memory Support' setting to get it to
The last time I built an RH system, one with 1GB, I had to recompile
the kernel and change the 'High Memory Support' setting to get it to
use the full 1GB.
That was under RH 8, though.
Even on redhat 8, all you have to do is install the bigmem kernel...
which does ship with RH8.
-
Hi all!
I want to know what's better between these 2 solutions :
CREATE TABLE user (
...
user_type text CHECK(user_type='Root' OR user_type = 'Admin' OR
user_type = 'Standard'));
or the following :
CREATE TABLE user_type(
user_type_id integer PRIMARY KEY,
user_type_desc text);
You can do this by doing
ALTER TABLE mytable
ADD CONSTRAINT myconstraint FOREIGN KEY (table_id) REFERENCES
myothertable(table_id);
Melanie
Brian C. Doyle wrote:
Hello all,
I was wondering if there is any way to add a primary and/or foreign
keys to existing tables in 7.3.2
On Mon, 2003-12-22 at 14:51, Lucas Lain wrote:
Hi everybody ... i need to restore only one database from a pg_dumpall backup
file... how can i do it?
If it's a plain text dump, make a copy of the backup file. Edit the
copy and delete everything that doesn't relate to the database to be
If it's a plain text dump, make a copy of the backup file. Edit the
copy and delete everything that doesn't relate to the database to be
restored.
it's quite large to do this ...
If you dumped in tar or special format, I believe you can use
pg_restore -d dbname
but I haven't done that
Hi,
Since Canada Post hasn't programmed their automated web tools for calculating
transportation costs to work with anything outside of Windows Internet Explorer, I'm
obliged to write a web based program optimized for all those *other* browsers, myself.
Part of this task requires that I set up
All,
I am having a problem with an INSERT onto a table I have created. First
off, here is the table:
---
CREATE TABLE reg (customer number SERIAL PRIMARY KEY, company name
VARCHAR(50) NULL, address VARCHAR(100) NULL, city VARCHAR(50) NULL,
state VARCHAR(2) NULL, zip VARCHAR(50) NULL, phone
On Mon, Dec 22, 2003 at 08:14:51PM -0300, Lucas Lain wrote:
If it's a plain text dump, make a copy of the backup file. Edit the
copy and delete everything that doesn't relate to the database to be
restored.
it's quite large to do this ...
Maybe you could try getting the line numbers
On Mon, Dec 22, 2003 at 04:24:52PM -0700, Andrew Ayers wrote:
INSERT INTO reg(customer number, company name, address, city, state,
zip, phone, alt_phone, fax, alt_fax, iaccess, browser, provider,
software, sversion, ynintegrated, ynnewtest, login, password, txtnetid,
alias_1, alias_2, url,
I wish to insert data into a table from a very large text file (from a
cron script) using COPY. However if the lName (TEXT), fName(TEXT),
workDate(DATE) already exist I don't want to insert data and just want
to move onto the next record. Is there any way I can tell my bash
script/COPY to
How about this:
Let's call your current table tab.
Insert into a table with the same shape as your table tab called 'lfd'.
Create an index on table lfd on fields lname, fname, workdate.
Delete from lfd where lfd.lname = tab.lname and lfd.fname = tab.fname
and lfd.workdata = tab.workdate
Insert
On 22/12/2003 21:37 Melanie Bergeron wrote:
Hi all!
I want to know what's better between these 2 solutions :
CREATE TABLE user (
...
user_type text CHECK(user_type='Root' OR user_type = 'Admin' OR
user_type = 'Standard'));
or the following :
CREATE TABLE user_type(
user_type_id
On Mon, Dec 22, 2003 at 04:37:51PM -0500, Melanie Bergeron wrote:
I want to know what's better between these 2 solutions :
CREATE TABLE user (
...
user_type text CHECK(user_type='Root' OR user_type = 'Admin' OR
user_type = 'Standard'));
or the following :
CREATE TABLE
On Monday 22 December 2003 08:16 am, Keith C. Perry wrote:
I'm not familiar with the cygwin environment but is there something about
that is turning off users to using it to run PG?
It seems to me we should be seeing *more* ports about how PG is performing
on cygwin instead of questions
Its been almost 4 weeks since PostgreSQL 7.4 was released, and, as with
all new releases, several bugs have been identified as administrators
migrate their production databases up from older releases.
As the list of Changes since 7.4 is fairly small, they are included in
this email:
*
32 matches
Mail list logo