Re: [SQL] listen_addresses = '*' ok, specific address(es) no

2006-06-15 Thread Andrew Sullivan
Well, do you actually have an interface with that address? A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)-

Re: [SQL] SQL Technique Question

2006-06-15 Thread Andrew Sullivan
hich benefit includes "easier to debug queries"). There is a probably non-zero cost to the extra joins. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets ou

Re: [SQL] concurrency problem

2006-06-19 Thread Andrew Sullivan
ect nextval(). Then you can insert it as currval() for all your other INSERTs. No, there is no race condition or concurrency problem: see the docs on these functions. No locks. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do

Re: Fwd: [SQL] Start up question about triggers

2006-06-23 Thread Andrew Sullivan
t already have been rewritten, I think. No? I _think_ that even BEFORE triggers happen after the rewriter stage is called, but someone who has more clue will be able to correct me if I'm wrong. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place

Re: Fwd: [SQL] Start up question about triggers

2006-06-26 Thread Andrew Sullivan
ainly, I have been saying is that your plan to get the list of transform commands is fundamentally misguided. If you want to track changes, then that's what you should do: track what changed. Note that there is a project that already, in fact, does this for you as part of how it works: Sl

Re: Fwd: [SQL] Start up question about triggers

2006-06-26 Thread Andrew Sullivan
to find a solution for it. Ah. That was not, in fact, clear to me. What is it about Slony that doesn't solve this problem? You've checked it out, right? <http://www.slony.info> will get you there. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything,

Re: Fwd: [SQL] Start up question about triggers

2006-06-26 Thread Andrew Sullivan
t doesn't tell you what the database looks like. It tells you what commands were sent. What about triggers? Rules? For that matter, what about SELECT now() or SELECT nextval() ? -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Andrew Sullivan
eep two databases in two locations: that's a matter of safety. Slony does it automatically, as long as the daemon is running. No need to control it. _Unless_ you want to be able to write in the second database. That's a different problem. You can't do that with Slony. A -- Andrew

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Andrew Sullivan
On Tue, Jun 27, 2006 at 02:48:38PM +0300, Forums @ Existanze wrote: > Hello again andrew, > > Actually man I do need to be able to write to both databases, and keep them > synchronized, and all this because of the recurring xenofobia for technology Then sorry, but this can't b

Re: Fwd: [SQL] Start up question about triggers

2006-06-27 Thread Andrew Sullivan
Java," and then start asking what problems you can solve, you can do anything ;-) I prefer the strategy whereby one asks what the problem is to be solved first, then choose the technology. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did*

Re: [SQL] Alternative to serial primary key

2006-07-06 Thread Andrew Sullivan
on md5). Primary keys have to be unique, of course. I _think_ with a hundred columns, you could probably prove (using brute force, if need be) that the hashes are going to be unique, assuming the list of possible values in each column is bounded. A -- Andrew Sullivan | [EMAIL PROTECTED] A c

Re: [SQL] Alternative to serial primary key

2006-07-06 Thread Andrew Sullivan
int, I thought. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choos

Re: [SQL] Alternative to serial primary key

2006-07-06 Thread Andrew Sullivan
a unique contraint. A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [SQL] Alternative to serial primary key

2006-07-06 Thread Andrew Sullivan
ave to cope with the error. It's probably an acceptable cheat, as you're right that the collision risk is pretty small. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA

Re: [SQL] Alternative to serial primary key

2006-07-07 Thread Andrew Sullivan
en. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [SQL] Alternative to serial primary key

2006-07-07 Thread Andrew Sullivan
old city map will tell you that even this "impossible case" is by no means impossible. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative work need not end up well. --Dennis Ri

Re: [SQL] MS-SQL<->Postgres sync

2006-07-10 Thread Andrew Sullivan
actually any product that does this right now, unless you're willing to use some sort of statement replica system (which means you have to deal with failures in one database and not another). Is the idea that this is multi-master? A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that

Re: [SQL] MS-SQL<->Postgres sync

2006-07-11 Thread Andrew Sullivan
ould allow you to run slony daemons that connected to it and a > postgresql server and did replication. Just mad scientisting for a > second. Well, yes, but that's why I asked whether it's multimaster. Because if so, it'll be at least tricky to do under Slony I. A -- Andrew

