Which is still later datetime than the /var/log/postgres... log.
Connection attempt shows the same log
postgres@atlassian:/home/myuser$ psql
psql: FATAL: the database system is starting up
Nothing in the syslog that seems connected.
*Brian Mills*
CTO
*Mob: *0410660003
*Melbourne* 03 9012 3460
is starting up
2017-01-28 23:00:01 AEDT FATAL: the database system is starting up
2017-01-29 07:14:00 AEDT FATAL: the database system is starting up
I also still can't connect.
postgres@atlassian:/home/tbadmin$ psql
psql: FATAL: the database system is starting up
*Brian Mills*
CTO
0001000500A3
*Brian Mills*
CTO
*Mob: *0410660003
*Melbourne* 03 9012 3460 or 03 8376 6327 *|* *Sydney* 02 8064 3600 *|*
*Brisbane* 07 3173 1570
Level 1 *|* 600 Chapel Street *|* South Yarra*|* VIC *|* 3141 *|*
Australia
<https://www.facebook.com/TryBooking/> <https://tw
I have a consistent sql dump from 24 hour previous.
The file level backup was done with rsync -a of full data directory after
the issue occurred so could reset as I learned.
Brian
On Sun, 29 Jan 2017 at 9:18 am, Adrian Klaver
wrote:
> On 01/28/2017 01:55 PM, Brian Mills wrote:
> >
postgres?
The log mentions this:
2017-01-27 20:36:18 AEDT LOG: last completed transaction was at log time
2017-01-24 02:08:00.023064+11
(which is moments before, or possibly as the disk filled up doing a db
backup dump)
*Brian Mills*
CTO
*Mob: *0410660003
*Melbourne* 03 9012 3460 or 03 8376 6327
might have something wrong about the process.
Any thoughts on the above log?
*Brian Mills*
CTO
*Mob: *0410660003
*Melbourne* 03 9012 3460 or 03 8376 6327 *|* *Sydney* 02 8064 3600 *|*
*Brisbane* 07 3173 1570
Level 1 *|* 600 Chapel Street *|* South Yarra*|* VIC *|* 3141 *|*
Australia
&
7;x_type' : undeclared identifier in
core\exchange-traits.h
sql << "SELECT i, s FROM t WHERE i = 0", soci::into(r);
std::cout << r.get<0>() << "\t" << r.get<1>() << std::endl;
return(0);
}
//-
> We expect of everyone in our spaces to try their best to do the same in a
> kind and gentle manner. If you feel it's just a minor offense and the person
> didn't mean harm by it,
>
> simply ignore it unless the pattern of talk continues. If the person
> continues or they say something you feel is
> 3. A safe, respectful, productive and collaborative environment is free
> comments related to gender, sexual orientation, disability, physical
> appearance, body size or race.
I think you meant "free OF comments".
However it still picks a few special classes of complaint, some of
which cause am
>> "3) A safe, respectful, productive and collaborative environment is
>> free of negative personal criticism directed at a member of a
>> community, rather than at the technical merit of a topic."
>>
> A safe, respectful, productive and collaborative environment is free
> of non-technical or per
> * Participants who disrupt the collaborative space, or participate in
> a pattern of behaviour which could be considered harassment will not
> be tolerated.
Perhaps changing the ", or participate" to " by engaging" would make
that statement more focused.
> "Disrupting the collaborative space" i
Is it possible, and if so how, to dump and then load a database to/from a
file from within a psql connection?
--
Brian Cardarella
CEO of DockYard
Visit us: http://dockyard.com
Call us: (855) DOCK-YRD
Follow me on Twitter: http://twitter.com/bcardarella
Follow us on Twitter
>> Participation does not need to be limited to copy-editing. Of all the
>> ways to develop a community CoC, we're engaged in just about the worst
>> possible one right now.
>
> so what would be a better way of developing this ?
Of interesting note, the Ruby community is currently considering
swi
ore
--
Best Wishes,
Chris Travers
Efficito: Hosted Accounting and ERP. Robust and Flexible. No
vendor lock-in.
http://www.efficito.com/learn_more
All;
Thanks for the great Ideas, I'll let you know where we end up.
Brian FehrleDatabase Administrator I
On 6/5/07, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
Ranieri Mazili schrieb:
> Hello,
>
> I need to store users and passwords on a table and I want to store it
> encrypted, but I don't found documentation about it, how can I create a
> table with columns "user" and "password" with column "passwo
On 6/5/07, Marko Kreen <[EMAIL PROTECTED]> wrote:
On 6/5/07, Tino Wildenhain <[EMAIL PROTECTED]> wrote:
> Ranieri Mazili schrieb:
> > Hello,
> >
> > I need to store users and passwords on a table and I want to store it
> > encrypted, but I don't found documentation about it, how can I create a
>
On 6/5/07, Marko Kreen <[EMAIL PROTECTED]> wrote:
On 6/5/07, Marko Kreen <[EMAIL PROTECTED]> wrote:
> both md5 and sha1 are actually easier to bruteforce than
> the old DES-based crypt.
If this statement seems weird - the problem is the speed.
MD5 and SHA1 are just faster algorithms than des-cry
Hi,
We're trying to figure out why we're getting poor query performance on a
particular database running on a 64 bit Solaris box. The info for the poor
database is:
Red Hat Enterprise Linux AS release 4 (Nahant Update 2) Linux vl-sfv40z-001
2.6.9-22.0.2.ELsmp #1 SMP Thu Jan 5 17:11:56 EST 200
On 8/1/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I bought a Dell server and I am going to use it for installing PostgrSQL
> 8.2.4. I always used Windows so far and I would like now to install a
> Linux distribution on the new server. Any suggestion on which distribution
> ? Fedo
On 8/1/07, Douglas McNaught <[EMAIL PROTECTED]> wrote:
> Joseph S <[EMAIL PROTECTED]> writes:
>
> > My small gripes about Ubuntu are:
> > 1) rpm, for all its faults, is still better than using apt
>
> You *must* be joking. In Debian and Ubuntu, I've never had a tenth of
> the dependency hell tha
On 8/2/07, Andrej Ricnik-Bay <[EMAIL PROTECTED]> wrote:
> On 8/3/07, Merlin Moncure <[EMAIL PROTECTED]> wrote:
>
> > they do, but experience has shown it is prudent to be able to
> > administrate the hardware directly from the box.
>
> I'm curious: which aspect of hardware administration
> on a Li
I'm using postgresql in a Ruby on Rails app and I've moved some of the
application logic from Ruby (ActiveRecord callbacks) to postgresql
(triggers + functions) for performance reasons. The problem is that
now those parts of the app remain untested. Does anyone have a
suggestion for doing a
rring the initdb phase of the installer.
- Brian Peck
- 858-795-1398
ot sure if this should be listed as another caveat on the PITR
recovery page but in the very least I wanted to post to the list so
that others attempting to archive and recover compressed WALs may be
aware of a potential issue.
Brian Wipf
<[EMAIL PROTECTED]>
---
play
will not update these indexes. The recommended workaround is to
manually REINDEX each such index after completing a recovery operation"
Is it possible there are issues with btree indexes being maintained
properly as well? Any other ideas?
Brian Wipf
Clickspace Int
On 3-Oct-07, at 8:07 AM, Tom Lane wrote:
PG 8.2 does store data in the pg_control file with which it can check
for the most common disk-format-incompatibility problems (to wit,
endiannness, maxalign, and --enable-integer-datetimes). If Brian has
stumbled on another such foot-gun, it'd be
On 3-Oct-07, at 12:46 PM, Richard Huxton wrote:
Tom Lane wrote:
Brian Wipf <[EMAIL PROTECTED]> writes:
PG tried to enforce the same LC_COLLATE and LC_CTYPE. On OS X,
the value of en_US.utf8 didn't exist, so I created a soft link
to en_US.UTF-8 in the /usr/share/locale/ direct
doing the requested copy. I
fixed the bug now. Thanks for your input Tom.
Brian Wipf
ClickSpace Interactive Inc.
<[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your desire to
choo
difficult to maintain when things go
wrong.
Brian Wipf
ClickSpace Interactive Inc.
<[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PR
digits after the slash would be the log segment. What is the rule
for determining the log segment from pg_controldata's output?
Thanks for the help!
Brian Wipf
ClickSpace Interactive Inc.
<[EMAIL PROTECTED]>
---(end of broadcast)---
T
On 17-Oct-07, at 12:01 AM, Brian Wipf wrote:
I'm working on a script that takes backups in intervals from our
warm PITR stand by server (both servers running PG 8.2.5). The
documentation advises "running pg_controldata on the standby server
to inspect the control file and det
On 18-Oct-07, at 3:15 PM, Brian Wipf wrote:
The offset is the last 6 hex digits of the checkpoint location
value. The offset contains leading zeros to make it 6 digits if its
actual value is less than 6 digits. Therefore, the digits between
the slash and the last 6 digits are the log
I have a test PG 8.2.5 installation that has been left idle with no
connections to it whatsoever for the last 24 hours plus. WALs are
being archived exactly 5 minutes apart, even though archive_timeout
is set to 60. Is this the expected behavior for a database with no
changes?
Brian
ortant that this even works. If anyone could shed any
insight though, I would appreciate the feedback.
Brian Wipf
<[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscri
On 29-Oct-07, at 11:06 PM, Tom Lane wrote:
Brian Wipf <[EMAIL PROTECTED]> writes:
The process I use that leads to the warnings is simple:
I use pg_controldata to determine the current checkpoint WAL location
of the standby server. I ensure I have this WAL file and all newer
WALs. I
d
which can be shut down periodically for taking base backups.
Brian Wipf
<[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 6: explain analyze is your friend
ce may be when I'm killing pgbench.
I'm not sure if this is a bug with PostgreSQL or OS X 10.5.1. Any
suggestions on what I can do to narrow down the problem further would
be greatly appreciated.
Brian Wipf
ClickSpace Interactive Inc.
<[EMAIL PROTECTED]>
--
On 3-Dec-07, at 3:51 PM, A.M. wrote:
On Dec 3, 2007, at 4:16 PM, Brian Wipf wrote:
We have a dual 3.0 GHz Intel Dual-core Xserve, running Mac OS X
10.5.1 Leopard Server and PostgreSQL 8.2.5. When we disconnect
several clients at a time (30+) in production, the CPU goes through
the roof
should be the query actually being performed.
- Brian Peck
- 858-795-1398
- Software Engineer
- Lockheed Martin
x27;
The idea being that I don't care too much what value is, but I need to know foo.
Thanks!
Brian
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAI
get a base backup.
Brian Wipf
<[EMAIL PROTECTED]>
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to
ses and
> dangerous content by *MailScanner* <http://www.mailscanner.info/>, and is
> believed to be clean.
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 183 8059
6 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
uninstall slony. The plus is that you can accomplish what you
need with pretty much 0 downtime.
--brian
On Oct 13, 2010, at 10:03 AM, EDH wrote:
> I have a large Postgres DB (1100 GB) that I'd like to move to a new
> physical machine. In the past I've done this via pg_dump & r
r
processes.
On Oct 13, 2010, at 10:59 AM, Evan D. Hoffman wrote:
> Thanks, Brian & Jaime. Regarding Slony, would that allow for
> migration to a new version as well - i.e. moving from 8.2 on the old
> machine to 8.4 on the new machine via Slony with minimal downtime?
>
>
ny examples for statement triggers.
If what I'm looking for doesn't exist, are there any common workarounds that
people use to find the set of updated/inserted/deleted rows?
Thanks in advance,
Brian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes t
able. This comes in quite handy
> when bulk-loading data, e.g. with COPY.
>
I'll look at doing something like you describe, although I wonder if the
overhead of doing a row trigger and then a mass update at the end with a
statement trigger will really be worth it for what I'm d
giving you the
solutions to your problems.
--brian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
h data)?
> Just create index this way, e.g.
> CREATE INDEX ir_translation_ltns ON tab ((md5(col)));
> where "tab" and "col" are table and column of which you want
> to create btree index.
This probably goes without saying, but you'll have to use col =
md5('blahblahblahblah') in your qualifiers to get the benefit of the index.
--brian
> Dear all,
>
> 2 days ago, I need to backup 2 databases in my Database server because I need
> to format the system and reinstalls again with the back up databases.
>
> After a fresh install of ubuntu-10.4 , I install postgreplus-8.4 binary and I
> think giving the previous data directory /hd
? I've been stumped on it.
-Brian Dunavant
Test script to display behavior below:
-- Setup the test data
CREATE OR REPLACE FUNCTION public.return_if_even(v_id integer) returns
integer
LANGUAGE sql AS
$$
SELECT case when v_id % 2 = 1 then 0 else v_id end;
$$;
create
What issue are you having? I'd imagine you have a race condition on
the insert into hometowns, but you'd have that same race condition in
your app code using a more traditional 3 query version as well.
I often use CTEs like this to make things atomic. It allows me to
remove transactional code ou
With the single CTE I don't believe you can do a full upsert loop. If
you're doing this inside of a postgres function, your changes are
already atomic, so I don't believe by switching you are buying
yourself much (if anything) by using a CTE query instead of something
more traditional here.
The a
WHERE NOT EXISTS(SELECT 1 FROM sel)
> RETURNING id
> )
> SELECT id INTO hometown_id FROM ins UNION ALL SELECT id FROM sel;
> RETURN hometown_id;
>
> EXCEPTION WHEN unique_violation
> THEN
> END;
> END LOOP;
> END;
> $ LANGUAGE plpgsql;
>
A very good point, but it does not apply as here (and in my article)
we are not using updates, only insert and select.
On Tue, Jan 13, 2015 at 6:03 PM, Thomas Kellerer wrote:
> Brian Dunavant wrote on 13.01.2015 22:33:
>>
>> What issue are you having? I'd imagine you have
This is not quite true. I don't believe there are any flight
simulator easter-eggs hidden inside the Postgres code. :)
On Wed, Jan 21, 2015 at 10:59 AM, Rémi Cura wrote:
> More bluntly maybe :
>
> if you can do it in Excel,
> you can do it in Postgres.
>
> Cheers,
> Rémi-C
>
> 2015-01-21 16:37
To lower the amount of time spent copy pasting aggregate column names,
it's probably worth noting Postgres will allow you to short cut that
with the column position. For example:
select long_column_name_A, long_column_name_b, count(1)
from foo
group by 1,2
order by 1,2
This works just fine. It'
or relation x
Command was: REFRESH MATERIALIZED VIEW myview;
In pg_hba I am using the "trust" method for everything (this is a test
cluster).
Is this expected behaviour or a bug?
--
Brian Sutherland
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
On Wed, Feb 18, 2015 at 10:34:33AM -0500, Tom Lane wrote:
> Brian Sutherland writes:
> > If I run this set of commands against PostgreSQL 9.4.1 I pg_restore
> > throws an error with a permission problem. Why it does so is a mystery
> > to me, given that the user perfor
You should consider a BitString.
http://www.postgresql.org/docs/9.4/static/datatype-bit.html
On Thu, Feb 19, 2015 at 11:10 AM, brian wrote:
>
> Hi folks,
>
> I have a single-user application which is growing beyond the
> fixed-format data files in which it currently holds its
hange or disappear. The behaviour is
the same with PostgreSQL versions 9.2.2 and 9.1.7.
I have tried (but failed) to reproduce this error in a simple .sql
script. Outside of the tests, it always seems to work.
Having run into a brick wall debugging this, I'm hoping there's someone
here
On Mon, Jan 14, 2013 at 09:05:09AM -0800, Adrian Klaver wrote:
> On 01/14/2013 08:30 AM, Brian Sutherland wrote:
> >Hi,
> >
> >I have a plpython stored procedure which sometimes fails when I run my
> >applications automated test suite. The procedure is called hundreds o
On Wed, Jan 16, 2013 at 08:10:26AM +1100, Chris Angelico wrote:
> On Tue, Jan 15, 2013 at 4:55 AM, Brian Sutherland
> wrote:
> > I'm guessing that it's some kind of race condition, but I wouldn't know
> > where to start looking.
>
> Look for a recursive i
On Mon, Jan 14, 2013 at 09:05:09AM -0800, Adrian Klaver wrote:
> On 01/14/2013 08:30 AM, Brian Sutherland wrote:
> >Hi,
> >
> >I have a plpython stored procedure which sometimes fails when I run my
> >applications automated test suite. The procedure is called hundreds o
On Thu, Jan 17, 2013 at 03:18:09PM +0700, Stuart Bishop wrote:
> On Mon, Jan 14, 2013 at 11:30 PM, Brian Sutherland
> wrote:
> > Hi,
> >
> > I have a plpython stored procedure which sometimes fails when I run my
> > applications automated test suite. The procedure i
On Thu, Jan 17, 2013 at 01:25:54PM +0100, Alban Hertroys wrote:
> On 17 January 2013 12:30, Brian Sutherland wrote:
>
> > > (we use buildout for our Python code, but our plpythonu stored
> > > procedures use the stock standard Python environment, as provided by
&
a directory, so there isn't a
permissions issue on the directory (I did verify it anyway to be sure). In
both cases, PG starts up fine in the command prompt manually using pg_ctl.
This issue is killing me and any pointers would be greatly appreciated.
*Brian Janes*
Technical Product Manager
I'm upgrading our database from 8.4 to 9.2 and I've run across a view that is
no longer working. When selecting from the view, I get a permission denied
error on one of the referenced tables. However, I can run the view's query
directly without problems and I have read access to all the tab
. I can do another
pg_restore and see if the problem is reproducible if you want.
On Aug 13, 2013, at 12:03 PM, Tom Lane wrote:
Brian Hirt writes:
I'm upgrading our database from 8.4 to 9.2 and I've run across a view that is
no longer working. � When selecting from the vie
I believe the following test should answer your question.
db=# create table test ( a integer not null unique );
CREATE TABLE
db=# insert into test values (1);
INSERT 0 1
db=# insert into test values (1);
ERROR: duplicate key value violates unique constraint "test_a_key"
DETAIL: Key (a)=(1) alr
That does not return the correct answer for the original poster's request.
flpg=# select position('om' in reverse('Tomomasaaa'));
position
--
15
(1 row)
On Mon, Mar 27, 2017 at 11:43 AM, Adrian Klaver
wrote:
> On 03/27/2017 08:05 AM, Ron Ben wrote:
>>
>> Hi,
>> positio
, 2017 at 12:16 PM, Adrian Klaver
wrote:
> On 03/27/2017 09:03 AM, Brian Dunavant wrote:
>>
>> That does not return the correct answer for the original poster's request.
>>
>> flpg=# select position('om' in reverse('Tomomasaaa'));
>>
From the docs you linked:
"Each expression can be the name or ordinal number of an output column
(SELECT list item), or it can be an arbitrary expression formed from
input-column values."
The "name" in your order by is a reference to the output column. The
following example shows the same with "
>From what you're saying about migrating, I'm assuming the new table
has additional columns or something. If you can map the difference,
then you could use CTE's to select from the first table, and if
nothing is there, then pull from the second table and pad it with
nulls so they "match". This sh
On Tue, May 9, 2017 at 6:00 PM, Patrick B wrote:
> SELECT
> split_part(n1.path::text, '/'::text, 18)::integer AS id,
> split_part(n1.path::text, '/'::text, 14)::integer AS clientid,
> lower(n1.md5::text)::character(32) AS md5, 0 AS cont,
> '-1000-1000-3000-6000'::uuid AS guid,
> n1
"FOR UPDATE" is part of "SELECT" not part of "UPDATE".
You can select the rows "for update" which will lock those rows. You
can then loop over the the results of the 'select' to do the rest of
your logic.
Be careful doing this if other things are also updating these rows.
With SKIP LOCKED you ca
A 'month' is an abstract measurement of time. Sometimes it's 29 days, 30,
or 31. You cannot say "I have 30 days, how many months is that?" because
the answer is "it depends".
- gives you an interval in days. In your example, you took
Jan 31 2016 and added "1 month". Postgres says "I know f
eSQ
L30W" (I replaced the actual password with **, but the real password is
supplied in the string.
Anyone have any ideas on how to get it to work inside VS2005? We are
mainly doing this for the ability to have a graphical IDE for debugging.
We are using PostgreSQL 8.2.4.
- Brian Peck
- 85
egularly to prevent this performance degradation?
postgresql 8.1.3 running on redhat es 4.
Thanks,
Brian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
mably) FSM
is needed if you vacuum more often?
Thanks,
Brian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
em, a:
> fgrep -i fsm /tmp/pgvac.log
returns no lines.
Any hints as to where the FSM info is in this file?
Thanks,
Brian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
were 0 unused item pointers.
0 pages are entirely empty.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
VACUUM
I don't see anything that looks like a "summary".
Thanks,
Brian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
);
regards, tom lane
The following greps of the vacuum verbose output return no lines:
fgrep -i fsm
fgrep 'free space'
fgrep 'page slots'
fgrep 'relations'
I've already posted the tail of this output previously.
I conclude that these lines
information does appear. The perils
of being a bit behind the times, I guess.
Thanks for your help,
Brian
I'd like to either 1) execute an alter table to re-add a constraint only
if it doesn't exist or 2) have psql ignore the failure when setting it's
exit status. Any ideas on how to do either would be appreciated.
Posgres 8.1.2
Thanks,
Brian
--
Sent via pgsql-general mail
ought
I'd check in with you.
Regards,
Brian Hirt
Postgres Version 8.2 and 8.3
test=# select show_trgm('魔法門英雄無敵2：王位爭奪戰');
show_trgm
---
{" 2"," 2 "}
(1 row)
Postgres Version 8.4
eral mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69
2009/9/29 tomrevam :
>
>
>
> Brian Modra-2 wrote:
>>
>> When did you last do an analyse and re-create indexes?
>> Is the table UPDATEd to or DELETEd from, or just INSERTed ?
>> Is your DB auto vacuuming?
>>
>
> My DB is auto-vacuuming all the t
the function in SQLs wherever you'd usually use an integer
> or is it just not possible?
>
> Iain
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
2009/9/29 Sam Mason :
> On Tue, Sep 29, 2009 at 02:25:52PM +0200, Brian Modra wrote:
>> 2009/9/29 tomrevam :
>> > My DB is auto-vacuuming all the time. The specific table I'm talking about
>> > gets vacuumed at least every 2 hours (usually a little more frequently t
.
It has a load of memory though... 50Mb is very little memory
considering you are talking about a professional database system
> Bob
--
Brian Modra Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
So
ghtmost 8 characters of all the table names are
dates. So only date strings are passed to the to_date function.
Absolutely nothing containing the string "tati" is passed to the to_date
function. What is going on? Is that a bug?
Brian
hema to be the one
that I want. So those internal pg_* views shouldn't even show up in the
query.
Brian
On Tue, Oct 8, 2013 at 1:50 PM, Brian Wong wrote:
> I'm posting this question to
> pgsql-general<http://www.postgresql.org/list/pgsql-general/>.
> Hopefully someone
extra data that's showing up is being added to the resultset cuz without
the additional where clause, the result set did not contain any of those
rows like pg_statistics/etc.
Brian
On Tue, Oct 8, 2013 at 4:10 PM, Steve Crawford <
scrawf...@pinpointresearch.com> wrote:
> On 10/08/2
to preserve the original source code of a view as
entered in the CREATE VIEW statement?
--Brian
ects at the beginning of the script,
just in case there's a change in the number or types of columns? That
seems tricky, especially considering there will be modules that depend
on yours.
You also mentioned an external CMS. Any suggestions?
--Brian
--
Sent via pgsql-general mailing list (p
On Sun, Oct 20, 2013 at 7:01 AM, Bill Moran wrote:
> You could adjust your workflow to use something like dbsteward:
> http://dbsteward.org/
Nifty, but without an editor, I don't think I could convince our
developers to author the databases in XML.
--Brian
--
Sent via pgsql-gene
ong. I'm big on
views because that allows my client code to do very specific queries
without having to write new SPs all the time.
--Brian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
the docs are wrong, and SSPI isn't available server-side on Linux,
what are my other options?
—Brian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
I've thought of one option, which I'm investigating: implementing
GSSAPI support in Npgsql. Microsoft claims this is possible using the
SSPI API:
http://msdn.microsoft.com/en-us/library/windows/desktop/aa380496(v=vs.85).aspx
—Brian
On Wed, Oct 30, 2013 at 3:16 PM, Brian Crowell wrot
t; The GSSAPI error messages are of the usual helpful kind, even including the
> colon that is followed by no detail.
I've been trying to enable the KRB5_TRACE environment variable in the
Postgres child processes, but I can't seem to make it stick. That
would (should!) provide som
201 - 300 of 529 matches
Mail list logo
