On 2013-12-18 10:41, Kevin Grittner wrote:
Dean Gibson (DB Administrator) wrote:
... that clearly spends some time building a separate index.
No it doesn't. If you are observing activity at that time, it is probably from
validating that the constraint is initially valid.
Ah ha! T
I have general question about FOREIGN KEYs:
1. Suppose I have table A with primary key X, and another table B with
field Y.
2. When I 'ALTER TABLE "B" ADD FOREIGN KEY( "Y" ) REFERENCES "A" ON
UPDATE CASCADE ON DELETE CASCADE', that clearly spends some time
building a separate index.
Oops; see correction below:
On 2010-11-04 16:41, Dean Gibson (DB Administrator) wrote:
On 2010-11-04 15:41, Christine Penner wrote:
I have a table column I want to change from a boolean to a smallint.
changing false to 0 and true to 1. How do I do that?
Christine Penner
Ingenious Software
On 2010-11-04 15:41, Christine Penner wrote:
I have a table column I want to change from a boolean to a smallint.
changing false to 0 and true to 1. How do I do that?
Christine Penner
Ingenious Software
250-352-9495
ch...@fp2.ca
ALTER TABLE ALTER col_name TYPE SMALLINT
USING CASE WHEN col_n
new (pending) master, before you "touch"ed the pending
master's trigger file, you should be OK, as all the DBs should be in
sync at that point.
When the primary DB server goes down, updates are no longer accepted.
In such a situation, the human goal is to get the updates accepted
aga
Oops; previously sent from the wrong eMail address, so I don't know if
this actually got sent:
Two days ago I upgraded five DB boxes (for load balancing) from 8.3.0 to
9.0.1 in order to use replication. The replication configuration went
reasonably well, and now all the four "h
Thanks.
I think I mistook postgres for postgres-plus.
Quoting Ashesh Vashi :
You can always download PostgreSQL installer for any supported platform
without any registration from
http://www.enterprisedb.com/products/pgdownload.do.
On Thu, Feb 11, 2010 at 4:30 PM, wrote:
Hi,
Please why is
Hi,
Please why is it that we must register at EnterpriseDB and register
each Windows installation of postgreSQL these days?
At times, I need to install on a server that is not on the internet
and have had to bear the pain of configuring a server for internet
before I can install postgreSQ
t.println("ret:" +
ret);
//LINE3
}
After LINE1 is executed, LINE3 is run and the output is: ret:false. LINE2 is
not executed.
Thanks.
Jack
On Fri, Oct 30, 2009 at 4:06 PM, Guillaume Lelarge
wrote:
> Le vendredi 30 octobre 2009 à 23:41:54, db de a écrit :
> > How to execute &
How to execute "SELECT pg_start_backup('label');" from java as a SQL
statement? I tries to use:
Statement.execute("SELECT pg_start_backup('label')")
But it does not work.
Thanks.
Jack
Hi,
I have a loop of the form:
FOR rec IN SELECT code FROM staff WHERE shiftgroup = NEW.groupe ORDER
BY code LOOP
WHILE sdate <= NEW.todate LOOP
SELECT INTO starty,endy,nday resumetime,closetime,nextday FROM
shifts WHERE shift = NEW.shift;
restim
Hi,
Congratulations on the release of version 8.4.
I am surprised that pgAdmin's help link is now directed to the
documentation website of postgresql. The embedded help CHM was not
packaged with it.
This implies that anytime one needs help on a simple syntax, one must
connect to the inte
Hi,
I have a table with BIG SERIAL field as Primary KEY. During high load,
entries in the BIG SERIAL field are jumped. One could see a row with
1367 and expecting the next INSERT to be 1368, one would end up
getting 1369.
Please is this normal?
Regards,
Chris
--
Sent via pgsql-general mailing
On 2008-03-13 23:14, Scott Marlowe wrote:
Tis the other way round I'm afriad. Schemas live in dbs, not the other way
around. Maybe you were thinking tablespaces?
You're right; I was thinking of tables, which I routinely move around
from schema to schema.
That also means he should ignore
On 2008-03-13 10:10, Gauthier, Dave wrote:
Ya, I'm thinking of dumping all the problem DBs, deleting them, recreating and
reloading.
Last thought: have you tried uninstalling and reinstalling PostgreSQL?
If something is corrupted on the disk, it's either the data or the
software. An u
On 2008-03-12 21:30, Scott Marlowe wrote:
...
> Can't rename a db, complains that it doesn't exist. Yet psql -l shows that
it does and I can connect to it ???
>
> mmdcc228_SETUP(120)% psql stdb2 -c "alter database stdb rename to
stdb_tmp"
>
> ERR
On 2008-03-09 11:49, Mitchell D. Russell wrote:
Dean:
I did the dump as so: psql –Upostgres databasename > c:\temp\dump.sql
I assume you meant pg_dump, not psql.
I think the database was set to SQL_ASCII before I dumped it, because
when I did the 2^nd restore last night to a new SQL
On 2008-03-09 01:45, Mitchell D. Russell wrote:
New to the list, so please forgive me in advance :)
I've been running 8.2 on windows server 2003 for quite some time now.
The database that I take care of stores records with various languages
in it (russian, chinese, etc) and has been working
On 2008-02-26 13:04, Tom Hart wrote:
I already have a php script that does some data scrubbing before the
copy. I added this line to the script and things seem to be working
better now
$line = iconv("ISO-8859-1", "UTF-8", $line);
Thanks for the help guys :-)
Read up on the difference bet
On 2008-02-22 17:57, Ralph Smith wrote:
I'm looking at the v7.4 manuals and I don't see how to encode for
importing into a v8 DB using UTF8.
Maybe I'm making this hard on myself?
The old DB is using SQL_ASCII.
We'd like the new one to use UTF8.
As development proceeds, I&#
On 2008-02-21 19:59, Tom Lane wrote:
You can set client_encoding in postgresql.conf if you want to, but I'm having a
hard time understanding why you think that'd be a good idea --- *particularly*
if your database encodings aren't all the same.
regards, tom lane
Act
If I "ALTER DATABASE ... SET client_encoding TO DEFAULT", is the default
the "client_encoding" in postgresql.conf when the server was last
started, or the value at the time the "ALTER DATABASE ... SET
client_encoding TO DEFAULT" statement is executed?
In other words, if I "ALTER DATABASE ... S
On 2008-02-21 13:37, Justin wrote:
... I'm wondering if there is a way to create this in a single select
statement??
I can't think of a way to do it???
Break down your problem using VIEWs. Create a VIEW that gets just ONE
of the averages, based on a starting date. Then create a SELECT that
On 2008-02-12 19:39, Ken Johanson wrote:
Dean Gibson (DB Administrator) wrote:
On 2008-02-12 16:17, Ken Johanson wrote:
Dean Gibson (DB Administrator) wrote:
...
I'm guessing you declare an explicit length of 1 (for portability),
or do you "CAST (x as char)"? And one mi
On 2008-02-12 16:17, Ken Johanson wrote:
Dean Gibson (DB Administrator) wrote:
...
I'm guessing you declare an explicit length of 1 (for portability), or
do you "CAST (x as char)"? And one might ask in what context we'd need
CHAR(1) on a numeric type, or else if substr/in
On 2008-02-12 07:30, Ken Johanson wrote:
Sure, but you're a prime candidate for understanding the value of
following the spec if you're trying to write software that works with
multiple databases.
The spec has diminished in this (CAST without length) context:
a) following it produces an outp
gsql/
-- Dean
On 2008-02-09 18:45, Tom Lane wrote:
"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
I've tried various places, and none seem to work. I've even done a
"strings `which psql` | grep psqlrc" to no avail.
"pg_config --sysco
I've tried various places, and none seem to work. I've even done a
"strings `which psql` | grep psqlrc" to no avail.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your
> I'm just looking for the correct workaround.
While adding a new collation is the "correct" solution it's a lot of work.
Even then pg can't use different collations anyway unless you reinit
the datadir using initdb.
One workaround is to cast the text value into a bytea value, and then it
will be
PostgreSqlClient ( old PgSqlClient ) 2.0 Beta 1 is available for download.
It's the first version for ADO.NET 2.0 and Microsoft .NET 2.0, be aware
that right now it doesn't provide integration with Visual Studio 2005.
Download information can be found:
http://sourceforge.net/project/showfiles
?
On 1/20/06, DB Subscriptions <[EMAIL PROTECTED]> wrote:
Hi,
I have this table:
CREATE TABLE users
(
userid varchar(100) NOT NULL,
nama varchar(50) NOT NULL,
pword varchar(255) NOT NULL,
groupe varchar(7) NOT NULL,
rolle int2 NOT NULL DEFAULT 2,
statux varchar(9) NOT NULL DEFAULT &
Hi,
I have this table:
CREATE TABLE users
(
userid varchar(100) NOT NULL,
nama varchar(50) NOT NULL,
pword varchar(255) NOT NULL,
groupe varchar(7) NOT NULL,
rolle int2 NOT NULL DEFAULT 2,
statux varchar(9) NOT NULL DEFAULT 'Active'::character varying,
CONSTRAINT users_pkey PRIMARY KEY (u
Hi,
Please as a superuser how would I obtain an equivalent of this query:
SELECT * FROM pg_shadow WHERE usename='userid' AND md5(passwd)='passwd'
I browse the content of the pg_shadow and the passwd field shows
something like md5...
All I am after is to validate a user against pg_shadow table i
On 2005-11-09 13:08, Martijn van Oosterhout wrote:
I want to run fast queries by knowing first characters of bar like :
1. Select records from foo where first character of bar is A
2. Select records from foo where first character of bar is B
3. Select records from foo where first two characters
CREATE TABLE new_name AS SELECT DISTINCT * FROM old_name;
DROP TABLE old_name;
ALTER TABLE new_name RENAME TO old_name;
On 2005-11-04 17:15, Peter Atkins wrote:
All,
I have a duplicate row problem and to make matters worse some tables don't have a PK or any unique identifier.
Anyone have a
The problem described below in 7.4.x, does not occur in 8.0.4, even with
near-simultaneous VACUUMs and updating. Previously, if one VACUUM was
run within a minute or two of the other, the problem below occurred.
-- Dean
On 2005-09-19 09:26, Dean Gibson (DB Administrator) wrote:
Simultaneous
On 2005-10-20 15:46, Roger Hand wrote:
On Thursday, October 20, 2005 1:01 PM, Martijn van Oosterhout wrote:
On Thu, Oct 20, 2005 at 09:28:25AM -0700, Dean Gibson (DB Administrator) wrote:
I just find it surprising that XML is not one of the formats provided,
considering that XML is
On 2005-10-19 23:52, Michael Glaesemann wrote:
On Oct 20, 2005, at 15:45 , Roger Hand wrote:
On Oct 20, 2005, at 14:50 , Dean Gibson (DB Administrator) wrote:
PSQL has the option to output the result of queries in several
different formats, including HTML. Suggestion: have an option to
PSQL has the option to output the result of queries in several different
formats, including HTML. Suggestion: have an option to output query
results in XML format. Suggested format:
field-1 value
field-2 value
etc. The user would be responsible for adding the enclosing XML.
NULL value
"_OperatorClass" (cost=0.00..1.07
rows=1 width=13)
Filter: (class_id = $0)
Sorry about the post to pgsql-general; since this appeared to be a 8.0
regression, I posted it there. I guess I should subscribe to
pgsql-perform ... ???
If/when you think this will
o queries aren't the same. The first one can only return 0 or 1 rows;
the second one can return 0, 1, or 2 rows.
An explain analyze of each should show why one is much faster than the
other.
On Mon, Oct 17, 2005 at 10:29:43AM -0700, Dean Gibson (DB Administrator) wrote:
In the query below,
opposed to about
fifteen minutes under 7.4.8.
-- Dean
On 2005-10-17 09:35, Dean Gibson (DB Administrator) wrote:
Last night I upgraded my three DB servers from 7.4.8 to 8.0.4 (RPM
from the PostgreSQL site). This morning I found my servers very busy
from three queries that were two hours old:
The
Last night I upgraded my three DB servers from 7.4.8 to 8.0.4 (RPM from
the PostgreSQL site). This morning I found my servers very busy from
three queries that were two hours old:
The following query ran in a fraction of a second on 7.4.8:
SELECT receipt_date, process_date, callsign AS
hu, 2005-10-13 at 11:30, Dean Gibson (DB Administrator) wrote:
What's the point of a binary search if the list is small enough to fit on a
line or two? And if a query can be substituted for N1-NN, you have to read all
the values anyway, and then the function is trivially expressed as a no
What's the point of a binary search if the list is small enough to fit
on a line or two? And if a query can be substituted for N1-NN, you have
to read all the values anyway, and then the function is trivially
expressed as a normal query with no decrease in speed.
-- Dean
On Wed, 2005-10-12 a
d/could be a single line of
SQL code takes about 6 lines of PHP. This seem wasteful and redundant
to me.
Here is a sample of what I'm talking about ($db is a PDO already
defined and created).
$query[1] = "UPDATE my.table, SET somefield = '$someval' WHERE
somecondition"
You can set up pg_hba.conf so that only certain Unix users that have
access to the local Unix PostgreSQL socket can access the database
without a password (every other process uses a TCP/IP connection); then
move the socket location to other than /tmp and restrict its access w/
Unix controls. De
Simultaneous VACUUMs in tables in different schemas appear to interact.
Observed in v7.4.5 & 7.4.8 on Fedora Core 1.
Details:
I have a database consisting of several schemas. Two of these schemas
are contain eight tables each (about 700K rows each), which are
populated and updated daily via
Hi,
Does anyone know of any open source PostgreSQL replicator that can
replicate data from Fedora Core4 to Windows Server? Can Slony do that?
Thanks for your advice.
Best regards.
Chris.
---(end of broadcast)---
TIP 1: if posting/reading through
Hi,
I have a table with this schema:
CREATE TABLE billing.bill
(
sno serial NOT NULL,
billno int4,
det date NOT NULL,
.
.
.
CONSTRAINT bill_pkey PRIMARY KEY (sno)
)
I want to execute a query that will not return any record. Which of
these queries is cheaper please?
1. Select * from
Even simpler: COALESCE( a = b, a IS NULL AND b IS NULL )
-- Dean
Greg Stark wrote on 2004-09-27 08:17:
Stephan Szabo <[EMAIL PROTECTED]> writes:
> > On Sun, 26 Sep 2004 20:16:52 +0200, David Helgason <[EMAIL PROTECTED]> wrote:
>
> > > On a similar note, I've found myself wanting an extended '=' op
On Thursday, Sept 18 Bruno Wolff said:
One option for you is to use the list address in the from header when
posting to the list. That will hide your address and not break
replies. Most likely the list checks the envelope sender address to see
whether or not the message needs moderator approva
52 matches
Mail list logo
