Обсуждение: Just committed some changes...
I've committed some changes which implement a few new things. From the CVS log: Implement nested block comments in the backend and in psql.Include updates for the comment.sql regression test. Implement SET SESSION CHARACTERISTICS and SET DefaultXactIsoLevel. Implement SET SESSION CHARACTERISTICS TRANSACTION COMMITand SET AutoCommit in the parser only.Need to add code to actuallydo something. Implement WITHOUT TIME ZONE type qualifier. Define SCHEMA keyword, along with stubbed-out grammar. Implement "[IN|INOUT|OUT] [varname] type" function argumentsin parser only; INOUT and OUT throws an elog(ERROR). Add PATH as a type-specific token, since PATH is in SQL99to support schema resource search and resolution. Since some of these changes involve tokens in the parser, you may need to do a "make clean all install" to get everything sync'd. afaict this is because we propagate a few of the gram.y token values deeper into the backend... - Thomas
On Fri, Jul 14, 2000 at 04:14:28PM +0000, Thomas Lockhart wrote: > Define SCHEMA keyword, along with stubbed-out grammar. I was just digging into pgaccess a little, cleaning up the diagramming feature I had added. In a fit of naivete, I had called them "schema", as in the logical idea, not the SQL key word. Since we're going to be implementing SQL SCHEMA, eventually, perhaps this would be a good time to rename this feature in pgaccess. How does "Diagrams" sound? Anyone have a better idea? The name appears on a tab. The other tabs are labelled: Tables, Queries, Views, Sequences, Functions, Reports, Forms, Scripts, Users, ????. Keep in mind, I have been thinking about connecting the schema diagrammer into the visual query builder, so that you can set a 'strict' mode, where it'll only allow joins that have been defined in the schema editor. That's why I named it schema, in the first place. It'd be nice to have the diagramming interact with primary key/foreign key constraints, optionally drawing them in automatically. However, all it does right now is draw tables and let you draw links between them, by dragging and dropping fieldnames. Ross -- Ross J. Reedstrom, Ph.D., <reedstrm@rice.edu> NSBRI Research Scientist/Programmer Computer and Information Technology Institute Rice University, 6100 S. Main St., Houston, TX 77005
> How does "Diagrams" sound? Anyone have a better idea? The name appears > on a tab. The other tabs are labelled: OK with me... - Thomas
"Ross J. Reedstrom" wrote: > > How does "Diagrams" sound? Anyone have a better idea? The name appears > on a tab. The other tabs are labelled: Sounds fine to me. Anyway, you are the people speaking english all day long :-) and you should say if it's ok I'll apply the pathes to the next PgAccess release. Constantin Teodorescu Braila, ROMANIA