trigger but it is driving me
crazy as to why this won't work as a rule. If I put something like the
following:
insert into foo values(NEW.points);
Then every transaction points value is copied to foo.
Any help is very appreciated.
Thanks,
Scott.
---(en
postgres user to correct the situation.
Is this a bug or desired behavior? I would imagine since I owned the tables
and then granted permissions to another user, I wouldn't lose my
permissions.
Any help or explanation would be appreciated.
Thanks,
Scott Saltsgaver
nd be to grant
permissions to yourself first and then to all other users?
Scott
-Original Message-
From: Tom Lane [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 5:38 PM
To: Saltsgaver, Scott
Cc: '[EMAIL PROTECTED]'
Subject: Re: [SQL] Granting of permissions on tables
this is a goofy situtation.
we had a new linux 2.4.4 kernel with a /tmp not writable by
postgres. granted, this is categorically hosed, but initdb still dumped core
under these circumstances. changing the /tmp to writable
immediately fixed the problem.
-j
=
John Scott
Senior Partner
ult like this
'A1', 'A', 'B1', 'B'
'B1', 'B', 'C1', 'C'
'C1', 'C', 'D1', 'D'
'B1', 'B', 'C2', 'C'
'B1', 'B', 'C5', 'C'
'A1', 'A', 'B3', 'B'
'A1', 'A', 'B4', 'B'
or I just like to get another tree start with 'B1'
like this
'B1', 'B', 'C1', 'C'
'C1', 'C', 'D1', 'D'
'B1', 'B', 'C2', 'C'
'B1', 'B', 'C5', 'C'
How can i make it by sql , and sql functions
Thanks lot and regards.
Scott
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
Tomasz,
This works!
Thanks,
Scott Ding
-Original Message-
From: Tomasz Myrta [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 20, 2003 9:06 AM
To: Scott Ding
Cc: [EMAIL PROTECTED]
Subject: Re: [SQL] point <-> polygon not supported?
Scott Ding wrote:
> Tomasz,
>
>
27;1000.007327','41',NULL,'+',NULL,'12358',NULL,NULL)
Jul 14 12:48:47 localhost postgres[2998]: [108] ERROR: Cannot insert a duplicate key
into unique index pk_fdata
Note that I do not try to insert anything into fid, the primary key on
this table. Why does Post
27;t realize it. I'll have to change my "bulk loading" script
to update the sequence after the load is done.
Thanks much,
Scott
--
----
Scott Cain, Ph. D. [EMAIL PRO
r this particular query,
explain analyze indicates that this is the more efficient form, but I
could easily see that at other times/for other parameters, a set unioned
together would be better. Are there any guidelines for this?
Thanks,
On Thu, 2003-07-17 at 15:00, Josh Berkus wrote:
> Scott,
>
> > I have a query that uses a series of ORs and I have heard that sometimes
> > this type of query can be rewritten to use UNION instead and be more
> > efficient.
>
> I'd be interested to know whe
nd,fphase,gid,ftarget_start,ftarget_stop)
Jul 14 12:48:47 localhost postgres[2998]: [107-2]
VALUES('XX',7327656,7327658,'1000.007327','41',NULL,'+',NULL,'12358',NULL,NULL)
Jul 14 12:48:47 localhost postgres[2998]: [10
tten a plpgsql function before, so
I don't have much experience with it; is there anything obviously wrong
with this function, or are there things that could be done better? At
least this appears to work and is much faster, completing substring
op
On Mon, 2003-08-04 at 11:55, Richard Huxton wrote:
> On Monday 04 August 2003 16:25, Scott Cain wrote:
> [snip]
> > [snip]
>
> You might want some checks to make sure that smin < smax, otherwise looks like
> it does the job in a good clean fashion.
Good point--smin <
On Mon, 2003-08-04 at 11:53, Tom Lane wrote:
> Scott Cain <[EMAIL PROTECTED]> writes:
> > At least this appears to work and is much faster, completing substring
> > operations like above in about 0.27 secs (that's about two orders of
> > magnitude improvement!)
&g
Joe,
Good idea, since I may not get around to profiling it this week. I
created a dump of the data set I was working with. It is available at
http://www.gmod.org/string_dump.bz2
Thanks,
Scott
On Mon, 2003-08-04 at 16:29, Joe Conway wrote:
> Is there a sample table schema and data
Oh, and I forgot to mention: it's highly compressed (bzip2 -9) and is
109M.
Scott
On Tue, 2003-08-05 at 11:01, Scott Cain wrote:
> Joe,
>
> Good idea, since I may not get around to profiling it this week. I
> created a dump of the data set I was working with. It is av
Title: Message
Hi
All,
Is there a function
available to validate if the input is a correct money format? For
exapmle, "23.56" is a correct number but "23.567" is incorrect. I just like to
do this in postgres level not in my application code.
Thanks
Scott
Morning,
I see lots of references to this error, but currently no fix for my
situation. I am converting an INFORMIX ESQL/C system to PostgreSQL
embedded C. I have hit several road blocks along the way and running
out of time to complete and test this convert - so I am coming to the
pros for some
-50-24w3/0 | 2003
(20 rows)
Thanks,
--
Scott A. Gerhardt, P.Geo.
Gerhardt Information Technologies
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
681 | 260.8 | 0 | 563.9 | 47899 | 9G/6-1-50-24w3/0 | 2003
200305 | 452 | 0 | 0 | 0 | 47899 | 9G/6-1-50-24w3/0 | 2003
200309 | 637 | 244.6 | 0 | 193.8 | 47899 | 9G/6-1-50-24w3/0 | 2003
Thanks,
--
Scott A. Gerhardt, P.Geo.
Gerhardt Information Technologies
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
On Wed, 2004-10-20 at 01:03, Kathiravan Velusamy wrote:
> Hello All,
>I am a newbie to PostgreSQL. I am using postgreSQL 7.4.5 in
> HP-Unix 11.11 PA , and 11.23 PA.
> I have a problem with postgreSQL Webmin (Webmin Version
> 1.070) testing in update function.
> This
On Fri, 2004-10-22 at 07:52, Davide Negri wrote:
> Hello,
>
> i have installed the 8.0 beta3-dev1 version of postgres on my pc, and
> I want to disable log. How can I do? It is possible to disable and
> donât write all the log, or how can I write all the log in a specific
> directory??
If you us
ld be greatly
appreciated. I've taken it as far as I can and don't really know where to
move from here.
Thanks in advance,
Scott Pederick
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
producttypeid_fkey FOREIGN KEY (producttypeid) REFERENCES
producttypes(producttypeid) ON UPDATE RESTRICT ON DELETE RESTRICT;
CONSTRAINT jobs_quarryid_fkey FOREIGN KEY (quarryid) REFERENCES
quarries(quarryid) ON UPDATE RESTRICT ON DELETE RESTRICT;
CONSTRAINT jobs_salesid_fkey FOREIGN KEY (salesi
On Thu, 2005-01-13 at 11:08, KÃPFERL Robert wrote:
> Hi,
>
> suppose I have a let's say heavy used table. There's a column containing
> UNIQUE in4
> values. The data type musn't exceed 32-Bit. Since however the table is heavy
> used 2^32 will be reached soon and then? There are far less than 4G-re
On Thu, 2005-01-13 at 15:19, Michael Fuhr wrote:
> On Thu, Jan 13, 2005 at 02:48:47PM -0600, Scott Marlowe wrote:
> > On Thu, 2005-01-13 at 11:08, KÃPFERL Robert wrote:
>
> > > suppose I have a let's say heavy used table. There's a column containing
> > >
On Thu, 2005-01-13 at 15:43, Andrew Sullivan wrote:
> On Thu, Jan 13, 2005 at 03:31:54PM -0600, Scott Marlowe wrote:
> > Any method that tries to reuse sequence numbers is a bad idea (TM) and
>
> Why? I can think of a dozen cases where it can be useful. It just
> depends
On Mon, 2005-01-31 at 16:29, Luiz Rafael Culik Guimaraes wrote:
> Hi Michael Fuhr
> >> how i can increse the number of commands in an transaction block
> >
> > What do you mean? What problem are you trying to solve?
>
> iÂm trying to solve the follow message
> current transaction is aborted, quer
On Tue, 2005-02-01 at 10:54, Joel Fradkin wrote:
> All is moving along well.
>
> I have all my views and data and am testing things out a bit.
>
> A table with 645,000 records for associates has view (basically select
> * from tblassociates where clientnum = âtestâ)
What does
explain analyze s
On Thu, 2005-02-03 at 16:16, lorid wrote:
> I could have sworn I kept a copy of prior emails that discussed how to
> get back a value that was just inserted into a autonumber (or in
> postgresql case a sequence number)
If you know the name of the sequence the number came from you can use
currva
On Wed, 2005-02-16 at 10:02, Keith Worthington wrote:
> Hi All,
>
> In several of my SQL statements I have to use a WHERE clause that contains
> mutiple ORs. i.e.
>
> WHERE column1 = 'A' OR
> column1 = 'B' OR
> column1 = 'C'
>
> Is there a more efficient SQL statement that accomplis
On Tue, 2005-03-01 at 04:52, mauro wrote:
> > Not always, AFAICT. The four most common reasons why PG tests slower
> > than Mysql are:
> > 1. You haven't configured or have misconfigured PostgreSQL.
> > 2. You are testing a MySQL-tuned application (lots of small, simple
> > queries, no views, no
On Wed, 2005-03-02 at 15:45, PFC wrote:
> > The reason PostgreSQL is slower is because it (and by extension the team
> > behind it) cares about your data.
>
> Sure, postgres is (a bit but not much) slower for a simple query like
> SELECT * FROM one table WHERE id=some number, and postgres
On Thu, 2005-03-10 at 14:09, Henry Ortega wrote:
> I have the following table
>
> FIELD_A| FIELD_B | TSTAMP
>
> x y
On Mon, 2005-03-21 at 15:57, Thomas Borg Salling wrote:
> I am looking for a way to âflattenâ a query result, so that rows are
> âtransposedâ into columns, just as asked here for oracle:
>
> http://groups.google.dk/groups?hl=da&lr=&client=firefox-a&rls=org.mozilla:en-US:official&selm=aad10be0.0401
On Mon, 2005-03-28 at 13:44, Thomas Seeber wrote:
> Hi,
>
> We were upgrading from postgres 7.3 -> 8.0 and having a little
> problems importing dates from some of our data sources. Say we have a
> date like '2004-17-05'. In postgres 7.3, postgres would intrept this
> as Year Day Month automatica
On Mon, 2005-03-28 at 15:43, T E Schmitz wrote:
> Hello,
> How expensive would it be to maintain the following VIEW:
>
> CREATE VIEW origin AS SELECT DISTINCT origin FROM transaktion
>
> if there is in index on transaktion.origin; the table transaktion has
> thousands of records and there are on
On Fri, 2005-04-08 at 12:08, Joel Fradkin wrote:
> Thanks all.
> I might have to add a button to do the count on command so they don't get
> the hit.
> I would want it to return the count of the condition, not the currently
> displayed number of rows.
>
> Is there any other database engines that p
On Fri, 2005-04-08 at 15:23, Vivek Khera wrote:
> On Apr 8, 2005, at 3:23 PM, Joel Fradkin wrote:
>
> > I set up the data on 4 10k scsi drives in a powervault and my wal on 2
> > 15k
> > drives. I am using links to those from the install directory. It
> > starts and
> > stops ok this way, but ma
On Fri, 2005-04-08 at 15:35, Bob Henkel wrote:
> On Apr 8, 2005 3:23 PM, Vivek Khera <[EMAIL PROTECTED]> wrote:
> On Apr 8, 2005, at 3:23 PM, Joel Fradkin wrote:
>
> > I set up the data on 4 10k scsi drives in a powervault and
> my wal on 2
> > 15k
>
On Fri, 2005-04-08 at 15:36, Vivek Khera wrote:
> On Apr 8, 2005, at 4:31 PM, Scott Marlowe wrote:
>
> > Note that there are several different RAID controllers you can get with
> > a DELL. I had good luck with the PERC 4C (AMI MegaRAID based) at my
> >
>
> I'v
On Fri, 2005-04-08 at 15:41, Vivek Khera wrote:
> On Apr 8, 2005, at 4:35 PM, Bob Henkel wrote:
>
> > desktop SATA drive with no RAID? I'm by any means as knowledgeable
> > about I/O
> > setup as many of you are but my 2 cents wonders if the Dell RAID is
> > really
> > that much slower than a co
Why not just do:
SELECT zipcode, zipdist($lat1d,$lon1d,lat,long) as distance from
zipcodes where zipdist($lat1d,$lon1d,lat,long) <= $dist;";
On Mon, 2005-04-11 at 20:25, Bill Lawrence wrote:
> Boy I sure thought that would work... I received the following from postgres:
>
> ERROR: Attribute "d
On Tue, 2005-04-12 at 14:29, Vivek Khera wrote:
> On Apr 8, 2005, at 4:50 PM, Scott Marlowe wrote:
>
> > Do you run your 2650s with hyperthreading on? I found that slowed mine
> > down under load, but we never had more than a couple dozen users
> > hitting
> >
On Tue, 2005-04-12 at 15:32, Vivek Khera wrote:
> On Apr 12, 2005, at 4:23 PM, Scott Marlowe wrote:
>
> > How much memory is in the box? I've heard horror stories about
> > performance with >2 gigs of ram, which is why I made them order mine
> > with 2 gigs. D
On Fri, 2005-04-22 at 00:30, Dinesh Pandey wrote:
> How to install Postgres 8.0.1 that supports 64-bit integer/date-time.
>
>
>
> # ./configure --prefix=/usr/local/pgsql
> --with-tclconfig=/usr/local/lib --with-tcl
>
> checking build system type... sparc-sun-solaris2.8
>
> checking host syst
On Fri, 2005-05-06 at 04:14, Kenneth Gonsalves wrote:
> how do i get a dump of a postgresql database without the data?
pg_dump -s for the schema
pg_dumpall -g for the globals, like usernames and all.
---(end of broadcast)---
TIP 4: Don't 'kill -9'
Are the constraints deferrable?
If they are, then you can replace the data with a single transaction.
If not, then you'll have to look at disabling triggers for the update.
On Fri, 2005-05-13 at 14:55, Mark Fenbers wrote:
> True, but Counties has about 8 or 9 rules, view, or pk constraints
> att
On Thu, 2005-05-12 at 14:07, [EMAIL PROTECTED] wrote:
> Hi:
>
> Oracle has a pseudo-column "ROWNUM" to return the sequence number in which a
> row was returned when selected from a table. The first row ROWNUM is 1, the
> second is 2, and so on.
>
> Does Postgresql have a similar pseudo-column "
On Tue, 2005-05-17 at 13:15, Postgres Admin wrote:
> Hi
>
> I'm trying to insert encrypted data into the database and I'm noticing
> error dealing with quotes. Below is the error print out...
>
> suggestions and/or at least point me in the direction to find a solution,
>
> Thanks,
> J
>
>
>
On Fri, 2005-05-20 at 13:27, Keith Worthington wrote:
> Scott,
>
> I realize that this thread went off in another direction however your
> suggestion proved very helpful for a problem that I was trying to solve. I
> wanted the row number of a set returned by a function. He
On Tue, 2005-05-24 at 13:26, Alain wrote:
> This tip was at the end of a message (from Szűcs Gábor).
>
> > TIP 9: the planner will ignore your desire to choose an index scan if your
> > joining column's datatypes do not match
>
> it looks very important, but I cannot understand it. Sound as
On Wed, 2005-06-15 at 17:08, Thomas Kellerer wrote:
> PFC wrote on 15.06.2005 22:04:
>
> >
> >> It's not the program or Java. The same program takes about 20 seconds
> >> with Firebird and the exactly same data.
> >
> >
> > Hm, that's still very slow (it should do it in a couple seconds l
On Tue, 2005-06-28 at 12:01, PFC wrote:
> >
> > What are the major differences between Unique, primary index & just
> > plain index?
> >
> > When creating tables I nominate one of these, but not sure what the
> > difference is?
> index is... an index !
>
> UNIQUE is an index which won't allow du
On Tue, 2005-06-28 at 13:22, Martín Marqués wrote:
> El Mar 28 Jun 2005 13:58, PFC escribió:
> >
> > >> Here is where I get uncertain as to if this is possible. My idea is to
> > >> create a pseudo type that triggers the creation of it's lookup tables
> > >> the same way the SERIAL type triggers c
On Wed, 2005-06-29 at 09:22, Russell Simpkins wrote:
> fair enough. but a simple order by id would never work.
>
Try this:
select *,
case
when id=2003 then 1
when id=1342 then 2
when id=799 then 3
when id=1450 then 4
On Thu, 2005-07-07 at 15:14, Theodore Petrosky wrote:
> you have to use currval inside a transaction...
>
> begin;
> insert something that increments the counter;
> select currval('sequence_name');
> end;
>
> using currval inside a transaction guarantees that the
> value is correct for your inser
On Wed, 2005-07-13 at 04:13, Aaron Bingham wrote:
> Hello,
>
> I've got an interesting problem: I need to select all possible values
> of an attribute that do /not/ occur in the database.
>
> This would be easy (in my case at least) if there were a way to
> generate a table containing all integer
On Tue, 2005-08-16 at 14:53, The One wrote:
> Hello,
>
> I have a table with one encrypted column.
> How can I do a select statement such that it will select all columns
> from the table and at the same time will decrypt it too?
A view should be able to do that...
---(en
On Sat, 2005-08-20 at 21:25, Matt L. wrote:
> Out of curiousity,
>
> 1. Does a boolean column occupy 1byte of disk whether
> or not the value is null or not?
No. Nulls are stored, one bit per, to a byte at a time. I.e. if you
have 8 null fields, they are stored in the same byte.
> 2. Is matc
On Wed, 2005-08-31 at 14:54, Jim C. Nasby wrote:
> SELECT sum(hours) FROM table WHERE emp_name = 'JSMITH' AND work_date =
> '8-15-2005'::date will give you the hours. So...
>
> INSERT INTO table
> SELECT blah
> WHERE (SELECT sum(hours) FROM table WHERE emp_name = 'JSMITH' AND
> work_date
On Mon, 2005-09-26 at 20:03, Tom Lane wrote:
> Ferindo Middleton Jr <[EMAIL PROTECTED]> writes:
> > Is there some reason why the SERIAL data type doesn't automatically have
> > a UNIQUE CONSTRAINT.
>
> It used to, and then we decoupled it. I don't think "I have no use for
> one without the other
On Thu, 2005-09-29 at 14:08, Axel Rau wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
> Exactly, that query works as I expected. Thank you.
> Can you answer this question as well:
> > Looking for a workaround, I learned that aggregate functions are not
> > allowed in WHERE clauses.
> > Q
27;0509' on them and I want to
move the data
to appropiate monthly tables. '0510' would represent shipped on 2005
october.
Eventually I want to create, insert, select all based on passing a string
such as '0509' to a function.
I am a newbie.
Th
On Thu, 2005-10-06 at 14:43, Hector Rosas wrote:
> Hello, I'm trying to select records in a table not present in a
> related table, in example, I've a table with message information
> (subject, message, date, etc) and another (usermessages) with where
> user(s) has that message, its state, etc. Rec
On Tue, 2005-10-11 at 16:12, Rick Schumeyer wrote:
> I'm not sure what I was thinking, but I tried the following query in pg:
>
> SELECT * FROM t GROUP BY state;
>
> pg returns an error.
>
> Mysql, OTOH, returns the first row for each state. (The first row with
> "AK", the first row with "PA",
On Wed, 2005-10-12 at 16:54, Greg Stark wrote:
> Stephan Szabo <[EMAIL PROTECTED]> writes:
>
> > On Tue, 11 Oct 2005, Rick Schumeyer wrote:
> >
> > > I'm not sure what I was thinking, but I tried the following query in pg:
> > >
> > > SELECT * FROM t GROUP BY state;
> > >
> > > pg returns an erro
On Wed, 2005-10-12 at 20:13, Greg Stark wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>
> > Hehe. When I turn on my windshield wipers and my airbag deploys, is it
> > a documented "feature" if the dealership told me about this behaviour
> > ahead of
On Thu, 2005-10-13 at 13:26, Greg Stark wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>
> > Sorry, but it's worse than that. It is quite possible that two people
> > could run this query at the same time and get different data from the
> > same se
On Thu, 2005-10-13 at 10:31, Shavonne Marietta Wijesinghe wrote:
> how can i do a query with 2 databases??
This is only supported by an add on called dblink, and it's a little bit
klunky.
Could schemas solve your problem?
---(end of broadcast)---
T
On Sat, 2005-10-22 at 00:39, Chris Travers wrote:
> Tom Lane wrote:
>
> >"Dean Gibson (DB Administrator)" <[EMAIL PROTECTED]> writes:
> >
> >
> >>I remember that discussion, and I was for the change. However, upon
> >>doing some testing after reading the above, I wonder if the
> >>blank-strip
On Tue, 2005-10-25 at 23:45, Kenneth Gonsalves wrote:
> hi,
> i was in a minor flame war with a mysql guy - his major grouse was that
> 'I wouldnt commit mission critical data to a database that needs to be
> vacuumed once a week'. So why does pg need vacuum?
The absolutely funniest thing about
On Tue, 2005-10-25 at 23:45, Kenneth Gonsalves wrote:
> hi,
> i was in a minor flame war with a mysql guy - his major grouse was that
> 'I wouldnt commit mission critical data to a database that needs to be
> vacuumed once a week'. So why does pg need vacuum?
Oh man oh man. After reading the ar
On Wed, 2005-10-26 at 10:16, Volkan YAZICI wrote:
> => SELECT
> -> (SELECT count(id) FROM sales
> -> WHERE id = 2
> -> AND date_trunc('hour', dt) = '2005-10-25 21:00:00'),
> -> (SELECT count(id) FROM sales
> -> WHERE id = 2
> -> AND date_trunc('hour', dt) =
On Wed, 2005-10-26 at 11:09, Jan Wieck wrote:
> On 10/26/2005 11:19 AM, Scott Marlowe wrote:
>
> > On Tue, 2005-10-25 at 23:45, Kenneth Gonsalves wrote:
> >> hi,
> >> i was in a minor flame war with a mysql guy - his major grouse was that
> >> '
On Wed, 2005-10-26 at 11:12, Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
> > On Tue, 2005-10-25 at 23:45, Kenneth Gonsalves wrote:
> >> i was in a minor flame war with a mysql guy - his major grouse was that
> >> 'I wouldnt commit mission cri
On Wed, 2005-11-30 at 12:42, Luis Silva wrote:
> I there, I'm trying to work with postgre, but i'm having a problem
> with inherits. I have a table (parent) that as an fk to another table.
> When i create a child, i loose the connection to the other table. i
> dont need to insert values in the par
On Tue, 2005-12-13 at 12:16, Gianluca Riccardi wrote:
> hello all,
> i'm usign PostgreSQL 7.4.7 in a Debian 3.1
>
> following is the SQL schema of my (very)small DB for a (very small)web
> business application:
> CREATE TABLE orders (
>id serial,
>order_code serial,
>customer_code i
I have 2 tables. One containing information about servers, and the other
containing information about IP addresses.
E.G.
Server table:
namemac
mac2
-
SERVER1 00:0d:56:ba:ad:92
SERVER2 00:0d:56
On Wed, 2006-02-22 at 12:08, Judith wrote:
>Hello everybody I need to update a field with the same value in the
> tables of my data base but this field exists in almost all tables and
> has the same value, I don't want to code a script, so my question is if
> there is some way to update that
On Wed, 2006-02-22 at 15:13, Andrew Sullivan wrote:
> On Wed, Feb 22, 2006 at 11:59:06AM -0600, Judith Altamirano Figueroa wrote:
> > Hello everybody I need to update a field with the same value in the
> > tables of my data base but this field exists in almost all tables and
> > has the same va
On Wed, 2006-03-01 at 11:51, Bryce Nesbitt wrote:
> I'm interested in creating a mirror database, for use in case one our
> primary machine goes down. Can people here help sort out which of the
> several replication projects is most viable?
>
> As far as I can tell, the winner is slony1 at
> http
On Wed, 2006-03-01 at 14:18, Bruce Momjian wrote:
> Stephan Szabo wrote:
> > > justify_days doesn't currently do anything with this result --- it
> > > thinks its charter is only to reduce day components that are >= 30 days.
> > > However, I think a good case could be made that it should normalize
On Wed, 2006-03-01 at 14:27, Bruce Momjian wrote:
> Scott Marlowe wrote:
> > On Wed, 2006-03-01 at 14:18, Bruce Momjian wrote:
> > > Stephan Szabo wrote:
> > > > > justify_days doesn't currently do anything with this result --- it
> > > > > thi
On Fri, 2006-03-03 at 14:10, Maciej Piekielniak wrote:
> Hello pgsql-sql,
>
> I dump db with pg_dump v.8.1.3 on database postgresql server 7.4.7.
> Data directory with my db on pg 7.4.7 had 1,8GB and
> file with dump had 2,7GB.
> Database have blob fields.
>
> When I restore db on pg 8.1 - data d
On Wed, 2006-03-08 at 06:07, Markus Schaber wrote:
> Hi, Scott,
>
> Scott Marlowe wrote:
>
> >>But it isn't '-2 months, -1 day'. I think what you are saying is what I
> >>am saying, that we should make the signs consistent.
> > Pretty much.
a test function
and the function failed.
Question 1: does pg/psql functions allow "SAVEPOINT/ROLLBACK"
functionality? (if so how?)
Question 2: if the answer to question 1 is "NO", what would be required
to get this implemented in the standard produ
On Mon, 2006-03-20 at 02:06, Eugene E. wrote:
> http://dev.mysql.com/doc/refman/5.0/en/news-5-0-19.html
> --- cut ---
> mysql no longer terminates data value display when it encounters a NUL
> byte. Instead, it displays NUL bytes as spaces. (Bug #16859)
> --- cut ---
Everyone here realizes that t
On Tue, 2006-03-21 at 08:58, [EMAIL PROTECTED] wrote:
> Hello,
>
> I've got 2 tables, "url" (U), and "bookmark" (B), with "bookmark" pointing to
> "url" via FK.
> Somehow I ended up with some rows in B referencing non-existent rows in U.
> This sounds super strange and dangerous to me, and it's n
On Fri, 2006-03-24 at 14:30, MaXX wrote:
> Hi,
>
> I have a table wich contains aggregated data,
> table stats_activity
> logtime timestamptz,
> count int
>
> given this dataset
> "2006-03-24 03:00:00+01";55
> "2006-03-24 04:00:00+01";33
> "2006-03-24 06:00:00+01";46
> "2006-03-24 07
On Wed, 2006-03-29 at 02:17, Achilleus Mantzios wrote:
> Hi, i am in the process of writing an application about
> tickets, flights, etc, and i am thinking of getting the primitive
> data ready at the begining and doing it the right way,
> (e.g. the user will just select a flight number and doesnt
On Fri, 2006-04-07 at 15:32, Bryce Nesbitt wrote:
> I have a need to copy/update data from one column to another, based on a
> join condition. Is this easy to do in pure SQL? I have google'ed
> without luck for a easy solution (that's not Microsoft specific, that
> is). For example:
>
> postgre
On Wed, 2006-04-26 at 11:09, Ray Madigan wrote:
> I have a table that I created that implements a linked list. I am not an
> expert SQL developer and was wondering if there are known ways to traverse
> the linked lists. Any information that can point me in the direction to
> figure this out would
Using PL/PGSQL, I am trying to create a procedure to display the count of rows in any single table of a database. The End-user would pass in a table name and the prodecure would display the table name with the row count.
I am able to hardcode the variable for table and get the appropriate results
On Mon, 2006-05-15 at 16:40, Emi Lu wrote:
> Hello,
>
> I tried "select greatest(max(a), max(b)) from public.test", but I got
> the following errors:
>
> ERROR: function greatest(integer, integer) does not exist
> HINT: No function matches the given name and argument types. You may
> need to
On Thu, 2006-06-01 at 14:47, Yasir Malik wrote:
> > It is a hack, but when someone wants you to do something in a way
> > different from the norm, aren't they asking for a hack?
> >
> > SQL Server does something like
> > select top (1) from
> >
> > I am thinking this is NOT a SQL-99 standard.
On Tue, 2006-06-06 at 10:30, Richard Broersma Jr wrote:
> > Personally: I think your posts are getting annoying. This isn't SQLCentral.
> > Learn to write your own damn queries or even better - buy a book on SQL...
>
> Personally: (being a newbie with an interest in developing a strong rdms
> sk
On Tue, 2006-06-06 at 16:17, Aaron Bono wrote:
> Though there may be a more eligant way to do it, when we did things
> like this in the past we created a function (or stored procedure) that
> got the min and max dates and then created a result set that iterated
> through the dates to create a virtu
On Thu, 2006-06-08 at 16:40, CG wrote:
> PostgreSQL 8.1
>
> I've been trying to write a SQL prepare routine. One of the challenging
> elements I'm running into is an empty set ...
>
> "select foo from bar where foo in ? ;"
>
> What if "?" is an set with zero elements? What is the proper value to
On Mon, 2006-06-26 at 08:59, Forums @ Existanze wrote:
> Hello again,
>
> The problem is not tracking WHAT changed, this can be done, as we have
> discussed in this thread, the problem is how to replicate the necessary
> commands that will alter a mirror database to reflect what has been changed,
1 - 100 of 399 matches
Mail list logo