[SQL] using constraint based paritioning to fix EAV type schemas? (view inheritance and constraints)

2006-07-18 Thread Andrew Hammond
I have a client with the following EAV inspired schema. CREATE TABLE many_tables ( table_id text primary key,-- defines which virtual table is encoded attribute1 text, attribute2 text, attribute3 text, attribute4 text, ... ); I'd like to use a mix of constraint bas

Re: [SQL] SQL generator

2006-07-25 Thread Andrew Hammond
1) If you don't know how to write the SQL for this, then you might want to ask yourself if you have sufficient expertise to write a tool which generates such queries. 2) I have seen many attempts at query generators. I have yet to see a design which achieves a good balance between simplicity and f

Re: [SQL] reusing AS

2006-07-25 Thread Andrew Hammond
Gregory Stewart wrote: > I am trying to do something like this: > > SELECT SUM(sales_today) AS sales_today_total, SUM(sales_lastweek) AS > sales_lastweek_total > CASE WHEN sales_today_total = '0' THEN '0'::int4 WHEN sales_lastweek_total = > '0' THEN '0'::int4 ELSE ((100/sales_today_total*sales_las

Re: [SQL] SQL generator

2006-07-26 Thread Andrew Sullivan
prised that casual users can accidentally do a 5-way Cartesian product. But it would make no difference if the commands were specified in natural language, because the conceptual confusion is the problem. A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out

Re: [SQL] Rows with exclusive lock

2006-07-26 Thread Andrew Hammond
Martin Marques wrote: > On Sun, 23 Jul 2006, Alvaro Herrera wrote: > > > Martin Marques escribió: > >> > >> After the SELECT FOR UPDATE other transactions can still see the locked > >> rows. I want a read/write lock, so no one can access does rows. > > > > SELECT FOR UPDATE acquires an exclusive l

Re: [SQL] Help with privilages please

2006-07-26 Thread Andrew Hammond
7.4.1 is quite old and has a number of serious known bugs. I'd suggest you either upgrade to 8.1.4 (current) or, if you can't do that, at least upgrade to 7.4.13 (latest 7.4) immediately. Hilary Forbes wrote: > Tom > > Thank you - I think that the underlying problem is that I was trying out > >

Re: [SQL] Disk is full, what's cool to get rid of?

2006-07-27 Thread Andrew Sullivan
uncate a table to clear enough space. Deleting anything under pg_xlog is more or less guaranteed to mean your database is garbage. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---

Re: [SQL] Storage of Binary Data

2006-07-27 Thread Andrew Sullivan
the best approach. It has the problem that COMMITs of this data aren't atomic (the file write could succeed and the database write fail, for example). But that can usually be worked around, and at least you're not bulking your database with binaries. A -- Andrew Sullivan | [EMA

[SQL] Dynamic Query

2009-10-19 Thread Andrew Hall
tance? The postgresql documentation seems to suggest that I can use the RETURN QUERY EXECUTE feature, or simply build my query with a string and execute it (I don't see how the latter can protect me from SQL Injection though???) Any help would be appreciated! Thanks, Andrew

[SQL] Table Valued Parameters

2009-10-23 Thread Andrew Hall
ould help me to arrive at an optimal solution. Cheers, Andrew. _ Download Messenger onto your mobile for free http://clk.atdmt.com/UKM/go/174426567/direct/01/

FW: [SQL] Table Valued Parameters

2009-10-23 Thread Andrew Hall
question more clear. Thanks, Andrew. > Date: Fri, 23 Oct 2009 20:10:48 +0200 > Subject: Re: [SQL] Table Valued Parameters > From: pavel.steh...@gmail.com > To: andre...@hotmail.com > CC: pgsql-sql@postgresql.org > > Hello > > 2009/10/23 Andrew Hall : > > Hi, > &

Re: [SQL] Table Valued Parameters

2009-10-24 Thread Andrew Hall
e to express my thanks to you for taking the time to suggest an approach. Cheers, Andrew. > Date: Fri, 23 Oct 2009 20:32:37 +0200 > Subject: Re: FW: [SQL] Table Valued Parameters > From: br...@zwartberg.com > To: andre...@hotmail.com > CC: pgsql-sql@postgresql.org > > 2

[SQL] PostgreSQL Security/Roles/Grants

2009-11-01 Thread Andrew Hall
signed to a user (or more accurately a 'login role') in postgreSQL? Many thanks, Andrew. _ New Windows 7: Find the right PC for you. Learn more. http://www.microsoft.com/uk/windows/buy/

[SQL] Foreign key - Indexing & Deadlocking.

2009-12-29 Thread Andrew Hall
the safe side. Thanks, Andrew. _ Use Hotmail to send and receive mail from your different email accounts http://clk.atdmt.com/UKM/go/186394592/direct/01/

[SQL] enforcing constraints across multiple tables

2010-06-25 Thread Andrew Geery
cated nature of the solution make the design poor? (C) Should I not worry about this constraint at the DB level and just enforce it at the application level? Below are the tables, functions and triggers I was using. Thanks! Andrew

[SQL] Re: [HACKERS] Facing authentication error on postgres 9.2 -> dblink functions

2013-02-06 Thread Andrew Dunstan
s time. So do NOT follow up this email. This question belongs on pgsql-general. If you have further questions pleease ask there. The short answer is that you need to provide the user name in your connect string. cheers andrew -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org

Re: [SQL] SELECT all fields except two

2006-08-03 Thread Andrew Hammond
This does not exist in SQL. However you could achieve similar functionality by doing a suitable query against the system info tables to find out what columns are available and then building your query appropriately. For an example, try psql -E -c '\d mytable' Drew Pit M. wrote: > select *,!Blob

Re: [SQL] alter column type from boolean to char with default

2006-08-03 Thread Andrew Hammond
Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> writes: > > On Wed, 2006-08-02 at 09:19 -0400, Tom Lane wrote: > >> Hmm ... the way I would have expected to work is > >> > >> alter table posts > >> alter column deleted drop default, > >> alter column deleted type char(1) > >> using (case when dele

Re: [SQL] timestamp (MS SQLServer's rowversion) functionality

2006-08-10 Thread Andrew Hammond
Tomski wrote: > Hello! > As many of you know, SQL Server (2000) has peculiar data type "timestamp" > which is not SQL standard timestamp. In fact it is "rowversion" type. It > makes tha field to be updated with current timestamp when row is updated or > inserted. > Is there any similiar functionali

[SQL] The Right Way to manage schemas in SCM systems

2006-08-11 Thread Andrew Hammond
I've been trying to figure out a good way to manage schema change control for a while now. Since I have a development background, I really want to find some way to check the schema into a SCM system like CVS (for example). Just using a pg_dump doesn't work very well becase there's no guarantee of c

Re: [SQL] timestamp (MS SQLServer's rowversion) functionality

2006-08-11 Thread Andrew Hammond
On 8/11/06, Aaron Bono <[EMAIL PROTECTED]> wrote: I put a create_dt and modify_dt column on every table and set the default to now(). Then I use this trigger: CREATE OR REPLACE FUNCTION "public"."modify_date_stamp_fn" () RETURNS SETOF opaque AS ' BEGIN -- if a trigger insert or update oper

Re: [SQL] Breaking up a query

2006-08-13 Thread Andrew Sullivan
plication is going to give better performance than joining in the database? This is what RDBMS _do_, for heaven's sake. (I agree that your plan shows it's taking a long time. But that's a different problem. We don't actually know what you want from your query.) A -- Andrew

Re: [SQL] SQLMAP IBATIS insert values from web forms to a money type column

2006-08-14 Thread Andrew Sullivan
dcast)--- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions

Re: [SQL] Multiple DB join

2006-08-15 Thread Andrew Sullivan
records isn't very big. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris ---(end of broadcast)--

Re: [SQL] Multiple DB join

2006-08-15 Thread Andrew Sullivan
he gain is going to be demonstrable. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [SQL] Multiple DB join

2006-08-15 Thread Andrew Sullivan
ou have two initially-unbound search terms there: ILIKE '%' and ~* '.*' are automatically seqscans, because you have nowhere in the index to start. If you really want to do this kind of unbound-string query, you need to look into full text search. The above approach is never goin

Re: [SQL] Multiple DB join

2006-08-15 Thread Andrew Sullivan
On Tue, Aug 15, 2006 at 10:25:00AM -0300, Jorge Godoy wrote: > I'd like to see some sort of data partitioning in PostgreSQL. Sure, I think everybody would. I think it's among the more interesting problems we have. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdot

Re: [SQL] Multiple DB join

2006-08-15 Thread Andrew Sullivan
ok at tsearch2, probably. If you had any way to enforce bounded searches, it'd be a different matter: strings with initial matches but an unbound end are fast. (You can do it the other way, too, by some tricks with reversing the strings.) A -- Andrew Sullivan | [EMAIL PROTECTED] The fa

Re: [SQL] problem with sequence.....

2006-08-16 Thread Andrew Sullivan
(This isn't completely safe. You can make it completely safe by doing it in two transactions, but that's best left as an exercise for the reader.) A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilto

Re: [SQL] OT: OpenDatabase Model ?

2006-08-16 Thread Andrew Sullivan
derstand your question correctly, I think this is what the various Normal Forms are for, no? A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP

Re: [SQL] DB creation script questions

2006-08-16 Thread Andrew Sullivan
; more robust solution anyways. Well, you could query the SQL-standard Information Schema. Alternatively, you can query the system tables like pg_class. But if you want the more standard one, use the tables under schema information_schema. That's the reason there's a standard. A -- And

Re: [SQL] OT: OpenDatabase Model ?

2006-08-17 Thread Andrew Sullivan
can make your physical data model resemble your logical data model, rather than pounding with a big hammer on your logical model to make the physical storage you have fit? The database is not a filesystem. If you just need a filesystem and a SQL-like interface to it, use MySQL 3.x. A -- Andrew Sulliva

Re: [SQL] Multiple DB join

2006-08-18 Thread Andrew Sullivan
e this subject | keyword subject1| keyword1 keyword2 keyword3 and you want every subject that matches on keyword2, then you have to search this with SELECT subject WHERE keyword = '%keyword2%'. The reason you have to do that is that your data is badly normalised. Is that it?

Re: [SQL] NULL becomes default

2006-08-21 Thread Andrew Sullivan
ce of triggers: > can I do that? DEFAULT won't work for this case, I don't think; you want to set it to the nextval() of the sequence or whatever it was you were trying to do. But it's not messy: this is precisely the sort of thing BEFORE triggers are good at. A -- Andrew Su

Re: [SQL] Lock Problem

2006-08-24 Thread Andrew Sullivan
post more detail. Why do you think you have table locks, to begin with? A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: RES: [SQL] Lock Problem

2006-08-25 Thread Andrew Sullivan
ning UPDATEs with that many updates per minure makes me think that maybe you have a lot of dead rows. Anyway, none of this supports your claim that you're getting table locks. The place to see what locks you are getting is pg_locks. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future

Re: [SQL] Best way to do this query..

2006-08-25 Thread Andrew Sullivan
hat column would be an end_date column, default infinity. When an insert comes along, you DO ALSO update the old row's end_date with a new column. Then you do DISTINCT ON max(effective) and use a CASE statement to suppress the infinity on the current rate. Does that help? -- Andrew Sullivan

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-28 Thread Andrew Sullivan
letely general way, such that it could be used for any arbitrary data, is a hard problem that might destroy performance. It's also a pretty exotic feature. You might want to ask on the -hackers list for more detail, though. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was vi

Re: [SQL]

2006-08-29 Thread Andrew Sullivan
a tutorial called EXPLAIN explained. Google will help you -- just use that title, with maybe "postgresql" tacked onto your search string. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data. --Roger Brinner ---(end of broadc

Re: [SQL] Create Assertion -- Question from a newbie

2006-08-30 Thread Andrew Sullivan
On Wed, Aug 30, 2006 at 04:47:29PM -0400, Gregory Stark wrote: > > Do *any* databases implement SQL standard Assertions? Somebody must've had an implementation, or it'd never have made it into the spec ;-) A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men

Re: [SQL] help with pagila

2006-09-01 Thread Andrew Sullivan
mething you can have, because of the way sets work.) A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland

Re: [SQL] help with pagila

2006-09-01 Thread Andrew Sullivan
proper. This is considerably better under recent releases, however, and I think you'd find, if you used the strict mode in the most recent release, that MySQL would choke on a query like you posted as well. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is n

Re: [SQL] pg_dump

2006-09-05 Thread Andrew Sullivan
talled, and you've got a mismatch in versions. Be my first guess, anyway. A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz ---

Re: [SQL] Query regarding to MS reporting services (Grand total problem)

2006-09-06 Thread Andrew Sullivan
On Tue, Sep 05, 2006 at 10:30:19PM -0700, Dinesh Tiwari wrote: > If any one have idea about this please help me. My idea is that you ask on a list that supports MS SQL Server. This isn't one. A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't

Re: [SQL] How to autoincrement a primary key...

2006-09-22 Thread Andrew Chilton
foo), it should read in full: CREATE SEQUENCE foo START 1; CREATE TABLE bar (id integer PRIMARY KEY DEFAULT nextval('foo')); Andy -- name: Andrew Chilton web: http://kapiti.geek.nz/ ---(end of broadcast)--- TIP 1: if posting/reading thro

Re: [SQL] Populating using Select

2006-09-26 Thread Andrew Sullivan
s much. Alternatively, the standard SQL introductions would get you there. A -- Andrew Sullivan | [EMAIL PROTECTED] In the future this spectacle of the middle classes shocking the avant- garde will probably become the textbook definition of Postmodernism. --Brad Holland ---

Re: [SQL] SEQUENCES

2006-10-02 Thread Andrew Sullivan
cient: for name in `psql -c "select relname from pg_class where relkind = 'S'" dbname; do psql -c "select last_value from $name" dbname; done. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than refor

Re: [SQL] Assigning a timestamp without timezone to a timestamp with timezone

2006-10-03 Thread Andrew Sullivan
ecause that's encoded in the timestamp. In general, I think timestamps without timezones are just a bad idea. A -- Andrew Sullivan | [EMAIL PROTECTED] I remember when computers were frustrating because they *did* exactly what you told them to. That actually

Re: [SQL] Assigning a timestamp without timezone to a timestamp

2006-10-03 Thread Andrew Sullivan
|"timezone" as timestamp from storetz where id = 1) as a; timestamp 2006-10-03 12:00:00+00 (1 row) A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes -

Re: [SQL] i have table

2006-10-05 Thread Andrew Sullivan
e the old table. If you want to insert &c., you put some rules there. A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz ---

Re: [SQL] Assigning a timestamp without timezone to a timestamp

2006-10-05 Thread Andrew Sullivan
gt; > testing=# SELECT a.timestamp::timestamptz from (SELECT '2006-10-03 > 09:00'||"timezone" as timestamp from storetz where id = 1) as a; >timestamp > > 2006-10-03 12:00:00+00 > (1 row) 2006-10-03 09:00:00-03 == 2

Re: [SQL] Assigning a timestamp without timezone to a timestamp

2006-10-05 Thread Andrew Sullivan
use you had char(3) there, and not all time zones are 3 characters long). But to answer your question, yes, it works. I just tried it. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem.

Re: [SQL] Too much time to delete 19000 rows

2006-10-06 Thread Andrew Sullivan
. . > I just think it could be occuring becouse of many constraints (7 at all) . . .it could be, yes. Are all the other tables &c. indexed correctly? VACUUMed and ANALYSEd? A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness.

Re: [SQL] i have table

2006-10-10 Thread Andrew Sullivan
On Mon, Oct 09, 2006 at 11:01:17AM -0500, Aaron Bono wrote: > On 10/5/06, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > >you want to insert &c., you put some rules there. > > If you do this you need to make the vie

Re: [SQL] conversion of numeric field from MSSQL to postgres

2006-10-23 Thread Andrew Sullivan
ubscribed. 2. person subscribed 3. person sent mail 4. anti-dup filter didn't catch the dup mail 5. second mail goes through 6. moderator approves original mail 7. mail shows up again. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no ba

Re: [SQL] Round Numeric Type

2006-10-31 Thread Andrew Sullivan
ts 0 > > Did anybody knows if it is possible to control this matter ? Sounds like your datatype doesn't match your input, and that you've got a type that rounds. What's the datatype you're putting into? A -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, &quo

Re: [SQL] record datatype comparisons

2006-10-31 Thread Andrew Sullivan
apes that are already identical, so they can use the matching rules for that. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)-

Re: [SQL] record datatype comparisons

2006-11-01 Thread Andrew Sullivan
modates these different things. The trade-off is that comparing a record to another record won't always work: because what a record is is not pre-determined, you can't have determinate rules for comparing one record to another. And without determinate rules, you can't have an equality

Re: [SQL] record datatype comparisons

2006-11-01 Thread Andrew Sullivan
and SELECT ROW(1,2). The row's datatype(s) is(are) defined. The record's datatype isn't. So you can have an equality operator for the row. You can see this from the error message when you do this: testing=# SELECT ROW(1,2) is distinct from ROW ('a','b')

Re: [SQL] record datatype comparisons

2006-11-01 Thread Andrew Sullivan
t I'm really past my Latin at this point, because even if I looked at the code that supports the record type, I wouldn't understand it. A -- Andrew Sullivan | [EMAIL PROTECTED] The whole tendency of modern prose is away from concreteness. --George Orwell -

Re: [SQL] hi i am getting error...can u solve this

2006-11-02 Thread Andrew Sullivan
On Thu, Nov 02, 2006 at 06:19:45PM +0530, Penchalaiah P. wrote: > > This is the table it contains some sample data.. but I want to see > difference between Between what? A -- Andrew Sullivan | [EMAIL PROTECTED] "The year's penultimate month" is not in truth a goo

Re: [SQL] Index + View Question

2006-11-03 Thread Andrew Sullivan
e some cases where the indexes on several tables simply won't work -- if the condition is such that all the tables need to be compared to one another, for instant, no index will help you, because you'll end up pulling everything into memory before anything else can happen. A -- Andrew Sulli

Re: [HACKERS] [SQL] Case Preservation disregarding case

2006-11-06 Thread Andrew Dunstan
probably add the second option without being nearly so invasive, though, and some people might feel that that would be sufficient. cheers andrew Chuck McDevitt wrote: We treated quoted identifiers as case-specific, as the spec requires. In the catalog, we stored TWO columns... The column name with

Re: [SQL] Random()

2006-11-16 Thread Andrew Sullivan
r is pseudo-random. Often it's very good pseudo-random -- most of the time, good enough for most purposes -- but it isn't true randomness of the sort that is delivered by (for example) particle decay. A -- Andrew Sullivan | [EMAIL PROTECTED] The plural of anecdote is not data.

Re: [SQL] [SQL NOTIFY Help] sending NOTIFY to the external program

2007-01-03 Thread Andrew Sullivan
On Wed, Jan 03, 2007 at 07:47:34PM +0530, [EMAIL PROTECTED] wrote: > > Yes, our application is supposed to know *immediately* that a change in > the database has occurred since, NOTIFY doesn't get you that anyway. It's _close_ to immediately, but it's still asynch

Re: [SQL] deleting records from a table

2007-01-12 Thread Andrew Sullivan
med table that has a number of now-empty slots can actually be a performance advantage, because new rows don't need to increase the size of the table's on-disk file (so you incur slightly less I/O). There's a "sweet spot" for this that you can discover by testing. A -- A

Re: [SQL] vacuum process taking more than 33 hours

2007-01-15 Thread Andrew Sullivan
r, a VACUUM FULL on the table in question ought to be enough to get you the space back. A -- Andrew Sullivan | [EMAIL PROTECTED] The fact that technology doesn't work is no bar to success in the marketplace. --Philip Greenspun ---(end of broadcast)

Re: [SQL] vacuum process taking more than 33 hours

2007-01-15 Thread Andrew Sullivan
On Mon, Jan 15, 2007 at 02:44:15PM +, Ezequiel Luis Pellettieri wrote: > Hi Andrew, > > Why don't you try droping all indexes exept but the constraints ones for > each table. I don't have the problem, so I don't know whether that will help. > then you'll

Re: [SQL] Update query by joining multiple tables.

2007-01-17 Thread Andrew Sullivan
les to appear in the WHERE condition and the update expressions. a -- Andrew Sullivan | [EMAIL PROTECTED] Users never remark, "Wow, this software may be buggy and hard to use, but at least there is a lot of code underneath." --Damien Katz ---(

Re: [SQL] Postgresql & Oracle Heteregenous services - strange behaviour

2007-01-17 Thread Andrew Sullivan
correct, although maybe no faster). The reason it isn't repeated, I bet, is that your connection is persistent, so the information gets cached. A -- Andrew Sullivan | [EMAIL PROTECTED] Everything that happens in the world happens at some place. --Jane Jacobs ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [SQL] Permissions Query?

2007-01-19 Thread Andrew Sullivan
8.1/interactive/functions-info.html#FUNCTIONS-INFO-ACCESS-TABLE A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes ---(end of broadcast)--- TIP

Re: [SQL] select based on multi-column primary keys

2007-01-21 Thread Andrew Sullivan
ing about is not a real primary key, but an artificial one. The OP already has a real primary key. SQL purists think artificial primary keys mean that you haven't done enough normalisation. I'm going to remain silent on that topic, though, so that we don't get a Thread That

Re: [SQL] select based on multi-column primary keys

2007-01-23 Thread Andrew Sullivan
se where it was five. Yes, the application needed rewriting. But it was normalised :) A -- Andrew Sullivan | [EMAIL PROTECTED] A certain description of men are for getting out of debt, yet are against all taxes for raising money to pay it off. --Alexander Hamilton -

Re: [SQL] Using Temporary Tables in postgres functions

2007-01-25 Thread Andrew Sullivan
he temp table and EXECUTE the statement. The problem is that the plan is cached for later re-use. Since the cached plan has the id of a table that no longer exists, you get this error. See the PL/pgSQL part of the manual for more on this. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately

Re: [SQL] LEFT Join Question

2007-01-26 Thread Andrew Sullivan
to be able to RIGHT OUTER JOIN the table you just LEFT JOINed to to the next table using a different column. A -- Andrew Sullivan | [EMAIL PROTECTED] Information security isn't a technological problem. It's an economics problem. --Bruce Schneier

Re: [SQL] Very strange postgresql behaviour

2007-01-29 Thread Andrew Sullivan
7.4 series. 7.4.2 was a long time ago, and I dimly remember something about data corruption early in the 7.4 series. It could be the source of your problem. A -- Andrew Sullivan | [EMAIL PROTECTED] This work was visionary and imaginative, and goes to show that visionary and imaginative wor

Re: [SQL] Differentiate Between Zero-Length String and NULL Column Values

2007-01-30 Thread Andrew Sullivan
QL, as far as I know. If you want to use the empty string, you need WHERE ean = '' If you want instead ean to be NULL, use the traditional \N to signify NULL on your way in, or define null some other way. A -- Andrew Sullivan | [EMAIL PROTECTED] Users

Re: [SQL] Differentiate Between Zero-Length String and NULLColumn Values

2007-01-30 Thread Andrew Sullivan
On Tue, Jan 30, 2007 at 02:38:07PM +0100, Bart Degryse wrote: > Andrew, I think you're wrong stating that Oracle would interpret > NULL and empty string as equal. The Oracle databases I use (8, 9 > and 10) certainly make a distiction between both values. Maybe > earlier versio

Re: [SQL] Differentiate Between Zero-Length String and NULLColumn Values

2007-01-30 Thread Andrew Sullivan
' in it, and been surprised. Or at least, I think it's like that. I do recall hearing a lot about how stupid Postgres was because it didn't like something that worked "perfectly well" on Oracle, which I was assured was the most SQL-compliant system on the planet. Happil

Re: [SQL] Log, Logs and more Logs

2007-01-30 Thread Andrew Sullivan
cs/8.2/static/runtime-config-logging.html A -- Andrew Sullivan | [EMAIL PROTECTED] If they don't do anything, we don't need their acronym. --Josh Hamilton, on the US FEMA ---(end of broadcast)--- TIP 7: You can help su

Re: [SQL] Log, Logs and more Logs

2007-01-30 Thread Andrew Sullivan
7;ll see the COMMIT as the thing that caused the error. A -- Andrew Sullivan | [EMAIL PROTECTED] Unfortunately reformatting the Internet is a little more painful than reformatting your hard drive when it gets out of whack. --Scott Morris -

Re: [SQL] Index Anding

2007-01-31 Thread Andrew Sullivan
ry limitation on every program at compile time. There are some hints about this in the FAQ_AIX. A -- Andrew Sullivan | [EMAIL PROTECTED] When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes ---(end of

<    1   2   3   4   >